[pgpool-general: 2236] Re: pgpoll 3.3.1 watchdog

Videanu Adrian videanuadrian at yahoo.com
Wed Nov 6 22:49:04 JST 2013


Hi,

Thanks for the tip, indeed that is the problem. My linux-headers are at version 3.9 and my kernel at 3.7.
I`ll recompile the kernel in order to use the heartbeat functionality.

Thanks again for the precious tips.


 
Regards,
Adrian Videanu


________________________________
 From: Yugo Nagata <nagata at sraoss.co.jp>
To: Videanu Adrian <videanuadrian at yahoo.com> 
Cc: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Sent: Wednesday, November 6, 2013 11:41 AM
Subject: Re: [pgpool-general: 2226] pgpoll 3.3.1 watchdog
 

Hi,

Sorry for responding late.

pgpool doesn't use Heartbeat (Pacemacer), so you don't have to install
Heartbeat package on your system.

pgpool uses SO_REUSEPORT functionality of socket if this is defined in linux
header file. SO_REUSEPORT is introduced in Linux kernel 3.9 and the error
occurs in old kernel. 

We assume SO_REUSEPORT is not defined in old kernel's header. However, for
some reason, your Gentoo has the 3.9 linux headers installed, but is still
running an older kernel.

So, if you update kernal to 3.9 and run, this error would be resolved.

In other way as a workaroud, you can try editing config.h before compiling
pgpool for undefining SOREUSEPORT .

$ ./configure
$ vi config.h

add the following line at last of config.h.
#undef SO_REUSEPORT

$ make install


On Wed, 30 Oct 2013 03:49:39 -0700 (PDT)
Videanu Adrian <videanuadrian at yahoo.com> wrote:

> Hi all,
> I`m trying to setup two HA instances of pgpool on 2 Gentoo boxes.
> When i start each instance i get : 
> 
> 
> 2013-10-30 12:46:50 LOG:   pid 28656: wd_chk_setuid all commands have setuid bit
> 2013-10-30 12:46:50 LOG:   pid 28656: watchdog might call network commands which using setuid bit.
> 2013-10-30 12:46:53 LOG:   pid 28656: wd_escalation: escalating to master pgpool
> 2013-10-30 12:46:55 LOG:   pid 28656: wd_escalation: escalated to master pgpool successfully
> 2013-10-30 12:46:55 LOG:   pid 28656: wd_init: start watchdog
> 2013-10-30 12:46:55 LOG:   pid 28656: pgpool-II successfully started. version 3.3.1 (tokakiboshi)
> 2013-10-30 12:46:56 ERROR: pid 28662: wd_create_hb_recv_socket: setsockopt(SO_REUSEPORT) failed. reason: Protocol not available
> 2013-10-30 12:46:56 ERROR: pid 28662: wd_hb_receiver: socket create failed
> 2013-10-30 12:46:56 ERROR: pid 28663: wd_create_hb_send_socket: setsockopt(SO_REUSEPORT) failed. reason: Protocol not available
> 2013-10-30 12:46:56 ERROR: pid 28663: wd_hb_sender: socket create failed
> 
> 
> I`m using heartbeat as monitor method.
> 
> Do i have to install heartbeat package on my system ?
> I have installed corosync but still got the same error.
> 
> 
>  
> Regards,
> Adrian Videanu


-- 
Yugo Nagata <nagata at sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131106/2bda65ea/attachment.html>


More information about the pgpool-general mailing list