Thread: BUG #5442: Postgres crash when closing a "/console" mstsc session

The following bug has been logged online:

Bug reference:      5442
Logged by:
Email address:      sdelforge@free.fr
PostgreSQL version: 8.4.3
Operating system:   Windows 2003
Description:        Postgres crash when closing a "/console" mstsc session
Details:

Hello,

I have nearly the same bug than "BUG #5305", but it occurs only with
/console mode.

Postgres is working as a windows service under the "postgres" user. We log
on the Windows server by using mstsc and we have sometimes a crash of a
prostgres process with "Exit code 128" which stop the postgres service.
After analysing, we saw that the crash occurs only when the "\console"
session stop (but not every time).

We are able to reproduce this crash:
1- Open an mstsc Windows session with "\console" and user Administrator
2- Open a standard mstsc Windows session with antoher user
3- In this new session, execute a process which is doing some requests on
the database and at the same time execute a database backup with pgAdmin
4- Close the "\console" session

Could you help?
Thanks

Re: BUG #5442: Postgres crash when closing a "/console" mstsc session

From
"Juan C. Aragon"
Date:
I have same problem with one of my servers, but never found the solution.
PostgreSQL version: 8.4.1
Operating system:   Windows 2003 Enterprise

Juan C. Aragon
-----Original Message-----
From: pgsql-bugs-owner@postgresql.org [mailto:pgsql-bugs-owner@postgresql.o=
rg] On Behalf Of sdelforge@free.fr
Sent: Thursday, April 29, 2010 8:27 AM
To: pgsql-bugs@postgresql.org
Subject: [BUGS] BUG #5442: Postgres crash when closing a "/console" mstsc s=
ession


The following bug has been logged online:

Bug reference:      5442
Logged by:=20=20=20=20=20=20=20=20=20=20
Email address:      sdelforge@free.fr
PostgreSQL version: 8.4.3
Operating system:   Windows 2003
Description:        Postgres crash when closing a "/console" mstsc session
Details:=20

Hello,

I have nearly the same bug than "BUG #5305", but it occurs only with
/console mode.

Postgres is working as a windows service under the "postgres" user. We log
on the Windows server by using mstsc and we have sometimes a crash of a
prostgres process with "Exit code 128" which stop the postgres service.=20
After analysing, we saw that the crash occurs only when the "\console"
session stop (but not every time).

We are able to reproduce this crash:
1- Open an mstsc Windows session with "\console" and user Administrator
2- Open a standard mstsc Windows session with antoher user
3- In this new session, execute a process which is doing some requests on
the database and at the same time execute a database backup with pgAdmin=20
4- Close the "\console" session

Could you help?
Thanks

--=20
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: BUG #5442: Postgres crash when closing a "/console" mstsc session

From
Craig Ringer
Date:
On 29/04/2010 8:26 PM, sdelforge@free.fr wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5442
> Logged by:
> Email address:      sdelforge@free.fr
> PostgreSQL version: 8.4.3
> Operating system:   Windows 2003
> Description:        Postgres crash when closing a "/console" mstsc session
> Details:
>
> Hello,
>
> I have nearly the same bug than "BUG #5305", but it occurs only with
> /console mode.
>
> Postgres is working as a windows service under the "postgres" user. We log
> on the Windows server by using mstsc and we have sometimes a crash of a
> prostgres process with "Exit code 128" which stop the postgres service.
> After analysing, we saw that the crash occurs only when the "\console"
> session stop (but not every time).
>
> We are able to reproduce this crash:
> 1- Open an mstsc Windows session with "\console" and user Administrator
> 2- Open a standard mstsc Windows session with antoher user
> 3- In this new session, execute a process which is doing some requests on
> the database and at the same time execute a database backup with pgAdmin
> 4- Close the "\console" session

Is there any chance you can follow these instructions:

http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows

and get a backtrace of the crash?

--
Craig Ringer