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..
Release : 21.2.8
Component : Spectrum Core / SpectroSERVER / Spectrum Install
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.
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.