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

[Yugo Nagata]

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>