From: | "Sergey Konoplev" <gray(dot)ru(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_cancel_backend() does not work with buzz queries |
Date: | 2007-10-03 08:11:32 |
Message-ID: | c3a7de1f0710030111u460ca738lcebc427e3934b907@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-ru-general |
Hi all,
I often face with buzz queries (see below). I've looked through pg
manual and huge amount of forums and mail archives and found nothing.
The only solution is to restart postgres server. Moreover I have to
terminate the process using HUP signal to stop the server.
transport=# select version();
version
-------------------------------------------------------------------------------------
PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.3 (SuSE Linux)
(1 row)
transport=# select datname, usename, procpid, current_query::char(15),
waiting, query_start from pg_catalog.pg_stat_activity where procpid =
20530;
datname | usename | procpid | current_query | waiting |
query_start
-----------+------------------+---------+-----------------+---------+-------------------------------
transport | belostotskaya_la | 20530 | select * from c | f |
2007-10-02 05:05:28.908687+04
(1 row)
transport=# select pg_catalog.pg_cancel_backend(20530);
pg_cancel_backend
-------------------
t
(1 row)
transport=# select datname, usename, procpid, current_query::char(15),
waiting, query_start from pg_catalog.pg_stat_activity where procpid =
20530;
datname | usename | procpid | current_query | waiting |
query_start
-----------+------------------+---------+-----------------+---------+-------------------------------
transport | belostotskaya_la | 20530 | select * from c | f |
2007-10-02 05:05:28.908687+04
(1 row)
--
Regards,
Sergey Konoplev
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2007-10-03 08:25:41 | Re: Select too many ids.. |
Previous Message | joynes | 2007-10-03 08:10:57 | Re: Find out encoding of data |
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Konoplev | 2007-10-03 08:35:57 | pg_cancel_backend() не снимает зависшие транзакции |
Previous Message | Oleg Deribas | 2007-10-02 08:34:00 | Re: management of BLOBs |