After Upgrade to 21.2.10, one of our Harvester servers is outputting an error for all interface pages.
An error occurred!
Control(30002): Stacked Protocol Trend - In
A Unable to connect to any of the specified MySQL hosts. error was returned:
The Netflow\Logs\oursql*.log file on the harvester shows queries to the 'ahtflows' table like this:
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (8ad14d9c7b): select srcaddr as hostAddr, count(*) as amountPerHost, ifnull(count(*)/ (@timeDiff / 60 ), count(*)) as averageMetric FROM ahtflows where ( timestamp > 1654189918 ) and ( timestamp <= 1654190280 ) group by hostAddr order by amountPerHost desc limit 10
Connection ID (thread ID): 22
Release : 21.2
Component : NQRAHV - NETQOS RA HARVESTER
Anomaly Detector component was running and attempting to query the Harvester's mysql database on port 3307.
The AD component has been deprecated, and it is not recommended to run this component in an NFA 21.2.x environment.