search cancel

Spectrum OneClick synchronization failure with performance manager

book

Article ID: 243803

calendar_today

Updated On:

Products

DX NetOps

Issue/Introduction

I restarted tomcat services and its still the same.

In the gui i can see:

A processing failure occurred on the data source during synchronization.

 

If i perform data source test - it is successful but synch still fails.

 

 

Environment

Release : 21.2

Component : Spectrum Integrations

Cause

The OC tomcat log shows:

Jun 09, 2022 08:03:53.193 (NETQOS/Startup/Container) (NetqosEventLog) - (ERROR) - Error creating netqos integtration database.
Caused by: com.aprisma.util.mysql.ScriptRunnerException: Error occurred while running SQL script.
  Script: /export/opt/DX/Spectrum/Install-Tools/netqos/sql/create_netqos_integ_db.sql
 at com.aprisma.util.mysql.SQLScriptRunner.runScript(SQLScriptRunner.java:162)
 at com.aprisma.util.mysql.SQLScriptRunner.runScript(SQLScriptRunner.java:134)
 at com.ca.im.netqos.integration.dao.jdbc.JdbcSchemaDAO.createDB(JdbcSchemaDAO.java:67)
 at com.ca.im.netqos.integration.dao.jdbc.JdbcSchemaDAO.init(JdbcSchemaDAO.java:47)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 

The mySQL log shows:

2022-06-09T02:15:58.024612Z 0 [ERROR] Another process with pid 14424 is using unix socket file.
2022-06-09T02:15:58.024620Z 0 [ERROR] Unable to setup unix socket lock file.
2022-06-09T02:15:58.024624Z 0 [ERROR] Aborting

this was caused by a hard shut down of the server, which left a lock file on the mySQL socket, that did not get cleared, so mySql could not start. 

Resolution

The MySQL server socket lock needs to be deleted from here Spectrum/mysql/tmp/mysql.sock

$ ls
mysql.sock  mysql.sock.lock
$ rm mysql.sock.lock
$ ls
mysql.sock

mySql can now be restarted.  We do not recommend to hard stop the OneClick server in this manner.