Skip site navigation (1) Skip section navigation (2)

Re: "Hanging Connection" blocks access to table (JBossMQ)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Goldner <mgoldner(at)agmednet(dot)com>
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, Michael Goldner <mike(dot)goldner(at)comcast(dot)net>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Date: 2006-10-11 19:15:22
Message-ID: 13679.1160594122@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Michael Goldner <mgoldner(at)agmednet(dot)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

In response to

Responses

pgsql-jdbc by date

Next:From: zhyu 86Date: 2006-10-12 21:42:01
Subject: MBC user cannot connect to server
Previous:From: Michael GoldnerDate: 2006-10-11 19:09:16
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group