Обсуждение: No one parent tuple was found

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

"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

> 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