Skip site navigation (1)Skip section navigation (2)
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?>