1
23.1 Legacy Series / Re: 23.1 flowd_aggregate.py crash DatabaseError: database disk image is malformed
« on: March 21, 2023, 12:54:46 am »
Much appreciated, worked like a charm. Reporting: Settings -> Reset Neflow Data
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
Much appreciated, worked like a charm. 2
23.1 Legacy Series / 23.1 flowd_aggregate.py crash DatabaseError: database disk image is malformed
« on: March 20, 2023, 02:03:07 am »Code: [Select]
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
Pages: [1]