I upgraded from 24.1.10_8 to 24.7.2 and I noticed that the Insight Aggregator service is not running. Looking at the logs I see this
QuoteError flowd_aggregate.py flowd aggregate died with message Traceback (most recent call last): File "/usr/local/opnsense/scripts/netflow/flowd_aggregate.py", line 160, in run aggregate_flowd(self.config, do_vacuum) File "/usr/local/opnsense/scripts/netflow/flowd_aggregate.py", line 80, in aggregate_flowd stream_agg_object.add(copy.copy(flow_record)) File "/usr/local/opnsense/scripts/netflow/lib/aggregates/source.py", line 73, in add super(FlowSourceAddrTotals, self).add(flow) File "/usr/local/opnsense/scripts/netflow/lib/aggregates/__init__.py", line 185, in add self._update_cur.execute(self._update_stmt, flow) sqlite3.DatabaseError: database disk image is malformed
Update:
Resetting the netflow data solved it.
Might I ask how you reset the netflow data?
EDIT: Sorry. Search first, than ask. Sorry.
Reporting --> Settings --> Reset Netflow Data.