Spectrum - DDM backup fails after upgrade to 10.4.1 or higher
Article ID: 192757
Updated On:
Products
Issue/Introduction
The DDM backup is failing after upgrading to 10.4.1 or higher.
The error in ddm_backup.log show next
200610 23:01:54 RDR1 INFO: Starting to lock all the tables...
200610 23:01:54 RDR1 ERROR: No tables to copy.
Environment
Release : 10.4.1, 21.2.x, 22.2.x, 23.3.x
Component : Spectrum Archive Manager
Cause
The ddm_save, ddm_load and ddm_backup binaries coming with the previous releases has been deprecated in 10.4.1. From 10.4.1 onward, instead, the ddm_save.pl is used to backup the DDM db.
This script rely on mysqlbackup client. The same client is used for performing different types of backup and restore operations, as well as other related tasks like backup compression, decompression and validation. This ensure improved performance with the MySQL backup and save the DDM Db without having to stop the Archive Manager.
However the client will only work on tables with Innodb engine. Tables using MyIsam engine will be ignored, hence the message "No tables to copy"
Next query can be used to confirm the tables engine: SHOW TABLE STATUS from ddmdb
Resolution
To resolve the issue, please convert the tables from MyIsam, to InnoDB, using the script convert_current_myisam_to_innodb.pl
This is described in product documentation: Post Migration Tasks
Additional Information
Feedback
