OPNsense Forum

Archive => 24.1, 24.4 Legacy Series => Topic started by: G on February 23, 2024, 10:44:59 AM

Title: [SOLVED] DuckDB error on Unbound update
Post by: G on February 23, 2024, 10:44:59 AM
Hi guys,
trying to update my system this morning from 23.7.12_5 to the latest. Upgrade process failing on unbound upgrade

>>> Invoking upgrade script 'unbound-duckdb.py'
Traceback (most recent call last):
  File "/usr/local/opnsense/site-python/duckdb_helper.py", line 65, in __enter__
    self.connection = duckdb.connect(database=self._path, read_only=self._read_only)
duckdb.IOException: IO Error: Trying to read a database file with version number 39, but we can only read version 51.
The database file was created with DuckDB version v0.6.0 or v0.6.1.


Any workarounds, or do I really need to get a lower version of duckdb?
Thanks for the help as usual.
Title: Re: DuckDB error on Unbound update
Post by: franco on February 23, 2024, 10:54:24 AM
Reporting: Settings: Drop DNS database button.


Cheers,
Franco
Title: Re: DuckDB error on Unbound update
Post by: G on February 23, 2024, 11:32:05 AM
Worked like a charm. Brilliant work Franco.