Re: query that canceled isnt logged

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: query that canceled isnt logged
Дата
Msg-id 5943.1575819720@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: query that canceled isnt logged  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-performance
Mariel Cherkassky <mariel.cherkassky@gmail.com> writes:
> If I'll try to run the following query and cancel it manually(ctrl+c) :
> select pg_sleep(10)
> I will see in the logs the following messages :

> 2019-12-08 17:16:34 IST postgres 30797  LOG:  statement: select
> pg_sleep(10);
> 2019-12-08 17:16:36 IST postgres 30797  ERROR:  canceling statement due to
> user request
> 2019-12-08 17:16:36 IST postgres 30797  STATEMENT:  select pg_sleep(10);

Note that that's going through "simple query" protocol (which is why
it says "statement:") but your application is evidently using "extended
query" protocol (because you see "execute ...:", at least when it's
working correctly).  I wonder whether the explanation is somewhere in
that.

The best theory I have at the moment, though, is that something is taking
exclusive locks on system catalogs, blocking parsing of even trivial
statements.

            regards, tom lane



В списке pgsql-performance по дате отправления:

Предыдущее
От: Mariel Cherkassky
Дата:
Сообщение: Re: query that canceled isnt logged
Следующее
От: Lars Aksel Opsahl
Дата:
Сообщение: Re: How to run in parallel in Postgres, EXECUTE_PARALLEL