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