Problem Note 65303: Upgrading from SAS® Viya® 3.4 to SAS® Viya® 3.5 fails with the error "/opt/sas/viya/home/bin/pg_ctl: No such file or directory..."
When you upgrade from SAS Viya 3.4 to SAS Viya 3.5, the upgrade might fail with the following error:
"stderr": "/opt/sas/viya/home/libexec/sasdatasvrc/script/sds_set_env_variable.sh: line 287: /opt/sas/viya/home/bin/pg_ctl: No such file or directory\nsds_set_env_variable ERROR: /opt/sas/viya/home/bin/pg_ctl --version | awk '{print $3}' returned an error or null. If a new pgpool node is being added to a new host for the postgres cluster with an old postgres version, it is not allowed."
This issue is caused by the yum option clean_requirements_on_remove, which is normally located in the /etc/yum.conf directory. If the option is set to 1, True, or yes, it removes the current PostgreSQL install because a new version of PostgreSQL is delivered with SAS Viya 3.5. However, the upgrade to the newer version of PostgreSQL is not required or automatic, so the current version needs to be kept.
If you encounter this error, complete these steps:
- Restore your system to a healthy and running SAS Viya 3.4 state.
- Set the clean_requirements_on_remove option in /etc/yum.conf to 0, False, or no. The default value for this option is False.
- Run the SAS Viya 3.5 upgrade.
Operating System and Release Information
SAS System | SAS Viya | Linux for x64 | 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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2020-01-16 15:42:01 |
Date Created: | 2020-01-06 13:13:13 |