Skip site navigation (1) Skip section navigation (2)

BUG #5965: PostgreSQL crashes during connection

From: "Daniel Migowski" <dmigowski(at)ikoffice(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5965: PostgreSQL crashes during connection
Date: 2011-04-06 09:45:25
Message-ID: 201104060945.p369jPKs053819@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

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

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2011-04-06 13:20:17
Subject: Re: [BUGS] Non Win/*nix UTF-8 codepage not known to PostgreSQL developers?!
Previous:From: Joseph AdamsDate: 2011-04-05 20:31:35
Subject: Re: BUG #5963: make -j4 check fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group