23.1 flowd_aggregate.py crash DatabaseError: database disk image is malformed

[greeone]

Code Select Expand


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

[Fright]

Reporting: Settings -> Reset Neflow Data

[greeone]

 8) Much appreciated, worked like a charm.

Reporting: Settings -> Reset Neflow Data