Postgres Pro
Downloads
Home   >   mailing lists

Re: "Hanging Connection" blocks access to table (JBossMQ) - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: "Hanging Connection" blocks access to table (JBossMQ)
Date
Msg-id 13679.1160594122@sss.pgh.pa.us
Whole thread Raw
In response to Re: "Hanging Connection" blocks access to table (JBossMQ)  (Michael Goldner <mgoldner@agmednet.com>)
Responses Re: "Hanging Connection" blocks access to table (JBossMQ)
List pgsql-jdbc
Tree view 
Michael Goldner <mgoldner@agmednet.com> writes:
> When I shutdown Jboss, the idle process disappears, but the 2 "INSERT
> waiting" processes remain indefinitely.

Ah.  That makes sense, because a backend blocked partway through a query
isn't going to notice its client disconnecting.  The question here
though is still "what are they waiting for?".  See pg_locks.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Michael Goldner
Date:
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Next
From: zhyu 86
Date:
Subject: MBC user cannot connect to server