Re: PANIC : right sibling's left-link doesn't match

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ow Mun Heng" <ow(dot)mun(dot)heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PANIC : right sibling's left-link doesn't match
Date: 2009-10-20 15:09:11
Message-ID: 27504.1256051351@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ow Mun Heng" <ow(dot)mun(dot)heng(at)wdc(dot)com> writes:
> [resend w/ plain text only - Sorry]
> right sibling's left-link doesn't match: block 121425 links to 124561
> instead of expected 121828 in index
> Oct 20 22:21:29 hmweb5 postgres[8795]: [3-2] "d_trh_trr_water_eval_pkey"

> What does the above mean?

It means you've got a corrupted index. REINDEX will probably fix it.
You should try to figure out what caused the problem though ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Waldomiro 2009-10-20 15:22:30 Sharedbuffers and WorkMem
Previous Message David Fetter 2009-10-20 14:57:57 Re: Free Tool to design Postgres Databases