Re: [PHPLIB] Postgres closes the channel; missing semicolon? From: Darryl Ross (djr <email protected>)
Date: 02/29/00

On Tue, 29 Feb 2000, Peter H. Lemieux wrote:

> I persistently get errors using PHPLIB 6.1 and PostgreSQL 6.4.2 like the
> following:
>
> Database error: Invalid SQL: select val from active_sessions where sid =
> 'f7a87f43986541c11df15faa96ddbe79' and name = 'Poe_Session'
> PostgreSQL Error: 1 (PQexec() -- Request was sent to backend, but backend
> closed
> the channel before responding. This probably means the backend terminated
> abnormally
> before or while processing the request. )
> Session halted.

I've had this error before usually during development. I'm not sure
exactly what causes it, but I think it is more of a postgres problem than
anything else. Try a ps -aux or something and look for any postgres
related processes (eg postmaster) that have been running for a long time.

Anyway my solution is to restart the postgres database server.

________________________________________________________________
   Darryl Ross <djr <email protected>> Cybersource Pty. Ltd.
     Web/Database Integration and Development
+61 3 9642 5997 Level 8, 140 Queen Street, Melbourne Australia

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.