[pgpool-general: 1452] pgPool-II 3.2.3 going in to an unrecoverable state after multiple starting stopping pgpool

ning chan ninchan8328 at gmail.com
Sat Mar 2 06:11:37 JST 2013


Hi All,
After upgrade to pgPool-II 3.2.3 and I tested my failover/ failback setup,
and start / stop pgpool mutlip times, I see one of the pgpool goes in to an
unrecoverable state.

Mar  1 10:45:25 server1 pgpool[3007]: received smart shutdown request
Mar  1 10:45:25 server1 pgpool[3007]: watchdog_pid: 3010
Mar  1 10:45:31 server1 pgpool[3338]: wd_chk_sticky: ifup[/sbin/ip] doesn't
have sticky bit
Mar  1 10:45:31 server1 pgpool[3339]: bind(:) failed. reason: Success
Mar  1 10:45:31 server1 pgpool[3339]: unlink(/tmp/.s.PGSQL.9898) failed: No
such file or directory


netstat shows the following:
[root at server1 ~]# netstat -na |egrep "9898|9999"
tcp        0      0 0.0.0.0:9898                0.0.0.0:*
LISTEN
tcp        0      0 0.0.0.0:9999                0.0.0.0:*
LISTEN
tcp        0      0 172.16.6.154:46650          172.16.6.153:9999
TIME_WAIT
tcp        9      0 172.16.6.154:9999           172.16.6.153:51868
CLOSE_WAIT
tcp        9      0 172.16.6.154:9999           172.16.6.153:51906
CLOSE_WAIT
tcp        0      0 172.16.6.154:9999           172.16.6.154:50624
TIME_WAIT
tcp        9      0 172.16.6.154:9999           172.16.6.153:51946
CLOSE_WAIT
unix  2      [ ACC ]     STREAM     LISTENING     18698  /tmp/.s.PGSQL.9898
unix  2      [ ACC ]     STREAM     LISTENING     18685  /tmp/.s.PGSQL.9999

Is this a known issue?

I will have to reboot the server in order to start pgpool back online.

My cluster has two servers (server0 & server1) which each of them are
running pgpool, and postgreSQL with streaming Replication setup.

Thanks~
Ning
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130301/32fd6a9b/attachment.html>


More information about the pgpool-general mailing list