During upgrade from 10.4.0 to 21.2.8, migration fails due to event size

Products

• CA Spectrum

Issue/Introduction

We are upgrading from 10.4.0 to 21.2.8 and we have landscapes that have very large size of ddmdb events that are important to us and we want to migrate.

From doing a test before the migration we see the following error on a ddmdb size of 3.8gb, the largest ddmdb size is just under 12gb.

 

How can we fix this so we can migrate the events properly?

 

ERROR 1205 (HY000) at line 1: Lock wait timeout exceeded; try restarting transaction

Error:event partition58 :1 executing "D:/spectrum/mysql/bin//mysql --defaults-file=D:/spectrum/mysql/my-spectrum.cnf -uSPEC_admin ddmdb --local-infile=1 -e "LOAD Data local INFILE 'D:/spectrum/SS/DDM/dbsavefile.tgz.tempdir//ddmdb_backup/event_partition58.txt' IGNORE into table ddmdb.event CHARACTER SET UTF8""

load of partition 58 failed

event partition table load failed exiting..

 

Environment

Release : 21.2.8

Component : Spectrum Core / SpectroSERVER  /  Spectrum Install

Cause

During the upgrade or migration with events we need to load the ddmdb and the current in house tool cannot handle events of this size properly.

Resolution

Engineering has released a new ddm_load_legacy.exe that resolves the upgrade problem that needs to be replaced during the upgrade.

The out of box fix will be included 21.2.12 so future releases should not have this problem.