Spectrum Archive Manager (DDM) database Event table insert error
At the same time, the following message recorded in the ARCHMGR.OUT.
-------------------------------------------------------------
3 29 01:49:09 ERROR TRACE at ModelArchDBImp.cc(4814): doSqlQuery/mysql_query: Failure executing query:
INSERT DELAYED IGNORE INTO event(model_h, utime, counter, clk_seq, version, node_id, user_key, type, severity, vardata_string) VALUES(5247247,1522255748,934267,411,1,'\0PV N ,67329,20,' \0\0\0\0 \0\0 \0\0\0zA
\0 \0\0\0 \0\0\0 \0\0\0 \0\0\0 \0\0\0 \0 \0\0\0 \0\0\0 \0\0\0 \0\0\0\0\0\0\0 \0\0\0 \0\0\0 \0\0\0 ?ZzA
\0 \0PV N \0\0 \0\0\0 \0\0\0 \0\0\0 ?ZyA
\0 \0PV N \0\0 \0\0\0 \r\0\0\0 \0\0\0\0\0\0\0')
- Query execution was interrupted ModelArchDb ERROR at DDMDbIf2.cc(885):
-------------------------------------------------------------
NOTE: Starting from DX NetOps Spectrum 21.2.4, the default root password for MySql is "MySqlR00t". For DX NetOps Spectrum versions prior to 21.2.4, the default root password is "root". In the following MySql commands, replace <PASSWD> with the root password for your DX NetOps Spectrum version.
The DDMDB Event table returned crashed status when the following is done:
1. Log into the SpectroSERVER system as the user that owns the Spectrum installation
2. If on Windows, start a bash shell by running "bash -login"
3. cd to the $SPECROOT/mysql directory and enter the following command to log into mysql:
./mysql --defaults-file=../my-spectrum.cnf -uroot -p<PASSWD> ddmdb
4. Enter the following command at the mysql prompt:
show table status;
5. Check for an error similar to the following:
| event | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL | NULL| NULL | NULL | Table '.\ddmdb\event' | is marked as crashed and should be repaired |