Spectrum Archive Manager (DDM) database Event table insert error
Article ID: 92209
Updated On: 10-13-2023
Products
Issue/Introduction
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):
-------------------------------------------------------------
Environment
Component: SPCCSS
Cause
NOTE: 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 |
Resolution
1. Log into the SpectroSERVER system as the user that owns the Spectrum installation
2. Ensure the Archive Manager process is not running
3. With the Archive Manager process not running, check the $SPECROOT/SS/DDM directory for a file named ".DDMDB.LOCK". If found, delete this file.
4. If on Windows, start a bash shell by running "bash -login"
5. cd to the $SPECROOT/SS/DDM directory and enter the following command to repair the database:
./ArchMgr -repair
6. You should see information similar to the following:
4 03 17:10:57 : ArchMgr started as user 'Administrator'
4 03 17:10:57 : ArchMgr attempting to repair corrupt database
SPC-SHD-29021:
**************************************************************************
4 03 17:10:58 ERROR TRACE at ModelArchDBImp.cc(4814): doSqlQuery/mysql_query: Failure executing query:
SHOW COLUMNS FROM event LIKE 'node_id' - Table '.\ddmdb\event' is marked as crashed and should be repaired
Database corruption detected:
ddmdb.event - Size of indexfile is: 54490112 Should be: 95400960
ddmdb.event - Size of datafile is: 288640840 Should be: 357222664
ddmdb.event - Corrupt
Repairing...
ddmdb.event - OK
4 03 17:11:08 : ArchMgr successfully repaired database.
7. If repair is successful, start the Archive Manager process as normal
Additional Information
Feedback
