[pgpool-general: 5610] Re: failed to bind a socket: "/var/run/postgresql/.s.PGSQL.9999"

[Yong Zhang]

It works! Thank you Pavel.

From: Pavel<mailto:balroga3 at yandex.ru>
Sent: Tuesday, July 4, 2017 8:55 PM
To: Yong Zhang<mailto:hiscal at outlook.com>; pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
Subject: Re: [pgpool-general: 5608] failed to bind a socket: "/var/run/postgresql/.s.PGSQL.9999"

Hello, Yong.

Try using the "fast" option for stopping pgpool:
This is how I did this:
cat /etc/systemd/system/pgpool2.service.d/override.conf
[Service]
ExecStart=
ExecStart=/usr/local/bin/pgpool -n -D
ExecStop=/usr/local/bin/pgpool -m fast stop
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=pgpool2


About starting error, I guess socket file was not correctly deleted during previous shutdown. Try deleting it manually and stopping pgpool with "fast" option next time as described above.

Hope it helps.


You wrote 4 июля 2017 г., 14:35:19:


        Does anyone have the same issue with mine?

OS: Ubuntu16.04
Pgpool2:  3.6.4-1.pgdg16.04+1
PostgreSQL:  9.6.3-1.pgdg16.04+1

Pgpool2 service is controlled by systemd.

Issues:

  1.  “Systemctl stop pgpool2” will take a long time and finally will be failed
  2.  “systemctl start pgpool2” will have below errors in logs:

Jul  4 16:50:30 pgpoolserver pgpool[2179]: 2017-07-04 16:50:30: pid 2179: FATAL:  failed to bind a socket: "/var/run/postgresql/.s.PGSQL.9999"
Jul  4 16:50:30 pgpoolserver pgpool[2179]: 2017-07-04 16:50:30: pid 2179: DETAIL:  bind socket failed with error: "Address already in use"
Jul  4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED
Jul  4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Unit entered failed state.
Jul  4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Failed with result 'exit-code'.





--
Best regards,
Pavel                          mailto:balroga3 at yandex.ru
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170705/ab67b1dd/attachment-0001.html>