[pgpool-committers: 5389] 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
------
V3_5_STABLE

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

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