[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.pgpool.net/pipermail/pgpool-general/attachments/20130301/32fd6a9b/attachment.htm>
More information about the pgpool-general
mailing list