From owner-freebsd-ports@FreeBSD.ORG Sun Dec 21 23:38:33 2014 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 96DAD19C; Sun, 21 Dec 2014 23:38:33 +0000 (UTC) Received: from mail-wi0-x22c.google.com (mail-wi0-x22c.google.com [IPv6:2a00:1450:400c:c05::22c]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 1E0B52F84; Sun, 21 Dec 2014 23:38:33 +0000 (UTC) Received: by mail-wi0-f172.google.com with SMTP id n3so6593641wiv.5; Sun, 21 Dec 2014 15:38:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=sender:date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to:user-agent; bh=yOCSKdPtlBMMws5DC3kLvx7iIdQ1pxxp7P6WiEZrlzw=; b=Bmc5NOkE0R+tZKASMdOCnJVc0T//83X08FoQP/KEjfi466YkX/1aJyk1GD7Edy3whF sHY1Vs/GXN4oO/77MLnhzh9f+YvxPQbc2Ow3G9Ph92i1r/50bHSjSIScWZ5vHvKdmNC2 5J0nPycR1YX5V24jukkwzFKJ8/3bai3GiCokmCRXId2u0M7F58YCGmdDcmEdt4EMmTti THSg0x0l7F15PCN2V8l724i7Xu1KyVKnXIKoD4wT4CKerOI5JNcr6Z4MniH20hXC8QHo YN6vz0mKV9oj3xF0T8tK7OzPO5N4MgbFJZopk8FZ64yfhmQBLf2Q7ijRF6YGYKOox8hr DmMQ== X-Received: by 10.180.72.199 with SMTP id f7mr26352989wiv.58.1419205111503; Sun, 21 Dec 2014 15:38:31 -0800 (PST) Received: from ivaldir.etoilebsd.net ([2001:41d0:8:db4c::1]) by mx.google.com with ESMTPSA id td6sm11178739wic.15.2014.12.21.15.38.30 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 21 Dec 2014 15:38:30 -0800 (PST) Sender: Baptiste Daroussin Date: Mon, 22 Dec 2014 00:38:28 +0100 From: Baptiste Daroussin To: Roger Marquis Subject: Re: sqlite error while executing DROP INDEX Message-ID: <20141221233828.GA43454@ivaldir.etoilebsd.net> References: <20141221194819.94F2FB59@hub.freebsd.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="AhhlLboLdkugWU4S" Content-Disposition: inline In-Reply-To: <20141221194819.94F2FB59@hub.freebsd.org> User-Agent: Mutt/1.5.23 (2014-03-12) Cc: freebsd-ports@freebsd.org, freebsd-pkg@freebsd.org X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Dec 2014 23:38:33 -0000 --AhhlLboLdkugWU4S Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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. >=20 > # pkg > 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 >=20 > Any sqlite gurus out there know how to fix this? >=20 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 p= orts tree or in portmaster/portupgrade (don't know what you do use) Based on that I'll give you a workaround. Best regards, Bapt --AhhlLboLdkugWU4S Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEABECAAYFAlSXWe8ACgkQ8kTtMUmk6Ez2ggCeLDD6Kn/Oab7ppPYLAmD+Vb3F 19UAn3BaSvEehCyDQlhlEw+5OY2q8mBW =viqT -----END PGP SIGNATURE----- --AhhlLboLdkugWU4S--