On Mon, Sep 12, 2011 at 6:47 PM, Lonni J Friedman <netll...@gmail.com> wrote: > On Mon, Sep 12, 2011 at 6:39 PM, Tatsuo Ishii <is...@sraoss.co.jp> wrote: >>>> I couldn't find anything possibly related to your problem at a first >>>> grance(in theory client_idle_limit and authentication_timeout are not >>>> related but you might want to change them to see anything could be >>>> changed). >>> >>> OK, I'll give that a try. Should I just try increasing them by 10 or 20s? >> >> I'd suggest giving them 0. This will prevent to initiate those >> functionalities which the directives are related. >> >> Also you hve child_life_time being 300. I don't expect this is related >> but could you set it to 0 and see anything gest changed for just in >> case? > > OK, i'll make those changes tomorrow (its late in the day here, and I > don't want to introduce potential problems in the middle of the night > when no one is closely monitoring the server), and let you know if > they have any impact.
client_idle_limit was already 0. I set authentication_timeout=0 and child_life_time=0, and restarted pgpool, however that had no impact. I'm still seeing: 26323 2011-09-13 09:28:19 PDT LOG: unexpected EOF on client connection 3933 2011-09-13 09:36:20 PDT LOG: unexpected EOF on client connection >>>> Do you have anything between pgpool and PostgreSQL? It has been >>>> reported that some firewall hardware/software kills TCP connections if >>>> they are idle for n seconds. >>> >>> Nope, there are no firewalls, or anything else that I'm aware of >>> sitting between pgpool and the database servers. >> >> Ok. >> >> Another possibility is, pgpool child process is dying for unknown >> reason. Do you see anything bad (for example child dies segfault) in >> the pgpool log? > > I don't believe that's happening, but I'll have to check the logs > tomorrow to verify. Currently, the only truly bad behavior that I'm > currently experiencing is this: > http://lists.pgfoundry.org/pipermail/pgpool-general/2011-September/003954.html I see no explicit segfaults in the pgpool logs. thanks for your help. _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general