vacuum full analyze problem

Started by pginfoover 23 years ago3 messagesgeneral
Jump to latest
#1pginfo
pginfo@t1.unisoftbg.com

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: pginfo (#1)
Re: vacuum full analyze problem

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

#3Medi Montaseri
medi.montaseri@intransa.com
In reply to: pginfo (#1)
Re: vacuum full analyze problem

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:

Show quoted text

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