Re: Log query parameters for terminated execute

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: Log query parameters for terminated execute
Дата
Msg-id 16162831532340351@sas1-640e2cc17194.qloud-c.yandex.net
обсуждение исходный текст
Ответ на Re: Log query parameters for terminated execute  (Ibrar Ahmed <ibrar.ahmad@gmail.com>)
Ответы Re: Log query parameters for terminated execute  (Ibrar Ahmed <ibrar.ahmad@gmail.com>)
Список pgsql-hackers
Hello
Thank you for review!
Well, i can miss some cases. I'm not sure about overall design of this patch. Is acceptable add errdetail_params to
statement_timeoutereport in such way?
 

After shutdown signal we must be in aborted state, so we mustn't call user-defined I/O functions. (quotation from
commentto errdetail_params in src/backend/tcop/postgres.c ). It seems i can not fix it with current design.
 

> ERROR:  canceling statement due to lock timeout at character 13
Hm, "at character"? How can we get this message? I found only "canceling statement due to lock timeout" (without "at
character")ereport in src/backend/tcop/postgres.c
 
Maybe try .. catch in parse state, not in execute?

regards, Sergei


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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: Expression errors with "FOR UPDATE" and postgres_fdw withpartition wise join enabled.
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Possible performance regression in version 10.1 with pgbenchread-write tests.