After upgrading to NFA 21.2.8 or 21.2.10, data stops collecting

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

After upgrading to NFA 21.2.8 or 21.2.10 you may run into a rate issue on the NFA Harvester:

You would notice that data is not processing and there are these 2 errors in the harvester-wrapper.log:

INFO   | jvm 1    | 2022/06/08 22:08:14 | java.sql.SQLException: The user specified as a definer (''@'localhost') does not exist
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.mysql.jdbc.CallableStatement.executeQuery(CallableStatement.java:858)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.base.data.BaseDAO.executeResultSet(BaseDAO.java:350)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.base.data.BaseDAO.executeSPRowSet(BaseDAO.java:336)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.base.data.BaseDAO.executeProcedureRowSet(BaseDAO.java:321)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.harvester.data.VirtualInterfaceDAO.hasVirtualCircuits(VirtualInterfaceDAO.java:57)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.harvester.business.VirtualInterface.hasVirtualCircuits(VirtualInterface.java:42)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.harvester.InterfaceCache.refreshVirtualInterfaces(InterfaceCache.java:178)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.harvester.InterfaceCache.initialize(InterfaceCache.java:50)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.harvester.PersistentCache.initialize(PersistentCache.java:53)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.harvester.Harvester.initializeComponents(Harvester.java:273)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.harvester.Harvester.run(Harvester.java:188)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at com.ca.im.ra.harvester.Harvester.main(Harvester.java:178)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at java.base/java.lang.reflect.Method.invoke(Unknown Source)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349)
INFO   | jvm 1    | 2022/06/08 22:08:14 |  at java.base/java.lang.Thread.run(Unknown Source)

as well as:

INFO   | jvm 1    | 2022/06/08 22:02:50 | java.lang.NullPointerException
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at com.ca.im.ra.harvester.ApplicationMappingCache.getMaskedTos(ApplicationMappingCache.java:595)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at com.ca.im.ra.harvester.tbn.TBNEntry.initialize(TBNEntry.java:208)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at com.ca.im.ra.harvester.HarvesterProcessor.mapFlow(HarvesterProcessor.java:396)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at com.ca.im.ra.harvester.HarvesterProcessor.createAndProcessTBNEntry(HarvesterProcessor.java:267)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at com.ca.im.ra.harvester.HarvesterProcessor.processFlow(HarvesterProcessor.java:262)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at com.ca.im.ra.flow.tools.FlowProcessor.execute(FlowProcessor.java:141)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at com.ca.im.ra.flow.tools.FlowProcessor.run(FlowProcessor.java:81)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
INFO   | jvm 1    | 2022/06/08 22:02:50 |  at java.base/java.lang.Thread.run(Unknown Source)
INFO   | jvm 1    | 2022/06/08 22:02:50 | 10:02:50 PM - [SEVERE  ] - Unhandled Exception

Environment

Release : 21.2.8 & 21.2.10

Component : NQRAHV - NETQOS RA HARVESTER

Cause

In 21.2.8 and higher, the MySQL anonymous user has been removed. Customers running NFA Harvester with a revision history that dates back to NFA 9.x will have MySQL procedures which refer to the anonymous user. We changed the definers to use the root user in more modern versions which did fresh installs. 

Resolution

1. Download the patch to the effected harvesters.

2. Extract the patch.

3. Read the readme to apply the patch.

4. Repeat on each harvester with the issue.

Additional Information

These mySQL changes will be included in the NFA 21.2.12 release.