Hello,
after I received a 500 error on login I tried to restart SAS.
I have the following error:
fatal: [casactive]: FAILED! => {"changed": true, "msg": "non-zero return code", "rc": 1, "stderr": "Shared connection to sas1 closed.\r\n", "stderr_lines": ["Shared connection to sas1 closed."], "stdout": "ERROR: f_get_pool_primary_from_watchdog: Failed '/opt/sas/viya/home/pgpool-II40/bin/pcp_watchdog_info -h 172.16.18.70 -p 5430 -U sas with sas password'. return_code: 1. Virtual IP may not be accessible. Check 'ping 172.16.18.70' from the current host\r\nERROR: f_show_pool_nodes: failed 'f_set_psql_to_pool_primary'. rC=2\r\nCurrentLogFile=/opt/sas/viya/config/var/log/sasdatasvrc/postgres/pgpool0/shutdownall_20251216_121506_668.log\r\nTo see the progress, do: tail -f <log-file>\r\nERROR: f_operate_node_request: The consul-template-operation-node service may be down or failed to invoke its template script. node: pgpool0, wait time=16s\r\nERROR: f_operate_node_request: Failed PoolNode:All:Stop for postgres\r\nERROR: f_stop_cluster: failed 'f_operate_node_request PoolNode:All:Stop'. rC=1\r\nERROR: main: failed 'f_stop_cluster'. rC=1\r\n", "stdout_lines": ["ERROR: f_get_pool_primary_from_watchdog: Failed '/opt/sas/viya/home/pgpool-II40/bin/pcp_watchdog_info -h 172.16.18.70 -p 5430 -U sas with sas password'. return_code: 1. Virtual IP may not be accessible. Check 'ping 172.16.18.70' from the current host", "ERROR: f_show_pool_nodes: failed 'f_set_psql_to_pool_primary'. rC=2", "CurrentLogFile=/opt/sas/viya/config/var/log/sasdatasvrc/postgres/pgpool0/shutdownall_20251216_121506_668.log", "To see the progress, do: tail -f <log-file>", "ERROR: f_operate_node_request: The consul-template-operation-node service may be down or failed to invoke its template script. node: pgpool0, wait time=16s", "ERROR: f_operate_node_request: Failed PoolNode:All:Stop for postgres", "ERROR: f_stop_cluster: failed 'f_operate_node_request PoolNode:All:Stop'. rC=1", "ERROR: main: failed 'f_stop_cluster'. rC=1"]}
I have restarted the postgres service and the consul template operation service manually but without any result.
I don't think is a network issue.
