search

pgpool / pgpool2

This is the official mirror of git://git.postgresql.org/git/pgpool2.git. Note that this is just a *mirror* - we don't work with pull requests on github. Please subscribe to pgpool-hackers mailing list from our website and submit your patch to this mailing list.
https://www.pgpool.net
Other
305 stars 87 forks source link

cannot stop/start pgpool2 service with systemd on Ubuntu 16.04 #9

Closed yongzhang closed 6 years ago

yongzhang commented 6 years ago

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 

    Jul 04 19:52:22 pgpoolserver systemd[1]: Stopping pgpool-II...
Jul 04 19:52:52 pgpoolserver systemd[1]: pgpool2.service: State 'stop-sigterm' timed out. Killing.
Jul 04 19:52:52 pgpoolserver systemd[1]: pgpool2.service: Main process exited, code=killed, status=9/KILL
Jul 04 19:52:52 pgpoolserver systemd[1]: Stopped pgpool-II.
Jul 04 19:52:52 pgpoolserver systemd[1]: pgpool2.service: Unit entered failed state.
Jul 04 19:52:52 pgpoolserver systemd[1]: pgpool2.service: Failed with result 'signal'.

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

Please help, thanks.