Thread: BUG #4897: PostgreSQL 8.3.7 crashes on Win2003 logoff

BUG #4897: PostgreSQL 8.3.7 crashes on Win2003 logoff

From

"Gerhard Leykam"

Date:

01 July 2009, 08:47:59

The following bug has been logged online:

Bug reference:      4897
Logged by:          Gerhard Leykam
Email address:      gel123@sealsystems.de
PostgreSQL version: 8.3.7.1
Operating system:   Windows Server 2003 SP2
Description:        PostgreSQL 8.3.7 crashes on Win2003 logoff
Details:

Hi!

That's what i have done:

Installed postgresql-8.3.7-1-windows.exe on Windows Server 2003 SP2 with one
click installer.

Create some load on the machine by running example program testlibpq.exe a
lot from a remote host. This is done by a perl script re-running
testlibpq.exe in an endless loop started 20 times.

Logoff remote desktop connection from WinSrv2003: CRASH

2009-07-01 10:15:02.515 CEST LOG:  Serverprozess (PID 2512) beendete mit
Status 128
2009-07-01 10:15:02.515 CEST LOG:  aktive Serverprozesse werden abgebrochen
2009-07-01 10:15:02.734 CEST LOG:  alle Serverprozesse beendet;
initialisiere neu
2009-07-01 10:15:03.734 CEST FATAL:  bereits bestehender Shared-Memory-Block
wird noch benutzt
2009-07-01 10:15:03.734 CEST TIPP:  PrÃ¼fen Sie, ob irgendwelche alten
Serverprozesse noch laufen und beenden Sie diese.

No postgres process running any more.
Old 8.3.5 used before even can not be restarted!!! Server boot is
necessary!
But the 8.3.7 can be restarted and crashes again by repeating above
scenario:

2009-07-01 10:16:36.281 CEST LOG:  database system was interrupted; last
known up at 2009-07-01 10:13:53 CEST
2009-07-01 10:16:36.343 CEST LOG:  database system was not properly shut
down; automatic recovery in progress
2009-07-01 10:16:36.453 CEST LOG:  record with zero length at 0/4A9AF0
2009-07-01 10:16:36.453 CEST LOG:  redo is not required
2009-07-01 10:16:36.609 CEST FATAL:  the database system is starting up
2009-07-01 10:16:36.656 CEST LOG:  Datenbanksystem ist bereit um
Verbindungen anzunehmen
2009-07-01 10:16:36.703 CEST LOG:  autovacuum launcher started
2009-07-01 10:17:35.515 CEST LOG:  Serverprozess (PID 2756) beendete mit
Status 128
2009-07-01 10:17:35.515 CEST LOG:  aktive Serverprozesse werden abgebrochen
2009-07-01 10:17:35.703 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.796 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.796 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.812 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.812 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.812 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.828 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.828 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.828 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.843 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.843 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.843 CEST FATAL:  the database system is in recovery
mode
2009-07-01 10:17:35.953 CEST LOG:  alle Serverprozesse beendet;
initialisiere neu
2009-07-01 10:17:36.953 CEST FATAL:  bereits bestehender Shared-Memory-Block
wird noch benutzt
2009-07-01 10:17:36.953 CEST TIPP:  PrÃ¼fen Sie, ob irgendwelche alten
Serverprozesse noch laufen und beenden Sie diese.

Sorry for the German/English log message mixture, but selecting English
during installation didn't fix it?!

The crash seems to be related to CreateProcess-Calls for new clients
arriving and Windows Logoff handling. Sometimes postgres.exe reports system
error 0xc0000142: Some ressources are missing.

Bye,
  Gerhard Leykam

Re: BUG #4897: PostgreSQL 8.3.7 crashes on Win2003 logoff

From

Gerhard Leykam

Date:

07 July 2009, 03:51:59

Hi!

There is a known Logoff/CreateProcess problem at MS:=20
http://support.microsoft.com/kb/960266/en-us

