| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Thomas Markus <t(dot)markus(at)proventis(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: infinite blocking statements in 8.2.3 |
| Date: | 2007-05-02 12:59:40 |
| Message-ID: | 20070502125940.GC4585@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2007-05-02 13:48:02 | Re: pg_user pg_shadow out of sync |
| Previous Message | Sandy Spence | 2007-05-02 10:55:51 | pg_user pg_shadow out of sync |