Postgres Pro
Downloads
Home   >   mailing lists

Re: infinite blocking statements in 8.2.3 - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: infinite blocking statements in 8.2.3
Date
Msg-id 20070502125940.GC4585@alvh.no-ip.org
Whole thread Raw
In response to infinite blocking statements in 8.2.3  (Thomas Markus <t.markus@proventis.net>)
List pgsql-admin
Tree view 
Thomas Markus wrote:
> I'm running 8.2.3 on ubuntu 6.06 (2.6.15-26-server SMP i686)
>
> sometimes i have SELECTs that never ends. Normally I drop connections by
> killing the connection process (kill <PID>). But these hanging
> connections (which blocks other statements infinitly) cant be killed.

What are they doing?  We've added interrupt checks in most of the loops,
so queries can normally be killed quickly, but maybe we've missed just
the one you're running.


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: "Srinivas Kotapally"
Date:
Subject: Re: Intermittent Postgres Connection refused Errors (JDBC)
Next
From: Michael Fuhr
Date:
Subject: Re: pg_user pg_shadow out of sync