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

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

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Date: 2006-10-13 11:52:57
Message-ID: 452F7E19.5020800@logix-tt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi, Tom,

Tom Lane wrote:
> 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.

Is there any possibility that we make a backend realize this SIGIO (or
whatever it gets) when the connection is closed? I often had the problem
that I shut down my application, but the server kept working on that
query for a long time.

The same is for very long running C-Code functions (like PostGIS
geomUnion() on geometries with millions of vertices), those also tend to
block the backend for long times, without any possibility to kill it
except SIGKILL.

Thanks,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org

In response to

Responses

pgsql-jdbc by date

Next:From: zhyu 86Date: 2006-10-13 14:09:36
Subject: Re: MBC user cannot connect to server
Previous:From: Dave CramerDate: 2006-10-13 10:35:29
Subject: Re: Retrieving arrays

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