[pgpool-general: 6802] Slave Down from pgpool

[Loai Abdallatif]

Dear all
i have setup two nodes of postgres 9.4 with streaming replication and they
work fine as below command:

 $repmgr -f repmgr/repmgr.conf cluster show
Role      | Connection String
* master  | host=10.10.0.2 (pgserver01)  port=3432 user=repmgr dbname=repmgr
  standby | host=10.10.0.3(pgserver02)  port=3432 user=repmgr dbname=repmgr

and sometimes the slave being deatatched from pgpool while its running and
accepting data from master node but from pgadmin its beeing deattached and
the error below appears in pgpool logs :

any one have an idea


ERROR: pid 1770: health check failed. 1 th host pgserver02 at port 3432 is
down
ec 30 12:57:26 dataserver01 pgpool[1770]: 2019-12-30 12:57:26 LOG:   pid
40056: pool_process_query: child connection forced to terminate due to
client_idle_limit (180) reached
Dec 30 12:57:27 dataserver01 pgpool[1770]: 2019-12-30 12:57:27 LOG:   pid
9877: connect_inet_domain_socket: select() timed out. retrying...
Dec 30 12:57:27 dataserver01 pgpool[1770]: 2019-12-30 12:57:27 LOG:   pid
1770: connect_inet_domain_socket: select() interrupted
Dec 30 12:57:27 dataserver01 pgpool[1770]: 2019-12-30 12:57:27 ERROR: pid
1770: make_persistent_db_connection: connection to pgserver02(3432) failed
Dec 30 12:57:27 dataserver01 pgpool[1770]: 2019-12-30 12:57:27 ERROR: pid
1770: health check failed. 1 th host pgserver02 at port 3432 is down
Dec 30 12:57:27 dataserver01 pgpool[1770]: 2019-12-30 12:57:27 LOG:   pid
40604: connect_inet_domain_socket: select() timed out. retrying...
Dec 30 12:57:28 dataserver01 pgpool[1770]: 2019-12-30 12:57:28 LOG:   pid
40743: pool_process_query: child connection forced to terminate due to
client_idle_limit (180) reached
Dec 30 12:57:28 dataserver01 pgpool[1770]: 2019-12-30 12:57:28 LOG:   pid
43528: pool_process_query: child connection forced to terminate due to
client_idle_limit (180) reached
Dec 30 12:57:29 dataserver01 pgpool[1770]: 2019-12-30 12:57:29 LOG:   pid
42497: pool_process_query: child connection forced to terminate due to
client_idle_limit (180) reached
Dec 30 12:57:30 dataserver01 pgpool[1770]: 2019-12-30 12:57:30 LOG:   pid
42306: pool_process_query: child connection forced to terminate due to
client_idle_limit (180) reached
Dec 30 12:57:37 dataserver01 pgpool[1770]: 2019-12-30 12:57:37 LOG:   pid
9877: connect_inet_domain_socket: select() timed out. retrying...
Dec 30 12:57:37 dataserver01 pgpool[1770]: 2019-12-30 12:57:37 LOG:   pid
40604: connect_inet_domain_socket: select() timed out. retrying...
Dec 30 12:57:38 dataserver01 pgpool[1770]: 2019-12-30 12:57:38 LOG:   pid
44622: pool_process_query: child connection forced to terminate due to
client_idle_limit (180) reached
Dec 30 12:57:39 dataserver01 pgpool[1770]: 2019-12-30 12:57:39 LOG:   pid
42245: pool_process_query: child connection forced to terminate due to
client_idle_limi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20191230/20fb313c/attachment.html>