View Issue Details

IDProjectCategoryView StatusLast Update
0000332Pgpool-II[All Projects] Generalpublic2017-12-14 00:12
ReportervishnuduttpvAssigned ToMuhammad Usama 
PriorityhighSeveritymajorReproducibilityalways
Status assignedResolutionopen 
Product Version3.6.5 
Target VersionFixed in Version 
Summary0000332: Watch dog issue
DescriptionI have configured pgpool 3.6.5 and postgres 9.5.6 . While trying to restart the pgpool ,Its showing error as follows
2017-08-23 22:58:17: pid 3658: LOG: failed to acquire the delegate IP address
2017-08-23 22:58:17: pid 3658: DETAIL: 'if_up_cmd' failed
2017-08-23 22:58:17: pid 3658: WARNING: watchdog escalation failed to acquire delegate IP
2017-08-23 22:58:17: pid 3647: LOG: watchdog escalation process with pid: 3658 exit with SUCCESS.
2017-08-23 22:58:18: pid 3665: LOG: set SO_REUSEPORT option to the socket
2017-08-23 22:58:18: pid 3663: LOG: set SO_REUSEPORT option to the socket
2017-08-23 22:58:18: pid 3663: LOG: creating watchdog heartbeat receive socket.
2017-08-23 22:58:18: pid 3663: DETAIL: set SO_REUSEPORT
2017-08-23 22:58:18: pid 3665: LOG: creating socket for sending heartbeat


I have given all the required permissions to the required commands(ip,arping,ping etc.)
But when I checked it through the postgres user bash, its working fine!
all the commands for bringing up the vip is running!
Also when I stop the pgpool ,
2017-08-23 22:58:45: pid 3643: LOG: received smart shutdown request
2017-08-23 22:58:45: pid 3643: LOG: shutdown request. closing listen socket
2017-08-23 22:58:45: pid 3733: LOG: stop request sent to pgpool. waiting for termination...
.2017-08-23 22:58:45: pid 3647: LOG: Watchdog is shutting down
2017-08-23 22:58:45: pid 3734: LOG: watchdog: de-escalation started
2017-08-23 22:58:45: pid 3734: LOG: successfully released the delegate IP:"192.168.43.6"
2017-08-23 22:58:45: pid 3734: DETAIL: 'if_down_cmd' returned with success

Its working fine!
Thanks in advance!
Additional Informationwd_hostname = ''
                                    # Host name or IP address of this watchdog
                                    # (change requires restart)
wd_port = 9000
                                    # port number for watchdog service
                                    # (change requires restart)
wd_priority = 1
                                                                        # priority of this watchdog in leader election
                                                                        # (change requires restart)

wd_authkey = ''
                                    # Authentication key for watchdog communication
                                    # (change requires restart)

wd_ipc_socket_dir = '/var/run/postgresql'
                                                                        # Unix domain socket path for watchdog IPC socket
                                                                           # The Debian package defaults to
                                                                        # /var/run/postgresql
                                                                        # (change requires restart)


# - Virtual IP control Setting -

delegate_IP = '192.168.43.6'
                                    # delegate IP address
                                    # If this is empty, virtual IP never bring up.
                                    # (change requires restart)
if_cmd_path = '/etc/pgpool-II/bin'
                                    # path to the directory where if_up/down_cmd exists
                                    # (change requires restart)
if_up_cmd = 'ip addr add 192.168.43.6/24 dev enp0s31f6 label enp0s31f6:0'
                                    # startup delegate IP command
                                    # (change requires restart)
if_down_cmd = 'ip addr del 192.168.43.6/24 dev enp0s31f6:0'
                                    # shutdown delegate IP command
                                    # (change requires restart)
arping_path = '/etc/pgpool-II/bin'

TagsNo tags attached.

Activities

Muhammad Usama

2017-08-30 00:08

developer   ~0001691

You have set "/etc/pgpool-II/bin" in if_cmd_path, Have you copied ip command binaries to this directory? And when you say the commands work fine from terminal using postgres user. Did you executed the commands from same "/etc/pgpool-II/bin" direcotry?

vishnuduttpv

2017-08-30 13:33

reporter   ~0001693

Yes. I executed the commands from the specified location in the conf file, ie "/etc/pgpool-II/bin". The permissions of the bin contents are as follows,

[root@localhost ~]# ls -l /etc/pgpool-II/bin/
total 2152
-rwsrwxrwx 1 root root 23752 Aug 23 20:11 arping
-rwsrwxrwx 1 root root 369216 Aug 23 20:11 ip
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_attach_node
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_detach_node
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_node_count
-rwxrwxrwx 1 apache root 29344 Aug 23 12:49 pcp_node_info
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_pool_status
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_proc_count
-rwxrwxrwx 1 apache root 29344 Aug 23 12:49 pcp_proc_info
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_promote_node
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_recovery_node
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_stop_pgpool
-rwxrwxrwx 1 apache root 29352 Aug 23 12:49 pcp_watchdog_info
-rwxrwxrwx 1 apache root 1378224 Aug 23 12:49 pgpool
-rwsrwxrwx 1 root root 62088 Aug 23 20:06 ping

And I have set the suid bits for the required in both the locations.
As postgres user, I executed the commands from the same specified location.

Muhammad Usama

2017-12-14 00:12

developer   ~0001866

Hi,

Sorry for the very delayed response, Were you able to get around the issue or are you still getting this problem?
I tried to reproduce the issue but unable to do so. If you are still getting seeing the issue please share the complete Pgpool-II log file and if possible set the log_min_message to DEBUG level before generating the log.

Thanks

Issue History

Date Modified Username Field Change
2017-08-24 02:35 vishnuduttpv New Issue
2017-08-24 22:29 t-ishii Assigned To => Muhammad Usama
2017-08-24 22:29 t-ishii Status new => assigned
2017-08-30 00:08 Muhammad Usama Note Added: 0001691
2017-08-30 13:33 vishnuduttpv Note Added: 0001693
2017-12-14 00:12 Muhammad Usama Note Added: 0001866