Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 25 Sep 2017 12:17:32 +0200 (CEST)
From:      =?ISO-8859-1?Q?Trond_Endrest=F8l?= <Trond.Endrestol@fagskolen.gjovik.no>
To:        FreeBSD questions <freebsd-questions@freebsd.org>
Subject:   pkg: sqlite: database disk image is malformed
Message-ID:  <alpine.BSF.2.21.1709251209070.19226@mail.fig.ol.no>

next in thread | raw e-mail | index | archive | help
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.



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?alpine.BSF.2.21.1709251209070.19226>