<div dir="ltr"><div dir="ltr"><div dir="ltr">Hi Ishii-San<div><br></div><div>The build is failing after this commit, with undefined reference to `extract_message' error</div><div><br></div><div><div><font face="monospace, monospace">protocol/pool_process_query.o: In function `detect_idle_in_transaction_sesion_timeout_error':</font></div><div><font face="monospace, monospace">/home/usama/work/community/pgpool2/src/protocol/pool_process_query.c:4294: undefined reference to `extract_message'</font></div><div><font face="monospace, monospace">collect2: error: ld returned 1 exit status</font></div><div><font face="monospace, monospace">make[2]: *** [pgpool] Error 1</font></div></div><div><br></div><div>Thanks</div><div>Best Regards</div><div>Muhammad Usama</div><div><br></div></div><div class="gmail_quote"><div dir="ltr">On Thu, Dec 6, 2018 at 1:29 PM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Deal with "terminating connection due to idle-in-transaction timeout" error.<br>
<br>
If idle_in_transaction_session_timeout parameter is set to reasonably<br>
short in postgresql.conf, the fatal error easily occurs and the<br>
connection from Pgpool-II to backend is terminated. This leads to<br>
Pgpool-II either hang (if only one of PostgreSQL equips equips the<br>
parameter) or unwanted failover (if all PostgreSQL equips with the<br>
parameter), and both are not good. So intercept the message and send<br>
the same message to frontend then exit to terminate the connection to<br>
frontend. This is similar treatment as the error "connection was<br>
terminated due to conflict with recovery, User was holding a relation<br>
lock for too long."<br>
<br>
Per bug 448.<br>
<br>
Branch<br>
------<br>
V4_0_STABLE<br>
<br>
Details<br>
-------<br>
<a href="https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=3f5986eee360f12e6a0bb77aa46f95abf5f6bc10" rel="noreferrer" target="_blank">https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=3f5986eee360f12e6a0bb77aa46f95abf5f6bc10</a><br>
<br>
Modified Files<br>
--------------<br>
src/include/protocol/pool_proto_modules.h | 1 +<br>
src/protocol/pool_process_query.c | 25 +++++++++++++++++++++++++<br>
2 files changed, 26 insertions(+)<br>
<br>
_______________________________________________<br>
pgpool-committers mailing list<br>
<a href="mailto:pgpool-committers@pgpool.net" target="_blank">pgpool-committers@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-committers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-committers</a><br>
</blockquote></div></div></div>