Date: Mon, 22 Dec 2014 16:11:11 +0000 From: Matthew Seaman <matthew@FreeBSD.org> To: freebsd-pkg@freebsd.org Subject: Re: sqlite error while executing DROP INDEX Message-ID: <5498429F.5040005@FreeBSD.org> In-Reply-To: <20141222151705.BF84CC16@hub.freebsd.org> References: <mailman.1.1419249600.27230.freebsd-ports@freebsd.org> <20141222151705.BF84CC16@hub.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --]
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 written
> 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 seen.
> 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
--
Dr Matthew J Seaman MA, D.Phil.
PGP: http://www.infracaninophile.co.uk/pgpkey
[-- Attachment #2 --]
-----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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5498429F.5040005>