[pgpool-general: 4742] Re: DETAIL: bind on ":" failed with reason: "Success"

[Lucas Luengas]

Hello.

You can check "listen_addresses" in pgpool.conf.

You can try this configuration for listening for all ip addresses.

listen_addresses = '*'

Regards


On Mon, Jun 27, 2016 at 5:29 PM, Avi Weinberg <AviW at gilat.com> wrote:

> Hi all,
>
>
>
> Pgpool will not start.  Only machine reboot helped.  I was not able to
> understand the log.  Please point me to what caused it not to start.
>
>
>
> Thanks
>
>
>
>
>
> 2016-06-27 14:11:43: pid 2449: LOG:  waiting for watchdog to initialize
>
> 2016-06-27 14:11:43: pid 2451: LOG:  setting the local watchdog node name
> to "Linux_postgres_server1_9999"
>
> 2016-06-27 14:11:43: pid 2451: LOG:  watchdog cluster configured with 1
> remote nodes
>
> 2016-06-27 14:11:43: pid 2451: LOG:  watchdog remote node:0 on
> 172.18.255.42:9000
>
> 2016-06-27 14:11:43: pid 2451: LOG:  interface monitoring is disabled in
> watchdog
>
> 2016-06-27 14:11:43: pid 2451: LOG:  IPC socket path:
> "/tmp/.s.PGPOOLWD_CMD.9000"
>
> 2016-06-27 14:11:43: pid 2451: LOG:  new outbond connection to
> 172.18.255.42:9000
>
> 2016-06-27 14:11:43: pid 2451: LOG:  watchdog node state changed from
> [LOADING] to [INITIALIZING]
>
> 2016-06-27 14:11:43: pid 2451: LOG:  new watchdog node connection is
> received from "172.18.255.42:43245"
>
> 2016-06-27 14:11:44: pid 2451: LOG:  received failback request for
> node_id: 0 from pid [2451]
>
> 2016-06-27 14:11:45: pid 2451: LOG:  watchdog node state changed from
> [INITIALIZING] to [STANDBY]
>
> 2016-06-27 14:11:45: pid 2451: LOG:  successfully joined the watchdog
> cluster as standby node
>
> 2016-06-27 14:11:45: pid 2451: DETAIL:  our join coordinator request is
> accepted by cluster leader node "Linux_postgres_server2_9999"
>
> 2016-06-27 14:13:15: pid 2704: LOG:  waiting for watchdog to initialize
>
> 2016-06-27 14:13:15: pid 2706: LOG:  setting the local watchdog node name
> to "Linux_postgres_server1_9999"
>
> 2016-06-27 14:13:15: pid 2706: LOG:  watchdog cluster configured with 1
> remote nodes
>
> 2016-06-27 14:13:15: pid 2706: LOG:  watchdog remote node:0 on
> 172.18.255.42:9000
>
> 2016-06-27 14:13:15: pid 2706: LOG:  interface monitoring is disabled in
> watchdog
>
> 2016-06-27 14:13:15: pid 2706: FATAL:  failed to create watchdog receive
> socket
>
> 2016-06-27 14:13:15: pid 2706: DETAIL:  bind on ":" failed with reason:
> "Success"
>
> 2016-06-27 14:13:15: pid 2704: LOG:  watchdog child process with pid: 2706
> exits with status 768
>
> 2016-06-27 14:13:15: pid 2704: FATAL:  watchdog child process exit with
> fatal error. exiting pgpool-II
>
> 2016-06-27 14:13:15: pid 2707: LOG:  setting the local watchdog node name
> to "Linux_postgres_server1_9999"
>
> 2016-06-27 14:13:15: pid 2707: LOG:  watchdog cluster configured with 1
> remote nodes
>
> 2016-06-27 14:13:15: pid 2707: LOG:  watchdog remote node:0 on
> 172.18.255.42:9000
>
> 2016-06-27 14:13:15: pid 2707: LOG:  interface monitoring is disabled in
> watchdog
>
> 2016-06-27 14:14:38: pid 2852: LOG:  waiting for watchdog to initialize
>
> 2016-06-27 14:14:38: pid 2854: LOG:  setting the local watchdog node name
> to "Linux_postgres_server1_9999"
>
> 2016-06-27 14:14:38: pid 2854: LOG:  watchdog cluster configured with 1
> remote nodes
>
> 2016-06-27 14:14:38: pid 2854: LOG:  watchdog remote node:0 on
> 172.18.255.42:9000
>
> 2016-06-27 14:14:38: pid 2854: LOG:  interface monitoring is disabled in
> watchdog
>
> 2016-06-27 14:14:38: pid 2854: FATAL:  failed to create watchdog receive
> socket
>
> 2016-06-27 14:14:38: pid 2854: DETAIL:  bind on ":" failed with reason:
> "Success"
>
> 2016-06-27 14:14:38: pid 2852: LOG:  watchdog child process with pid: 2854
> exits with status 768
>
> 2016-06-27 14:14:38: pid 2852: FATAL:  watchdog child process exit with
> fatal error. exiting pgpool-II
>
> 2016-06-27 14:14:38: pid 2855: LOG:  setting the local watchdog node name
> to "Linux_postgres_server1_9999"
>
> 2016-06-27 14:14:38: pid 2855: LOG:  watchdog cluster configured with 1
> remote nodes
>
> 2016-06-27 14:14:38: pid 2855: LOG:  watchdog remote node:0 on
> 172.18.255.42:9000
>
> 2016-06-27 14:14:38: pid 2855: LOG:  interface monitoring is disabled in
> watchdog
>
> 2016-06-27 14:25:29: pid 3390: LOG:  waiting for watchdog to initialize
>
> 2016-06-27 14:25:29: pid 3392: LOG:  setting the local watchdog node name
> to "Linux_postgres_server1_9999"
>
> 2016-06-27 14:25:29: pid 3392: LOG:  watchdog cluster configured with 1
> remote nodes
>
> 2016-06-27 14:25:29: pid 3392: LOG:  watchdog remote node:0 on
> 172.18.255.42:9000
>
> 2016-06-27 14:25:29: pid 3392: LOG:  interface monitoring is disabled in
> watchdog
>
> 2016-06-27 14:25:29: pid 3392: FATAL:  failed to create watchdog receive
> socket
>
> 2016-06-27 14:25:29: pid 3392: DETAIL:  bind on ":" failed with reason:
> "Success"
>
> 2016-06-27 14:25:29: pid 3390: LOG:  watchdog child process with pid: 3392
> exits with status 768
>
> 2016-06-27 14:25:29: pid 3390: FATAL:  watchdog child process exit with
> fatal error. exiting pgpool-II
>
> 2016-06-27 14:25:29: pid 3393: LOG:  setting the local watchdog node name
> to "Linux_postgres_server1_9999"
>
> 2016-06-27 14:25:29: pid 3393: LOG:  watchdog cluster configured with 1
> remote nodes
>
> 2016-06-27 14:25:29: pid 3393: LOG:  watchdog remote node:0 on
> 172.18.255.42:9000
>
> 2016-06-27 14:25:29: pid 3393: LOG:  interface monitoring is disabled in
> watchdog
> IMPORTANT - This email and any attachments is intended for the above named
> addressee(s), and may contain information which is confidential or
> privileged. If you are not the intended recipient, please inform the sender
> immediately and delete this email: you should not copy or use this e-mail
> for any purpose nor disclose its contents to any person.
>
> _______________________________________________
> 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.pgpool.net/pipermail/pgpool-general/attachments/20160627/5556463b/attachment.htm>