[pgpool-general: 3319] Re: popgun stops working with no log indication of issues

Tatsuo Ishii ishii at postgresql.org
Sun Nov 30 21:34:26 JST 2014

> I’m running 3.3.3 with a single master/slave setup and I’m having an issue where our app will suddenly start timing out on db queries, but there’s nothing in the pgpool log to indicate a problem.  Stopping pgpool and starting it again fixes the problem for about 24 hours until it re-occurs.  For the last few hours, however, it has been happening every hour.
> Is there some method I can use to debug this?

Sounds like a bug fixed in 3.3.4. When you type "ps xau|grep pgpool",
you should see some lines:

18122 pts/16   S      0:00 pgpool: wait for connection request                                      

which indicates that the pgpool child is ready for accepting
connection from client. The bug mentioned above is, when pgpool child
ends its work, it does't return to the waiting state. Thus no client
is accepted connection to pgpool, and your apps start timing out.

Please upgrade to 3.3.4.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list