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 <jeancld38(at)gmail(dot)com> wrote:

> Hi Bo Peng,
>
> Thank you for your feedback.
>
> You can find the status of my service below :
>
> [root(at)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(at)asa-pgpool02 tmp]#
>
> Thanks
>
>
>
> 2018-06-08 4:22 GMT+02:00 Bo Peng <pengbo(at)sraoss(dot)co(dot)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(at)gmail(dot)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(at)sraoss(dot)co(dot)jp>
> > SRA OSS, Inc. Japan
> >
> >

--
Bo Peng <pengbo(at)sraoss(dot)co(dot)jp>
SRA OSS, Inc. Japan