From owner-freebsd-questions@FreeBSD.ORG  Sat Aug  2 11:14:49 2014
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 420D1705
 for <freebsd-questions@freebsd.org>; Sat,  2 Aug 2014 11:14:49 +0000 (UTC)
Received: from mail-we0-x22d.google.com (mail-we0-x22d.google.com
 [IPv6:2a00:1450:400c:c03::22d])
 (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 D22E9243E
 for <freebsd-questions@freebsd.org>; Sat,  2 Aug 2014 11:14:48 +0000 (UTC)
Received: by mail-we0-f173.google.com with SMTP id q58so5441360wes.4
 for <freebsd-questions@freebsd.org>; Sat, 02 Aug 2014 04:14:47 -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=Y/rC2RObPvZpW+obdVaI05JAhC1x6oNJUMGq3jEpkjdKg2sg+YOjgpg4qyzvEOF44v
 sNJfrRFkSf4WVx7dPji7r/zOcOeIsvdBflhi9J+RPDKftrSeA8yKQMr1nh+mrsSzXLkm
 a07z8hyKzJc2acWV6RY2Ao/r2qMJpTcAGbNxhA/+Zp2OyQU7d4//MBoVCJI5zqWEyqRX
 C3jxAuI4OQJw6FgOZbSQFmCMtrB02LQbUxAyBzXpC8r9b4C1wO9juL0YviyxVMOeYnZC
 u+rLg9f0DIBCndsHLB+lDyRe7q6ZJKP3qyeE9jdKoGcoKSR4zOyMsbh+HyIXLdTehNGe
 7azQ==
X-Received: by 10.180.97.129 with SMTP id ea1mr14895485wib.71.1406978086970;
 Sat, 02 Aug 2014 04:14:46 -0700 (PDT)
Received: from almelo.raji.xor ([46.142.69.94])
 by mx.google.com with ESMTPSA id f16sm18264872wic.7.2014.08.02.04.14.45
 for <freebsd-questions@freebsd.org>
 (version=TLSv1.2 cipher=RC4-SHA bits=128/128);
 Sat, 02 Aug 2014 04:14:46 -0700 (PDT)
Date: Sat, 02 Aug 2014 13:14:44 +0200
Message-Id: <n88zjfnta6z.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: Sat, 02 Aug 2014 11:14:49 -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!