Thread: 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
itwork or it used to work but suddenly stopped working etc. The contents of the unit file could give a clue whether it
wassome 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-confidenceand 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
havereceived this e-mail in error, please telephone Fujitsu Australia Software Technology Pty Ltd on + 61 2 9452 9000
orby 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
andother defects. Fujitsu Australia Software Technology Pty Ltd does not accept liability for any loss or damage
(whetherdirect, indirect, consequential or economic) however caused, and whether by negligence or otherwise, which may
resultdirectly 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,

> 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