Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 684152E0037 for ; Sun, 30 Mar 2008 07:56:21 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 20666-10 for ; Sun, 30 Mar 2008 07:56:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by developer.postgresql.org (Postfix) with ESMTP id B0E852E0035 for ; Sun, 30 Mar 2008 07:56:20 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so1359487waf.5 for ; Sun, 30 Mar 2008 03:56:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=NtZpUWPdm323XK8WjFLqepLZcgdon0fBqmCsVTUPtgw=; b=hQI7N2yKj1kwsmhoDpfVv+2DOiBH7uCl/rK6mPBHOscWZaXegWZGlRaJB0bzaUYxGIMDGan5jGDGCegaYNyFIvRVI8MwrbZsHpjI/71Ihnia2VHCxLZ5z9+UrGKucF+jJD4+MZugE9D+/ngJCIXxcyv/tWaxsP0BIxk4LxNQ8v4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=tUEVCQg3P5YT7wyMfoubgarKbZ37ierjhWNvO9e/ltwkPE+WaJyV7o4dM0nYVbF4bDbiVqPts6vYuMnJwfqoKMSVqDDwKDpyx45RLy7GIHbVLruDYSZroV7Kh9pTUZap1ye2/s7FYdO19S95biD+fJUDqLMB1U+byVaPRcOikDw= Received: by 10.114.112.1 with SMTP id k1mr7704047wac.24.1206874579440; Sun, 30 Mar 2008 03:56:19 -0700 (PDT) Received: by 10.114.102.14 with HTTP; Sun, 30 Mar 2008 03:56:19 -0700 (PDT) Message-ID: <2ca799770803300356r185b1adbv2ab17c7cc8f212a7@mail.gmail.com> Date: Sun, 30 Mar 2008 13:56:19 +0300 From: "Mikko Partio" To: "Tom Lane" Subject: Re: Vacuum full crash Cc: pgsql-admin@postgresql.org In-Reply-To: <21772.1206824718@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11966_25107326.1206874579432" References: <2ca799770803291340p75d8a4e2o7dfd6c61e73270f6@mail.gmail.com> <21772.1206824718@sss.pgh.pa.us> X-Archive-Number: 200803/255 X-Sequence-Number: 28738 ------=_Part_11966_25107326.1206874579432 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Sun, Mar 30, 2008 at 12:05 AM, Tom Lane wrote: > "Mikko Partio" writes: > > 2008-03-29 22:25:15 EET [26841]: [3-1] PANIC: cannot abort transaction > > 3778747509, it was already committed > > Yeah, this is a well-known problem with VACUUM FULL ... > > Ok, that's good to know. Is there a bugfix on the way or is it more like a 'feature'? Regards Mikko ------=_Part_11966_25107326.1206874579432 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On Sun, Mar 30, 2008 at 12:05 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Mikko Partio" <mpartio@gmail.com> writes:
> 2008-03-29 22:25:15 EET [26841]: [3-1] PANIC:  cannot abort transaction
> 3778747509, it was already committed

Yeah, this is a well-known problem with VACUUM FULL ...



Ok, that's good to know. Is there a bugfix on the way or is it more like a 'feature'?

Regards

Mikko
------=_Part_11966_25107326.1206874579432--