DDM Database Save Failure

book

Article ID: 132321

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

When using ddm_save.pl to save the DDM database, it fails.  You can see a similar stacktrace in the log:


190506 16:18:30 MAIN    INFO: An exceptional situation is detected therefore printing 
 stacktrace. mysqlbackup might able to recover from this situation.

stack_bottom = 0 thread_stack 0x10000
/opt/CA/Spectrum/SS/DDM/mysqlbackup(my_print_stacktrace+0x2e)[0x6c134e]
/opt/CA/Spectrum/SS/DDM/mysqlbackup(_ZN3meb9ExceptionC1ENS_14enum_exit_codeEPKcS3_i+0xf1)[0x49da21]
/opt/CA/Spectrum/SS/DDM/mysqlbackup(_ZN3meb17Exception_factory16create_exceptionENS_14enum_exit_codeEPKcS3_i+0x48)[0x4a46a8]
/opt/CA/Spectrum/SS/DDM/mysqlbackup(_ZN3meb11Meb_session7performEv+0xe4)[0x4a4104]
/opt/CA/Spectrum/SS/DDM/mysqlbackup(_ZN3meb20mysqlbackup_parallelEiPPc+0x2a)[0x49d67a]
/opt/CA/Spectrum/SS/DDM/mysqlbackup(main+0x64)[0x49d814]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f023af47c05]
/opt/CA/Spectrum/SS/DDM/mysqlbackup[0x49d529]
190506 16:18:30 MAIN TRACE_1: created exception, file: '/export/home/pb2/build/sb_0-29729096-1532351551.24/meb-4.1.2/src/meb/meb_session.cpp'  line: 635  num: 2  msg: 'NULL'
mysqlbackup failed with errors!
190506 16:18:30 MAIN TRACE_2: [CLOSE] 8:/opt/CA/Spectrum/mysql/data/ib_logfile0
190506 16:18:30 MAIN TRACE_2: [CLOSE] 9:/opt/CA/Spectrum/mysql/data/ib_logfile0
190506 16:18:30 MAIN TRACE_2: [CLOSE] 10:/opt/CA/Spectrum/SS-DB-Backup/db_20190506_1549.DDMDb.tmpdir/datadir/ibbackup_logfile
190506 16:18:30 MAIN    INFO: Setting server system variable 'old_alter_table' back to '0'.
190506 16:18:30 MAIN TRACE_1: Executing MySQL query 'SET @@GLOBAL.old_alter_table = 0'
 
 

Cause

The mysql database is still running as type myisam.  It needs to be converted to innodb to work with the perl script (ddm_save.pl).

Environment

Release:
Component: SPCAPP

Resolution

Manually run the convert script to convert mysql from myisam to innodb using the "convert_current_myisam_to_innodb.pl" script:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-3/installing-and-upgrading/upgrading/migrating-and-upgrading-ca-spectrum.html#concept.dita_0f4aeba1d1631eef896cf0be58e5d093e5bbaa8e_PostMigrationTasks

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-3-1/installing-and-upgrading/upgrading/migrating-and-upgrading-ca-spectrum.html#concept.dita_703b7ca929d2ec16d153d142ae654c04653b2d5e_PostMigrationTasks

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-3-2/installing-and-upgrading/upgrading/migrating-and-upgrading-ca-spectrum.html#concept.dita_703b7ca929d2ec16d153d142ae654c04653b2d5e_PostMigrationTasks

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4/installing-and-upgrading/upgrading/migrating-and-upgrading-ca-spectrum.html#concept.dita_703b7ca929d2ec16d153d142ae654c04653b2d5e_PostMigrationTasks

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4-1/installing-and-upgrading/upgrading/migrating-and-upgrading-ca-spectrum.html#concept.dita_703b7ca929d2ec16d153d142ae654c04653b2d5e_PostMigrationTasks

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4/installing-and-upgrading/upgrading.html

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4-1/installing-and-upgrading/upgrading.html