Hi,
... My Insight Aggregator stopped running with this log ... any ideas why this happened?
Best,
Klaus
/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 110, in add super(FlowSourceAddrDetails, 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
2020-06-26T22:11:24 /flowd_aggregate.py: start watching flowd
2020-06-26T22:11:22 /flowd_aggregate.py: startup, check database.
I encountered a similar issue when my logs filled the disk drive I was writing them to. Check your used space and make sure the disk isn't full.