Re: Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index

From: CM J <postgres(dot)newbie(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index
Date: 2009-07-08 04:33:57
Message-ID: d65fd1a40907072133g4e08d99bk637f415f7afa6e35@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>Sounds like a data corruption problem

After reindexing, the problem seems to go away. Is there any way to
determine what caused the data corruption in the first place ??

Thanks.

On Mon, Jul 6, 2009 at 8:29 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> CM J <postgres(dot)newbie(at)gmail(dot)com> writes:
> > I am running Postgres 8.3.7 on Windows 2003 with my java
> > application.Off late, the server crashes with the following trace:
>
> > *2009-07-01 14:47:07.250 ISTPANIC: failed to add item to the right
> sibling
> > in index "mevservices2_ndx"*
>
> Sounds like a data corruption problem ... try reindexing that index.
>
> regards, tom lane
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yar Tikhiy 2009-07-08 05:17:44 Re: Warm standby: 1 to N
Previous Message Tim Uckun 2009-07-08 02:28:15 Re: Replication