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
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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5498429F.5040005>