OPNsense Forum

Archive => 18.7 Legacy Series => Topic started by: cguilford on October 22, 2018, 02:32:27 pm

Title: Insight Not Working -per Flowd_aggregate error
Post by: cguilford on October 22, 2018, 02:32:27 pm

Can anyone provide any assistance?  I tried to reinstall flowd via the packages section of the GUI, any other help would be appreciated.

Oct 22 08:29:41    flowd_aggregate.py: flowd aggregate died with message Traceback (most recent call last): File "/usr/local/opnsense/scripts/netflow/flowd_aggregate.py", line 151, in run aggregate_flowd(do_vacuum) File "/usr/local/opnsense/scripts/netflow/flowd_aggregate.py", line 80, in aggregate_flowd stream_agg_object.add(flow_record_cpy) File "/usr/local/opnsense/scripts/netflow/lib/aggregates/interface.py", line 70, in add super(FlowInterfaceTotals, self).add(flow) File "/usr/local/opnsense/scripts/netflow/lib/aggregate.py", line 261, in add self._update_cur.execute(self._insert_stmt, flow) DatabaseError: database disk image is malformed

Title: Re: Insight Not Working -per Flowd_aggregate error
Post by: cguilford on October 22, 2018, 02:37:45 pm

ohhh sorry found more options under the settings for repairing the database I'll run those and if that doesn't work I'll repost.

Title: Re: Insight Not Working -per Flowd_aggregate error
Post by: cguilford on October 23, 2018, 02:05:21 pm

Turns out the repair did NOT fix the issue it still kept saying no data was available but the service would start without errors, so I had to wind up doing a "reset netflow data" to get things up and working again.