Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[GENERAL] PANIC : right sibling's left-link doesn't match

627 views
Skip to first unread message

Ow Mun Heng

unread,
Oct 20, 2009, 10:30:35 AM10/20/09
to

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.

 

 

 

Ow Mun Heng

unread,
Oct 20, 2009, 10:31:47 AM10/20/09
to
[resend w/ plain text only - Sorry]

Thanks.

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


--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Tom Lane

unread,
Oct 20, 2009, 11:09:11 AM10/20/09
to
"Ow Mun Heng" <ow.mu...@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

0 new messages