Postgres Pro
Downloads
Home   >   mailing lists

Thread: ERROR: Parent tuple was not found

ERROR: Parent tuple was not found

From
"Gaetano Mendola"
Date:
During a vacuum full in a couple of tables I obtain:

ERROR: Parent tuple was not found


and in another table:

NOTICE:  Child itemid in update-chain marked as unused - can't continue
repair_frag

time ago TOM told me that is not a problem, what does mean exactly "is not a
problem".



Ciao
Gaetano.

Re: ERROR: Parent tuple was not found

From
Tom Lane
Date:
"Gaetano Mendola" <mendola@bigfoot.com> writes:
> During a vacuum full in a couple of tables I obtain:
> ERROR: Parent tuple was not found
> and in another table:
> NOTICE:  Child itemid in update-chain marked as unused - can't continue
> repair_frag
> time ago TOM told me that is not a problem, what does mean exactly "is not a
> problem".

It means "you have not lost any data".

If you want to get rid of the error messages, I believe that updating to
7.2.4 will fix 'em.

            regards, tom lane

Re: ERROR: Parent tuple was not found

From
"Gaetano Mendola"
Date:
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:14774.1044375379@sss.pgh.pa.us...
> "Gaetano Mendola" <mendola@bigfoot.com> writes:
> > During a vacuum full in a couple of tables I obtain:
> > ERROR: Parent tuple was not found
> > and in another table:
> > NOTICE:  Child itemid in update-chain marked as unused - can't continue
> > repair_frag
> > time ago TOM told me that is not a problem, what does mean exactly "is
not a
> > problem".
>
> It means "you have not lost any data".
>
> If you want to get rid of the error messages, I believe that updating to
> 7.2.4 will fix 'em.


I hope you didn't remove only the error notify
;-)


Ciao
Gaetano.