From owner-freebsd-pkg@FreeBSD.ORG Mon Dec 22 16:11:20 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 282DA13B for ; Mon, 22 Dec 2014 16:11:20 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "ca.infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id BD1843F3F for ; Mon, 22 Dec 2014 16:11:19 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.2.117.99]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.1/8.15.1) with ESMTPSA id sBMGBBER046062 (version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Mon, 22 Dec 2014 16:11:12 GMT (envelope-from matthew@FreeBSD.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk sBMGBBER046062 Authentication-Results: smtp.infracaninophile.co.uk/sBMGBBER046062; dkim=none reason="no signature"; dkim-adsp=none; dkim-atps=neutral Message-ID: <5498429F.5040005@FreeBSD.org> Date: Mon, 22 Dec 2014 16:11:11 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: freebsd-pkg@freebsd.org Subject: Re: sqlite error while executing DROP INDEX References: <20141222151705.BF84CC16@hub.freebsd.org> In-Reply-To: <20141222151705.BF84CC16@hub.freebsd.org> Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="NhJ6wMiQBhXiN0W0cKwUEfKJb2p8FIwUC" X-Virus-Scanned: clamav-milter 0.98.5 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.8 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 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: Mon, 22 Dec 2014 16:11:20 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --NhJ6wMiQBhXiN0W0cKwUEfKJb2p8FIwUC Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 22/12/2014 15:17, Roger Marquis wrote: > Can all of these records can be safely deleted, all of the pkg-configs,= > or should the delete be limited to pkg-config|7714? Also curious about= > the significance of the package_id field and how n+1 records were writt= en > in the first place. I trust someone has filed one or more bugzillas as= > it appears pkg should be checking for dupes on at least two dimensions.= Glad to hear that you've got the problem sorted now. As I recall the switch between devel/pkg-config and devel/pkgconf was over two years ago, and there were some UPDATING instructions that should have been followed at the time: 20120726: AFFECTS: users of devel/pkg-config AUTHOR: bapt@FreeBSD.org devel/pkg-config has been replaced by devel/pkgconf # portmaster -o devel/pkgconf devel/pkg-config or # portupgrade -fo devel/pkgconf pkg-config-\* pkgng: # pkg set -o devel/pkg-config:devel/pkgconf # pkg install -f devel/pkgconf There's been a lot of changes in both ports and pkg since then, but I think not doing the above in 2012 and the subsequent changes to pkg(8) culminating in the latest schema changes in 1.4.0 explain what you've see= n. > Forensics is also hampered by the lack of a date field, ideally > reflecting the package's install date (with epoch/unix timestamp > precision). Consider this a feature request. There is a date field, but it's in the packages table. Try: SELECT id, origin, name, version, time FROM PACKAGES WHERE name LIKE 'pkgconf%' ; time is given as a unix epoch time which you can convert to something more understandable like so: % date -j -r 1411539887 Wed Sep 24 07:24:47 BST 2014 Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey --NhJ6wMiQBhXiN0W0cKwUEfKJb2p8FIwUC Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.20 (Darwin) iQJ8BAEBCgBmBQJUmEKfXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkAT5TAP/j4Lexf2nWvHQUozkW6yOuF/ id5A00mXuyP4IlXv9ICoKo1pNcBmTJe0+R2alvEasL9945FfC8KkKdKIeJpqORCP v+0WrE7MqPqe1CfJPbPjuwho61FcLCQkAAUrnSk5yemJZpurm7r/AchagcEQ7zCH +1/74kugkYbSKk16E59kJAezw744tRCAG5uDA4bI1dKgN2y20k45vJk4R4Xjvgf6 04rdd78zv8xtmC4JiqsZpmoHQzjusU/w7U7BvP+LwWRJbD9GkzjAgXTHltdGPdH0 HTbxbMzVtsoWlru4GSi6DWg2l3uaPDl90GeYNB2Fiy9oEeWG0jD+D52RG1/+bELq jEk/68V6X6jlkFchONV/sD4RdkkspfJGzlfHOOc44m9imaH0CoUaJKpZFvZjDNeA ez4pLFuj+TZnDMsorR3LSbV8C3bzmDf08KlAA7RfnLHIKSlxpJWs9l+5f7SKdmFR PybjixhDnJrv1oMP8TccWh4RvkaSF4ysw2HXACZTEBH8HShm8zoXndEI22tMmWV6 qeOAqfD3EWC+N7mlvKqOcplkTcO00UdBZP1o7BAnOKd0sZ/GcSawa1vgG993XIat ZrNPjDI7HnoS3tN3Cpr7AwrXMEHBh1Kfq2j/83WYdE+3Lzs7Aa+yG4DvMHob3nPT b2WQEM3mZThishutACFN =mD2A -----END PGP SIGNATURE----- --NhJ6wMiQBhXiN0W0cKwUEfKJb2p8FIwUC--