Archive Manager no longer start after restoring the DDM database

Products

• Network Observability
• Spectrum

Issue/Introduction

After migration of Primary SpectroSERVER to the new server, the Archive Manager is not starting.

SPC-OCP-10067: The Archive Manager has been shut down because there was an error opening its database. The most likely causes:

• The SQL database server is not running.
• The username, password, hostname, or database name is not correct.
• The Database is invalid or corrupt.

Environment

DX NetOps Spectrum: Any version

Cause

The root account was used to restore the DDM database, hence the owner of the ddmdb database file is root. The MySQL server does not have the privilege to access it.

In the $SPECROOT/msyql/bin/MYSQL.OUT file:

2025-06-05T10:30:09.565665Z 40 [ERROR] [MY-012592] [InnoDB] Operating system error number 13 in a file operation.
2025-06-05T10:30:09.565700Z 40 [ERROR] [MY-012595] [InnoDB] The error means mysqld does not have the access rights to the directory.
2025-06-05T10:30:09.565707Z 40 [ERROR] [MY-012162] [InnoDB] Trying to import a tablespace, but could not open the tablespace file ./ddmdb/event#p#event_22_4_2025.ibd

Resolution

Perform the following steps on the problematic host:

1. Drop the DDM database.

cd $SPECROOT/mysql/bin/

./mysql.exe -uroot -p<password> ddmdb       (Windows)

./mysql  --defaults-file=../my-spectrum.cnf  -uroot -p<password> ddmdb        (Linux)

mysql> drop database ddmdb;

2. Recreate the DDM database.

cd $SPECROOT/mysql/bin/

./mysql.exe -uroot -p<password>        (Windows)

./mysql  --defaults-file=../my-spectrum.cnf  -uroot -p<password>         (Linux)

mysql> create database ddmdb;

 

3. Delete the $SPECROOT/SS/DDM/.DDMDB.LOCK file in case it exists.

 

4. Initialize the DDM database:

 

cd $SPECROOT/SS/DDM/

./ddm_load.pl -i -l <LH> 

 

5. Restore the DDM database:

 

cd $SPECROOT/SS/DDM/
./ddm_load.pl -f  <ddmdb_backup_file>

Additional Information

Just changing the ownership of the ddm database files and restarting the MySQL server service did not fix the issue.

Stop/start the Spectrum MySQL server service.

To stop MySQL service service:

cd $SPECROOT/bin/

./cmdC <hostname> 2 MYSQL
OR

./cmdC localhost 2 MYSQL

 

To start MySQL service service:

cd $SPECROOT/bin/

./launchinstdbapp <hostname> MYSQL y MYSQL.OUT
OR

./launchinstdbapp localhost MYSQL y MYSQL.OUT