[pgpool-general: 2286] Re: Strange watchdog - trusted server issue

Yugo Nagata nagata at sraoss.co.jp
Fri Nov 15 15:44:24 JST 2013


Hi,

> Nov 14 13:34:11 pgdb92-id03 pgpool[10108]: get_result: ping data: PING 
> 10.201.101.92 (10.201.101.92) 56(84) bytes of data.#012#012--- 
> 10.201.101.92 ping statistics ---#0123 packets transmitted, 3 received, 
> 0% packet loss, time 2006ms#012rtt min/avg/max/mdev = 
> 0.000/0.000/0.002/0.001 ms

There is a strange string '#012', which should be a line break.
Is this the same is other log lines about PING, or only right
before down of pgpool-II?


On Thu, 14 Nov 2013 14:45:10 +0100
Sam Wouters <sam at ericom.be> wrote:

> Hi,
> 
> I have a running pgpool-II (3.3.1 on ubuntu-lts, package from postgresql 
> repo) cluster, consisting of three nodes with watchdog enabled.
> After a random period of time (a couple hours), watchdog goes into down 
> state, with below log lines. This happenes consequently and on different 
> clusters, no network issues that I know off (checked tcpdumps etc).
> The log also says that ping to the trusted servers succeeds, but 
> nevertheless you get the "failed to connect to any trusted servers"?
> 
> Any help in debugging this issue would be very much appreciated....
> 
> Sam
> 
> <LOG SNIPPET>
> Nov 14 13:34:11 pgdb92-id03 pgpool[10107]: wd_hb_send: send 224 byte packet
> Nov 14 13:34:11 pgdb92-id03 pgpool[10107]: wd_hb_sender: send heartbeat 
> signal to 10.201.101.92:9694
> Nov 14 13:34:11 pgdb92-id03 pgpool[10106]: wd_hb_recv: received 224 byte 
> packet
> Nov 14 13:34:11 pgdb92-id03 pgpool[10106]: wd_hb_receiver: received 
> heartbeat signal from 10.201.101.92:5432
> Nov 14 13:34:11 pgdb92-id03 pgpool[10108]: exec_ping: succeed to ping 
> 10.201.101.91
> Nov 14 13:34:11 pgdb92-id03 pgpool[10108]: get_result: ping data: PING 
> 10.201.101.91 (10.201.101.91) 56(84) bytes of data.#012
> Nov 14 13:34:11 pgdb92-id03 pgpool[10108]: exec_ping: succeed to ping 
> 10.201.101.92
> Nov 14 13:34:11 pgdb92-id03 pgpool[10108]: get_result: ping data: PING 
> 10.201.101.92 (10.201.101.92) 56(84) bytes of data.#012#012--- 
> 10.201.101.92 ping statistics ---#0123 packets transmitted, 3 received, 
> 0% packet loss, time 2006ms#012rtt min/avg/max/mdev = 
> 0.000/0.000/0.002/0.001 ms
> Nov 14 13:34:11 pgdb92-id03 pgpool[10108]: wd_lifecheck: failed to 
> connect to any trusted servers
> Nov 14 13:34:11 pgdb92-id03 pgpool[10108]: wd_IP_down: not delegate IP 
> holder
> </LOG SNIPPET>
> 
> 


-- 
Yugo Nagata <nagata at sraoss.co.jp>


More information about the pgpool-general mailing list