Re: PANIC: right sibling

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Scott Whitney <swhitney(at)journyx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PANIC: right sibling
Date: 2007-12-04 18:05:57
Message-ID: 20071204180557.GG4727@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Scott Whitney wrote:
> I don't really understand the postings I've found on this issue. This has
> been going on for quite some time, but now that I'm regularly vacuuming this
> db, I was looking for any info on how to fix this problem...I don't even
> know enough about it to know what to include in this message.

Probably a REINDEX on the corrupted index would solve it.

I'm not sure if there's a known bug in the version you're using. If
there is, obviously you should upgrade to a fixed one. Otherwise you
may be able to help us find it by saving the corrupted index before
reindexing it, for examination.

--
Alvaro Herrera Developer, http://www.PostgreSQL.org/
"The only difference is that Saddam would kill you on private, where the
Americans will kill you in public" (Mohammad Saleh, 39, a building contractor)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aldor 2007-12-04 19:37:28 Re: Cannot kill autovacuum
Previous Message Kenneth Marshall 2007-12-04 18:03:55 Re: PANIC: right sibling