backend closing unexpectedly
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
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