Spectrum - ddm backup fails after upgrade to 10.4.1
search cancel

Spectrum - ddm backup fails after upgrade to 10.4.1


Article ID: 192757


Updated On:


CA Spectrum DX NetOps


The ddm backup is failing after upgrading to 10.4.1

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.


Release : 10.4.1, 21.2.x

Component : Spectrum Core / SpectroSERVER


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


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