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

Re: pg_cancel_backend() не снимает зависшие транзакции

From: Заяц Алексей <az(at)antora(dot)ru>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: pgsql-ru-general(at)postgresql(dot)org
Subject: Re: pg_cancel_backend() не снимает зависшие транзакции
Date: 2007-10-03 09:13:43
Message-ID: 47035D47.4020504@antora.ru (view raw or flat)
Thread:
Lists: pgsql-ru-general
Sergey Konoplev пишет:
> transport=# select datname, usename, procpid, current_query::char(15),
> waiting, query_start from pg_catalog.pg_stat_activity where procpid =
> 20530;
Покажи полностью:
select * from pg_catalog.pg_stat_activity;
select * from pg_catalog.pg_locks ;

Может там какие-нить функции используются, которые не умеют
CHECK_FOR_INTERRUPTS ?

-- 
С уважением,
Алексей Заяц.


In response to

Responses

pgsql-ru-general by date

Next:From: Richard HuxtonDate: 2007-10-03 10:18:32
Subject: Re: pg_cancel_backend() does not work with buzz queries
Previous:From: Nick GazaloffDate: 2007-10-03 09:12:23
Subject: Re: pg_cancel_backend() не снимает зависшие транзакции

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