Re: vacuum problem - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuum problem
Date
Msg-id 24490.1043272184@sss.pgh.pa.us
Whole thread Raw
In response to vacuum problem  (pginfo <pginfo@t1.unisoftbg.com>)
Responses Re: vacuum problem
List pgsql-general
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

pgsql-general by date:

Previous
From: Björn Metzdorf
Date:
Subject: Re: sort by relevance
Next
From: will trillich
Date:
Subject: HOW-TO do incomplete dates: year, optional month, optional day?