Solved [Solved] PKG-1.2 missing table pkg_annotation

[Nicop]

Dear FreeBSD community,

I'm having trouble using pkg-1.2.2 under FreeBSD-9.2 when I try to update the package list, search a package or upgrade the existing packages. However, I can remove a package without any issue. For example, here is what I get:

# pkg update
Updating repository catalogue
pkg: sqlite: no such table: pkg_annotation
pkg: sqlite: cannot rollback - no transaction is active
pkg: Unable to find catalogs

I opened the package database at /var/db/pkg/local.sqlite and the pkg_annotation table exists but is empty. I installed all the third party applications using the port collection. Here is my make.conf file:

# added by use.perl 2013-07-21 02:36:02
PERL_VERSION=5.14.4
WITH_PKGNG=     yes
.include "/usr/local/etc/ports_sites.conf"

I'm also using the following pkg.conf and /usr/local/etc/pkg/repos/FreeBSD.conf files:

# pkg.conf
ALIAS              : {
  all-depends: query %dn-%dv,
  annotations: info -A,
  build-depends: info -qd,
  download: fetch,
  iinfo: info -i -g -x,
  isearch: search -i -g -x,
  leaf: query -e "%a == 0" "%n-%v",
  leaf: query -e "%a == 0" "%n-%v",
  list: info -ql,
  origin: info -qo,
  provided-depends: info -qb,
  raw: info -R,
  required-depends: info -qr,
  shared-depends: info -qB,
  show: info -f -k,
  size: info -sq,
  }

# FreeBSD.conf
FreeBSD : {
    url : "pkg+http://pkg.freebsd.org/${ABI}/latest",
    enabled : true,
    mirror_type : "SRV",
    signature_type : "FINGERPRINTS",
    fingerprints : "/usr/share/keys/pkg",
}

Any idea for this problem?

Thank you for your help.

Nicolas

 

[Nicop]

Re: PKG-1.2 missing table pkg_annotation

Hello,

I found a workaround on the Github page of the project. This appends after an interruption of the PKG updating process. The solution is to run the following command:

rm /var/db/pkg/repo-*

I hope this will help.

Source: https://github.com/freebsd/pkg/issues/677