Postgres 9.1 and 9.2 crashing with exit code 9

From: Tony Kurz <tony(dot)kurz(at)joulex(dot)net>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Postgres 9.1 and 9.2 crashing with exit code 9
Date: 2013-02-12 12:39:15
Message-ID: DBD2452DADA9F24286C985F92B31F988572536E8A5@EXMBOX5.hosting.inetserver.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello Guys

I have following situation:

PostgreSQL Database 9.1 32 Bit is crashing immediately, it's an Windows 2008R2.
I have patched to 9.2 64Bit, but is crashing with the same Exit code

What is "exit code 9"??
Here is an cut from the postgres.log

013-01-31 14:42:08 CETCONTEXT: automatic vacuum of table "cloud.public.m201301_devicestatus"2013-01-31 14:43:14 CETLOG: server process (PID 5820) exited with exit code 9
2013-01-31 14:43:14 CETLOG: terminating any other active server processes
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:14 CETWARNING: terminating connection because of crash of another server process
2013-01-31 14:43:14 CETDETAIL: 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.
2013-01-31 14:43:14 CETHINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-01-31 14:43:15 CETLOG: all server processes terminated; reinitializing
2013-01-31 14:43:24 CETFATAL: pre-existing shared memory block is still in use
2013-01-31 14:43:24 CETHINT: Check if there are any old server processes still running, and terminate them.

We have an active antivirus scanner, but we excluding the PostgreSQL folders where are the data folder locate is.

Hope any one can help
Best regards

Tony

Browse pgsql-bugs by date

  From Date Subject
Next Message bernardjech 2013-02-12 16:39:42 BUG #7869: Expressions in a view for rows that are not part of the view result set are still evaluated
Previous Message kensanmail 2013-02-12 07:57:56 BUG #7868: Different class on numeric number through PgOleDb-1.0.0.20