Обсуждение: vacuum problem

Hi,

I try to run vacuum full analyze on pg 7.3.1 but I get this messages:

NOTICE:  Child itemid in update-chain marked as unused - can't continue
repair_frag
ERROR:  Parent tuple was not found.

How can I solve the problem?

regards,
ivan.

pginfo <pginfo@t1.unisoftbg.com> writes:
> I try to run vacuum full analyze on pg 7.3.1 but I get this messages:

> NOTICE:  Child itemid in update-chain marked as unused - can't continue
> repair_frag
> ERROR:  Parent tuple was not found.

I don't believe that's 7.3.anything.  Check the version again?

> How can I solve the problem?

If this is 7.2.*, you might find that updating to 7.2.4 (due out in a
week) will fix it.  Otherwise I'd suggest dumping and reloading the
table.

            regards, tom lane

Hi Tom,

Very sorry for my mistake.
I have 4 pg 7.3.1 servers running, but realy it was 7.2.1.
I will reload the data.

regards,
ivan.

Tom Lane wrote:

> pginfo <pginfo@t1.unisoftbg.com> writes:
> > I try to run vacuum full analyze on pg 7.3.1 but I get this messages:
>
> > NOTICE:  Child itemid in update-chain marked as unused - can't continue
> > repair_frag
> > ERROR:  Parent tuple was not found.
>
> I don't believe that's 7.3.anything.  Check the version again?
>
> > How can I solve the problem?
>
> If this is 7.2.*, you might find that updating to 7.2.4 (due out in a
> week) will fix it.  Otherwise I'd suggest dumping and reloading the
> table.
>
>                         regards, tom lane

What's the release date for 7.2.4? Is it ready for download? I can't find it from Postgres
Web site. Where I can find the bug fixing list for this release?
Thanks

Wenzhe

At 04:49 PM 1/22/2003 -0500, Tom Lane wrote:
>pginfo <pginfo@t1.unisoftbg.com> writes:
>> I try to run vacuum full analyze on pg 7.3.1 but I get this messages:
>
>> NOTICE:  Child itemid in update-chain marked as unused - can't continue
>> repair_frag
>> ERROR:  Parent tuple was not found.
>
>I don't believe that's 7.3.anything.  Check the version again?
>
>> How can I solve the problem?
>
>If this is 7.2.*, you might find that updating to 7.2.4 (due out in a
>week) will fix it.  Otherwise I'd suggest dumping and reloading the
>table.
>
>                        regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster