The following bug has been logged online:
Bug reference: 5260
Logged by: Toni Helenius
Email address: toni.helenius@syncrontech.com
PostgreSQL version: 8.3.9
Operating system: Windows 2008 Server Enterprise
Description: Postgre crashed unexpectedly
Details:
Postgre database was running normally and several applications using it
normally like any other day. Then the Postge just died and didn't recover by
itself.. Here is the log:
2009-12-31 13:41:09 EET LOG: server process (PID 7020) was terminated by
exception 0xC0000005
2009-12-31 13:41:09 EET HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2009-12-31 13:41:09 EET LOG: terminating any other active server processes
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET WARNING: terminating connection because of crash of
another server process
2009-12-31 13:41:09 EET DETAIL: 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-12-31 13:41:09 EET HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2009-12-31 13:41:09 EET LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2009-12-31 13:41:09 EET FATAL: the database system is in recovery mode
2009-12-31 13:41:10 EET LOG: all server processes terminated;
reinitializing
2009-12-31 13:41:20 EET FATAL: pre-existing shared memory block is still in
use
2009-12-31 13:41:20 EET HINT: Check if there are any old server processes
still running, and terminate them.