Thread: watchdog issues
Hello Guys'
I have implement a pgpool-II cluster and the standby service want not to add on the watchdog info..
Some issues for help?
[root@tes01 ~]# /usr/pgpool-10/bin/pcp_watchdo g_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
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
-----
test01 active
├─12725 pgpool: wait for connection request
├─12784 pgpool: wait for connection request
└─14564 pgpool: wait for connection request
Jul 17 09:55:59 test01 pgpool[2925]: [431-1] 2018-07-17 09:55:59: pid 2925: LOG: new connection received
Jul 17 09:55:59 test01 pgpool[2925]: [431-2] 2018-07-17 09:55:59: pid 2925: DETAIL: connecting host=test01 port=59438
Jul 17 09:55:59 test01 pgpool[2925]: [432-1] 2018-07-17 09:55:59: pid 2925: ERROR: backend authentication failed
Jul 17 09:55:59 test01 pgpool[2925]: [432-2] 2018-07-17 09:55:59: pid 2925: DETAIL: backend response with kind 'E' when expecting 'R'
Jul 17 09:55:59 test01 pgpool[2925]: [432-3] 2018-07-17 09:55:59: pid 2925: HINT: This issue can be caused by version mismatch (current version 3)
Jul 17 09:55:59 test01 pgpool[2166]: [222-1] 2018-07-17 09:55:59: pid 2166: LOG: new connection received
Jul 17 09:55:59 test01 pgpool[2166]: [222-2] 2018-07-17 09:55:59: pid 2166: DETAIL: connecting host=test01 port=59442
Jul 17 09:55:59 test01 pgpool[2166]: [223-1] 2018-07-17 09:55:59: pid 2166: ERROR: backend authentication failed
Jul 17 09:55:59 test01 pgpool[2166]: [223-2] 2018-07-17 09:55:59: pid 2166: DETAIL: backend response with kind 'E' when expecting 'R'
Jul 17 09:55:59 test01 pgpool[2166]: [223-3] 2018-07-17 09:55:59: pid 2166: HINT: This issue can be caused by version mismatch (current version 2)
[root@test01 pgpool-II-10]#
├─12784 pgpool: wait for connection request
└─14564 pgpool: wait for connection request
Jul 17 09:55:59 test01 pgpool[2925]: [431-1] 2018-07-17 09:55:59: pid 2925: LOG: new connection received
Jul 17 09:55:59 test01 pgpool[2925]: [431-2] 2018-07-17 09:55:59: pid 2925: DETAIL: connecting host=test01 port=59438
Jul 17 09:55:59 test01 pgpool[2925]: [432-1] 2018-07-17 09:55:59: pid 2925: ERROR: backend authentication failed
Jul 17 09:55:59 test01 pgpool[2925]: [432-2] 2018-07-17 09:55:59: pid 2925: DETAIL: backend response with kind 'E' when expecting 'R'
Jul 17 09:55:59 test01 pgpool[2925]: [432-3] 2018-07-17 09:55:59: pid 2925: HINT: This issue can be caused by version mismatch (current version 3)
Jul 17 09:55:59 test01 pgpool[2166]: [222-1] 2018-07-17 09:55:59: pid 2166: LOG: new connection received
Jul 17 09:55:59 test01 pgpool[2166]: [222-2] 2018-07-17 09:55:59: pid 2166: DETAIL: connecting host=test01 port=59442
Jul 17 09:55:59 test01 pgpool[2166]: [223-1] 2018-07-17 09:55:59: pid 2166: ERROR: backend authentication failed
Jul 17 09:55:59 test01 pgpool[2166]: [223-2] 2018-07-17 09:55:59: pid 2166: DETAIL: backend response with kind 'E' when expecting 'R'
Jul 17 09:55:59 test01 pgpool[2166]: [223-3] 2018-07-17 09:55:59: pid 2166: HINT: This issue can be caused by version mismatch (current version 2)
[root@test01 pgpool-II-10]#
-----
test02 standby
pgpool-log in my standby test02 :
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,
Jean
On 07/17/2018 07:01 AM, Jean Claude wrote: > Hello Guys' > > I have implement a pgpool-II cluster and the standby service want not to > add on the watchdog info.. > Some issues for help? > > Jul 17 09:55:59 test01 pgpool[2166]: [223-2] 2018-07-17 09:55:59: pid > 2166: DETAIL: backend response with kind 'E' when expecting 'R' > Jul 17 09:55:59 test01 pgpool[2166]: [223-3] 2018-07-17 09:55:59: pid > 2166: HINT: This issue can be caused by version mismatch (current > version 2) I don't use pgpool-II, but I would take the above as indicator that there may be different versions of pgpool-II trying to communicate with each other and failing. So what are the versions for each pgpool-II node? > [root@test01 pgpool-II-10]# > > > Thanks in advance, > Jean > -- Adrian Klaver adrian.klaver@aklaver.com