The following bug has been logged online: Bug reference: 5965 Logged by: Daniel Migowski Email address: dmigow...@ikoffice.de PostgreSQL version: 8.3.9 Operating system: Windows 7 Description: PostgreSQL crashes during connection Details:
Hi, My PostgreSQL server just crashed during an attempt to connect to it (multiple times at once, a connection pool just started up). These lines were found in the logfile afterwards: 2011-04-06 11:38:03 CEST [2860] LOG: server process (PID 19812) was terminated by exception 0xC000012D 2011-04-06 11:38:03 CEST [2860] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2011-04-06 11:38:03 CEST [2860] LOG: terminating any other active server processes 2011-04-06 11:38:03 CEST [12208] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [12208] 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. 2011-04-06 11:38:03 CEST [12208] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [23548] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [23548] 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. 2011-04-06 11:38:03 CEST [23548] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [24024] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [24024] 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. 2011-04-06 11:38:03 CEST [24024] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [120] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [120] 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. 2011-04-06 11:38:03 CEST [120] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [10948] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [10948] 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. 2011-04-06 11:38:03 CEST [10948] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [26172] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [26172] 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. 2011-04-06 11:38:03 CEST [26172] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [12176] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [12176] 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. 2011-04-06 11:38:03 CEST [12176] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [3420] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [3420] 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. 2011-04-06 11:38:03 CEST [3420] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [11184] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [11184] 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. 2011-04-06 11:38:03 CEST [11184] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [7664] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [7664] 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. 2011-04-06 11:38:03 CEST [7664] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [23716] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [23716] 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. 2011-04-06 11:38:03 CEST [23716] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [15424] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [15424] 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. 2011-04-06 11:38:03 CEST [15424] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [18384] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [18384] 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. 2011-04-06 11:38:03 CEST [18384] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [9272] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [9272] 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. 2011-04-06 11:38:03 CEST [9272] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [13448] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [13448] 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. 2011-04-06 11:38:03 CEST [13448] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:03 CEST [14496] WARNING: terminating connection because of crash of another server process 2011-04-06 11:38:03 CEST [14496] 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. 2011-04-06 11:38:03 CEST [14496] HINT: In a moment you should be able to reconnect to the database and repeat your command. 2011-04-06 11:38:04 CEST [15020] LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-04-06 11:38:04 CEST [13480] LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-04-06 11:38:04 CEST [20124] LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-04-06 11:38:04 CEST [17376] LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-04-06 11:38:04 CEST [13480] LOG: connection received: host=helena.ikoffice.de port=58369 2011-04-06 11:38:04 CEST [20124] LOG: connection received: host=helena.ikoffice.de port=58371 2011-04-06 11:38:04 CEST [20124] FATAL: the database system is in recovery mode 2011-04-06 11:38:04 CEST [13480] FATAL: the database system is in recovery mode 2011-04-06 11:38:04 CEST [17376] LOG: connection received: host=helena.ikoffice.de port=58370 2011-04-06 11:38:04 CEST [17376] FATAL: the database system is in recovery mode 2011-04-06 11:38:04 CEST [2860] LOG: all server processes terminated; reinitializing 2011-04-06 11:38:04 CEST [2860] FATAL: could not create shared memory segment: 1455 2011-04-06 11:38:04 CEST [2860] DETAIL: Failed system call was CreateFileMapping(size=787668992, name=Global/PostgreSQL:C:/Program Files/PostgreSQL/8.3/data). I get these crashes occasionally, and don't know if they have been fixed in a later version. Sorry for not using the bleeding edge version :). -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
