search cancel

DX Spectrum : Archive Manager Table Conversion issue

book

Article ID: 201848

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

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

Cause

It appears that the convert_current_myisan_to_innodb.pl 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 

Environment

Release : 10.4

Component : Spectrum Core / SpectroSERVER

Resolution

> 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
event_innodb
event
tmp_partitionlog


> 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.