But even installing this hotfix didn't solve the problem.

Nobody out there with an idea?

Bye
   Gerhard Leykam


Gerhard Leykam schrieb:
> The following bug has been logged online:
>=20
> Bug reference:      4897
> Logged by:          Gerhard Leykam
> Email address:      gel123@sealsystems.de
> PostgreSQL version: 8.3.7.1
> Operating system:   Windows Server 2003 SP2
> Description:        PostgreSQL 8.3.7 crashes on Win2003 logoff
> Details:=20
>=20
> Hi!
>=20
> That's what i have done:
>=20
> Installed postgresql-8.3.7-1-windows.exe on Windows Server 2003 SP2 with =
one
> click installer.
>=20
> Create some load on the machine by running example program testlibpq.exe a
> lot from a remote host. This is done by a perl script re-running
> testlibpq.exe in an endless loop started 20 times.
>=20
> Logoff remote desktop connection from WinSrv2003: CRASH
>=20
> 2009-07-01 10:15:02.515 CEST LOG:  Serverprozess (PID 2512) beendete mit
> Status 128
> 2009-07-01 10:15:02.515 CEST LOG:  aktive Serverprozesse werden abgebroch=
en
> 2009-07-01 10:15:02.734 CEST LOG:  alle Serverprozesse beendet;
> initialisiere neu
> 2009-07-01 10:15:03.734 CEST FATAL:  bereits bestehender Shared-Memory-Bl=
ock
> wird noch benutzt
> 2009-07-01 10:15:03.734 CEST TIPP:  Pr=C3=BCfen Sie, ob irgendwelche alten
> Serverprozesse noch laufen und beenden Sie diese.
>=20
> No postgres process running any more.
> Old 8.3.5 used before even can not be restarted!!! Server boot is
> necessary!
> But the 8.3.7 can be restarted and crashes again by repeating above
> scenario:
>=20
> 2009-07-01 10:16:36.281 CEST LOG:  database system was interrupted; last
> known up at 2009-07-01 10:13:53 CEST
> 2009-07-01 10:16:36.343 CEST LOG:  database system was not properly shut
> down; automatic recovery in progress
> 2009-07-01 10:16:36.453 CEST LOG:  record with zero length at 0/4A9AF0
> 2009-07-01 10:16:36.453 CEST LOG:  redo is not required
> 2009-07-01 10:16:36.609 CEST FATAL:  the database system is starting up
> 2009-07-01 10:16:36.656 CEST LOG:  Datenbanksystem ist bereit um
> Verbindungen anzunehmen
> 2009-07-01 10:16:36.703 CEST LOG:  autovacuum launcher started
> 2009-07-01 10:17:35.515 CEST LOG:  Serverprozess (PID 2756) beendete mit
> Status 128
> 2009-07-01 10:17:35.515 CEST LOG:  aktive Serverprozesse werden abgebroch=
en
> 2009-07-01 10:17:35.703 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.796 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.796 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.812 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.812 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.812 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.828 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.828 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.828 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.843 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.843 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.843 CEST FATAL:  the database system is in recovery
> mode
> 2009-07-01 10:17:35.953 CEST LOG:  alle Serverprozesse beendet;
> initialisiere neu
> 2009-07-01 10:17:36.953 CEST FATAL:  bereits bestehender Shared-Memory-Bl=
ock
> wird noch benutzt
> 2009-07-01 10:17:36.953 CEST TIPP:  Pr=C3=BCfen Sie, ob irgendwelche alten
> Serverprozesse noch laufen und beenden Sie diese.
>=20
> Sorry for the German/English log message mixture, but selecting English
> during installation didn't fix it?!
>=20
> The crash seems to be related to CreateProcess-Calls for new clients
> arriving and Windows Logoff handling. Sometimes postgres.exe reports syst=
em
> error 0xc0000142: Some ressources are missing.
>=20
> Bye,
>   Gerhard Leykam