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: pgsql-general(at)postgresql(dot)org
Subject: Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index
Date: 2009-07-06 05:58:51
Message-ID: d65fd1a40907052258w2ec20272jaafb039827389b53@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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

*2009-07-01 14:47:07.250 ISTSTATEMENT: insert into
MEVSERVICES(NSIP,EPTIME,VSVRSVCNAME,VSVRNAME,VSVRSVCENTITYTYPE) values
($1,$2,$3,$4,$5)*

This application has requested the Runtime to terminate it in an unusual
way.

Please contact the application's support team for more information.

*2009-07-01 14:47:08.609 ISTLOG: server process (PID 2204) exited with exit
code 3*

*2009-07-01 14:47:08.609 ISTLOG: terminating any other active server
processes*

*2009-07-01 14:47:08.640 ISTWARNING: terminating connection because of
crash of another server process*

*2009-07-01 14:47:08.640 ISTDETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.*

*2009-07-01 14:47:08.640 ISTHINT: In a moment you should be able to
reconnect to the database and repeat your command.*

*2009-07-01 14:47:08.687 ISTWARNING: terminating connection because of
crash of another server process*

*2009-07-01 14:47:08.687 ISTDETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.*

*2009-07-01 14:47:08.687 ISTHINT: In a moment you should be able to
reconnect to the database and repeat your command.*

*2009-07-01 14:47:08.828 ISTWARNING: terminating connection because of
crash of another server process*

*2009-07-01 14:47:08.828 ISTDETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.*

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The index is defined on a column of type varchar(100) . Is this is a bug
in postgres and is this related to the discussion mentioned in the thread
below:

http://www.mail-archive.com/pgsql-hackers(at)postgresql(dot)org/msg87557.html

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2009-07-06 06:15:03 Re: LIKE problem
Previous Message Juan Pablo Cook 2009-07-06 05:55:54 LIKE problem