Date: Tue, 28 Jun 2022 16:24:53 +0200 From: Baptiste Daroussin <bapt@FreeBSD.org> To: Graham Perrin <grahamperrin@gmail.com> 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> In-Reply-To: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org> References: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, Jun 27, 2022 at 08:59:52PM +0100, Graham Perrin wrote: > From <https://pastebin.com/raw/uPExYGha>: > > 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: <https://github.com/freebsd/freebsd-ports/blob/f117f2c48552792743a74a931a49e76fc4a9c0f7/UPDATING#L8-L40>; > > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20220628142453.s4swjw2ijxeljzg7>