sqlite error while executing DROP INDEX

[Baptiste Daroussin]

On Sun, Dec 21, 2014 at 11:42:31AM -0800, Roger Marquis wrote:
> Of all the pkgng bugs we've finally hit one that doesn't have an obvious workaround.
> 
>    # pkg <anything>
>    pkg: sqlite error while executing DROP INDEX deps_unique;CREATE UNIQUE INDEX deps_unique ON deps(name, version, package_id); in file pkgdb.c:2262: UNIQUE constraint failed: deps.name, deps.version, deps.package_id
> 
> Any sqlite gurus out there know how to fix this?
> 
Can you host somewhere you /var/db/pkg/local.sqlite somehow one of your
dependency is very bad, in theory this is impossible, either a bug in the ports
tree or in portmaster/portupgrade (don't know what you do use)

Based on that I'll give you a workaround.

Best regards,
Bapt
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 181 bytes
Desc: not available
URL: <http://lists.freebsd.org/pipermail/freebsd-pkg/attachments/20141222/70af25f7/attachment.sig>