Update fails: database disk image is malformed

[gerivives]

Hello,

When trying to upgrade to the latest release from the GUI I am getting the following error.

Code Select Expand

***GOT REQUEST TO CHECK FOR UPDATES***
Currently running OPNsense 24.7.9_1 (amd64) at Sun Dec 29 10:51:15 CET 2024
Fetching changelog information, please wait... done
Updating OPNsense repository catalogue...
Fetching meta.conf: . done
Fetching packagesite.pkg: .......... done
Processing entries: .......... done
OPNsense repository update completed. 861 packages processed.
Updating SunnyValley repository catalogue...
Waiting for another process to update repository SunnyValley
Updating mimugmail repository catalogue...
Fetching meta.conf: . done
Fetching packagesite.pkg: ....... done
Processing entries: .......... done
mimugmail repository update completed. 190 packages processed.
All repositories are up to date.
pkg: sqlite error while executing PRAGMA user_version; in file pkgdb.c:2370: database disk image is malformed
pkg: sqlite error while executing PRAGMA user_version; in file pkgdb.c:2370: database disk image is malformed
self: No packages available to install matching 'opnsense'
***DONE***

I have tried following the steps detailed in these posts (reindex the DB and restore a backup with no success). I am still getting the same exact error.
https://forum.opnsense.org/index.php?topic=15868.0
https://www.reddit.com/r/opnsense/comments/15cszup/after_hardware_related_crash_sqlite_database_disk/

When I navigate to the plugins tab, all of them appear highlighted in red with a message stating that they are missing.

Any further ideas on how to proceed?

Thanks,

Gerard

[EricPerl]

Look for  opnsense-bootstrap. I'll let you decide if it's the proper next step...