Postgres Pro
Downloads
Home   >   mailing lists

Thread: No one parent tuple was found

No one parent tuple was found

From
"A.Bhuvaneswaran"
Date:
Hi,

We are using postgresql 7.2.3 on redhat 7.1.

When we run vacuum full we get an error message 'No one parent tuple was
found'. But vacuum analyze goes fine. Infact 4 months back we had same
error while we were using 7.2.1. So we did upgrade to 7.2.3 and it went
off fine then. But now the same error crops up. What can be done in this
case? Googling and search in the archive doesn't help much.

regards,
bhuvaneswaran

Re: No one parent tuple was found

From
Tom Lane
Date:
"A.Bhuvaneswaran" <bhuvansql@myrealbox.com> writes:
> We are using postgresql 7.2.3 on redhat 7.1.

> When we run vacuum full we get an error message 'No one parent tuple was
> found'. But vacuum analyze goes fine. Infact 4 months back we had same
> error while we were using 7.2.1. So we did upgrade to 7.2.3 and it went
> off fine then. But now the same error crops up. What can be done in this
> case?

7.2.4 fixes a couple additional cases of this, but I think you need 7.3
to have a complete fix.

            regards, tom lane

Re: No one parent tuple was found

From
"A.Bhuvaneswaran"
Date:
> We are using Postgres 7.2.1 and we have the same problem.
>
> We are upgrading to 7.3 but the error like not to be fixed.
>
> What can we do?

We have not yet upgraded to 7.3 due to other factors, but we must upgrade.
Do you mean that the error 'No one parent tuple was found' occurs in 7.3?

regards,
bhuvaneswaran