<div dir="ltr">Hi<div><br></div><div>I am looking into this issue. and unfortunately like <span class="" id=":4zr.1" tabindex="-1" style="background:yellow">Ishii</span>-San I am also not able to reproduce it. But I found one issue in 3.4 that might cause the problem. Can you please try the attached patch if it solves the problem. Also, if the problem still persists, it would be really helpful if you could share the <span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow"></span><span class="" id=":4zr.2" tabindex="-1" style="background:yellow">pgpool</span>-II log. </div><div><br></div><div>Thanks</div><div>Best regards</div><div>Muhammad Usama</div><div> </div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jan 8, 2016 at 12:00 PM, Gerhard Wiesinger <span dir="ltr"><<a href="mailto:lists@wiesinger.com" target="_blank">lists@wiesinger.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 08.01.2016 07:32, Tatsuo Ishii wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 07.01.2016 22:32, Tatsuo Ishii wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I heard similar reports but problem for developers is, nobody knows<br>
how to reproduce the hang (a stack trace after the hang is not very<br>
helpful).<br>
<br>
<br>
</blockquote>
Yes, there were already 2? on the list.<br>
<br>
I can reproduce it randomly in about one day. I think stack traces<br>
should be sufficient when e.g. debug code has been added.<br>
</blockquote>
No. That's just a consequence of many problems including this one.<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
How to track the bug down?<br>
Debug code?<br>
Enhanced logging?<br>
</blockquote>
A debug logging would be helpful (start pgpool with -d option) but it<br>
will consume huge disk space if you want to save all off them. Is it<br>
possible to keep only last 30 minues debug logs before the problem<br>
occurs? I guess even 10 minutes is enough to know the cause of the<br>
problem.<br>
</blockquote>
<br></span>
Can you try to reproduce it, too?<br>
<br>
My use case is very simple:<br>
1.) One persistent connection with username1/database1 doing an insert every minute<br>
2.) Nagios bombs out about 10 simple SELECT queries every minute with username2/database1 nearly at the same time (so it looks like sometimes same backend connection can be used)<br>
So should be easy to test. I close the unused backend connections after 2s, so if you bomb e.g. every 10s should be fast to reproduce.<br>
<br>
Happens in my case in 0.5-24h.<div class="HOEnZb"><div class="h5"><br>
<br>
Ciao,<br>
Gerhard<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</div></div></blockquote></div><br></div>