From owner-freebsd-questions@FreeBSD.ORG  Sun Aug  3 09:16:05 2014
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTPS id 8C40F5BB
 for <freebsd-questions@freebsd.org>; Sun,  3 Aug 2014 09:16:05 +0000 (UTC)
Received: from mail-we0-x22a.google.com (mail-we0-x22a.google.com
 [IPv6:2a00:1450:400c:c03::22a])
 (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits))
 (Client CN "smtp.gmail.com",
 Issuer "Google Internet Authority G2" (verified OK))
 by mx1.freebsd.org (Postfix) with ESMTPS id 28238221D
 for <freebsd-questions@freebsd.org>; Sun,  3 Aug 2014 09:16:05 +0000 (UTC)
Received: by mail-we0-f170.google.com with SMTP id w62so6310342wes.15
 for <freebsd-questions@freebsd.org>; Sun, 03 Aug 2014 02:16:03 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=date:message-id:from:to:subject:mime-version:content-type
 :content-transfer-encoding;
 bh=aMW4Q8qkHBakypjtGNsSlo8TbSII1jJRUiH8Dj0ifsQ=;
 b=l5FuuycnoO6z/2Iwra11mO7i1hIBhyj1/FJ7wwDfwzXYf+h4JqQSP9E9epDHpKt2dk
 xCakuEQl8++u9L//nhdeuKEXMKCjDa33y2/fxa3IwBlosHxxY+vv4xZNbXKSEAEvvNNF
 2FzBwq82RKM79sji4QEVJiwgtfWhjlxF8BvnCj+Uq7E8oLZjB+iapAyK8LCCu1bxYCSs
 e6tjYiP9cRPC5DYwfjwKOnlr3SM4kxYp3TcME9Yh7rkf+ZuJPnUk/XZ8FGAIXnVADK4z
 HubSE1XtpQ8j2L7V9Co/3HtXAMSCwLpNJoSLN9TOi8qL3X+CICUY+qiPLi9OB2RYdbR8
 NYPQ==
X-Received: by 10.180.80.225 with SMTP id u1mr20453780wix.69.1407057363343;
 Sun, 03 Aug 2014 02:16:03 -0700 (PDT)
Received: from almelo.raji.xor ([46.142.88.74])
 by mx.google.com with ESMTPSA id gq4sm27976584wib.8.2014.08.03.02.16.02
 for <freebsd-questions@freebsd.org>
 (version=TLSv1.2 cipher=RC4-SHA bits=128/128);
 Sun, 03 Aug 2014 02:16:02 -0700 (PDT)
Date: Sun, 03 Aug 2014 11:16:00 +0200
Message-Id: <n88d2cilyr3.fsf@almelo.raji.xor>
From: Wolfgang Hukriede <whukriede@gmail.com>
To: freebsd-questions@freebsd.org
Subject: pkg: sqlite error while executing PRAGMA user_version 
MIME-version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions/>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 03 Aug 2014 09:16:05 -0000

I'm getting

host> pkg info
pkg: sqlite error while executing PRAGMA user_version; in file pkgdb.c:2284: database is locked

I already tried to reboot, rm /var/db/pkg/repo* to no effect.

When run as root "pkg info" shows a few packages, but most not.

This is fbsd 8.4, pkg version 1.3.3 on a diskless machine (9.1 as nfs
server).

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.

Many thanks!