Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx/msg87557.html

 Thanks.


 




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux