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

[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"


WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the
current transaction and exit, because
WARNING:  terminating connection because of crash of another server process

What does the above mean?

This is causing DB to have bad reactions.

Thanks.

Is there an index error? Should I drop and re-create the index is it?

"Ow Mun Heng" <ow.mun.heng@wdc.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