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 86, in aggregate_flowd stream_agg_object.cleanup(do_vacuum) File "/usr/local/opnsense/scripts/netflow/lib/aggregates/__init__.py", line 208, in cleanup self._update_cur.execute('delete from timeserie where mtime < :expire', {'expire': expire_timestamp}) sqlite3.DatabaseError: database disk image is malformed
Restarting the service causes the same fail. Anyone knows how to fix or reset the DB
OPNsense 23.1.3_4-amd64
FreeBSD 13.1-RELEASE-p7
OpenSSL 1.1.1t 7 Feb 2023
Reporting: Settings -> Reset Neflow Data
8) Much appreciated, worked like a charm.
Quote from: Fright on March 20, 2023, 05:38:54 PM
Reporting: Settings -> Reset Neflow Data