On Tue, 04 Jan 2005 18:30:43 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Lonni J Friedman <[EMAIL PROTECTED]> writes: > > ERROR: No one parent tuple was found > > > Anyone have any suggestions on how to correct this? > > Shut down whatever long-running transaction is hanging around in the > background. You wouldn't be getting this error if vacuum weren't > trying to move a chain of updated tuples, and that can only happen > if there's an old transaction someplace. > > Of course, the real fix is to use a newer Postgres. I note this in > the 7.2.4 CVS logs: > > 2003-01-26 18:09 tgl > > * src/backend/access/heap/heapam.c (REL7_2_STABLE): Back-patch > fixes to ensure t_ctid always has correct value (prevents some > instances of 'No one parent tuple' VACUUM error, and perhaps worse > things).
Thanks Tom. I should have googled first, cause this seems to have come up alot before 7.2.4 was released. I'll schedule some down time and see if running vacuum fixes this (temporarily). Getting postgresql upgraded might require an act of $DEITY *sigh* -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman [EMAIL PROTECTED] LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
