The global synch is not completing and DA and spectrum data sources stay in synchronizing state.
I see in Global Synchronization Status
Last Run Status: Failed
Services were started and then stopped in the middle of the spectrum synch, and an sql call was not completed.
We see this in the DMService.log:
INFO | jvm 1 | 2020/09/10 16:55:12 | | Start firstPollLoop
STATUS | wrapper | 2020/09/10 17:02:06 | TERM trapped. Shutting down.
INFO | jvm 1 | 2020/09/10 17:04:54 | | Start firstPollLoop
INFO | jvm 1 | 2020/09/10 17:04:54 | java.util.concurrent.ExecutionException: org.springframework.dao.DuplicateKeyException: StatementCallback; SQL [CALL sp_reset_item_mapping_table()]; Duplicate entry '69975681' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '69975681' for key 'PRIMARY'
So the sql call did not complete and now there are duplicate entries in the table.
Release : 3.7
Component : IM Reporting / Admin / Configuration
systemctl stop caperfcenter_console; systemctl stop caperfcenter_devicemanager; systemctl stop caperfcenter_eventmanager; systemctl stop caperfcenter_sso;
mysql netqosportal -unetqos -pnetqos (your password will vary)
mysql> show processlist;
and make sure no sql calls being made.
Next run this sql command:
delete from item_mapping;
restart capc processes
systemctl start caperfcenter_sso; sleep 30; systemctl start caperfcenter_devicemanager; sleep 30; systemctl start caperfcenter_eventmanager; sleep 30; systemctl start caperfcenter_console;