[pgpool-general: 4940] Re: pgpool log errors

[Shay Cohavi]

Thanks for your reply!
I'll rebuild the source and check the issue again!

Thanks,
cohavisi



On Mon, Aug 22, 2016 at 5:55 PM, Muhammad Usama <m.usama at gmail.com> wrote:

> Hi
>
> Health check timed out warning normally means that pgpool-II health check
> is not able to connect to backend within the health_check_timeout period.
> So can you verify if you are getting some network glitches and/or errors in
> PG server log that related to the connection failure.
>
> I have also found a possible issue that can cause the same where some
> signal other than health check alarm if received while the pgpool health
> check is waiting for the data could be mistakenly considered as the health
> check timed out signal, and I have just pushed the fix for that in 3.4, 3.5
> and master branches.
>
> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=
> 861a71b740a546848bcad581cc0777abfae79ddc
>
> Can you try building from the source if you still face the same problem.
>
> Thanks
> Best regards
> Muhammad Usama
>
>
> On Mon, Aug 8, 2016 at 12:18 PM, Shay Cohavi <cohavisi at gmail.com> wrote:
>
>> Hi,
>> after upgardig pgpool to 3.5.3 version I keep getting these errors via
>> pgpool log massages:
>>
>> 2016-08-08 10:15:59: pid 14964: LOG:  child process with pid: 22056 exits
>> with status 256
>> 2016-08-08 10:15:59: pid 14964: LOG:  fork a new child process with pid:
>> 22128
>> 2016-08-08 10:16:00: pid 14964: LOG:  child process with pid: 22032 exits
>> with status 256
>> 2016-08-08 10:16:00: pid 14964: LOG:  fork a new child process with pid:
>> 22138
>> *2016-08-08 10:16:00: pid 14964: WARNING:  health check timed out while
>> waiting for reading data*
>> *2016-08-08 10:16:00: pid 14964: ERROR:  unable to read data from DB node
>> 0*
>> *2016-08-08 10:16:00: pid 14964: DETAIL:  pool_check_fd call failed with
>> an error "Interrupted system call"*
>> 2016-08-08 10:16:00: pid 14964: LOG:  child process with pid: 22033 exits
>> with status 256
>> 2016-08-08 10:16:00: pid 14964: LOG:  fork a new child process with pid:
>> 22140
>> 2016-08-08 10:16:00: pid 14964: LOG:  child process with pid: 22065 exits
>> with status 256
>>
>>
>> healthcheck parameters:
>>
>> health_check_period=1
>> # Health check period
>> # Disabled (0) by default
>> health_check_timeout=20
>> # Health check timeout
>> # 0 means no timeout
>> health_check_user='postgres'
>> # Health check user
>> health_check_password='postgres'
>> # Password for health check user
>> health_check_database=''
>> # Database name for health check. If '', tries 'postgres' frist, then
>> 'template1'
>>
>> health_check_max_retries=2
>> # Maximum number of times to retry a failed health check before giving up.
>> health_check_retry_delay=1
>>
>>
>> please advice..
>>
>> Thanks,
>> cohavisi
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160822/f0b9368c/attachment.html>