Problem with the pkg datebase

[Matthew Seaman]

On 02/09/15 09:15, Willem Jan Withagen (EcoRacks) wrote:
> Hi,
> 
> Trying to run a 'pkg upgrade -f' which gives me:
> 
> pkg: sqlite error while executing UPDATE packages SET name=?1  WHERE
> name=?2; in file pkg_jobs.c:1576: UNIQUE constraint failed: packages.name
> 
> And upgrading is not really possibe.
> 
> How do I fix the database?

The unique key in the pkg DB changed from port origin to port name
relatively recently.  This means you've managed to get two packages with
the same name but different origins installed -- one way it seems fairly
common to do that is when you had the docbook ports installed, but you
haven't been updating them religiously, but there are other ways.

Try:

  pkg query -a "%n\t\t%v %o" | sort | less

and try and spot the repeated name. You may also see some packages that
have been arbitrarily renamed to avoid this sort of collision. Deleting
the affected packages (either repeated name or renamed) and reinstalling
should solve the problem.  There aren't any name collisions possible in
the ports anymore, so once you're fully up to date this shouldn't happen
again.

	Cheers,

	Matthew


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 949 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freebsd.org/pipermail/freebsd-ports/attachments/20150209/5d77fa95/attachment.sig>