backend closing unexpectedly

Started by Adam Kornickover 24 years ago2 messagesgeneral
Jump to latest
#1Adam Kornick
akornick@whgrp.com

Folks,

I have a moderately complex query running on small views (10-30
records) which used to work, but is now dying unexptecedly. The query
is via aolserver, but also creates the same response when using pgsql.

Within pgsql, I get:

pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Within aolserver, I get:

Error: dbinit: error(localhost::acs,pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.

I'm running postgresql-7.1.2-5PGDG, on RedHat 7.1...thoughts?

Thanks,

Adam

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Adam Kornick (#1)
Re: backend closing unexpectedly

Adam Kornick <akornick@whgrp.com> writes:

I have a moderately complex query running on small views (10-30
records) which used to work, but is now dying unexptecedly.

Sounds like a backend core dump. Please look for the core file
(should be under $PGDATA/base/yourdbnumber/) and send us a debugger
backtrace. You might have to recompile with --enable-debug to get
a useful (symbolic) backtrace.

If you are feeling out of your depth with that request, instead
put together a self-contained example that triggers the crash,
and send it along.

regards, tom lane