[pgpool-general: 5116] Re: pgpool-general Digest, Vol 61, Issue 12

Lakkinani, ChandraSekhar (NBCUniversal) ChandraSekhar.Lakkinani at nbcuni.com
Thu Nov 10 17:37:09 JST 2016 

Hi Usama,

Thanks for your help.

Here's the log files and conf files from both the servers.

Thanks,
Chandra L.




-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of pgpool-general-request at pgpool.net
Sent: Thursday, November 10, 2016 8:30 AM
To: pgpool-general at pgpool.net
Subject: pgpool-general Digest, Vol 61, Issue 12

Send pgpool-general mailing list submissions to
	pgpool-general at pgpool.net

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.sraoss.jp/mailman/listinfo/pgpool-general
or, via email, send a message with subject or body 'help' to
	pgpool-general-request at pgpool.net

You can reach the person managing the list at
	pgpool-general-owner at pgpool.net

When replying, please edit your Subject line so it is more specific than "Re: Contents of pgpool-general digest..."


Today's Topics:

   1. [pgpool-general: 5115] Re: failed to create watchdog receive
      socket (Muhammad Usama)


----------------------------------------------------------------------

Message: 1
Date: Thu, 10 Nov 2016 01:37:08 +0500
From: Muhammad Usama <m.usama at gmail.com>
To: "Lakkinani,	ChandraSekhar (NBCUniversal)"
	<ChandraSekhar.Lakkinani at nbcuni.com>
Cc: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net>
Subject: [pgpool-general: 5115] Re: failed to create watchdog receive
	socket
Message-ID:
	<CAEJvTzUk_w8aijXpYzfreNTA7GTPY7jid0Y3e=m_O5Fy=O1b0Q at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

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-0001.html>

------------------------------

_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general


End of pgpool-general Digest, Vol 61, Issue 12
**********************************************
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGPOOLslave.conf
Type: application/octet-stream
Size: 39381 bytes
Desc: PGPOOLslave.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161110/7b1b9a64/attachment-0002.obj>
-------------- 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/20161110/7b1b9a64/attachment-0003.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: slavepgpool.jpg
Type: image/jpeg
Size: 313846 bytes
Desc: slavepgpool.jpg
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161110/7b1b9a64/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: masterpgpool.JPG
Type: image/jpeg
Size: 265365 bytes
Desc: masterpgpool.JPG
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161110/7b1b9a64/attachment-0001.jpe>

More information about the pgpool-general mailing list