Re: error during vacuum full

Barry Lind <barry@xythos.com>

From: Barry Lind <barry@xythos.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hacker <pgsql-hackers@postgresql.org>
Date: 2002-07-10T04:10:24Z
Lists: pgsql-hackers
Tom,

It was not compiled with debug.  I will do that now and see if this 
happens again in the future.  If and when it happens again what would 
you like me to do?  I am willing provide you access if you need it.

thanks,
--Barry

Tom Lane wrote:

>Barry Lind <barry@xythos.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
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>  
>