Date: Mon, 22 Dec 2014 07:17:02 -0800 (PST) From: Roger Marquis <marquis@roble.com> To: freebsd-ports@freebsd.org Cc: freebsd-pkg@freebsd.org Subject: Re: sqlite error while executing DROP INDEX In-Reply-To: <mailman.1.1419249600.27230.freebsd-ports@freebsd.org> References: <mailman.1.1419249600.27230.freebsd-ports@freebsd.org>
| previous in thread | raw e-mail | index | archive | help
Matthew Seaman wrote: > SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2' > AND package_id='7714'; > Given two rows that are exactly the same No two rows but it apears one of pkg's dependencies may have changed names at some point: # SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2' # AND package_id='7714'; devel/pkgconf|pkgconf|0.8.7_2|7714 # SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2'; devel/pkg-config|pkgconf|0.8.7_2|7669 devel/pkg-config|pkgconf|0.8.7_2|7670 devel/pkg-config|pkgconf|0.8.7_2|7671 devel/pkg-config|pkgconf|0.8.7_2|7685 devel/pkg-config|pkgconf|0.8.7_2|7686 devel/pkgconf|pkgconf|0.8.7_2|7700 devel/pkgconf|pkgconf|0.8.7_2|7714 devel/pkg-config|pkgconf|0.8.7_2|7714 devel/pkgconf|pkgconf|0.8.7_2|7747 devel/pkgconf|pkgconf|0.8.7_2|7748 devel/pkg-config|pkgconf|0.8.7_2|7755 devel/pkg-config|pkgconf|0.8.7_2|7756 devel/pkg-config|pkgconf|0.8.7_2|7772 devel/pkg-config|pkgconf|0.8.7_2|7775 devel/pkgconf|pkgconf|0.8.7_2|7798 devel/pkgconf|pkgconf|0.8.7_2|7800 devel/pkgconf|pkgconf|0.8.7_2|7802 devel/pkg-config|pkgconf|0.8.7_2|7804 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. 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. Grazie! Roger
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?>