Re: error during vacuum full

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(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
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>