Re: BUG #4897: PostgreSQL 8.3.7 crashes on Win2003 logoff - Mailing list pgsql-bugs

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