Re: Server process crashes when using count(field). - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Server process crashes when using count(field).
Date
Msg-id 20030329073515.P10874-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Server process crashes when using count(field).  (KroK <krok@void.ru>)
List pgsql-bugs
> netstat=> select count(*) from ruscan_current ;
>  count
> --------
>  194672
> (1 row)
>
> netstat=> select count(sld_id) from ruscan_current ;
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
> !>
>
> That's All !
>
> And there are no log messages  with this configureation of logging :
>
> server_min_messages = info
> client_min_messages = info
>
> There are only the following in logs :
>
> Mar 29 13:20:19 frost postgres[14486]: [7] LOG:  server process (pid 15079) was terminated by signal 11

Unless your ulimits are set up to disallow core files, this should have
generated a core file in the data directory for the database you were
connected to.  If you have one, please post a backtrace.  If not, set the
ulimits to allow core, restart the server and see if you can get it to
crash again with a core.

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #926: if old postgresql.jar in CLASSPATH, ant fails
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #927: Hardcoded paths in windows install (731a1)