[pgpool-general: 3350] Re: Watchdog - ifconfig up failed

[Tatsuo Ishii]

> Le 03/12/2014 15:21, Tatsuo Ishii a écrit :
>>> Yeah could be. I will come up if other idea comes to me.
>> 
>> I wonder what signal action for SIGCHLD is set before calling
>> fork(). If it's set to SIG_IGN, then sigchild will not be delivered to
>> parent when the child exits. What about making sure that the action is
>> SIG_DFL?
> 
> Hi Tatsuo,
> 
> Good catch, it seems this one did the trick:

Glad to hear that.

> ~~~~~
> Dec  4 16:10:04 db01 pgpool[22511]: wd_hb_send: send 224 byte packet
> Dec  4 16:10:04 db01 pgpool[22511]: wd_hb_sender: send heartbeat signal
> to db02:9899
> Dec  4 16:10:06 db01 pgpool[22511]: wd_hb_send: send 224 byte packet
> Dec  4 16:10:06 db01 pgpool[22511]: wd_hb_sender: send heartbeat signal
> to db02:9899
> Dec  4 16:10:08 db01 pgpool[22511]: wd_hb_send: send 224 byte packet
> Dec  4 16:10:08 db01 pgpool[22511]: wd_hb_sender: send heartbeat signal
> to db02:9899
> Dec  4 16:10:10 db01 pgpool[22511]: wd_hb_send: send 224 byte packet
> Dec  4 16:10:10 db01 pgpool[22511]: wd_hb_sender: send heartbeat signal
> to db02:9899
> Dec  4 16:10:12 db01 pgpool[22511]: wd_hb_send: send 224 byte packet
> Dec  4 16:10:12 db01 pgpool[22511]: wd_hb_sender: send heartbeat signal
> to db02:9899
> Dec  4 16:10:14 db01 pgpool[22509]: wd_escalation: escalating to master
> pgpool
> Dec  4 16:10:14 db01 pgpool[22509]: exec_ifconfig: 'sudo /bin/ip addr
> add xxx.xx.xx.xx/24 dev bond0' succeeded
> Dec  4 16:10:14 db01 pgpool[22511]: wd_hb_send: send 224 byte packet
> Dec  4 16:10:14 db01 pgpool[22511]: wd_hb_sender: send heartbeat signal
> to db02:9899
> Dec  4 16:10:16 db01 pgpool[22509]: exec_ifconfig: 'sudo /usr/bin/arping
> -w 1 -U -I bond0 xxx.xx.xx.xxx' succeeded
> Dec  4 16:10:16 db01 pgpool[22511]: wd_hb_send: send 224 byte packet
> Dec  4 16:10:16 db01 pgpool[22511]: wd_hb_sender: send heartbeat signal
> to db02:9899
> Dec  4 16:10:18 db01 pgpool[22509]: exec_ping: succeed to ping
> xxx.xxx.xxx.xxx
> Dec  4 16:10:18 db01 pgpool[22509]: get_result: ping data: PING
> xxx.xxx.xxx.xxx (xxx.xxx.xx.xx) 56(84) bytes of data.#012#012---
> xxx.xxx.xxx.xxx ping statistics ---#0123 packets transmitted, 3
> received, 0% packet loss, time 1999ms#012rtt min/avg/max/mdev =
> 0.013/0.015/0.020/0.005 ms
> Dec  4 16:10:18 db01 pgpool[22509]: wd_IP_up: ifconfig up succeeded
> Dec  4 16:10:18 db01 pgpool[22509]: wd_declare: send the packet to
> declare the new master
> Dec  4 16:10:18 db01 pgpool[22509]: wd_escalation: escalated to master
> pgpool successfully
> ~~~~~
> 
> Attached is the patch applied on 3.3.4.
> Could we hope to see that included in a stable release?

Sure. I will commit/put into 3.3-stable tree.

> By the way it seems that the tests in 3.4.0 are broken due to the file
> layout change. Compilation fails also when enabling memcache.

Yup. We have fixed the problem in 3.4-stable tree. We plan to release
3.4.1 in January (probably along with 3.3 series update release.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp