From owner-freebsd-questions@FreeBSD.ORG  Sun Aug  3 13:09:34 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 4ADA3F09
 for <freebsd-questions@freebsd.org>; Sun,  3 Aug 2014 13:09:34 +0000 (UTC)
Received: from mail-wg0-x234.google.com (mail-wg0-x234.google.com
 [IPv6:2a00:1450:400c:c00::234])
 (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 DA4D82B95
 for <freebsd-questions@freebsd.org>; Sun,  3 Aug 2014 13:09:33 +0000 (UTC)
Received: by mail-wg0-f52.google.com with SMTP id a1so6413040wgh.35
 for <freebsd-questions@freebsd.org>; Sun, 03 Aug 2014 06:09:31 -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=FwqCIlvSa1hM27XjBE5MH6YAOeZncJv5waer9bJcRJM=;
 b=m06X1SmDc6VowlmzIQ5bUpwEEZK7CHKaQo0+gpUGDUFdqrMIIywKSV5x39L82mmyuL
 C7XkHe399UvtlxIPsmUEBwIOxoCaRvhO/0t5+WSQoQ+yThDq7pG1RmXPJsQCl2Wn6zOp
 LJZgWlMhogZaYSv1hclMWewqc1NQ2KPbNV3HYWktDIg2Ka+04XcqwSUChG1c7egcaKzb
 IQOPtCDk82dWLXci0pjScGSA09HQTnd/2wCf6/xRS2bbZL3PDsHj98q3vaCCZhoeMvD0
 hSDO7OZJv7Lyh06YOLydlQcWllr56imv5xy2fnHDEEjoPd73jFxX238HmvFTTF4TDYEb
 DhDQ==
X-Received: by 10.180.90.11 with SMTP id bs11mr22407772wib.47.1407071371680;
 Sun, 03 Aug 2014 06:09:31 -0700 (PDT)
Received: from almelo.raji.xor ([46.142.88.74])
 by mx.google.com with ESMTPSA id wd7sm35735121wjc.36.2014.08.03.06.09.30
 for <multiple recipients>
 (version=TLSv1.2 cipher=RC4-SHA bits=128/128);
 Sun, 03 Aug 2014 06:09:30 -0700 (PDT)
Date: Sun, 03 Aug 2014 15:09:29 +0200
Message-Id: <n888un5vhx2.fsf@almelo.raji.xor>
From: Wolfgang Hukriede <whukriede@gmail.com>
To: freebsd-questions@freebsd.org,m.seaman@infracaninophile.co.uk
Subject: Re: 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 13:09:34 -0000

Matthew Seaman wrote:

  # 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

Yes, this is what I get.

In the meantime I discovered that "pkg info" works on the diskless box
when invoked as root. I then tried "pkg upgrade -n" and "pkg upgrade".
This worked after some contortions. (It first said "locked", while
the second or third attempt was ok.)

Becoming somewhat more confident I tried a "pkg delete nnn", but
interrupted that with control-c. This seems to have been a mistake,
because now I get "database is locked" consistently and nothing works,
while output for "select * from pkg_lock" is "1|1|0" and "select *
from pkg_lock_pid" returns a number (A pid? But there's no process
with that pid).

Any way to remove to lock? 

Thank you!