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.
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 |