Hilfe zu: sqlite - database disk image is malformed

[DokuKäfer]

Hallo zusammen,

ich habe hier ein OPNSense mit Version 23.7 am laufen.
Ich kann keine Update mehr installieren, es kommt folgende Fehlermeldung:

Code: [Select]

***GOT REQUEST TO CHECK FOR UPDATES***
Currently running OPNsense 23.7 at Thu Oct 19 21:22:47 CEST 2023
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. 853 packages processed.
All repositories are up to date.
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
Checking integrity... done (0 conflicting)
Your packages are up to date.
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
Checking for upgrades (1 candidates): . done
Processing candidates (1 candidates): . done
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 159  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'openssl' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'openssl' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 127  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'python39' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'python39' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-setuptools' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-setuptools' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 149  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-numpy' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-numpy' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 49  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 49  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 149  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 38  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 38  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 127  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 22  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 22  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 43  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 43  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 159  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing END TRANSACTION; in file pkgdb.c:2333: database disk image is malformed
Checking integrity...pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-numpy' in file pkgdb_iterator.c:412: database disk image is malformed
Assertion failed: (p != NULL), function pkg_conflicts_check_local_path, file pkg_jobs_conflicts.c, line 313.
Child process pid=46138 terminated abnormally: Abort trap
***DONE***

Der sqlite .SELFTEST spuckt mir folgendes aus:

Code: [Select]

root@OPNsense:~ # sqlite3 /var/db/pkg/local.sqlite
SQLite version 3.42.0 2023-05-16 12:36:15
Enter ".help" for usage hints.
sqlite> .selftest
Missing SELFTEST table - default checks only
1: error-code-1: database disk image is malformed
1 errors out of 1 tests

Ein .REINDEX hat leider nichts gebracht.

Code: [Select]

sqlite> REINDEX;
Runtime error: database disk image is malformed (11)


Code: [Select]

Version 23.7 is correct.
>>> Check for missing or altered base files
No problems detected.
>>> Check installed repositories
OPNsense
>>> Check installed plugins
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
>>> Check locked packages
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
>>> Check for missing package dependencies
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages:
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages... done
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
>>> Check for missing or altered package files
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages:
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages... done
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
>>> Check for core packages consistency
Core package "opnsense" not known to package database.
***DONE***

Jetzt nun die Frage, hat jemand eine Idee wie ich dieses Problem beheben kann?
Liegt dies an einer defekten Festplatte/SSD ?


Danke und Grüße