search cancel

DX Spectrum : Archive Manager Table Conversion issue


Article ID: 201848


Updated On:


CA Spectrum


After upgrade of spectrum 10.2.3 to 10.4.0, while performing the achieve manger table conversion activity user observed that table conversion struck and database seems to be down.

- perl.exe was in task manager
- 1 mysqld.exe and 1 mysql.exe in task manager (the script uses mysql.exe -e to run commands and we did not see one executing)
- 'show full processlist;' query do not show any activity


Release : 10.4

Component : Spectrum Core / SpectroSERVER


It appears that the script hung while processing. It was at the point where it should have
  executed mysql to import a data file $SPECROOT/mysql/bin/event_1601045221.txt 


> stopped the script (CTRL+C).
> We loaded the datafile event_1601045221.txt into the event_innodb table

cd $SPECROOT/mysql/bin/
./mysql -uroot -proot -e "LOAD DATA LOCAL INFILE 'event_1601045221.txt' INTO TABLE event_innodb CHARACTER SET UTF8'" -v ddmdb

LOAD DATA LOCAL INFILE 'event_1601045221.txt' INTO TABLE event_innodb CHARACTER SET UTF8

This took 5-10 minutes and appeared to have about 4 days of data as we saw 4 partitions increasing in size

>  Checked tables
use ddmdb;
show tables;

We saw

> Following the script, the next steps were to rename the tables
RENAME TABLE event TO event_tmp;
RENAME TABLE event_innodb TO event;
RENAME TABLE tmp_partitionlog TO partitionlog;

- For sanity
show create table event;

The output of this command showed that the event table was partitioned and using the innodb engine

*** For the moment we are leaving the MyISAM event table (now event_tmp), if all looks ok they will drop the table
use ddmdb;
DROP TABLE event_tmp;

- Started the ArchMgr
The ArchMgr started up without any issue

- Launched the OneClick Console
- OneClick shows 'Events' as connected and green
- we were able to see events for models under the Events Tab both current and old.