From nobody Tue Jun 28 14:24:53 2022 X-Original-To: freebsd-pkg@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 97D0587AE7E; Tue, 28 Jun 2022 14:24:56 +0000 (UTC) (envelope-from bapt@FreeBSD.org) Received: from smtp.freebsd.org (smtp.freebsd.org [96.47.72.83]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "smtp.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4LXRgr3wx6z4X33; Tue, 28 Jun 2022 14:24:56 +0000 (UTC) (envelope-from bapt@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1656426296; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=VasbzOytTU9G+ahmosXGpwOT72q6aCnime6Wx5tQpCA=; b=Ygo0aqX7YW5Yf1dR2/utfMxSFRfTOjMXvuVxPVHX7WYG93slLMGgTBhx2ZBIl3SI3msNXm yqmkdevjRR06f/2h4S3lPPG6oQqH14KMn6Za2Gp+rAEovHlgwnlkJYGYoL+S4RL6p9EAb7 hJs8BM5dFnYDsI59CxaWzDqHWAemZSC93wI8z+LwAsDZPa6TeovNYPCAnrcOz57D030beN yK14FBZEhOeAnrIbugZygedHQkoaUaPi8Ah18HUwlE4UEEWOjdliJneR6Lfwz4B8bhmFRG I/k/G3hkd5cT1js9wNXotNp1mNGwG5+Eopd+63dJiz5BHXhYz7w0e/sr5PnRlQ== Received: from aniel.nours.eu (nours.eu [176.31.115.77]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) (Authenticated sender: bapt) by smtp.freebsd.org (Postfix) with ESMTPSA id 4E5BD2F9A4; Tue, 28 Jun 2022 14:24:56 +0000 (UTC) (envelope-from bapt@FreeBSD.org) Received: by aniel.nours.eu (Postfix, from userid 1001) id 7352E167421; Tue, 28 Jun 2022 16:24:53 +0200 (CEST) Date: Tue, 28 Jun 2022 16:24:53 +0200 From: Baptiste Daroussin To: Graham Perrin Cc: freebsd-pkg@freebsd.org, freebsd-ports@freebsd.org Subject: Re: pkg: sqlite error while executing UPDATE =?utf-8?Q?packages_?= =?utf-8?B?4oCm?= pkgdb.c:2648: UNIQUE constraint failed: packages.name Message-ID: <20220628142453.s4swjw2ijxeljzg7@aniel.nours.eu> References: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org> List-Id: Binary package management and package tools discussion List-Archive: https://lists.freebsd.org/archives/freebsd-pkg List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-pkg@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org> ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1656426296; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=VasbzOytTU9G+ahmosXGpwOT72q6aCnime6Wx5tQpCA=; b=LkBJpUIZYhWEKjP5U4kLPMmAFd6QE7xjd+/0ZZ5qy9WbRw89yhkJzvKZp2d5zyZFWe0FyV icY8XuE9JB3G3EZkF0dkypf8YEnLMN4vtt/j8EZCqp5I0Crom3q0m6NzdMnfkaMhY8J1NK 3xBxVtgPVytbdfjOOhNkbbzSiX4JstomyjFbw2+8sLOSXqn/iGB1dlECr5/+h85vfvv/o6 62Vo2ov2TnhsCEkb3haqVbfcD2d7UiYI7XwBQB7P2t0D9yBtzpyJjvTgTzD7iO3BZP9jJa dj8U21gIg95A9WFxXgmQY0dLmDyhwexYREy8hmrajsDSDKAUL+rMLsNGXkGUUg== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1656426296; a=rsa-sha256; cv=none; b=x7VSdjrc/DLVwwEU4uza6ud9zL5ktfkBSGJYJOC16QWNYpTBoj2vR+DSayW1mW+DjDIhph 1t1vVXdizeVEDJQyA0tHpI2OwrTSpB9JN2RbSRLjd8ZYTZkaDG8JPaAfLeLX5HqBk3Dbg+ 50RYiTuloY3D9Jz4v0Kl9Cmmt0S6XxfXRJcx9ya/UbisfKLxM3w60/2hoUNLlDOFq5I9B9 U7FgOC3zVNgjKHkAwvw1OZ0ovi0bcJX7aPuKVEVKpGi/OcrLvEVJyw+Fosij/O78VQat87 ZNGC1Op1I5paRqVvh2vilw06Kn7IftYYprsWtKLPApsliVPrwxFX13YWznZiwg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N On Mon, Jun 27, 2022 at 08:59:52PM +0100, Graham Perrin wrote: > From : > > pkg: sqlite error while executing UPDATE packages SET name='py39-setuptools' WHERE id=44784 in file pkgdb.c:2648: UNIQUE constraint failed: packages.name > pkg: sqlite error while executing UPDATE packages SET name='py39-sqlite3' WHERE id=45711 in file pkgdb.c:2648: UNIQUE constraint failed: packages.name > > Please, should I be concerned? > > Context: > > TIA > No you don't have to worry it means that you already have some py39 packages installed. The advice if pkg set is a bad advice and actually a broken advice. because the version number will not be bumped, the only reason why it kind of works is because pkg is clever enough to figure some dependencies are invalid anymore so will pkg will request a reinstallation. So it is flawed. Best regards, Bapt