pkg: sqlite: database disk image is malformed

[Trond Endrestøl]

Something interesting happened while upgrading one of my systems:

===>   Registering installation for tcl86-8.6.7
Installing tcl86-8.6.7...
pkg-static: sqlite error while executing iterator in file pkgdb_iterator.c:1035: database disk image is malformed
pkg-static: sqlite error while executing INSERT OR REPLACE INTO files (path, sha256, package_id) VALUES (?1, ?2, ?3) in file pkgdb.c:1788: database disk image is malformed
*** Error code 70

Running pkg check -{B,d,s} gives:

# pkg check -B
Checking all packages: 100%

# pkg check -d
Checking all packages: 100%

# pkg check -s
Checking all packages: 100%

System is running ZFS with checksums enabled, but with non-ECC memory, 
thus memory corruption is possible. ZFS says the pool is healthy.

Any chance of learning which values pkg is attempting to insert or 
replace?

Running pkg delete lang/tcl86 removed that port and all its consumers, 
yet the SQL error persists.

I have an identical system next to this little bugger, so I could 
steal /var/db/local.sqlite from that system ...

-- 
Trond.