The NetQos NQMySQL Service stops and cannot be started on the NFA Harvester

Products

• DX NetOps
• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

The "NetQos NQMySQL" service dies after each attempt to start it.

The log file oursql_error.log shows the following error:

2024-09-18T12:48:30.442408Z 0 [System] [MY-010116] [Server] E:/CA/NFA/Netflow/bin/mysqld.exe (mysqld 8.0.33-commercial) starting as process 8100
2024-09-18T12:48:30.470111Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-18T12:48:30.471313Z 1 [ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2024-09-18T12:48:30.471832Z 1 [ERROR] [MY-012278] [InnoDB] 
2024-09-18T12:48:30.472342Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-09-18T12:48:30.473011Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-09-18T12:48:30.473452Z 0 [ERROR] [MY-010119] [Server] Aborting

Environment

Windows NetQoS NFA Harvester versions

Cause

Another process is locking the files used that the NQMySQL service wants to use.

Resolution

We have seen this error occur when the files that NQMySQL wants to use are locked by another process.

Was any new software recently installed that might be doing realtime scans of your NFA directories? If so, make sure that the NFA directory is excluded from any realtime AV scans. We have also seen cases were 3rd-party software installs another instance of MySQL that attempts to use the same files at the same time, locking NFA out.

Try rebooting the Harvester to see if this clears up the error.