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
pgsql-jdbc by date
|Next:||From: zhyu 86||Date: 2006-10-12 21:42:01|
|Subject: MBC user cannot connect to server|
|Previous:||From: Michael Goldner||Date: 2006-10-11 19:09:16|
|Subject: Re: "Hanging Connection" blocks access to table (JBossMQ) |