1
24.7 Production Series / [SOLVED] Insight Aggregator not starting after upgrade
« on: August 24, 2024, 09:33:42 pm »
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
Update:
Resetting the netflow data solved it.
Quote
Error 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.