[pgpool-general: 5114] Re: failed to create watchdog receive socket

[Lakkinani, ChandraSekhar (NBCUniversal)]

Hi Team,

I am also facing this error. Please see below. I have attached my conf file.


==============
bash-4.1$ tail -1000f /tmp/pgpool.log
2016-11-09 09:24:57: pid 54151: DEBUG:  pool_coninfo_size: num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) * sizeof(ConnectionInfo) (136) = 2228224 bytes requested for shared memory
2016-11-09 09:24:57: pid 54151: DEBUG:  ProcessInfo: num_init_children (32) * sizeof(ProcessInfo) (32) = 1024 bytes requested for shared memory
2016-11-09 09:24:57: pid 54151: DEBUG:  Request info are: sizeof(POOL_REQUEST_INFO) 5224 bytes requested for shared memory
2016-11-09 09:24:57: pid 54151: DEBUG:  Recovery management area: sizeof(int) 4 bytes requested for shared memory
2016-11-09 09:24:57: pid 54151: DEBUG:  WD_Node_List: sizeof(unsigned char) (1) * MAX_NUM_BACKENDS (128) = 128 bytes requested for shared memory
2016-11-09 09:24:57: pid 54151: LOG:  waiting for watchdog to initialize
2016-11-09 09:24:57: pid 54152: LOG:  setting the local watchdog node name to "Linux_ushdbld00034.stg-tfayd.com_9999"
2016-11-09 09:24:57: pid 54152: LOG:  watchdog cluster configured with 1 remote nodes
2016-11-09 09:24:57: pid 54152: LOG:  watchdog remote node:0 on ushdbls00030.stg-tfayd.com:9000
2016-11-09 09:24:57: pid 54152: LOG:  interface monitoring is disabled in watchdog
2016-11-09 09:24:57: pid 54152: LOG:  IPC socket path: "/tmp/.s.PGPOOLWD_CMD.9000"
2016-11-09 09:24:57: pid 54152: DEBUG:  STATE MACHINE INVOKED WITH EVENT = STATE CHANGED Current State = LOADING
2016-11-09 09:24:57: pid 54152: LOG:  new outbond connection to ushdbls00030.stg-tfayd.com:9000
2016-11-09 09:24:57: pid 54152: DEBUG:  STATE MACHINE INVOKED WITH EVENT = NEW OUTBOUND_CONNECTION Current State = LOADING
2016-11-09 09:24:57: pid 54152: DEBUG:  sending watchdog packet Socket:7, Type:[ADD NODE], Command_ID:3, data Length:175
2016-11-09 09:24:57: pid 54152: DEBUG:  received packet tyep R while need packet type
2016-11-09 09:24:57: pid 54152: DEBUG:  STATE MACHINE INVOKED WITH EVENT = PACKET RECEIVED Current State = LOADING
2016-11-09 09:24:57: pid 54152: FATAL:  Add to watchdog cluster request is rejected by node "ushdbls00030.stg-tfayd.com:9000"
2016-11-09 09:24:57: pid 54152: HINT:  check the watchdog configurations.
2016-11-09 09:24:57: pid 54152: LOG:  Watchdog is shutting down
2016-11-09 09:24:57: pid 54151: DEBUG:  reaper handler
2016-11-09 09:24:57: pid 54151: DEBUG:  watchdog child process with pid: 54152 exit with FATAL ERROR. pgpool-II will be shutdown
2016-11-09 09:24:57: pid 54151: LOG:  watchdog child process with pid: 54152 exits with status 768
2016-11-09 09:24:57: pid 54151: FATAL:  watchdog child process exit with fatal error. exiting pgpool-II
2016-11-09 09:24:57: pid 54153: LOG:  setting the local watchdog node name to "Linux_ushdbld00034.stg-tfayd.com_9999"
2016-11-09 09:24:57: pid 54153: LOG:  watchdog cluster configured with 1 remote nodes
2016-11-09 09:24:57: pid 54153: LOG:  watchdog remote node:0 on ushdbls00030.stg-tfayd.com:9000
2016-11-09 09:24:57: pid 54153: LOG:  interface monitoring is disabled in watchdog
2016-11-09 09:24:57: pid 54153: LOG:  IPC socket path: "/tmp/.s.PGPOOLWD_CMD.9000"
2016-11-09 09:24:57: pid 54153: DEBUG:  STATE MACHINE INVOKED WITH EVENT = STATE CHANGED Current State = LOADING
2016-11-09 09:24:57: pid 54153: LOG:  new outbond connection to ushdbls00030.stg-tfayd.com:9000
2016-11-09 09:24:57: pid 54153: DEBUG:  STATE MACHINE INVOKED WITH EVENT = NEW OUTBOUND_CONNECTION Current State = LOADING
2016-11-09 09:24:57: pid 54153: DEBUG:  sending watchdog packet Socket:7, Type:[ADD NODE], Command_ID:3, data Length:175
2016-11-09 09:24:57: pid 54153: DEBUG:  received packet tyep R while need packet type
2016-11-09 09:24:57: pid 54153: DEBUG:  STATE MACHINE INVOKED WITH EVENT = PACKET RECEIVED Current State = LOADING
2016-11-09 09:24:57: pid 54153: FATAL:  Add to watchdog cluster request is rejected by node "ushdbls00030.stg-tfayd.com:9000"
2016-11-09 09:24:57: pid 54153: HINT:  check the watchdog configurations.
2016-11-09 09:24:57: pid 54153: LOG:  Watchdog is shutting down
2016-11-09 09:24:57: pid 54153: LOG:  Watchdog is shutting down


==============

Thanks,
Chandra L.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161109/705caee9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGPOOL.conf
Type: application/octet-stream
Size: 37365 bytes
Desc: PGPOOL.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161109/705caee9/attachment-0001.obj>