OPNsense Forum

Archive => 18.7 Legacy Series => Topic started by: jkemp on January 27, 2019, 03:29:54 am

Title: Insight Aggregator will not start
Post by: jkemp on January 27, 2019, 03:29:54 am
Hello All,

I have a situation pertaining to Insight Aggregator will sometimes start then quit. Most of the time it will not start. This started happening a day ago.

Can someone give me some pointers on best course of action. I reset The RRD and clear all logs from the shell and that didn't work.

Here is a log from System/General

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 86, in aggregate_flowd stream_agg_object.cleanup(do_vacuum) File "/usr/local/opnsense/scripts/netflow/lib/aggregate.py", line 278, in cleanup self._update_cur.execute('delete from timeserie where mtime < :expire', {'expire': expire_timestamp}) DatabaseError: database disk image is malformed

Thanks for any help or time spent on this issue,

James
Title: Re: Insight Aggregator will not start
Post by: franco on January 30, 2019, 12:39:56 pm
> DatabaseError: database disk image is malformed

Clear Netflow data from Reporting: Settings page.


Cheers,
Franco