From owner-freebsd-questions@FreeBSD.ORG Sun Aug 3 09:44:10 2014 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id C2276A97 for ; Sun, 3 Aug 2014 09:44:10 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "ca.infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 6ACA22573 for ; Sun, 3 Aug 2014 09:44:10 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.2.117.99]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.9/8.14.9) with ESMTP id s739i21s025753 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Sun, 3 Aug 2014 10:44:03 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) Authentication-Results: lucid-nonsense.infracaninophile.co.uk; dmarc=none header.from=infracaninophile.co.uk DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk s739i21s025753 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1407059043; bh=Nz1WFCtXhNaGAQ8zHIRekXM+Bj0UTS6TlkTdhlCngUE=; h=Date:From:To:Subject:References:In-Reply-To; z=Date:=20Sun,=2003=20Aug=202014=2010:43:54=20+0100|From:=20Matthew =20Seaman=20|To:=20freebsd-questi ons@freebsd.org|Subject:=20Re:=20pkg:=20sqlite=20error=20while=20e xecuting=20PRAGMA=20user_version|References:=20|In-Reply-To:=20; b=h2oliaBY14ZjRQYM3UINSbAYAf/sn5ArXasejHtUiTLyYKqlIgbKU1OR2d6twoFUf 0te4qnhE9fjmyE2+Zb0VOGfnCVuRvN/27FyOCvtmUsA+2VHyDhG88mzy+LIUYlaoEj UyBffpwQEPwtnEgCb8ulooE5FMc6PyAuf0fLa81k= Message-ID: <53DE045A.7080009@infracaninophile.co.uk> Date: Sun, 03 Aug 2014 10:43:54 +0100 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: freebsd-questions@freebsd.org Subject: Re: pkg: sqlite error while executing PRAGMA user_version References: In-Reply-To: X-Enigmail-Version: 1.6 OpenPGP: id=E1ECF9BB Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="hQ4RJo2EX9otcJgUKPGDhN3CX2c89i22j" X-Virus-Scanned: clamav-milter 0.98.4 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.6 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 03 Aug 2014 09:44:10 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --hQ4RJo2EX9otcJgUKPGDhN3CX2c89i22j Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 03/08/2014 10:16, Wolfgang Hukriede wrote: > I'm getting >=20 > host> pkg info > pkg: sqlite error while executing PRAGMA user_version; in file pkgdb.c:= 2284: database is locked >=20 > I already tried to reboot, rm /var/db/pkg/repo* to no effect. >=20 > When run as root "pkg info" shows a few packages, but most not. >=20 > This is fbsd 8.4, pkg version 1.3.3 on a diskless machine (9.1 as nfs > server). >=20 > Is there any recipe on how to proceed? I'd very much be willing to > rebuild the sqlite database from zero but don't know how. Using sqlite on an NFS mounted partition is unfortunately liable to various locking problems. pkg(8) should be NFS resistant, but it may not be resistant enough... Can you try this: # pkg shell SQLite version 3.8.5 2014-06-04 14:06:34 Enter ".help" for usage hints. sqlite> select * from pkg_lock ; 0|0|0 sqlite> select * from pkg_lock_pid ; sqlite> .quit That shows the expected output when there are no active locks in the system. If you system already shows that, then unfortunately it's a fundamental problem with trying to lock the database on NFS, and will require an updated version of pkg(8) to fix. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey JID: matthew@infracaninophile.co.uk --hQ4RJo2EX9otcJgUKPGDhN3CX2c89i22j Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.20 (Darwin) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQJ8BAEBCgBmBQJT3gRiXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkATV5kP/1ybBhhh8GwxoXOcnPG9ms7o Im3VfGEF6fZCNJYiHjWDs/moV1pQZ4Q6Im89yiOa8w8EhxWb405BJP44ewLz3TV/ ThixvmHYyLIqwmfJxNXKz8WxFh6gQ1Y3yWq0dr+H733l3aUDkWWd6bHfvSDUA8C+ oFqaUfn96VUs7piQUrzce8pCcL89DKEOx24B2RlbVLrVsBie9ahT6RwNuqDgmIyw tDDxw4q/V/Er1eyYt1pt4NXRGF9MzjRjZAmSjUMMp485foHi2IwiexSMBZxGXx+C Mil11A/wqtD88X6UEbinu3jah4OydFB5El0LWJreFhbnOQ+45c7hatfoBqwH36ke RoX5cGuZdb03mk5y8PuEpKcTAhH+yImm+k2nuQqdPqYDmttlUQUT0/xT1PedWcfF n9x2ohsbOJ3Iok3jftEasHVpzp4N5fqs3ZGf2Gvu89mz4oFm0Y9ozU9v51y7zbRJ u9PFgurVzXaIsn/5Ai3qlU4gVJotgrp0rXEOYSKSwRnfmD7NToIXBvlydg7euQyz L80rl3C+jHgb5J8DAvWOQk4ItFKSmIrX1ERd3V3wOVxdbDrBEa1qkj/XFWyrPDh+ /3uQwC7AtU01s98gBg1Up2+tSJw5XvcmTUdLx2Rpzrd3IYWoWYkCGpVb3Ve1DlQ2 O6ZHd4pSyVYS4oB8q3mj =Jc1V -----END PGP SIGNATURE----- --hQ4RJo2EX9otcJgUKPGDhN3CX2c89i22j--