Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 664E52E003F for ; Sat, 29 Mar 2008 18:05:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03607-10 for ; Sat, 29 Mar 2008 18:05:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5B69D2E0035 for ; Sat, 29 Mar 2008 18:05:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m2TL5IXa021773; Sat, 29 Mar 2008 17:05:18 -0400 (EDT) To: "Mikko Partio" cc: pgsql-admin@postgresql.org Subject: Re: Vacuum full crash In-reply-to: <2ca799770803291340p75d8a4e2o7dfd6c61e73270f6@mail.gmail.com> References: <2ca799770803291340p75d8a4e2o7dfd6c61e73270f6@mail.gmail.com> Comments: In-reply-to "Mikko Partio" message dated "Sat, 29 Mar 2008 22:40:54 +0200" Date: Sat, 29 Mar 2008 17:05:18 -0400 Message-ID: <21772.1206824718@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/254 X-Sequence-Number: 28737 "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 ... regards, tom lane