View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000332 | Pgpool-II | General | public | 2017-08-24 02:35 | 2017-12-14 00:12 |
| Reporter | vishnuduttpv | Assigned To | Muhammad Usama | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Product Version | 3.6.5 | ||||
| Summary | 0000332: Watch dog issue | ||||
| Description | I 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 Information | wd_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' | ||||
| Tags | No tags attached. | ||||
|
|
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? |
|
|
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. |
|
|
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 |
| 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 |
