Re: vacuum is failing

Lonni J Friedman <netllama@gmail.com> 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).

            regards, tom lane