<div style="font-family: Arial, sans-serif; font-size: 14px;">oh.. sorry I missed additional information. this is for additinal information on the same thread.<br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px;">you can reproduce this on the branch V4_4_STABLE, V4_5_STABLE, and master branch.<br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px;">I had installed after <span>autoreconf -fi</span> before testing with new branch (version 4.5 new guide)<br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px;">and I also re-attach the patch file which is based on master branch.<br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px;">before fix</div><div style="font-family: Arial, sans-serif; font-size: 14px;">------------<br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><span>psql (15.3)</span><div><span>Type "help" for help.</span></div><div><br></div><div><span>test=# PGPOOL RESET client_idle_limit;</span></div><div><span>ERROR: Pgpool node id file /pgpool_node_id does not exist</span></div><div><span>DETAIL: If watchdog is enable, pgpool_node_id file is required</span></div><div><span>message type 0x43 arrived from server while idle</span></div><div><span>message type 0x5a arrived from server while idle</span></div><div><span>test=# show pool_version;</span></div><div><span> pool_version </span></div><div><span>----------------------</span></div><div><span> 4.5.2 (hotooriboshi)</span></div><div><span>(1 row)</span></div><div><br></div><span>test=# </span><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">after fix</div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">----------</div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span>seo@seo-ThinkPad-E14-Gen-2:~$ psql -p 11000 test</span><div><span>psql (15.3)</span></div><div><span>Type "help" for help.</span></div><br><div><span>test=# PGPOOL RESET client_idle_limit;</span></div><div><span>SET</span></div><div><span>test=# PGPOOL RESET client_idle_limit;</span></div><div><span>SET</span></div><div><span>test=# show pool_version;</span></div><div><span> pool_version </span></div><div><span>----------------------</span></div><div><span> 4.5.2 (hotooriboshi)</span></div><div><span>(1 row)</span></div><span></span><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span>Regards</span><br>Kwangwon Seo<br><div>Bitnine Global Inc.</div><div><a target="_blank" rel="noreferrer nofollow noopener" href="http://www.bitnine.net">www.bitnine.net</a></div><span></span><br></div><div style="font-family: Arial, sans-serif; font-size: 14px;"><br></div><div class="protonmail_quote">
On Friday, June 7th, 2024 at 12:41, keiseo <keiseo@protonmail.com> wrote:<br>
<blockquote type="cite" class="protonmail_quote">
<span>Hello, and nice to meet you guys. </span><div><br></div><div><span><span>kashif_zeeshan(<span><span translate="no" tabindex="-1"><span><span></span>kashif.z@bitnine.net<span></span></span></span></span>)</span> found the abnormal query result with a specific query that is "PGPOOL RESET" query.</span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span><br></span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span>He shared this to me and I also had a same thing.<br></span></div><div><br></div><div><span>especially this bug only occurred when with watchdog is enabled.</span></div><div><br></div><div><span>I just do test some with regression test number 4 (watchdog) with fixing this one.</span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span><br></span></div><div><span>This is the text result.</span></div><div><br></div><div><span>before fixing.</span></div><div><span>-----------------</span></div><div><span>seo@seo-ThinkPad-E14-Gen-2:~$ psql -p 11000 test</span></div><div><span>psql (15.3)</span></div><div><span>Type "help" for help.</span></div><div><br></div><div><span>test=# PGPOOL RESET client_idle_limit;</span></div><div><span>ERROR: Pgpool node id file �0/pgpool_node_id does not exist</span></div><div><span>DETAIL: If watchdog is enable, pgpool_node_id file is required</span></div><div><span>test=# PGPOOL RESET client_idle_limit;</span></div><div><span>SET</span></div><div><span>ERROR: Pgpool node id file �y/pgpool_node_id does not exist</span></div><div><span>DETAIL: If watchdog is enable, pgpool_node_id file is required</span></div><div><span>message type 0x5a arrived from server while idle</span></div><div><span>message type 0x43 arrived from server while idle</span></div><div><span>message type 0x5a arrived from server while idle</span></div><div><span>test=# </span></div><div><br></div><div><span>after fixing.</span></div><div><span>-----------------</span></div><div><span>eo@seo-ThinkPad-E14-Gen-2:~$ psql -p 11000 test</span></div><div><span>psql (15.3)</span></div><div><span>Type "help" for help.</span></div><div><br></div><div><span>test=# PGPOOL RESET client_idle_limit;</span></div><div><span>SET</span></div><div><span>test=# PGPOOL RESET client_idle_limit;</span></div><div><span>SET</span></div><div><span>test=# PGPOOL RESET client_idle_limit;</span></div><div><span>SET</span></div><div><span>test=#</span></div><div><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span>And also there's some explanation about why I do this and what I want to do in patch file.</span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div><span>Could you please review this patch? </span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span><br></span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span><br></span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><br></div><div><span>If this is not a bug or only occurs for me, <span>this patch should be abandoned. but that's also good<span><span> for the pgpool because there's nothing matter on it!</span></span><br></span></span></div><div><span><span><span></span><div><span></span></div></span></span></div><div><span><br></span></div><div><span>oh well, <span>I read the guideline</span> but this is the first time sending a mail to hackers..</span></div><div><span><br></span></div><div><span>if I missed something, sorry about that and please tell me.</span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span><br></span></div><div style="font-family: Arial, sans-serif; font-size: 14px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);"><span>Regards.<br></span></div>
</blockquote><br>
</div>