RE: idle-in-transaction timeout error does not give a hint

Поиск
Список
Период
Сортировка
От Ideriha, Takeshi
Тема RE: idle-in-transaction timeout error does not give a hint
Дата
Msg-id 4E72940DA2BF16479384A86D54D0988A6F46B341@G01JPEXMBKW04
обсуждение исходный текст
Ответ на Re: idle-in-transaction timeout error does not give a hint  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: idle-in-transaction timeout error does not give a hint  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список pgsql-hackers
>From: Tatsuo Ishii [mailto:ishii@sraoss.co.jp]
>
>> Personally, I don't find this hint particularly necessary.  The
>> session was terminated because nothing was happening, so the real fix
>> on the application side is probably more involved than just retrying.
>> This is different from some of the other cases that were cited, such
>> as serialization conflicts, where you just got unlucky due to
>> concurrent events.  In the case of idle-in-transaction-timeout, the
>> fault is entirely your own.
>
>Hum. Sounds like a fair argument. Ideriha-san, what do you think?
>

Hi.
As Peter mentioned, application code generally needs to handle more things 
than retrying.
So I'm ok with not adding this hint.

Regards,
Takeshi Ideriha





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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: [HACKERS] Weaker shmem interlock w/o postmaster.pid
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: idle-in-transaction timeout error does not give a hint