pkgdb errors after crash

[Aaron LI]

On Sun, 9 Sep 2018 21:12:19 +0200
spuelmaschien at email.de wrote:
> 
> # pkg install samba46
> Updating Marburg repository catalogue...
> Marburg repository is up to date.
> Updating RWTH_AACHEN repository catalogue...
> RWTH_AACHEN repository is up to date.
> All repositories are up to date.
> pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1035:
> 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 = ?1 in file pkgdb_iterator.c:396:
> 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 = ?1 in file pkgdb_iterator.c:396:
> 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 = ?1 in file pkgdb_iterator.c:396:
> database disk image is malformed pkg: sqlite error while executing iterator
> in file pkgdb_iterator.c:1035: database disk image is malformed pkg: sqlite
> error while executing iterator in file pkgdb_iterator.c:1035: database disk
> image is malformed pkg: sqlite error while executing iterator in file
> pkgdb_iterator.c:1035: database disk image is malformed
> 
> ...
> 
>         libarchive: 3.3.2,1 [RWTH_AACHEN]
>         lzo2: 2.10_1 [RWTH_AACHEN]
> 
> Installed packages to be UPGRADED:
>         libressl: 2.7.3 -> 2.7.4 [RWTH_AACHEN]
> 
> Installed packages to be REINSTALLED:
>         gettext-runtime-0.19.8.1_1 [RWTH_AACHEN]
> 
> Number of packages to be installed: 38
> Number of packages to be upgraded: 1
> Number of packages to be reinstalled: 1
> 
> The process will require 514 MiB more space.
> 
> Proceed with this action? [y/N]: y
> [1/40] Upgrading libressl from 2.7.3 to 2.7.4...
> pkg: sqlite error while executing INSERT OR REPLACE INTO packages( origin,
> name, version, comment, desc, message, arch, maintainer, www, prefix,
> flatsize, automatic, licenselogic, mtree_id, time, manifestdigest,
> dep_formula,
> vital)VALUES( ?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13,
> (SELECT id FROM mtree WHERE content = ?14), NOW(), ?15, ?16, ?17 ) in file
> pkgdb.c:1723: database disk image is malformed # pkg info samba46 pkg:
> sqlite error while executing iterator in file pkgdb_iterator.c:1035:
> database disk image is malformed
> 

Hi Sascha,

It seems your local pkg repo db is corrupted.  I had a look at pkg's man
pages and suggest that you try:

# pkg update -f

to force building the database.  If it doesn't help, you can delete (+backup)
the files in /var/db/pkg and try again.


Cheers,
-- 
Aaron
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://lists.dragonflybsd.org/pipermail/users/attachments/20180910/dc5c16b2/attachment-0005.bin>