Spectrum db_optimize script terminates
The cause of this is likely environmental in nature and likely could not be pinpointed.
The workaround to this issue is to utilize the out of the box MySQL Tools to optimize.
1. Log into the SpectroSERVER system as the user that owns the Spectrum installation
2. If running Windows, start a bash shell by running "bash -login"
3. cd to the $SPECROOT/mysql/bin directory and enter the following command:
./mysqlcheck --defaults-file=../my-spectrum.cnf -uroot -proot -o ddmdb
This may take some time to complete depending on the size of the Archive Manager (ddmdb) database.
Please reference the "DDM Database Maintenance" section of the documentation for more information.