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