[pgpool-general: 3743] Re: Connection issue

[Gervais de Montbrun]

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