Postgres Pro
Downloads
Home   >   mailing lists

Watchdog issues - Mailing list pgsql-admin

From Pierre Ochsenbein
Subject Watchdog issues
Date
Msg-id CABG8FoMz1Ea9rUsHrQBvQKto5x_FX6yJDhJtoHLy3Zr3RRP4Wg@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
Hello Guys'

About my output below. I need to modify the port number of my standby server (9999) to work the pgpool cluster?

[root@tes01 ~]# /usr/pgpool-10/bin/pcp_watchdog_info -p 9898 -U pgpool
Password:
2 YES test01.adm.test.ch:5432 Linux test01 test01.test.cacc.ch

test01.adm.test.ch:5432 Linux pgpool01 test01.test.cacc.ch 5432 9000 4 MASTER
Not_Set test02.test.cacc.ch 9999 9000 0 DEAD

-----

Log in my standby test02 :

Jul 13 11:38:08 test02 pgpool[824]: [7-1] 2018-07-13 11:38:08: pid 824: FATAL:  Add to watchdog cluster request is rejected by node "pgpool01.adm.cacc.ch:9000"
Jul 13 11:38:08 test02 pgpool[824]: [7-2] 2018-07-13 11:38:08: pid 824: HINT:  check the watchdog configurations.
Jul 13 11:38:08 test02 pgpool[824]: [8-1] 2018-07-13 11:38:08: pid 824: LOG:  Watchdog is shutting down
Jul 13 11:38:08 test02 pgpool[776]: [2-1] 2018-07-13 11:38:08: pid 776: LOG:  watchdog child process with pid: 824 exits with status 768
Jul 13 11:38:08 test02 pgpool[776]: [3-1] 2018-07-13 11:38:08: pid 776: FATAL:  watchdog child process exit with fatal error. exiting pgpool-II
Jul 13 11:38:08 test02 systemd[1]: pgpool-II-10.service: main process exited, code=exited, status=3/NOTIMPLEMENTED
Jul 13 11:38:08 test02 pgpool[830]: [1-1] 2018-07-13 11:38:08: pid 830: FATAL:  could not read pid file
Jul 13 11:38:08 test02 systemd[1]: pgpool-II-10.service: control process exited, code=exited status=3
Jul 13 11:38:08 test02 systemd[1]: Unit pgpool-II-10.service entered failed state.
Jul 13 11:38:08 test02 systemd[1]: pgpool-II-10.service failed

Thanks in advance,
Pierre

pgsql-admin by date:

Previous
From: 066ce286@free.fr
Date:
Subject: plpython3u and virtualenv
Next
From: "Alfonso Moscato"
Date:
Subject: repeated out of shared memory error - not related to max_locks_per_transaction