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

On 2018-11-28 04:17, Tatsuo Ishii wrote:
> +                     errmsg("terminating connection due to idle-in-transaction timeout"),
> +                     errhint("In a moment you should be able to reconnect to the"
> +                             " database and repeat your command.")));

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.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services