Re: postgres server crash - Mailing list pgsql-hackers-win32

From Magnus Hagander
Subject Re: postgres server crash
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C7783@algol.sollentuna.se
Whole thread Raw
In response to postgres server crash  ("Prabin Gade" <gade@pervasive-postgres.com>)
List pgsql-hackers-win32
> Hi all,
>
> I am running DBT2 benchmarks on a 4 way Win 2003 server when
> the postgres server process crashes. Then I tried on a 1 GB
> P4 desktop running XP and could reproduce the problem quite
> often. The error message is at the end of this mail.
>
> I did the following to dig more into the problem:
>
> *    The server crashes with default postgresql.conf parameters
> *    I tried to get more log info by turned few log params
> in postgresql.conf file and ran it for only 1 connection. To
> my surprise there was no crash and the entire DBT2 ran successfully.
> *    Then I started making the log params one by one default
> so that I can zero on the log param which is making it pass.
> I see turning log_min_error_statement to a debug level is not
> causing server crash for 1 connection.
> *    Then I tried to increase the no. of connections to 20
> and see that it crashes always.
>
> I had run the DBT2 tests on the same box on SLES 9.0 without
> any problems. Hence I suspect this is a win32 port problem.

Seems reasonable to expact that, yes :)


> It seems the server is crashing on a wait.

What makes you say this?
Any chance you could get a debugger attached to the crashing process and
show us where it dies?


//Magnus

pgsql-hackers-win32 by date:

Previous
From: Petr Jelinek
Date:
Subject: Re:
Next
From: frank church
Date:
Subject: Manual installation of PostgreSQL 8