SRM reporting db is out of sync - Communication link failure

Products

• Network Observability
• Spectrum

Issue/Introduction

The issue started after copying the VM to another host in KVM (Kernel-based Virtual Machine).

The MySQL service and the Linux host have already been restarted, but the problem remains.

Aug 05, 2025 10:33:21 AM (SRM/LandscapeManager/LandscapeThread_0) (com.aprisma.errorlog) - (WARN) -  (ReportManager) - (ERROR) - Error initializing event polling

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

 

The MySQL select fails for large reporting databases.

mysql> select count(*) from event;

mysql> select count(*) from alarminfo;

 

ERROR 2013 (HY000): Lost connection to MySQL server during query

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/spectrum/mysql/tmp/mysql.sock' (111)

ERROR:

Can't connect to the server

Environment

DX NetOps Spectrum: Any version

Resolution

The issue was fixed after backing up the reporting db from the original host and restoring it to the copied host.

Stop the Tomcat service prior running the mysqldump and mysql command lines to backup and restore MySQL database:

To backup:

./mysqldump --defaults-file=../my-spectrum.cnf -uroot -p<password> --opt --routines --ignore-table=reporting.v_active_user_model --ignore-table=reporting.v_alarm_activity --ignore-table=reporting.v_ncm_config_diff --ignore-table=reporting.v_security_string_accessibility_by_landscape --ignore-table=reporting.v_user_report_security --compress --databases reporting > /tmp/dump_reporting.sql

To restore:

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<password> reporting < /tmp/dump_reporting.sql