[Pgpool-general] health check failed due an Interrupted system call

[Tatsuo Ishii]

> Hi all,
> 
> Yesterday, one of my backend node was degenerated because of a health
> check fail.
> 
> 010-02-28 18:13:41 ERROR: pid 23996: health check failed during read.
> host X at port 5432 is down. reason: Interrupted system call
> 2010-02-28 18:14:04 LOG:   pid 23996: set 0 th backend down status
> 2010-02-28 18:14:04 LOG:   pid 23996: starting degeneration. shutdown
> host X(5432)
> 2010-02-28 18:14:07 LOG:   pid 23996: failover_handler: set new master
> node: 1
> 2010-02-28 18:14:07 LOG:   pid 23996: failover done. shutdown host X(5432)
> 
> I've looked in the source code which system call is (in main.c pgpool-II
> 2.3.2.1). It seems that its is read().
> 
> It is the first time I notice this kind of error. Usually, it a timed
> out connection one. So, I'm not confident about reproducing it.
> 
> How can I interpret this error? Is it simply because read() was blocked?

Health check failed because PostgreSQL does not reply within
health_check_timeout seconds. Please check PostgreSQL log. If you
don't find anything strange there, probably the cause is network
physical problem. Maybe switch or hub hardware problem?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp