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

Jérôme Schell jsh at myreseau.org
Fri Dec 5 01:17:52 JST 2014


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:
~~~~~
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?

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.

Thanks a lot.
Regards.
-- 
Jérôme
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool2-watchdog-wait-fix.patch
Type: text/x-patch
Size: 1114 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141204/83ddacdb/attachment.bin>


More information about the pgpool-general mailing list