[pgpool-committers: 5387] pgpool: Deal with "terminating connection due to idle-in-transaction ti

Tatsuo Ishii ishii at sraoss.co.jp
Thu Dec 6 17:29:23 JST 2018


Deal with "terminating connection due to idle-in-transaction timeout" error.

If idle_in_transaction_session_timeout parameter is set to reasonably
short in postgresql.conf, the fatal error easily occurs and the
connection from Pgpool-II to backend is terminated. This leads to
Pgpool-II either hang (if only one of PostgreSQL equips equips the
parameter) or unwanted failover (if all PostgreSQL equips with the
parameter), and both are not good. So intercept the message and send
the same message to frontend then exit to terminate the connection to
frontend. This is similar treatment as the error "connection was
terminated due to conflict with recovery, User was holding a relation
lock for too long."

Per bug 448.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=9ad425a5903505c6eca1fa18bbb0ef1dc17a8a60

Modified Files
--------------
src/include/protocol/pool_proto_modules.h |  1 +
src/protocol/pool_process_query.c         | 25 +++++++++++++++++++++++++
2 files changed, 26 insertions(+)



More information about the pgpool-committers mailing list