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

[Muhammad Usama]

Hi


Apparently, as per the log shared above, the watchdog on the remote
(second) pgpool-II node is rejecting the add request (Add to watchdog
cluster request is rejected by node "ushdbls00030.stg-tfayd.com:9000"),
This happens because of the configuration mismatch on the pgpool-II nodes.

Can you share the pgpool.conf and pgpool log of both pgpool-II nodes.


Thanks

Best regards

Muhammad Usama




On Wed, Nov 9, 2016 at 10:40 PM, Lakkinani, ChandraSekhar (NBCUniversal) <
ChandraSekhar.Lakkinani at nbcuni.com> wrote:

> 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.
>
>
>
>
>
>
>
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161110/8bad42a0/attachment.html>