Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 8389E475D30 for ; Tue, 2 Apr 2002 12:40:30 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g32HeZF26288; Tue, 2 Apr 2002 12:40:35 -0500 (EST) To: gry@ll.mit.edu Cc: pgsql-sql@postgresql.org Subject: Re: vacuum full fails: Parent tuple was not found[7.2] In-reply-to: <20020402114647.49646b8c.gry@ll.mit.edu> References: <20020402114647.49646b8c.gry@ll.mit.edu> Comments: In-reply-to george young message dated "Tue, 02 Apr 2002 11:46:47 -0500" Date: Tue, 02 Apr 2002 12:40:35 -0500 Message-ID: <26285.1017769235@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200204/17 X-Sequence-Number: 7282 george young writes: > [Postgres 7.2, SuSE Linux 7.3 (2.4.10), Pentium-III, gcc-3.0.4] > vacuum full fails on pg_class: > VACUUM FULL VERBOSE ANALYZE pg_class; > NOTICE: --Relation pg_class-- > NOTICE: Pages 147: Changed 0, reaped 134, Empty 0, New 0; Tup 2559: Vac 0, Keep/VTL 666/222, UnUsed 7051, MinLen 116, MaxLen 176; Re-using: Free/Avail. Space 833148/831052; EndEmpty/Avail. Pages 0/116. > CPU 0.00s/0.00u sec elapsed 0.00 sec. > NOTICE: Index pg_class_oid_index: Pages 45; Tuples 2559: Deleted 0. > CPU 0.02s/0.00u sec elapsed 0.05 sec. > NOTICE: Index pg_class_relname_index: Pages 149; Tuples 2559: Deleted 0. > CPU 0.04s/0.00u sec elapsed 0.11 sec. > ERROR: Parent tuple was not found > What does this mean, and how can I fix it? This looks like a bug in VACUUM FULL's handling of chains of updated tuples (ie, a series of updates of the same row that might all still be visible to some open transaction(s)). I am guessing that somewhere in the background you have a backend sitting idle with an open BEGIN block. Closing that transaction will probably make the error disappear. I have long suspected that the VACUUM chain logic still contains some corner-case mistakes, but it's very difficult to come by test cases. I am itching to look at your case with a debugger ... but unless your installed postmaster was already compiled with debug symbols, there's probably no hope of learning anything here. Reinstalling a debug-enabled executable would entail closing that open transaction, which will make the symptom disappear. If by chance you do have debug symbols in your installation, then please DON'T close that open transaction. Let's talk ... regards, tom lane