Re: Service pgpool

From: Jean Claude <jeancld38(at)gmail(dot)com>
To: Bo Peng <pengbo(at)sraoss(dot)co(dot)jp>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Service pgpool
Date: 2018-06-08 09:40:28
Message-ID: CA+3uWVSHj1TRswhmfxnG9Uja-_nTXReFTtj5R5rDw3m=hR7R_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2018-06-08 09:53:54 Re: Code of Conduct plan
Previous Message Ron 2018-06-08 09:27:02 Re: Can you make a simple view non-updatable?