From: | Pierre Ochsenbein <pierreochsenbein(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Watchdog issues |
Date: | 2018-07-19 08:30:48 |
Message-ID: | CABG8FoMz1Ea9rUsHrQBvQKto5x_FX6yJDhJtoHLy3Zr3RRP4Wg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello Guys'
About my output below. I need to modify the port number of my standby
server (9999) to work the pgpool cluster?
[root(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alfonso Moscato | 2018-07-20 11:14:53 | repeated out of shared memory error - not related to max_locks_per_transaction |
Previous Message | 066ce286 | 2018-07-19 08:22:46 | plpython3u and virtualenv |