[pgpool-committers: 5386] pgpool: Deal with "terminating connection due to idle-in-transaction ti
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.
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