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

[Tatsuo Ishii]

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
------
V4_0_STABLE

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

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