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

Re: postgres server crash

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Prabin Gade" <gade(at)pervasive-postgres(dot)com>,<pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: postgres server crash
Date: 2005-07-18 08:54:41
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C7783@algol.sollentuna.se (view raw or flat)
Thread:
Lists: 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

Next:From: frank churchDate: 2005-07-19 11:50:50
Subject: Manual installation of PostgreSQL 8
Previous:From: Petr JelinekDate: 2005-07-15 20:58:46
Subject: Re:

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