Re: Hung backends

"Schmidt, Peter" <peter.schmidt@prismedia.com> writes:
> The java frontend I'm using to test this scenario makes multiple connections
> and crashes(unhandled exception) before disconnecting. This appears to leave
> one "postgres" proccess for each connection. Can anyone point me in the
> right direction?
> SELECT version(); ->  PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.0

Hm.  I'd definitely recommend updating to 7.0.3 if you are using
unreliable clients, because 7.0.2 forgets to run its transaction-abort
routine if the client disconnects mid-transaction, with various
annoying consequences.  However, that wouldn't lead to the
above-described symptom.

It looks like the backends don't know that their clients have gone away,
which would suggest that the kernel is failing to deliver an EOF
indication on the socket connection.  Are you using TCP connections,
or Unix sockets?  Is there some other process that could be holding the
client end of the connection open?

            regards, tom lane