Restore from backup on the new SES server failed


Doc ID    SOLN211944
Version:    2.0
Status:    Published
Published date:    18 Jan 2016
Created Date:    10 Oct 2012
Author:   
tbokor
 

Details

Backup was taken from the existing MBT SES server in production. The new S8800 was installed at the BP with the same IP parameters, but the restore from backup file fails:
 

THEPID is: 12691
backup: 13: Fatal error received from post_restore routine for ses';' see log file
backup: 13: post-restore for ses failed with error - 256 -- Restore terminated
Value for file >/etc/opt/ecs/backup/ses_153634_20120914.info is undefined or not a
FileHandle at /opt/ecs/lib/perl/fileop.pm line 590.
Performing ERROR RECOVERY, please wait.....

***************

Customer has Co-Res SES system and after server replaced the SES backup restoration was failing with same error as above

The User had activated SP7b sometime ago on the old SES system and later they de-activated the patch and removed it  and than took a backup of the server. The installed the new server and did not apply any patch for SES and they attempted to restore the translations which would fail with above error

 

 

 

The backup’s logs are showing that at the time they did the backup of the SES database, the patch was indeed just “unpacked”. But because of the schema version, apparently that patch must have been activated at some point but then was deactivated.
 

Customer system without SES patch:
mvss=# select * from local_parameters;
application |  scope   |          name          |       value
-------------+----------+------------------------+-------------------
system      | database | schema                 | 5122======================!!
system      | database | database_version       | 7.4.17
system      | database | upgrade_in_progress    | false
boot        | system   | role                   | master
boot        | system   | master_ip_address      | 192.168.8.60
system      | info     | software_version       | SES-5.2.1.0-016.1

 

Backup file we wanted to restore:
COPY local_parameters (application, scope, name, value) FROM stdin;
boot    system  role    master
system  database        database_version        7.4.17
system  database        upgrade_in_progress     false
boot    system  master_ip_address       192.168.8.60
system  database        schema  5124===========================!!
system  info    software_version        SES-5.2.1.0-016.1
 

Problem Clarification

Customer is to replace old MBT duplex server with new S8800. The new S8800 was installed with the same IP parameters. SES backup was made on the old MBT. Using this backup the restoration attempt failed on the new S8800 SES Virtual Machine. During the restoration the below error occured:
THEPID is: 12691
backup: 13: Fatal error received from post_restore routine for ses';' see log file
backup: 13: post-restore for ses failed with error - 256 -- Restore terminated
Value for file >/etc/opt/ecs/backup/ses_153634_20120914.info is undefined or not a
FileHandle at /opt/ecs/lib/perl/fileop.pm line 590.
Performing ERROR RECOVERY, please wait.....

Cause

New server did not have the same Service Pack as the production server

Database schema mistmatch due to no patch installed on the new installed server while user was trying to restore translations from old server which had service pack 7b installed.

error message by the restore script (fileop.pm 590 error)-, found that  the /usr/impress/sip-server/bin/pre-checks fails. It fails with the following exception “SESUTIL ERROR: The backup cannot be restored its database schema version is greater than system DB schema version”. Just before this exception, the script executes an SQL query of: “SELECT value FROM local_parameters WHERE application=\'system\' AND scope=\'database\' AND name=\'schema\';”.

Solution

After installing SP5 (same SP as on the production server) restore was successful

Scenario 2: Installed service pack 7b and than checked database schema which now show 5124 same as the backup translations and therefore restoration of backup was successful.


Avaya -- Proprietary. Use pursuant to the terms of your signed agreement or Avaya policy