Date: Sun, 22 Jan 2017 12:30:18 +0000 From: Matthew Seaman <matthew@FreeBSD.org> To: freebsd-ports@freebsd.org Subject: Re: pkg database issue: database version 34 is newer than libpkg(3) version 33 ? Message-ID: <0f79185a-0241-aef1-7fd1-bdd0fd831771@FreeBSD.org> In-Reply-To: <20170122093652.GM13006@home.opsec.eu> References: <20170122093652.GM13006@home.opsec.eu>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --TXlFi7mWNXTDjoxPrPjQSwDuUpunQas3K Content-Type: multipart/mixed; boundary="pwQP1E6OKHfDW1Lq9T6gfD6V2nIITTMbK"; protected-headers="v1" From: Matthew Seaman <matthew@FreeBSD.org> To: freebsd-ports@freebsd.org Message-ID: <0f79185a-0241-aef1-7fd1-bdd0fd831771@FreeBSD.org> Subject: Re: pkg database issue: database version 34 is newer than libpkg(3) version 33 ? References: <20170122093652.GM13006@home.opsec.eu> In-Reply-To: <20170122093652.GM13006@home.opsec.eu> --pwQP1E6OKHfDW1Lq9T6gfD6V2nIITTMbK Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 22/01/2017 09:36, Kurt Jaeger wrote: > # pkg delete pkg > pkg: warning: database version 34 is newer than libpkg(3) version 33, b= ut 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: n= o such table: pkg_search >=20 > I've tried to create the table pkg_search using sqlite3, but: >=20 > CREATE VIRTUAL TABLE pkg_search USING fts4(id, name, origin); > Error: vtable constructor failed: pkg_search >=20 > 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 --pwQP1E6OKHfDW1Lq9T6gfD6V2nIITTMbK-- --TXlFi7mWNXTDjoxPrPjQSwDuUpunQas3K Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQJ8BAEBCgBmBQJYhKXaXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkATRlsP+wSIARUNQ+qI64HZL4V28yJv xW+mpvnt0BwCOmtKkaO5O5Tf/kDEV9IBbCMEcBPWtuR0kcgUcrgrkSwS2ZHXk3XC BaQcN32Tbi7OfDKppw09bWoprEUU/P+LEOaPYe2IVJzlzVrU+Ep0mWQhMZQYWC1p O2mFMX6bPRjARZIKaB/unWGVHn6/ZycQg3ROYfVn7npZz6QsNxnw+XCikV6nHGyn GBusQ9MZaX7upelwSM+1AbAJgWNtYZ5hH5oORRdTRBOI+WxmqS0p5DA9fphmtvlT H/tsbs7ZQlT3pwcSe39/3URI7YVYAwRkXA0kXlF+15ej+lCmZoIK+XVFzZR5PbbA k10MsTyEUVJ2jvTXP95xt5FVaB3dLkSXLv1AIoJeXBat7ISqC7AGidXh4KaefsCK PBSPHpyb6ghTN5/dnzL2LuFeEsRCvGXVwSMW+o2Ajr7WIkOXSYKjJX24lDvhmr66 WuIAeZyy3QBrox8MqRJ80vithXX9bC+VFwgPiF5DivfxjMmlu67oIlnBZ0MFagJ/ mgNZDJZP57mh5YaSUjp4awZzL6kSBnHR1yOfSgOM0ZM5adn67jr6vmVrVVkaAJ+p EbQEsLEBd3+FFXUbLd5/ydZeCqIguIxRV3tfm7bP13IbrrkFlahTPzJGyDqBcsEc 1+lyq0cBKCd3I4ELa6YC =MGOA -----END PGP SIGNATURE----- --TXlFi7mWNXTDjoxPrPjQSwDuUpunQas3K--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?0f79185a-0241-aef1-7fd1-bdd0fd831771>