[pgpool-general: 5298] Pgpool Startup issue

[ahmad milani]

Hi,

My pgpool was working fine but now I get the bellow error and it wont
start(after a sudden shut down):

*●* pgpool-II-95.service - PGPool-II Middleware Between PostgreSQL Servers
And PostgreSQL Database Clients

   Loaded: loaded (/usr/lib/systemd/system/pgpool-II-95.service; enabled;
vendor preset: disabled)

   Active: *failed* (Result: exit-code) since Sun 2017-02-05 13:50:22 UTC;
33min ago

  Process: 2534 ExecStop=/usr/pgpool-9.5/bin/pgpool -f
/etc/pgpool-II-95/pgpool.conf -m fast stop *(code=exited, status=3)*

  Process: 2532 ExecStart=/usr/pgpool-9.5/bin/pgpool -f
/etc/pgpool-II-95/pgpool.conf $OPTS *(code=exited, status=3)*

 Main PID: 2532 (code=exited, status=3)


Feb 05 13:50:22 pgpool systemd[1]: Started PGPool-II Middleware Between
PostgreSQL Servers And PostgreSQL Database Clients.

Feb 05 13:50:22 pgpool systemd[1]: Starting PGPool-II Middleware Between
PostgreSQL Servers And PostgreSQL Database Clients...

Feb 05 13:50:22 pgpool pgpool[2532]: 2017-02-05 13:50:22: pid 2532: FATAL:
failed to bind a socket: "/tmp/.s.PGSQL.5432"

Feb 05 13:50:22 pgpool pgpool[2532]: 2017-02-05 13:50:22: pid 2532:
DETAIL:  bind socket failed with error: "Address already in use"

Feb 05 13:50:22 pgpool systemd[1]: *pgpool-II-95.service: main process
exited, code=exited, status=3/NOTIMPLEMENTED*

Feb 05 13:50:22 pgpool pgpool[2534]: 2017-02-05 13:50:22: pid 2534: FATAL:
could not read pid file

Feb 05 13:50:22 pgpool systemd[1]: *pgpool-II-95.service: control process
exited, code=exited status=3*

Feb 05 13:50:22 pgpool systemd[1]: *Unit pgpool-II-95.service entered
failed state.*

Feb 05 13:50:22 pgpool systemd[1]: *pgpool-II-95.service failed.*



017-02-05 13:52:35: pid 2543: FATAL:  failed to bind a socket:
"/tmp/.s.PGSQL.5432"

2017-02-05 13:52:35: pid 2543: DETAIL:  bind socket failed with error:
"Address already in use"
I restarted it-- > no luck
I'm on centos 7. I read somethings about startup script but have no clue
about them.
Your help is appritiated.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170205/3aad7da1/attachment.html>