<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<p>Tatsuo,</p>
<p><br>
</p>
<p>we will test the fix. </p>
<p>Thank you for notifying!</p>
<p><br>
</p>
<p>Just wondering - is it linked to the problem which I notified you before:</p>
<p></p>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.337135+03:00 OAA-54999c4d7735 pgpool[18655]: [15820-1] LOG: DB node id: 0 backend pid: 18795 statement: Execute: COMMIT</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.337383+03:00 OAA-54999c4d7735 pgpool[18655]: [15820-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.337620+03:00 OAA-54999c4d7735 pgpool[18655]: [15821-1] LOG: DB node id: 1 backend pid: 9485 statement: Execute: COMMIT</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.337839+03:00 OAA-54999c4d7735 pgpool[18655]: [15821-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.338075+03:00 OAA-54999c4d7735 pgpool[18655]: [15822-1] LOG: DB node id: 0 backend pid: 18795 statement: DISCARD ALL</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.338291+03:00 OAA-54999c4d7735 pgpool[18655]: [15822-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.338402+03:00 OAA-54999c4d7735 pgpool[18655]: [15823-1] LOG: DB node id: 1 backend pid: 9485 statement: DISCARD ALL</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.338508+03:00 OAA-54999c4d7735 pgpool[18655]: [15823-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.338600+03:00 OAA-54999c4d7735 pgpool[18655]: [15824-1] LOG: DB node id: 0 backend pid: 18795 statement: BEGIN</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.338695+03:00 OAA-54999c4d7735 pgpool[18655]: [15824-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.338819+03:00 OAA-54999c4d7735 pgpool[18655]: [15825-1] LOG: DB node id: 1 backend pid: 9485 statement: BEGIN</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339000+03:00 OAA-54999c4d7735 pgpool[18655]: [15825-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339100+03:00 OAA-54999c4d7735 pgpool[18655]: [15826-1] LOG: DB node id: 0 backend pid: 18795 statement: DEALLOCATE "S_1"</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339200+03:00 OAA-54999c4d7735 pgpool[18655]: [15826-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339293+03:00 OAA-54999c4d7735 pgpool[18655]: [15827-1] LOG: <b><span style="color: rgb(255, 0, 0);">pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 18795 statement:
"DEALLOCATE "S_1"" message: "prepared statement "S_1" does not exist"</span></b></span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339382+03:00 OAA-54999c4d7735 pgpool[18655]: [15827-2] LOCATION: pool_proto_modules.c:3225</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339481+03:00 OAA-54999c4d7735 pgpool[18655]: [15828-1] LOG: DB node id: 1 backend pid: 9485 statement: DEALLOCATE "S_1"</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339580+03:00 OAA-54999c4d7735 pgpool[18655]: [15828-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339671+03:00 OAA-54999c4d7735 pgpool[18655]: [15829-1]
<b><span style="color: rgb(255, 0, 0);">LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 9485 statement: "DEALLOCATE "S_1"" message: "prepared statement "S_1" does not exist"</span></b></span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339763+03:00 OAA-54999c4d7735 pgpool[18655]: [15829-2] LOCATION: pool_proto_modules.c:3225</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339864+03:00 OAA-54999c4d7735 pgpool[18655]: [15830-1] LOG: DB node id: 1 backend pid: 9485 statement: COMMIT</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.339978+03:00 OAA-54999c4d7735 pgpool[18655]: [15830-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.340074+03:00 OAA-54999c4d7735 pgpool[18655]: [15831-1] LOG: DB node id: 0 backend pid: 18795 statement: COMMIT</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.340173+03:00 OAA-54999c4d7735 pgpool[18655]: [15831-2] LOCATION: pool_proto_modules.c:3209</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.340265+03:00 OAA-54999c4d7735 pgpool[18655]: [15832-1] LOG: child exiting, 1 connections reached</span></i></div>
<span style="font-size: 10pt;"></span>
<div><i><span style="font-size: 10pt;">2017-03-24T12:05:29.340428+03:00 OAA-54999c4d7735 pgpool[18655]: [15832-2] LOCATION: child.c:406</span></i></div>
<div><br>
</div>
<br>
<p></p>
<br>
Sergey<br>
<div style="color: rgb(0, 0, 0);">
<div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Tatsuo Ishii <ishii@sraoss.co.jp><br>
<b>Sent:</b> Friday, March 24, 2017 11:58 AM<br>
<b>To:</b> Sergey Kim<br>
<b>Cc:</b> pgpool-hackers@pgpool.net<br>
<b>Subject:</b> Re: [pgpool-committers: 3874] pgpool: Fix the case when duplicate statement remains.</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">Sergey,<br>
<br>
I have found a nasty bug with Pgpool-II and pushed the fix to git<br>
repository. You might want to test the fix.<br>
<br>
> Fix the case when duplicate statement remains.<br>
> <br>
> By using parse_before_bind, it is possible a parsed statement remains<br>
> on the load balance node even if explicit close is issued because the<br>
> close is redirected to the primary node. Fix is, issue close to both<br>
> primary and load balance node anytime. This sounds is a little bit<br>
> over killing but I think there's no way to remember the statement<br>
> remains on a load balance node.<br>
> <br>
> Also clean up some ifdef NOT_USED garbage.<br>
> <br>
> Branch<br>
> ------<br>
> bug271<br>
> <br>
> Details<br>
> -------<br>
> <a href="http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=2277a500042c8bbe2a4e2a069d23cece0e6ecded" id="LPlnk118208" previewremoved="true">
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=2277a500042c8bbe2a4e2a069d23cece0e6ecded</a><br>
> <br>
> Modified Files<br>
> --------------<br>
> src/auth/pool_auth.c | 11 ---<br>
> src/context/pool_session_context.c | 19 ++++<br>
> src/include/context/pool_session_context.h | 1 +<br>
> src/protocol/pool_process_query.c | 142 ++---------------------------<br>
> src/protocol/pool_proto_modules.c | 109 +++-------------------<br>
> 5 files changed, 40 insertions(+), 242 deletions(-)<br>
> <br>
</div>
</span></font></div>
</div>
</body>
</html>