backend closed

Started by Charlesabout 24 years ago3 messagesgeneral
Jump to latest
#1Charles
charles@a3a.com.br

Hi folks

when i start a select sql in my postgres db, its return
a message:
pqReadData() -- backend closed the channel unexpectedly..

the select consist in a "not exists" term.

Ps. I haved vacuum the database with no errors.

anybody know, how i can resolve this ?

Regards
Charles

#2Doug McNaught
doug@wireboard.com
In reply to: Charles (#1)
Re: backend closed

Charles <charles@a3a.com.br> writes:

Hi folks

when i start a select sql in my postgres db, its return
a message:
pqReadData() -- backend closed the channel unexpectedly..

Sounds like the backend may be crashing, which indicates a bug or
possible data corruption. Check your postmaster logs for error
messages, and see if there are any coredumps in your data directory.

What version are you running?

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Charles (#1)
Re: backend closed

Charles <charles@a3a.com.br> writes:

when i start a select sql in my postgres db, its return
a message:
pqReadData() -- backend closed the channel unexpectedly..

Can't help you without seeing the exact command, and the schema
declarations for the tables it uses.

Also, which PG version are you using? (If it's less than 7.1,
the answer is probably going to be "time to update".)

regards, tom lane