[pgpool-general: 3744] Re: Connection issue

Tatsuo Ishii ishii at postgresql.org
Fri May 22 09:06:55 JST 2015


Hi Gervais,

debug5, please.

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

> Hi Tatsuo,
> 
> Is “log_min_messages" the log setting that you would like me to turn up to debug? It is current set to info. Is there a debug level that you require? 1,2,3,4,5?
> 
> Cheers,
> Gervais
> 
>> On May 21, 2015, at 8:04 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>> 
>>> Hi All,
>>> 
>>> I see a lot of info about child processes starting and stopping in my syslog and wonder if this is normal. I have searched for and can not find exit code status info for pgpool processes.
>>> 
>>> Sample log output:
>>> May 21 13:33:51 server0 pgpool[19162]: [67815-1] 2015-05-21 13:33:51: pid 19162: LOG:  child process with pid: 3120 exits with status 512
>>> May 21 13:33:51 server0 pgpool[19162]: [67816-1] 2015-05-21 13:33:51: pid 19162: LOG:  fork a new child process with pid: 3860
>>> May 21 13:33:51 server0 pgpool: 2015-05-21 13:33:51: pid 19162: LOG:  child process with pid: 3120 exits with status 512
>>> May 21 13:33:51 server0 pgpool: 2015-05-21 13:33:51: pid 19162: LOG:  fork a new child process with pid: 3860
>>> May 21 13:33:52 server0 pgpool[19162]: [67817-1] 2015-05-21 13:33:52: pid 19162: LOG:  child process with pid: 2858 exits with status 512
>>> May 21 13:33:52 server0 pgpool[19162]: [67818-1] 2015-05-21 13:33:52: pid 19162: LOG:  fork a new child process with pid: 3861
>>> May 21 13:33:52 server0 pgpool: 2015-05-21 13:33:52: pid 19162: LOG:  child process with pid: 2858 exits with status 512
>>> May 21 13:33:52 server0 pgpool: 2015-05-21 13:33:52: pid 19162: LOG:  fork a new child process with pid: 3861
>>> May 21 13:33:52 server0 pgpool[19162]: [67819-1] 2015-05-21 13:33:52: pid 19162: LOG:  child process with pid: 3115 exits with status 512
>>> May 21 13:33:52 server0 pgpool[19162]: [67820-1] 2015-05-21 13:33:52: pid 19162: LOG:  fork a new child process with pid: 3862
>>> May 21 13:33:52 server0 pgpool: 2015-05-21 13:33:52: pid 19162: LOG:  child process with pid: 3115 exits with status 512
>>> May 21 13:33:52 server0 pgpool: 2015-05-21 13:33:52: pid 19162: LOG:  fork a new child process with pid: 3862
>>> May 21 13:33:52 server0 pgpool[19162]: [67821-1] 2015-05-21 13:33:52: pid 19162: LOG:  child process with pid: 31112 exits with status 512
>>> May 21 13:33:52 server0 pgpool[19162]: [67822-1] 2015-05-21 13:33:52: pid 19162: LOG:  fork a new child process with pid: 3863
>>> May 21 13:33:52 server0 pgpool: 2015-05-21 13:33:52: pid 19162: LOG:  child process with pid: 31112 exits with status 512
>>> May 21 13:33:52 server0 pgpool: 2015-05-21 13:33:52: pid 19162: LOG:  fork a new child process with pid: 3863
>>> May 21 13:33:53 server0 pgpool[19162]: [67823-1] 2015-05-21 13:33:53: pid 19162: LOG:  child process with pid: 31347 exits with status 512
>>> May 21 13:33:53 server0 pgpool[19162]: [67824-1] 2015-05-21 13:33:53: pid 19162: LOG:  fork a new child process with pid: 3864
>>> May 21 13:33:53 server0 pgpool: 2015-05-21 13:33:53: pid 19162: LOG:  child process with pid: 31347 exits with status 512
>>> May 21 13:33:53 server0 pgpool: 2015-05-21 13:33:53: pid 19162: LOG:  fork a new child process with pid: 3864
>>> May 21 13:33:53 server0 pgpool[19162]: [67825-1] 2015-05-21 13:33:53: pid 19162: LOG:  child process with pid: 3067 exits with status 512
>>> May 21 13:33:53 server0 pgpool[19162]: [67826-1] 2015-05-21 13:33:53: pid 19162: LOG:  fork a new child process with pid: 3865
>>> May 21 13:33:53 server0 pgpool: 2015-05-21 13:33:53: pid 19162: LOG:  child process with pid: 3067 exits with status 512
>>> May 21 13:33:53 server0 pgpool: 2015-05-21 13:33:53: pid 19162: LOG:  fork a new child process with pid: 3865
>>> May 21 13:33:54 server0 pgpool[19162]: [67827-1] 2015-05-21 13:33:54: pid 19162: LOG:  child process with pid: 31686 exits with status 512
>>> May 21 13:33:54 server0 pgpool[19162]: [67828-1] 2015-05-21 13:33:54: pid 19162: LOG:  fork a new child process with pid: 3866
>>> May 21 13:33:54 server0 pgpool: 2015-05-21 13:33:54: pid 19162: LOG:  child process with pid: 31686 exits with status 512
>>> May 21 13:33:54 server0 pgpool: 2015-05-21 13:33:54: pid 19162: LOG:  fork a new child process with pid: 3866
>>> 
>>> Is this normal behaviour? Is exit status 512 the proper status? I am running pgpool-II version 3.4.1 (tataraboshi) on CentOS 7.
>> 
>> Yes. However the child process dies every 1 second, this is not unusual
>> of course. Can you get debug log to understand what's going on?
>> 
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
> 


More information about the pgpool-general mailing list