pkg database issue: database version 34 is newer than libpkg(3) version 33 ?
lists at opsec.eu
Sun Jan 22 12:55:17 UTC 2017
> On 22/01/2017 09:36, Kurt Jaeger wrote:
> > # pkg delete pkg
> > pkg: warning: database version 34 is newer than libpkg(3) version 33, but still compatible
> > pkg: sqlite error while executing INSERT OR ROLLBACK INTO pkg_search(id, name, origin) VALUES (?1, ?2 || '-' || ?3, ?4); in file pkgdb.c:1544: no such table: pkg_search
> > I've tried to create the table pkg_search using sqlite3, but:
> > CREATE VIRTUAL TABLE pkg_search USING fts4(id, name, origin);
> > Error: vtable constructor failed: pkg_search
> > Any ideas on how to proceed ?
> Do you have a backup of your pkg database? If not, make one now.
> This looks like you have downgraded pkg(8) at some point -- it's
> complaining because the DB schema is more advanced that what it is
Yes. The question is: why is
CREATE VIRTUAL TABLE pkg_search USING fts4(id, name, origin);
in sqlite3 failing, even if
pkg info sqlite3
is configured with:
FTS4 : on
> You should be able to do that, since the DB schema is meant
> to be kept compatible between different versions, but it looks like
> there may have been a failure to do that.
> Easiest way out here is to upgrade to the latest version of pkg(8).
It was easier to nuke /usr/local and /var/db/pkg and re-add the
few relevant packages 8-}
> Failing that, you'ld need to take heroic measures to rebuild your pkg
> database using a DB schema compatible with your version of pkg. One way
> to do that is to move aside your existing pkg DB, initialise a new empty
> DB and then re-install all of the packages on your system.
Yes, that worked.
pi at opsec.eu +49 171 3101372 3 years to go !
More information about the freebsd-ports