Re: Service pgpool - Mailing list pgsql-general

From Jean Claude
Subject Re: Service pgpool
Date
Msg-id CA+3uWVSHj1TRswhmfxnG9Uja-_nTXReFTtj5R5rDw3m=hR7R_Q@mail.gmail.com
Whole thread Raw
In response to Re: Service pgpool  (Bo Peng <pengbo@sraoss.co.jp>)
List pgsql-general
Hi all,

How I can resolved the error about the pgpool daemon? any idea?

Jun 08 05:23:05 -pgpool02 pgpool[1400]: [5-1] 2018-06-08 05:23:05: pid 1400: LOG:  setting the local watchdog node name to "-pgpool02.adm.cacc.ch:5432 Linux -pgpool02"
Jun 08 05:23:05 -pgpool02 pgpool[1400]: [6-1] 2018-06-08 05:23:05: pid 1400: LOG:  watchdog cluster is configured with 1 remote nodes
Jun 08 05:23:05 -pgpool02 pgpool[1400]: [7-1] 2018-06-08 05:23:05: pid 1400: LOG:  watchdog remote node:0 on -pgpool01.adm.cacc.ch:9000
Jun 08 05:23:05 -pgpool02 pgpool[1400]: [8-1] 2018-06-08 05:23:05: pid 1400: LOG:  interface monitoring is disabled in watchdog
Jun 08 05:23:05 -pgpool02 pgpool[1400]: [9-1] 2018-06-08 05:23:05: pid 1400: LOG:  watchdog node state changed from [DEAD] to [LOADING]
Jun 08 05:23:05 -pgpool02 pgpool[1400]: [10-1] 2018-06-08 05:23:05: pid 1400: LOG:  new outbound connection to -pgpool01.adm.cacc.ch:9000
Jun 08 05:23:05 -pgpool02 pgpool[1400]: [11-1] 2018-06-08 05:23:05: pid 1400: FATAL:  Add to watchdog cluster request is rejected by node "-pgpool01.adm.cacc.ch:9000"
Jun 08 05:23:05 -pgpool02 pgpool[1400]: [11-2] 2018-06-08 05:23:05: pid 1400: HINT:  check the watchdog configurations.
Jun 08 05:23:05 -pgpool02 pgpool[1400]: [12-1] 2018-06-08 05:23:05: pid 1400: LOG:  Watchdog is shutting down
Jun 08 05:23:05 -pgpool02 systemd[1]: Removed slice User Slice of postgres.
Jun 08 05:23:05 -pgpool02 systemd[1]: Stopping User Slice of postgres.
Jun 08 05:23:07 -pgpool02 pgpool-II-10[1369]: Starting pgpool-II-10 service: [FAILED]
Jun 08 05:23:07 -pgpool02 systemd[1]: pgpool-II-10.service: control process exited, code=exited status=1
Jun 08 05:23:07 -pgpool02 systemd[1]: Failed to start SYSV: Starts and stops the pgpool daemon.
Jun 08 05:23:07 -pgpool02 systemd[1]: Unit pgpool-II-10.service entered failed state.
Jun 08 05:23:07 -pgpool02 systemd[1]: pgpool-II-10.service failed.
Jun 08 05:23:07 -pgpool02 polkitd[475]: Unregistered Authentication Agent for unix-process:1363:7104696 (system bus name :1.137, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-8) (disconnected from bus)
Jun 08 05:31:59 -pgpool02 sshd[1914]: Accepted publickey for root from 172.16.254.41 port 51817 ssh2: RSA SHA256:tI23LiyQq17BD1HA2CTjnRe10Ai2Gc/tykb3VxbUNL4
Jun 08 05:32:00 -pgpool02 systemd[1]: Started Session 50 of user root.
Jun 08 05:32:00 -pgpool02 sshd[1914]: pam_unix(sshd:session): session opened for user root by (uid=0)
Jun 08 05:32:00 -pgpool02 systemd-logind[479]: New session 50 of user root.
Jun 08 05:32:00 -pgpool02 systemd[1]: Starting Session 50 of user root.


Thanks for your help.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Can you make a simple view non-updatable?
Next
From: Chris Travers
Date:
Subject: Re: Code of Conduct plan