From owner-freebsd-pkg@freebsd.org Wed Dec 14 08:40:10 2016 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id D624DC77AA3 for ; Wed, 14 Dec 2016 08:40:10 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id BFF3E177F for ; Wed, 14 Dec 2016 08:40:10 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.ysv.freebsd.org (Postfix) id BF59FC77AA2; Wed, 14 Dec 2016 08:40:10 +0000 (UTC) Delivered-To: pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id BF02AC77AA1 for ; Wed, 14 Dec 2016 08:40:10 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id AE4AB177E for ; Wed, 14 Dec 2016 08:40:10 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id uBE8eA9Y034646 for ; Wed, 14 Dec 2016 08:40:10 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: [Bug 213611] ports-mgmt/pkg: 1.9.1 pkgdb locking doesn't work on NFS Date: Wed, 14 Dec 2016 08:40:10 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: gerhard.dorner@hob.de X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Dec 2016 08:40:10 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D213611 --- Comment #3 from dornergd --- I have tested pkg 1.9.4 and still get the same error in combination with NF= S: "pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1033: database is locked. To get more information I activated the debug output: # pkg -dddd info=20 DBG(1)[22647]> pkg initialized DBG(4)[22647]> Pkgdb: running 'PRAGMA user_version;' DBG(4)[22647]> Pkgdb: executing 'PRAGMA foreign_keys =3D ON;' DBG(4)[22647]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO mtree(cont= ent) VALUES(?1)' ... DBG(4)[22647]> Pkgdb: preparing statement 'INSERT OR IGNORE INTO requires(require) VALUES(?1)' DBG(4)[22647]> Pkgdb: running 'SELECT id, origin, name, name as uniqueid, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages = AS p ORDER BY p.name;' pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1033: database is locked But when I start "pkg shell" and run the "SELECT"-statement there, I get a = list of all my installed packages, Additional I found out that this problem exists since version 1.9.0. --=20 You are receiving this mail because: You are the assignee for the bug.=