Service pgpool

On 06/07/2018 11:16 AM, Jean Claude wrote:

Hi all,

below my problem about daemon :

Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops
the pgpool daemon.
Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered
failed state.
Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed.

Can you help me?

You probably want to ask on the pgpool list:

https://pgpool.net/mediawiki/index.php/Mailing_lists

Thanks a lot

--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
*** A fault and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
***** Unless otherwise stated, opinions are my own. *****

On 06/07/2018 11:25 AM, Joshua D. Drake wrote:

On 06/07/2018 11:16 AM, Jean Claude wrote:

Hi all,

below my problem about daemon :

Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and
stops the pgpool daemon.
Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered
failed state.
Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed.

Can you help me?

You probably want to ask on the pgpool list:

https://pgpool.net/mediawiki/index.php/Mailing_lists

If you do it would help to include the OS and its version as well as the
pgpool-II version.

Looks to me like a start script using SYSV init in a systemd system and
systemd not liking it.

Thanks a lot

--
Adrian Klaver
adrian.klaver@aklaver.com

And also the contents of the unit file itself and some more details whether is it the first time you are trying to get it work or it used to work but suddenly stopped working etc. The contents of the unit file could give a clue whether it was some typo or the sequence at which the different directives are executed in a unit, target dependencies and so on.

Best Regards,

Nawaz Ahmed
Software Development Engineer

Fujitsu Australia Software Technology Pty Ltd
14 Rodborough Road, Frenchs Forest NSW 2086, Australia
T +61 2 9452 9027
Nawaz@fast.au.fujitsu.com
fastware.com.au

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Friday, 8 June 2018 4:30 AM
To: Joshua D. Drake <jd@commandprompt.com>; Jean Claude <jeancld38@gmail.com>; pgsql-general@lists.postgresql.org
Subject: Re: Service pgpool

On 06/07/2018 11:25 AM, Joshua D. Drake wrote:

On 06/07/2018 11:16 AM, Jean Claude wrote:

Hi all,

below my problem about daemon :

Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and
stops the pgpool daemon.
Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered
failed state.
Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed.

Can you help me?

You probably want to ask on the pgpool list:

https://pgpool.net/mediawiki/index.php/Mailing_lists

If you do it would help to include the OS and its version as well as the pgpool-II version.

Looks to me like a start script using SYSV init in a systemd system and systemd not liking it.

Thanks a lot

--
Adrian Klaver
adrian.klaver@aklaver.com

Disclaimer

The information in this e-mail is confidential and may contain content that is subject to copyright and/or is commercial-in-confidence and is intended only for the use of the above named addressee. If you are not the intended recipient, you are hereby notified that dissemination, copying or use of the information is strictly prohibited. If you have received this e-mail in error, please telephone Fujitsu Australia Software Technology Pty Ltd on + 61 2 9452 9000 or by reply e-mail to the sender and delete the document and all copies thereof.

Whereas Fujitsu Australia Software Technology Pty Ltd would not knowingly transmit a virus within an email communication, it is the receiver’s responsibility to scan all communication and any files attached for computer viruses and other defects. Fujitsu Australia Software Technology Pty Ltd does not accept liability for any loss or damage (whether direct, indirect, consequential or economic) however caused, and whether by negligence or otherwise, which may result directly or indirectly from this communication or any files attached.

If you do not wish to receive commercial and/or marketing email messages from Fujitsu Australia Software Technology Pty Ltd, please email unsubscribe@fast.au.fujitsu.com

Hi,

below my problem about daemon :

Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the pgpool daemon.
Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed state.
Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed.

Could you show more error messages about systemd?

As a common case, starting Pgpool-II failed due to
missing the socket file directory which is specified
in pgpool.conf.

By the way as Joshua has already suggested, probably It
would better to make questions in the Pgpool-II dedicated
mailing list.

On Thu, 7 Jun 2018 20:16:19 +0200
Jean Claude <jeancld38@gmail.com> wrote:

Hi all,

below my problem about daemon :

Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the
pgpool daemon.
Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed
state.
Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed.

Can you help me?

Thanks a lot

