From owner-freebsd-pkg@FreeBSD.ORG  Fri Nov  1 16:08:13 2013
Return-Path: <owner-freebsd-pkg@FreeBSD.ORG>
Delivered-To: freebsd-pkg@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115])
 (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTP id 1DCB97BC
 for <freebsd-pkg@freebsd.org>; Fri,  1 Nov 2013 16:08:13 +0000 (UTC)
 (envelope-from bengta@P142s.sics.se)
Received: from sink.sics.se (sink.sics.se [193.10.64.88])
 (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by mx1.freebsd.org (Postfix) with ESMTPS id A943426C3
 for <freebsd-pkg@freebsd.org>; Fri,  1 Nov 2013 16:08:12 +0000 (UTC)
Received: from P142s.sics.se (h139n3-u-d1.ias.bredband.telia.com
 [90.228.197.139])
 by sink.sics.se (8.14.5/8.14.5) with ESMTP id rA1FxoCh015853
 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
 Fri, 1 Nov 2013 16:59:50 +0100 (CET)
 (envelope-from bengta@P142s.sics.se)
Received: from P142s.sics.se (localhost [127.0.0.1])
 by P142s.sics.se (8.14.7/8.14.7) with ESMTP id rA1FxU05002478;
 Fri, 1 Nov 2013 16:59:30 +0100 (CET)
 (envelope-from bengta@P142s.sics.se)
Received: (from bengta@localhost)
 by P142s.sics.se (8.14.7/8.14.7/Submit) id rA1FxU66002477;
 Fri, 1 Nov 2013 16:59:30 +0100 (CET)
 (envelope-from bengta@P142s.sics.se)
From: Bengt Ahlgren <bengta@sics.se>
To: freebsd-pkg@freebsd.org
Subject: ffmpeg update failed
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (berkeley-unix)
Date: Fri, 01 Nov 2013 16:59:30 +0100
Message-ID: <uh71u30dsf1.fsf@P142s.sics.se>
MIME-Version: 1.0
Content-Type: text/plain
X-BeenThere: freebsd-pkg@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: Binary package management and package tools discussion
 <freebsd-pkg.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-pkg>,
 <mailto:freebsd-pkg-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-pkg>
List-Post: <mailto:freebsd-pkg@freebsd.org>
List-Help: <mailto:freebsd-pkg-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-pkg>,
 <mailto:freebsd-pkg-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 01 Nov 2013 16:08:13 -0000

I ran into trouble updating ffmpeg according to the recent UPDATING
entry:

portmaster -o multimedia/ffmpeg multimedia/ffmpeg1

after multimedia/ffmpeg was updated, portmaster failed to update
dependencies:

===>>> Updating dependency entry for ffmpeg-2.1,1 in each dependent port
pkg: sqlite: columns package_id, origin are not unique (pkgdb.c:3605)

On a build machine I am using portmaster to update, then build packages
with pkg create -a, and finally a repo with pkg repo.

I discovered this issue after the fact when pkg on a pkg-updated machine
complained that ffmpeg1 was missing, since portmaster already had
removed ffmpeg1.  I have re-installed ffmpeg1 to temporarily fix the
issue, but how can I get rid of the ffmpeg1 dependency?  Do I need to
reinstall everything that has that dependency?  Or is the pkg database
broken beyond repair?

Bengt