EnterpriseDB/repmgr

LOG: could not receive data from client: Connection reset by peer

Opened this issue · 0 comments

lohengrin1870 commented

Hello

Sometimes we hit this kind of issue when launching "repmgr cluster show" by an automatic script which is monitoring the cluster state do you have an idea what's wrong because the script doesn't get the status of cluster and returns an error ?

2022-03-25` 20:45:11 CET [57351]: [1-1] user=repmgr,db=repmgr,client=x.x.x.138 LOG: could not receive data from client: Connection reset by peer

2022-03-25 21:12:43 CET [37218]: [1-1] user=repmgr,db=repmgr,client=x.x.x.138 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37220]: [1-1] user=repmgr,db=repmgr,client=x.x.x.137 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37223]: [1-1] user=repmgr,db=repmgr,client=x.x.x.138 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37224]: [1-1] user=repmgr,db=repmgr,client=x.x.x.139 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37226]: [1-1] user=repmgr,db=repmgr,client=x.x.x.139 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37227]: [1-1] user=repmgr,db=repmgr,client=x.x.x.139 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37228]: [1-1] user=repmgr,db=repmgr,client=x.x.x.139 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37229]: [1-1] user=repmgr,db=repmgr,client=x.x.x.139 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37230]: [1-1] user=repmgr,db=repmgr,client=x.x.x.139 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37232]: [1-1] user=repmgr,db=repmgr,client=x.x.x.139 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37233]: [1-1] user=repmgr,db=repmgr,client=x.x.x.139 LOG: could not receive data from client: Connection reset by peer
2022-03-25 21:12:43 CET [37235]: [1-1] user=repmgr,db=repmgr,client=x.x.x.145 LOG: could not receive data from client: Connection reset by peer
...

repmgr 5.3 PostgreSQL 10.19
There is a pgbouncer and an haproxy too,

here is the output of cluster show :
ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string
-------+-----------------+---------+-----------+-----------------+----------+----------+----------+---------------------------------------------------------------------------------------------------------------------------
11101 | pgsql-a2s11-101 | primary | * running | | GE | 100 | 142 | host=x.x.x.137 port=5432 application_name=pgsql-a2s11-101 user=repmgr dbname=repmgr connect_timeout=2 sslmode=disable
12102 | pgsql-a2s12-102 | standby | running | pgsql-a2s11-101 | GE | 100 | 142 | host=x.x.x.138 port=5432 application_name=pgsql-a2s12-102 user=repmgr dbname=repmgr connect_timeout=2 sslmode=disable
21101 | pgsql-a2s21-101 | standby | running | pgsql-a2s12-102 | BE | 0 | 142 | host=x.x.x.139 port=5432 application_name=pgsql-a2s21-101 user=repmgr dbname=repmgr connect_timeout=2 sslmode=disable
22102 | pgsql-a2s22-102 | standby | running | pgsql-a2s21-101 | BE | 0 | 142 | host=x.x.x.145 port=5432 application_name=pgsql-a2s22-102 user=repmgr dbname=repmgr connect_timeout=2 sslmode=disable