Insight Aggregator not running anymore

[klausdude]

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.

[samsonmcnulty]

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.