pkgng beta 11: pkg-static: The database is outdated and opened readonly *** Error code 74

[Anton Shterenlikht]

On Mon, Apr 16, 2012 at 09:20:41AM +0100, Anton Shterenlikht wrote:
> Updating ports-mgmt/pkg to b11:
> 
> ===>  Installing for pkg-1.0.b11
> ===>   Generating temporary packing list
> ===>  Checking if ports-mgmt/pkg already installed
> pkg-static: The database is outdated and opened readonly
> *** Error code 74
> 
> Stop in /usr/ports/ports-mgmt/pkg.
> 
> Please advise

Looking at the bit which issued the error:

# grep -C3 "The database is outdated" ./work/pkg-1.0-beta11/libpkg/pkgdb.c

        while (db_version < DBVERSION) {
                if (!sqlite3_db_readonly(db->sqlite, "main")) {
                        pkg_emit_error("The database is outdated and opened readonly");
                        return (EPKG_FATAL);
                }
                db_version++;
# 

I decided to update sqlite3, only to discover
that I can no longer do it:

# make -C  /usr/ports/databases/sqlite3 
/usr/local/sbin/pkg: not found
===>  License unknown accepted by the user
===>  Found saved configuration for sqlite3-3.7.11
===>   sqlite3-3.7.11 depends on file: /usr/local/sbin/pkg - not found
===>    Verifying install for /usr/local/sbin/pkg in /usr/ports/ports-mgmt/pkg
===>  Installing for pkg-1.0.b11
===>   Generating temporary packing list
===>  Checking if ports-mgmt/pkg already installed
pkg-static: The database is outdated and opened readonly
*** Error code 74

Stop in /usr/ports/ports-mgmt/pkg.
*** Error code 1


How can I recover from this?

Is it a good idea to switch to
the old tools for recovery?

-- 
Anton Shterenlikht
Room 2.6, Queen's Building
Mech Eng Dept
Bristol University
University Walk, Bristol BS8 1TR, UK
Tel: +44 (0)117 331 5944
Fax: +44 (0)117 929 4423