[pgpool-general: 1946] Re: pgpool 3.2.5 watchdog ifconfig down always hangs
Jeff Frost
jeff at pgexperts.com
Fri Jul 26 23:48:46 JST 2013
Yes, you can see the pgpool processes stuck in my ps output below.
They happily exit once I kill -9 the sudo process.
I'll see if I can get some stack traces but if you can't reproduce on Ubuntu or CentOS, I suspect it's something with Debian Squeeze's sudo or ifconfig commands.
On Jul 26, 2013, at 3:24 AM, Yugo Nagata <nagata at sraoss.co.jp> wrote:
> Hi,
>
> Does pgpool hang as well as ifconfig when it is stopped?
> I cannot reproduce this on CentOS and Ubuntu. Both pgpool and
> ifconfig stops normally.
>
> Could you please provide me the stack trace of hanging pgpool and
> log msessages?
>
>
> On Thu, 25 Jul 2013 09:56:36 -0700
> Jeff Frost <jeff at pgexperts.com> wrote:
>
>> This seems to be the same on 3.2.3, 3.2.4 and 3.2.5.
>>
>> The watchdog section of pgpool.conf looks like this:
>>
>> use_watchdog = on
>> delegate_IP = '10.100.2.72'
>> wd_hostname = '10.100.2.70'
>> wd_port = 9000
>> ifconfig_path = '/usr/bin'
>> arping_path = '/usr/bin'
>> if_up_cmd = 'sudo ifconfig eth0:1 $_IP_$ netmask 255.255.255.0 up'
>> if_down_cmd = 'sudo ifconfig eth0:1 $_IP_$ netmask 255.255.255.0 down'
>> arping_cmd = 'sudo arping -U $_IP_$ -w 1'
>> wd_interval = 3
>> other_pgpool_hostname0 = '10.100.2.71'
>> other_pgpool_port0 = 9999
>> other_wd_port0 = 9000
>>
>> virtual IP starts up great and properly moves to the secondary pgpool server
>> if you stop pgpool. However, the ifconfig becomes defunct and never exits
>> requiring a kill -9:
>>
>> jeff at pgpool01:/tmp/pgpool$ ps -ef|grep pgpool
>> postgres 19974 1 0 09:51 pts/0 00:00:00 /tmp/pgpool/bin/pgpool -n
>> postgres 19975 1 0 09:51 pts/0 00:00:00 logger -t pgpool -p local0.info
>> postgres 19978 19974 0 09:51 pts/0 00:00:00 pgpool: watchdog
>> postgres 19979 19974 0 09:51 pts/0 00:00:00 pgpool: lifecheck
>> jeff 20735 1615 0 09:54 pts/0 00:00:00 grep pgpool
>>
>> jeff at pgpool01:/tmp/pgpool$ ps -ef|grep ifconfig
>> root 20439 19979 0 09:52 pts/0 00:00:00 sudo ifconfig eth0:1
>> 10.100.2.72 netmask 255.255.255.0 down
>> root 20440 20439 0 09:52 pts/0 00:00:00 [ifconfig] <defunct>
>> jeff 20737 1615 0 09:54 pts/0 00:00:00 grep ifconfig
>>
>> System is Debian Squeeze. Any idea how to fix this? kill -9 of the sudo
>> allows pgpool to exit.
>>
>> --
>> Jeff Frost <jeff at pgexperts.com>
>> CTO, PostgreSQL Experts, Inc.
>> Phone: 1-888-PG-EXPRT x506
>> FAX: 415-762-5122
>> http://www.pgexperts.com/
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> --
> Yugo Nagata <nagata at sraoss.co.jp>
---
Jeff Frost <jeff at pgexperts.com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/
More information about the pgpool-general
mailing list