Horton
Menu

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "V. M." <txian@hotmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2001-07-12T15:14:15Z
Lists: pgsql-hackers 
"V. M." <txian@hotmail.com> writes:
> lindo=# vacuum analyze;
> NOTICE:  Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS 
> NOT THE SAME AS HEAP' (4).
> 	Recreate the index.
> NOTICE:  Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS 
> NOT THE SAME AS HEAP' (4).
> 	Recreate the index.
> NOTICE:  Child itemid in update-chain marked as unused - can't continue 
> repair_frag
> VACUUM

Interesting --- can you show us the sequence that got you into this
state?  A reproducible case that causes these messages would be very
useful for debugging.

> what i must do here?

Dumping and reloading the table should fix it, if nothing else does.

BTW, what Postgres version is this?

			regards, tom lane