From: george young <gry@ll.mit.edu>
To: pgsql-sql@postgresql.org
Subject: vacuum full fails: Parent tuple was not found[7.2]
Date: Tue, 2 Apr 2002 11:46:47 -0500
Message-ID: <20020402114647.49646b8c.gry@ll.mit.edu> (raw)
[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?
Vacuum without the "full" directive works OK.
--
I cannot think why the whole bed of the ocean is
not one solid mass of oysters, so prolific they seem. Ah,
I am wandering! Strange how the brain controls the brain!
-- Sherlock Holmes in "The Dying Detective"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gry@ll.mit.edu
Subject: Re: vacuum full fails: Parent tuple was not found[7.2]
In-Reply-To: <20020402114647.49646b8c.gry@ll.mit.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox