We are using the Flow Statistics page in the NFA Administration GUI. Verified that port 8067 is open in both directions between the NFA Console machine and the Harvesters.
The graphs at the top of the page are showing data. When a Harvester is selected, a “Loading” indicator appears for over a minute, then a “No Matching records found” message appears.
The current Reporter\Logs\WebServicesQueryLog*.log shows the following timeout error:
11:13:57 -1 - Query:
[email protected]:3308
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
select id, min(flowRate) as minIFFlows, max(flowRate) as maxIFFlows, avg(flowRate) as avgIFFlows, percentile(flowRate, 95) as pct95IFFlows, name, ip, interfaces from ( select (select count(interfaces.id) from interfaces where interfaces.routerid = routers.id ) as interfaces, routers.ID as id, (sum(interfaceflows.InFlows + interfaceflows.OutFlows)/15) as flowRate, routers.sysName as name, INET_NTOA(routers.routerAddress) as ip from interfaceflows, routers where interfaceflows.endtime >= 1453219500 and interfaceflows.endtime <= 1453305900 and routers.harvesterID = 4 and interfaceflows.AgentID in (select agents_all_view.ID from agents_all_view where agents_all_view.routerid = routers.id) group by routers.id, interfaceflows.endtime ) x group by id
(1 min 30 sec)
By default, the Time Period for data in the Flow Statistics page is set to “Daily”. By shortening this Time Period, we can reduce the amount of data returned by the MySQL queries and reduce the possibility of Timeout errors.
To correct this you can delete rows from the database to cut this data down to the last week's worth of data by following the steps below.