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

[Muhammad Usama]

Hi Ishii-San

The build is failing after this commit, with undefined reference to
`extract_message' error

protocol/pool_process_query.o: In function
`detect_idle_in_transaction_sesion_timeout_error':
/home/usama/work/community/pgpool2/src/protocol/pool_process_query.c:4294:
undefined reference to `extract_message'
collect2: error: ld returned 1 exit status
make[2]: *** [pgpool] Error 1

Thanks
Best Regards
Muhammad Usama

On Thu, Dec 6, 2018 at 1:29 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> 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(+)
>
> _______________________________________________
> pgpool-committers mailing list
> pgpool-committers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-committers
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-committers/attachments/20181207/ef1156cd/attachment.html>