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

[Tatsuo Ishii]

> Mar  1 10:45:31 server1 pgpool[3339]: bind(:) failed. reason: Success

This error messge seems pretty strange. ":" should be something like
"/tmp/.s.PGSQL.9898". Also it's weired because 2failed. reason:
Success". To isolate the problem, can please disable watchdog and try
again?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


> 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