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

[Muhammad Usama]

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/7b1e9cd0/attachment.html>