BUG #5965: PostgreSQL crashes during connection - Mailing list pgsql-bugs

From Daniel Migowski
Subject BUG #5965: PostgreSQL crashes during connection
Date
Msg-id 201104060945.p369jPKs053819@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5965: PostgreSQL crashes during connection  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5965
Logged by:          Daniel Migowski
Email address:      dmigowski@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 :).

pgsql-bugs by date:

Previous
From: Joseph Adams
Date:
Subject: Re: BUG #5963: make -j4 check fails
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #5965: PostgreSQL crashes during connection