Postgres Pro
Downloads
Home   >   mailing lists

Thread: vacuum full analyze problem

vacuum full analyze problem

From
pginfo
Date:
Hi,

I am using pg 7.2.3.

If I try to start vacuum full analyze the postgresql works some time and
stops with this message:

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

Where can I find more info about the problem and how to solve it?

regards.

Re: vacuum full analyze problem

From
Tom Lane
Date:
pginfo <pginfo@t1.unisoftbg.com> writes:
> I am using pg 7.2.3.

> If I try to start vacuum full analyze the postgresql works some time and
> stops with this message:

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

Ignore it (it's only a NOTICE) until you get around to updating to 7.3.

            regards, tom lane

Re: vacuum full analyze problem

From
Medi Montaseri
Date:
What vacuum-ing related feature or fix is available in 7.3....
I have been having problems with vacuum-ing (leading to crashes)....is
7.3 fixing some
vacuum-ing related bugs.....

Tom Lane wrote:

>pginfo <pginfo@t1.unisoftbg.com> writes:
>
>
>>I am using pg 7.2.3.
>>
>>
>
>
>
>>If I try to start vacuum full analyze the postgresql works some time and
>>stops with this message:
>>
>>
>
>
>
>>NOTICE:  Child itemid in update-chain marked as unused - can't continue
>>repair_frag.
>>
>>
>
>Ignore it (it's only a NOTICE) until you get around to updating to 7.3.
>
>            regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>