From owner-freebsd-questions@freebsd.org  Thu Mar  2 15:33:00 2017
Return-Path: <owner-freebsd-questions@freebsd.org>
Delivered-To: freebsd-questions@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 E028FCF46AA
 for <freebsd-questions@mailman.ysv.freebsd.org>;
 Thu,  2 Mar 2017 15:33:00 +0000 (UTC) (envelope-from bsd@lordcow.org)
Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3])
 by mx1.freebsd.org (Postfix) with ESMTP id CAC37118
 for <freebsd-questions@freebsd.org>; Thu,  2 Mar 2017 15:33:00 +0000 (UTC)
 (envelope-from bsd@lordcow.org)
Received: by mailman.ysv.freebsd.org (Postfix)
 id C96E6CF46A9; Thu,  2 Mar 2017 15:33:00 +0000 (UTC)
Delivered-To: questions@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 C91B5CF46A8
 for <questions@mailman.ysv.freebsd.org>; Thu,  2 Mar 2017 15:33:00 +0000 (UTC)
 (envelope-from bsd@lordcow.org)
Received: from mail.lordcow.org (lordcow.org [IPv6:2c0f:fb18:402:5::2])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client CN "devaux.za.net", Issuer "Cow Certificate Authority" (not verified))
 by mx1.freebsd.org (Postfix) with ESMTPS id 245A6117
 for <questions@freebsd.org>; Thu,  2 Mar 2017 15:32:59 +0000 (UTC)
 (envelope-from bsd@lordcow.org)
Received: from lordcow.org (localhost [127.0.0.1])
 by mail.lordcow.org (8.15.2/8.15.2) with ESMTPS id v22FWpDF012176
 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT)
 for <questions@freebsd.org>; Thu, 2 Mar 2017 17:32:51 +0200 (SAST)
 (envelope-from lordcow@lordcow.org)
X-Authentication-Warning: lordcow.org: Host localhost [127.0.0.1] claimed to
 be lordcow.org
Received: (from lordcow@localhost)
 by lordcow.org (8.15.2/8.15.2/Submit) id v22FWkZp012153
 for questions@freebsd.org; Thu, 2 Mar 2017 17:32:46 +0200 (SAST)
 (envelope-from lordcow)
Date: Thu, 2 Mar 2017 17:32:46 +0200
From: Gareth de Vaux <bsd@lordcow.org>
To: questions@freebsd.org
Subject: pkg database corrupt
Message-ID: <20170302153246.GA90367@lordcow.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.7.2 (2016-11-26)
X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,BAYES_00
 autolearn=ham autolearn_force=no version=3.4.1
X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on lordcow.org
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.23
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <https://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: <https://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 02 Mar 2017 15:33:01 -0000

Hi all, on a fresh 11.0-RELEASE install (updated to 11.0-RELEASE-p8) I get the following:

# pkg audit
pkg: sqlite error while executing sqlite open in file pkgdb.c:1107: unable to open database file


'pkg info' etc. works. If I rebuild /var/db/pkg/local.sqlite from /var/backups it gets worse
(missing tables etc.) and if I delete /var/db/pkg/local.sqlite and rebuild all ports from
scratch I end up with the same initial problem. Any ideas? My current local.sqlite is at
http://lordcow.org/local.sqlite .