Re: Service pgpool
Hi, Thanks, I have reinstall the package and now it's OK. Regards, 2018-06-10 3:55 GMT+02:00 Bo Peng : > 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 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 : > > > > > 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 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 > > > SRA OSS, Inc. Japan > > > > > > > > > -- > Bo Peng > SRA OSS, Inc. Japan > >
Re: Service pgpool
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 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 : > > > 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 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 > > SRA OSS, Inc. Japan > > > > -- Bo Peng SRA OSS, Inc. Japan
Re: Service pgpool
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 : > 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 > na...@fast.au.fujitsu.com > fastware.com.au > > > > > -Original Message- > From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] > Sent: Friday, 8 June 2018 4:30 AM > To: Joshua D. Drake ; Jean Claude < > jeancl...@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.kla...@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 > unsubscr...@fast.au.fujitsu.com > pgpool.conf Description: Binary data
Re: Service pgpool
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.
Re: Service pgpool
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 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 SRA OSS, Inc. Japan
RE: Service pgpool
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 na...@fast.au.fujitsu.com fastware.com.au -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Friday, 8 June 2018 4:30 AM To: Joshua D. Drake ; Jean Claude ; 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.kla...@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 unsubscr...@fast.au.fujitsu.com
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.kla...@aklaver.com
Re: 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. *
