Horton
Menu

Thread

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

    V. M. <txian@hotmail.com> — 2001-07-12T09:41:14Z

    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


what i must do here?

thanks,
valter
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

    Bruce Momjian <pgman@candle.pha.pa.us> — 2001-07-12T14:27:33Z

    > 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

I would drop and recreate the index.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

    Tom Lane <tgl@sss.pgh.pa.us> — 2001-07-12T15:14:15Z

    "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