Problem Note 59101: Database backup fails with the SAS® Deployment Backup and Recovery Tool and returns "COMMAND_TOOL_ERROR_PGBACKUP"
The Deployment Backup and Recovery Tool might report a failure when performing a backup of the EVManager database when your deployment is SAS 9.4TS1M3. When the database backup fails, the Deployment Backup and Recovery Tool reports an exception like the one shown here:
Got Exception as follows:
Backup Errors
Error Entry:
Status Code: 311
Name: COMMAND_TOOL_ERROR_PGBACKUP
Category: DATABASE
Classification: ERROR
Date and Time Of Error: 2016-09-01T01_09_43
Log Name: backupserver.log
Log File Location: /usr/local/SAS/config/Lev1/Backup
Originating Tier: Host: yourhost.yourdomain.com
Configuration Directory: /usr/local/SAS/config/Lev1
Message: An error encountered in the pg_backup utility.
When you look at the backupserver.log, you see LOCK TABLE and IN ACCESS SHARE MODE.
Here is an example:
INFO com.sas.svcs.backup.server.handler.PostgresBackupHandler - pg_dump: The command was: LOCK TABLE public.hq_metric_data_3d_0s IN ACCESS SHARE MODE
This issue has been fixed in SAS® 9.4TS1M4 software. If your software is SAS® 9.4TS1M3, use the workaround provided below.
Workaround
To work around the problem, you need to replace your hq-server-5.8.0.jar with an updated version of the file. Before replacing the file, you must first stop the SAS® Environment Manager.
- Stop the SAS Environment Manager.
2. Locate the hq-server-5.8.0.jar file. Here is an example:
SAS-configuration-directory\LevN\Web\SASEnvironmentManager\server-5.8.0-EE\hq-engine\hq server\webapps\ROOT\WEB-INF\lib
3. Make a backup of your hq-server-5.8.0.jar file by renaming the file to hq-server-5.8.0.jar.old
4. Download and save a new hq-server-5.8.0.jar file from here: hq-server-5.8.0.jar.txt
Important: Do not open the file.
5. Rename hq-server-5.8.0.jar.txt to hq-server-5.8.0.jar and then copy the file to this location:
SAS-configuration-directory\LevN\Web\SASEnvironmentManager\server-5.8.0-EE\hq-engine\hq-engine\hq-server\webapps\ROOT\WEB-INF\lib
6. Restart the SAS Environment Manager Server.
Operating System and Release Information
SAS System | SAS Environment Manager | Microsoft® Windows® for x64 | 2.5 | 2.5 | 9.4 TS1M3 | 9.4 TS1M4 |
64-bit Enabled AIX | 2.5 | 2.5 | 9.4 TS1M3 | 9.4 TS1M4 |
64-bit Enabled Solaris | 2.5 | 2.5 | 9.4 TS1M3 | 9.4 TS1M4 |
HP-UX IPF | 2.5 | 2.5 | 9.4 TS1M3 | 9.4 TS1M4 |
Linux for x64 | 2.5 | 2.5 | 9.4 TS1M3 | 9.4 TS1M4 |
Solaris for x64 | 2.5 | 2.5 | 9.4 TS1M3 | 9.4 TS1M4 |
*
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.
With the Deployment Backup and Recovery Tool, the backup of Postgres fails with "The command was: LOCK TABLE public.hq_metric_data_0d_0s IN ACCESS SHARE MODE"
Type: | Problem Note |
Priority: | high |
Date Modified: | 2017-05-04 17:11:43 |
Date Created: | 2016-10-06 12:06:54 |