Re: error during vacuum full

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: error during vacuum full
Date: 2002-07-10 04:00:49
Message-ID: 13764.1026273649@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Barry Lind <barry(at)xythos(dot)com> writes:
> When trying to perform a full vacuum I am getting the following error:
> ERROR: No one parent tuple was found

Want to dig into it with gdb, or let someone else into your system to
do so?

I've suspected for awhile that there's still a lurking bug or three
in the VACUUM FULL tuple-chain-moving code, but without an example
to study it's damn hard to make any progress.

Note that restarting the postmaster will probably make the problem
go away, as tuple chains cannot exist unless there are old open
transactions. So unless your installation is already compiled
--enable-debug, there's probably not much we can learn :=(

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Barry Lind 2002-07-10 04:10:24 Re: error during vacuum full
Previous Message jtv 2002-07-10 03:48:37 Re: Unintegrated stuff in source tree