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-11 13:04:18
Message-ID: CA+3uWVRJo3KoQp6O+gdw8P2+LinfDSciz2F363Oun7qfr=cdzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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

Regards,

2018-06-10 3:55 GMT+02:00 Bo Peng <pengbo(at)sraoss(dot)co(dot)jp>:

> 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
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean Claude 2018-06-11 13:06:35 Add to watchdog cluster request is rejected by node
Previous Message Thomas Kellerer 2018-06-11 11:26:16 Re: Catching unique_violation exception on specific column/index