<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">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<p>Tatsuo,</p>
<p>I have <span style="font-size: 12pt;">updated the test tool:</span></p>
<p><br>
</p>
There is the 'target' folder in the attached tarball (and source codes). The folder contains jar file that implements tests for #231 & #271 issues.</div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<br>
</div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
please run it as:</div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<span># java -jar target/tests-1.0-SNAPSHOT-jar-with-dependencies.jar PGPOOL_HOST PGPOOL_PORT DB_NAME DB_USER DB_PASSWORD <b><span style="color: rgb(255, 0, 0);">271</span></b></span></div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<br>
</div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<span><b></b></span><span style="font-weight: bold; color: rgb(255, 0, 0);">'271'</span><b> here means the ID of the test to run, currently there are 2 IDs possible - 231 & 271.
</b>Each test launched for 1000 times. This is the code level constant so far.</div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<b><br>
</b></div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
For example launch for the test 271 on the HEAD of bug271 git branch ends with error:</div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<div><i><span style="font-size: 10pt;">
<div>[skim@localhost pgpool]$ java -jar target/tests-1.0-SNAPSHOT-jar-with-dependencies.jar 10.28.64.176 5432 oss oss WfovD22ufP78Wq 271</div>
<div>Test iteration '0'</div>
<div>Test iteration '1'</div>
<div><b><span style="color: rgb(255, 0, 0);">Exception in thread "main" java.lang.RuntimeException: Balanced</span></b></div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>at com.pgpool.tests.Issue271_SingleThread.runTest(Issue271_SingleThread.java:52)</div>
<div><span class="Apple-tab-span" style="white-space:pre"></span>at com.pgpool.tests.TestStarter.main(TestStarter.java:44)</div>
<div></div>
<div>[skim@localhost pgpool]$ <span style="color: rgb(255, 0, 0);"><b>echo $?</b></span></div>
<div><span style="color: rgb(255, 0, 0);"><b>1</b></span></div>
<div><br>
</div>
</span></i></div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
And the following pgpool log is generated (syslog):</div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<br>
</div>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<i></i>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.859057+03:00 OAA-54999c4d7735 pgpool[1041]: [129385-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 0 backend pid: 1513 statement: Parse: BEGIN</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.859206+03:00 OAA-54999c4d7735 pgpool[1041]: [129385-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.859385+03:00 OAA-54999c4d7735 pgpool[1041]: [129386-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 1 backend pid: 28847 statement: Parse: BEGIN</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.859558+03:00 OAA-54999c4d7735 pgpool[1041]: [129386-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.859702+03:00 OAA-54999c4d7735 pgpool[1041]: [129387-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 0 backend pid: 1513 statement: B message</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.859856+03:00 OAA-54999c4d7735 pgpool[1041]: [129387-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.860000+03:00 OAA-54999c4d7735 pgpool[1041]: [129388-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 1 backend pid: 28847 statement: B message</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.860158+03:00 OAA-54999c4d7735 pgpool[1041]: [129388-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.860323+03:00 OAA-54999c4d7735 pgpool[1041]: [129389-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 0 backend pid: 1513 statement: Execute: BEGIN</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.860557+03:00 OAA-54999c4d7735 pgpool[1041]: [129389-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.860778+03:00 OAA-54999c4d7735 pgpool[1041]: [129390-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 1 backend pid: 28847 statement: Execute: BEGIN</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.860992+03:00 OAA-54999c4d7735 pgpool[1041]: [129390-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.861217+03:00 OAA-54999c4d7735 pgpool[1041]: [129391-1] 2017-03-14 20:44:09: pid 1041:LOG: <b><span style="color: rgb(255, 0, 0);">DB node id: 0 backend pid: 1513 statement: Parse: insert into write_table(id)
values($1)</span></b></span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.861423+03:00 OAA-54999c4d7735 pgpool[1041]: [129391-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.861686+03:00 OAA-54999c4d7735 pgpool[1041]: [129392-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 0 backend pid: 1513 statement: B message</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.861904+03:00 OAA-54999c4d7735 pgpool[1041]: [129392-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.862148+03:00 OAA-54999c4d7735 pgpool[1041]: [129393-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 0 backend pid: 1513 statement: D message</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.862360+03:00 OAA-54999c4d7735 pgpool[1041]: [129393-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.862592+03:00 OAA-54999c4d7735 pgpool[1041]: [129394-1] 2017-03-14 20:44:09: pid 1041:LOG: <b><span style="color: rgb(255, 0, 0);">DB node id: 0 backend pid: 1513 statement: Execute: insert into write_table(id)
values($1)</span></b></span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.862826+03:00 OAA-54999c4d7735 pgpool[1041]: [129394-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.863058+03:00 OAA-54999c4d7735 pgpool[1041]: [129395-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 1 backend pid: 28847 statement: B message</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.863306+03:00 OAA-54999c4d7735 pgpool[1041]: [129395-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.863502+03:00 OAA-54999c4d7735 pgpool[1041]: [129396-1] 2017-03-14 20:44:09: pid 1041:LOG: <b><span style="color: rgb(255, 0, 0);">DB node id: 1 backend pid: 28847 statement: Execute: select id from
write_table where id = $1</span></b></span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.863665+03:00 OAA-54999c4d7735 pgpool[1041]: [129396-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.864601+03:00 OAA-54999c4d7735 pgpool[1041]: [129397-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 1 backend pid: 28847 statement: ABORT</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.864761+03:00 OAA-54999c4d7735 pgpool[1041]: [129397-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.864914+03:00 OAA-54999c4d7735 pgpool[1041]: [129398-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 0 backend pid: 1513 statement: ABORT</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.865097+03:00 OAA-54999c4d7735 pgpool[1041]: [129398-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.865322+03:00 OAA-54999c4d7735 pgpool[1041]: [129399-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 0 backend pid: 1513 statement: DISCARD ALL</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.865606+03:00 OAA-54999c4d7735 pgpool[1041]: [129399-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.865844+03:00 OAA-54999c4d7735 pgpool[1041]: [129400-1] 2017-03-14 20:44:09: pid 1041:LOG: DB node id: 1 backend pid: 28847 statement: DISCARD ALL</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.866101+03:00 OAA-54999c4d7735 pgpool[1041]: [129400-2] 2017-03-14 20:44:09: pid 1041:LOCATION: pool_proto_modules.c:3208</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.866976+03:00 OAA-54999c4d7735 pgpool[1041]: [129401-1] 2017-03-14 20:44:09: pid 1041:LOG: child exiting, 1 connections reached</span></i></div>
<div><i><span style="font-size: 10pt;">2017-03-14T20:44:09.867095+03:00 OAA-54999c4d7735 pgpool[1041]: [129401-2] 2017-03-14 20:44:09: pid 1041:LOCATION: child.c:406</span></i></div>
<div><i><br>
</i></div>
<i></i><br>
</div>
If you wish I can put the source codes into some git repository.<br>
<br>
<br>
<span style="font-size: 10pt;">Sergey.</span><br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Sergey Kim<br>
<b>Sent:</b> Tuesday, March 14, 2017 4:19 PM<br>
<b>To:</b> Tatsuo Ishii<br>
<b>Cc:</b> pgpool-hackers@pgpool.net; Boris Voskanov<br>
<b>Subject:</b> Re: [pgpool-committers: 3836] pgpool: Branch refs/heads/bug271 was created</font>
<div> </div>
</div>
<div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Tatsuo, </p>
<p><br>
</p>
<p>this time all previously created tests succeeded but out application failed to start. So we started searching for the problem and could reproduce "balanced select problem". The test can run for minutes before reproduction of the problem (((</p>
<p>I'm not sure if it can help but please pay attention that time lag between insert is select requests is very small. <span style="font-size:12pt"></span></p>
<p><br>
</p>
<p>Please see the pgpool logs:</p>
<p></p>
<div><span style="font-size:10pt">2017-03-14T16:06:37.889485+03:00 OAA-54999c4d7735 pgpool[25595]: [79-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 0 backend pid: 25885 statement: B message</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.889702+03:00 OAA-54999c4d7735 pgpool[25595]: [79-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.889924+03:00 OAA-54999c4d7735 pgpool[25595]: [80-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 1 backend pid: 27691 statement: B message</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.890090+03:00 OAA-54999c4d7735 pgpool[25595]: [80-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.890248+03:00 OAA-54999c4d7735 pgpool[25595]: [81-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 0 backend pid: 25885 statement: Execute: BEGIN</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.890378+03:00 OAA-54999c4d7735 pgpool[25595]: [81-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.890535+03:00 OAA-54999c4d7735 pgpool[25595]: [82-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 1 backend pid: 27691 statement: Execute: BEGIN</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.890693+03:00 OAA-54999c4d7735 pgpool[25595]: [82-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.890863+03:00 OAA-54999c4d7735 pgpool[25595]: [83-1] 2017-03-14 16:06:37: pid 25595:LOG:
</span><b><span style="color:rgb(255,0,0); font-size:10pt"> DB node id: 0 backend pid: 25885 statement: Parse: insert into write_table(id) values($1)</span></b></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.891144+03:00 OAA-54999c4d7735 pgpool[25595]: [83-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.891390+03:00 OAA-54999c4d7735 pgpool[25595]: [84-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 0 backend pid: 25885 statement: B message</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.891637+03:00 OAA-54999c4d7735 pgpool[25595]: [84-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.891895+03:00 OAA-54999c4d7735 pgpool[25595]: [85-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 0 backend pid: 25885 statement: D message</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.892091+03:00 OAA-54999c4d7735 pgpool[25595]: [85-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.892272+03:00 OAA-54999c4d7735 pgpool[25595]: [86-1] 2017-03-14 16:06:37: pid 25595:LOG: </span><b><span style="color:rgb(255,0,0); font-size:10pt">DB node id: 0 backend pid: 25885 statement: Execute: insert
into write_table(id) values($1)</span></b></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.892442+03:00 OAA-54999c4d7735 pgpool[25595]: [86-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.892642+03:00 OAA-54999c4d7735 pgpool[25595]: [87-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 1 backend pid: 27691 statement: B message</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.892828+03:00 OAA-54999c4d7735 pgpool[25595]: [87-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.892998+03:00 OAA-54999c4d7735 pgpool[25595]: [88-1] 2017-03-14 16:06:37: pid 25595:LOG: </span><b><span style="color:rgb(255,0,0); font-size:10pt">DB node id: 1 backend pid: 27691 statement: Execute: select
id from write_table where id = $1</span></b></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.893187+03:00 OAA-54999c4d7735 pgpool[25595]: [88-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.893359+03:00 OAA-54999c4d7735 pgpool[25595]: [89-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 1 backend pid: 27691 statement: ABORT</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.893584+03:00 OAA-54999c4d7735 pgpool[25595]: [89-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.893839+03:00 OAA-54999c4d7735 pgpool[25595]: [90-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 0 backend pid: 25885 statement: ABORT</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.894039+03:00 OAA-54999c4d7735 pgpool[25595]: [90-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.894220+03:00 OAA-54999c4d7735 pgpool[25595]: [91-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 0 backend pid: 25885 statement: DISCARD ALL</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.894403+03:00 OAA-54999c4d7735 pgpool[25595]: [91-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.894587+03:00 OAA-54999c4d7735 pgpool[25595]: [92-1] 2017-03-14 16:06:37: pid 25595:LOG: DB node id: 1 backend pid: 27691 statement: DISCARD ALL</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.894753+03:00 OAA-54999c4d7735 pgpool[25595]: [92-2] 2017-03-14 16:06:37: pid 25595:LOCATION: pool_proto_modules.c:3208</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.894944+03:00 OAA-54999c4d7735 pgpool[25595]: [93-1] 2017-03-14 16:06:37: pid 25595:LOG: child exiting, 1 connections reached</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.895079+03:00 OAA-54999c4d7735 pgpool[25595]: [93-2] 2017-03-14 16:06:37: pid 25595:LOCATION: child.c:406</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.895371+03:00 OAA-54999c4d7735 pgpool[25566]: [47-1] 2017-03-14 16:06:37: pid 25566:LOG: child process with pid: 25595 exits with status 256</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.895635+03:00 OAA-54999c4d7735 pgpool[25566]: [47-2] 2017-03-14 16:06:37: pid 25566:LOCATION: pgpool_main.c:2380</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.895943+03:00 OAA-54999c4d7735 pgpool[25566]: [48-1] 2017-03-14 16:06:37: pid 25566:LOG: fork a new child process with pid: 25887</span></div>
<div><span style="font-size:10pt">2017-03-14T16:06:37.896174+03:00 OAA-54999c4d7735 pgpool[25566]: [48-2] 2017-03-14 16:06:37: pid 25566:LOCATION: pgpool_main.c:2466</span></div>
<div><br>
</div>
<br>
<p></p>
And java client logs:</div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<div><span style="font-size:10pt">16:06:37.890 (2) simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@689604d9, maxRows=0, fetchSize=0, flags=1</span></div>
<div><span style="font-size:10pt">16:06:37.890 (2) FE=> Parse(stmt=null,query="BEGIN",oids={})</span></div>
<div><span style="font-size:10pt">16:06:37.890 (2) FE=> Bind(stmt=null,portal=null)</span></div>
<div><span style="font-size:10pt">16:06:37.890 (2) FE=> Execute(portal=null,limit=0)</span></div>
<div><span style="font-size:10pt">16:06:37.890 (2) FE=> Parse(stmt=null,query="insert into write_table(id) values($1)",oids={23})</span></div>
<div><span style="font-size:10pt">16:06:37.890 (2) FE=> Bind(stmt=null,portal=null,$1=<-613120604>)</span></div>
<div><span style="font-size:10pt">16:06:37.890 (2) FE=> Describe(portal=null)</span></div>
<div><span style="font-size:10pt">16:06:37.890 (2) FE=> Execute(portal=null,limit=0)</span></div>
<div><span style="font-size:10pt">16:06:37.890 (2) FE=> Sync</span></div>
<div><span style="font-size:10pt">16:06:37.892 (2) <=BE ParseComplete [null]</span></div>
<div><span style="font-size:10pt">16:06:37.892 (2) <=BE BindComplete [unnamed]</span></div>
<div><span style="font-size:10pt">16:06:37.892 (2) <=BE CommandStatus(BEGIN)</span></div>
<div><span style="font-size:10pt">16:06:37.892 (2) <=BE ParseComplete [null]</span></div>
<div><span style="font-size:10pt">16:06:37.892 (2) <=BE BindComplete [unnamed]</span></div>
<div><span style="font-size:10pt">16:06:37.892 (2) <=BE NoData</span></div>
<div><b><span style="color:rgb(255,0,0); font-size:10pt">16:06:37.892 (2) <=BE CommandStatus(INSERT 0 1)</span></b></div>
<div><span style="font-size:10pt">16:06:37.893 (2) <=BE ReadyForQuery(T)</span></div>
<div><span style="font-size:10pt">16:06:37.893 (2) simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@18078bef, maxRows=0, fetchSize=0, flags=0</span></div>
<div><span style="font-size:10pt">16:06:37.893 (2) FE=> Bind(stmt=S_1,portal=null,$1=<-613120604>)</span></div>
<div><span style="font-size:10pt">16:06:37.893 (2) FE=> Execute(portal=null,limit=0)</span></div>
<div><span style="font-size:10pt">16:06:37.893 (2) FE=> Sync</span></div>
<div><span style="font-size:10pt">16:06:37.895 (2) <=BE BindComplete [unnamed]</span></div>
<div><b><span style="color:rgb(255,0,0); font-size:10pt">16:06:37.895 (2) <=BE CommandStatus(SELECT 0)</span></b></div>
<div><span style="font-size:10pt">16:06:37.895 (2) <=BE ReadyForQuery(T)</span></div>
<div><span style="font-size:10pt">16:06:37.895 (2) FE=> Terminate</span></div>
<div><span style="font-size:10pt">Exception in thread "main" java.lang.RuntimeException: Balanced</span></div>
<div><span class="Apple-tab-span" style="white-space:pre; font-size:10pt"></span><span style="font-size:10pt">at com.pgpool.tests.Issue271_SingleThread.runTest(Issue271_SingleThread.java:57)</span></div>
<div><span class="Apple-tab-span" style="white-space:pre; font-size:10pt"></span><span style="font-size:10pt">at com.pgpool.tests.TestStarter.main(TestStarter.java:37)</span></div>
<div><br>
</div>
<br>
</div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
The java test is attached:</div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<br>
</div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
P/S:</div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
Pgpool was build from branch bug271:</div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<div><i><span style="font-size:10pt">[root@OAA-54999c4d7735 pgpool2]# git log -2</span></i></div>
<div><i><span style="font-size:10pt">commit 0955a22fb7f30c5b9c1fabe2873c09246453ee50</span></i></div>
<div><i><span style="font-size:10pt">Author: Tatsuo Ishii <ishii@postgresql.org></span></i></div>
<div><i><span style="font-size:10pt">Date: Tue Mar 14 19:03:02 2017 +0900</span></i></div>
<div><i><br>
</i></div>
<div><i><span style="font-size:10pt"> Fix problem described in [pgpool-hackers: 2125].</span></i></div>
<div><i><span style="font-size:10pt"> </span></i></div>
<div><i><span style="font-size:10pt"> Two problems are fixed:</span></i></div>
<div><i><span style="font-size:10pt"> </span></i></div>
<div><i><span style="font-size:10pt"> - The writing_transaction flag is not reset at transaction</span></i></div>
<div><i><span style="font-size:10pt"> committed/aborted. Before it was done in CommandComplete but now it</span></i></div>
<div><i><span style="font-size:10pt"> is possible that we need to check the flag before a command complete</span></i></div>
<div><i><span style="font-size:10pt"> message arrives. So at Execute, it is taken care by</span></i></div>
<div><i><span style="font-size:10pt"> handle_query_context() which used to be a static function in</span></i></div>
<div><i><span style="font-size:10pt"> CommandComplete.c. Also the session context memory is always cleared</span></i></div>
<div><i><span style="font-size:10pt"> before start a session context.</span></i></div>
<div><i><span style="font-size:10pt"> </span></i></div>
<div><i><span style="font-size:10pt"> - Ready for query Re-sync code path in read_kind_from_backend did not</span></i></div>
<div><i><span style="font-size:10pt"> work. The pending message corresponding to the ready for query</span></i></div>
<div><i><span style="font-size:10pt"> message could be a sync message, which does not have query</span></i></div>
<div><i><span style="font-size:10pt"> context. But before we checked if there's a query context</span></i></div>
<div><i><span style="font-size:10pt"> exists. The check is bogus and removed.</span></i></div>
<div><i><br>
</i></div>
<div><i><span style="font-size:10pt">commit 7c955b2a2dfb77623055b5eae9afe041de3105ee</span></i></div>
<div><i><span style="font-size:10pt">Author: Tatsuo Ishii <ishii@postgresql.org></span></i></div>
<div><i><span style="font-size:10pt">Date: Sun Mar 12 10:19:34 2017 +0900</span></i></div>
<div><i><br>
</i></div>
<div><i><span style="font-size:10pt"> Downgrade 1 more ereport from LOG to DEBUG1.</span></i></div>
<br>
</div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<br>
</div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<br>
<br>
<div style="color:rgb(0,0,0)">
<div><span style="font-size:10pt">Sergey</span>
<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> Tuesday, March 14, 2017 1:28 PM<br>
<b>To:</b> Sergey Kim<br>
<b>Cc:</b> pgpool-hackers@pgpool.net<br>
<b>Subject:</b> Re: [pgpool-committers: 3836] pgpool: Branch refs/heads/bug271 was created</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt">
<div class="PlainText">Hi Sergey,<br>
<br>
I have created a new branch named "bug271" which has been used to<br>
develop the patch for bug 271 on private git repository. Now you could<br>
use either the email attached patches or the branch if it's<br>
convieninet for you. The branch was created against the master<br>
branch. I will occasionaly rebase it with the master branch. In the<br>
near future the branch will be merged into the master branch (and I<br>
plan to back-patch it to 3.6 stable tree).<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" id="LPlnk270346" previewremoved="true">
http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:http://www.sraoss.co.jp<br>
<br>
From: pgpool-committers-bounces@pgpool.net<br>
Subject: [pgpool-committers: 3836] pgpool: Branch refs/heads/bug271 was created<br>
Date: Tue, 14 Mar 2017 10:19:33 +0000<br>
Message-ID: <E1cnjYD-0005zz-GZ@gothos.postgresql.org><br>
<br>
> Branch refs/heads/bug271 was created.<br>
> <br>
> View: <a href="http://git.postgresql.org/gitweb?p=pgpool2.git;a=shortlog;h=refs/heads/bug271" id="LPlnk584703" previewremoved="true">
http://git.postgresql.org/gitweb?p=pgpool2.git;a=shortlog;h=refs/heads/bug271</a><br>
</div>
</span></font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>