pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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"



view thread (2+ messages)  latest in thread

Message-ID: <20020402114647.49646b8c.gry@ll.mit.edu>
Permalink:  ../20020402114647.49646b8c.gry@ll.mit.edu/
Also on:    postgresql.org/message-id/20020402114647.49646b8c.gry@ll.mit.edu

 · 

reply

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