pkg database issue: database version 34 is newer than libpkg(3) version 33 ?

[Matthew Seaman]

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
expecting.  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).

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.

	Cheers,

	Matthew


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 931 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freebsd.org/pipermail/freebsd-ports/attachments/20170122/13d9cb5c/attachment.sig>