--
Bo Peng <pengbo@sraoss.co.jp>
SRA OSS, Inc. Japan

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.

Dear all,

Attached you can find my pgpoof.conf file.

[root@pgpool02 pgpool-II-10]# pgpool -v
pgpool-II version 3.7.3 (amefuriboshi)
[root@asa-pgpool02 pgpool-II-10]#

[root@pgpool02 pgpool-II-10]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.5 (Maipo)
[root@pgpool02 pgpool-II-10]#

Thanks.

2018-06-08 0:10 GMT+02:00 Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>:

Hi,

Jun 08 04:40:17 asa-pgpool02 pgpool-II-10[30787]: Starting pgpool-II-10
service: pgpool is already running with pid 4285 [FAILED]

It seemed like Pgpool-II is already started. Did you start Pgpool-II twice?

Also may I ask some questions?

- How did you install Pgpool-II, using source code or RPM packages?

- If you installed Pgpool-II by using RPM packages, did you use the RPM packages
from PGDG repository provided by PostgreSQL community or from pgpool yum repository
provided by Pgpool-II community?

- Could you provide the RPM package name?

- How did you start Pgpool-II?
It seemed like you started Pgpool-II with systemd, but the init script is used.
Normally on RHEL 7.x the systemd service is used to start a service.

On Fri, 8 Jun 2018 10:47:34 +0200
Jean Claude <jeancld38@gmail.com> wrote:

Hi Bo Peng,

Thank you for your feedback.

You can find the status of my service below :

[root@asa-pgpool02 tmp]# systemctl status pgpool-II-10.service
● pgpool-II-10.service - SYSV: Starts and stops the pgpool daemon
Loaded: loaded (/etc/rc.d/init.d/pgpool-II-10; bad; vendor preset:
disabled)
Active: failed (Result: exit-code) since Fri 2018-06-08 04:40:17 EDT;
5min ago
Docs: man:systemd-sysv-generator(8)
Process: 30787 ExecStart=/etc/rc.d/init.d/pgpool-II-10 start
(code=exited, status=1/FAILURE)

Jun 08 04:40:17 asa-pgpool02 systemd[1]: Starting SYSV: Starts and stops
the pgpool daemon...
Jun 08 04:40:17 asa-pgpool02 pgpool-II-10[30787]: Starting pgpool-II-10
service: pgpool is already running with pid 4285 [FAILED]
Jun 08 04:40:17 asa-pgpool02 systemd[1]: pgpool-II-10.service: control
process exited, code=exited status=1
Jun 08 04:40:17 asa-pgpool02 systemd[1]: Failed to start SYSV: Starts and
stops the pgpool daemon.
Jun 08 04:40:17 asa-pgpool02 systemd[1]: Unit pgpool-II-10.service entered
failed state.
Jun 08 04:40:17 asa-pgpool02 systemd[1]: pgpool-II-10.service failed.
[root@asa-pgpool02 tmp]#

Thanks

2018-06-08 4:22 GMT+02:00 Bo Peng <pengbo@sraoss.co.jp>:

Hi,

below my problem about daemon :

Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops

the pgpool daemon.

Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered

failed state.

Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed.

Could you show more error messages about systemd?

As a common case, starting Pgpool-II failed due to
missing the socket file directory which is specified
in pgpool.conf.

By the way as Joshua has already suggested, probably It
would better to make questions in the Pgpool-II dedicated
mailing list.

On Thu, 7 Jun 2018 20:16:19 +0200
Jean Claude <jeancld38@gmail.com> wrote:

Hi all,

below my problem about daemon :

Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops

the

pgpool daemon.
Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed
state.
Jun 07 14:06:45 vm02 systemd[1]: pgpool-II-10.service failed.

Can you help me?

Thanks a lot

--
Bo Peng <pengbo@sraoss.co.jp>
SRA OSS, Inc. Japan

--
Bo Peng <pengbo@sraoss.co.jp>
SRA OSS, Inc. Japan

Hi,

Thanks, I have reinstall the package and now it's OK.

Regards,

2018-06-10 3:55 GMT+02:00 Bo Peng <pengbo@sraoss.co.jp>: