When you attempt to upgrade from SAS Viya 3.4 to SAS Viya 3.5, the upgrade might fail with a time-out when trying to execute a stop on the PostgreSQL cluster. The error might look similar to the following:
TASK [pgpoolc-x64_redhat_linux_6-yum : Execute Cluster Stop] ********************************************************************************************************************
changed: [deployTarget] => (item={u'HA_PGPOOL_WATCHDOG_PORT': u'', u'PCP_PORT': u'5430', u'SANMOUNT': u'/opt/sas/viya/config/data/sasdatasvrc', u'SERVICE_NAME': u'postgres', u'HA_PGPOOL_VIRTUAL_IP': u'', u'POOL_NUMBER': u'0', u'PGPOOL_PORT': u'5431'})
TASK [pgpoolc-x64_redhat_linux_6-yum : Await completion] ************************************************************************************************************************
FAILED - RETRYING: Await completion (50 retries left).
FAILED - RETRYING: Await completion (49 retries left).
… (repeated)
FAILED - RETRYING: Await completion (1 retries left).
failed: [deployTarget] (item={'ansible_loop_var': u'item', u'ansible_job_id': u'159919960846.2254', 'item': {u'HA_PGPOOL_WATCHDOG_PORT': u'', u'PCP_PORT': u'5430', u'SERVICE_NAME': u'postgres', u'SANMOUNT': u'/opt/sas/viya/config/data/sasdatasvrc', u'HA_PGPOOL_VIRTUAL_IP': u'', u'POOL_NUMBER': u'0', u'PGPOOL_PORT': u'5431'}, u'started': 1, 'changed': True, 'failed': False, u'finished': 0, u'results_file': u'/root/.ansible_async/159919960846.2254'}) => {"ansible_job_id": "159919960846.2254", "ansible_loop_var": "item", "attempts": 50, "changed": false, "finished": 0, "item": {"ansible_job_id": "159919960846.2254", "ansible_loop_var": "item", "changed": true, "failed": false, "finished": 0, "item": {"HA_PGPOOL_VIRTUAL_IP": "", "HA_PGPOOL_WATCHDOG_PORT": "", "PCP_PORT": "5430", "PGPOOL_PORT": "5431", "POOL_NUMBER": "0", "SANMOUNT": "/opt/sas/viya/config/data/sasdatasvrc", "SERVICE_NAME": "postgres"}, "results_file": "/root/.ansible_async/159919960846.2254", "started": 1}, "started": 1}
2020-01-06 16:31:13,997 p=23177 u=subart | NO MORE HOSTS LEFT
To work around the issue, run the playbook again.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
SAS System | SAS Viya | Linux for x64 | 3.4 | 3.5 | | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.