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

[Tatsuo Ishii]

Sorry, my fault. Will fix.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

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