From nobody Mon Jun 27 19:59:52 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 4836E8754EE; Mon, 27 Jun 2022 20:02:49 +0000 (UTC) (envelope-from grahamperrin@freebsd.org) Received: from smtp.freebsd.org (smtp.freebsd.org [IPv6:2610:1c1:1:606c::24b:4]) (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 4LWzD91Przz3tjd; Mon, 27 Jun 2022 20:02:49 +0000 (UTC) (envelope-from grahamperrin@freebsd.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1656360169; h=from:from:reply-to:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type; bh=OlFAA+RSpMFfjBT84urhZbbEyOKaOBLfLsaSi98dJuM=; b=MKkgGzhW576RLKv9oWAlInGokHnF3R8MsnUPedaGOI4ZLpum7ZFJY4DPk7pL6eek63XUdG fMrW9uY967ZFpLKZMM1EA7EPDgbEws8YdA/KNJdhpFvL5257vW3n/9pRj7WzWVma5m2qOb A7uwJzcpLwJW7eKvkW1s9lGzRNYOrD3l+UzqzOKrSBM5hLnYQ4SHaeERGLHVSLjSf9MAqZ UM2GTr/kw40gsCAqQsO8/MLLiztl6E8mUnkLHifKcaAqSVstyyGJiuN+VEV55LiqBfHwfS v9mDH396ekqit7+ebUEgArLuDKms0vmhjOdlaIt+2XJJtf500VuHDhFsaJWPhQ== Received: from [IPV6:2001:470:1f1c:a0::2] (tunnel642390-pt.tunnel.tserv1.lon2.ipv6.he.net [IPv6:2001:470:1f1c:a0::2]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) (Authenticated sender: grahamperrin) by smtp.freebsd.org (Postfix) with ESMTPSA id C280425A32; Mon, 27 Jun 2022 20:02:48 +0000 (UTC) (envelope-from grahamperrin@freebsd.org) Message-ID: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org> Date: Mon, 27 Jun 2022 20:59:52 +0100 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 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:91.0) Gecko/20100101 Thunderbird/91.10.0 To: freebsd-pkg@freebsd.org, freebsd-ports@freebsd.org Content-Language: en-GB Reply-To: Graham Perrin From: Graham Perrin Subject: =?UTF-8?Q?pkg=3a_sqlite_error_while_executing_UPDATE_packages_?= =?UTF-8?Q?=e2=80=a6_pkgdb=2ec=3a2648=3a_UNIQUE_constraint_failed=3a_package?= =?UTF-8?Q?s=2ename?= Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------WA27xGhYZLitXwArO9zecK17" ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1656360169; h=from:from:reply-to:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type; bh=OlFAA+RSpMFfjBT84urhZbbEyOKaOBLfLsaSi98dJuM=; b=Tf3px4+SRO8QC3EXHYWvu7aIgV/9q+Gp0lS69n7jh6QpVDimFq+205jNrj2IDiWdKOoAc5 Czr7X9lgAF5jOTw3/ZvQlapHJ7ZfiFGu8KgZZ46tPcecKTgrCz3vQfCqhdiVvBPzTqv0f0 ZM8R3j9FbFITGa9VEHK1XXVF0ZEDSaXiB9LImMumCniRFtvhvFepKKwcqUKfJBFlAXz9RB ncm/cAk24G0CZ2xPuHN/VWyTpoMBSl01QJRdhid8WXtdPZqYnHE5vTD5Sw1S7VWCAa/Kgt e1TJUtyvcxbJCL9Mui9enqWLyV0QD1lSGNpKT+9D5VBs9zlrD+iUuhHO6hSd+g== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1656360169; a=rsa-sha256; cv=none; b=Fkf3rnPqlCXbHAGe60AcMzln2wjEQbLEBld//AVS+nG2u6SnW11HZwMd/uaCxwKPb9s6Yw ycIeFMci2L08Bz1a3WumZB7JQ98HsCOp1TH0A4MwKgnqnsbr+fhZQwkQ3YawqRbC5mibDa o1BJ52f3mL1hyZRP3/f/yVwC/2a72z1iO5TRrHDEFiaUNAoxQg0FS486DbOiU3d8boxnRt yHPwg8XjXVPtkOag76KAR8IdC+aORvrGB59IlZ3+ClauBjY3DmXuLJjyn4H+uMXxiaknE8 xNGB8PVzejYpB36uSlge+UCnr4LW8q2ePvAWT3341ObXnJIiNvS7JERYKSaovQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------WA27xGhYZLitXwArO9zecK17 Content-Type: multipart/mixed; boundary="------------L50hv4823D0IKtDUPNXIBQcO"; protected-headers="v1" From: Graham Perrin Reply-To: Graham Perrin To: freebsd-pkg@freebsd.org, freebsd-ports@freebsd.org Message-ID: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org> Subject: =?UTF-8?Q?pkg=3a_sqlite_error_while_executing_UPDATE_packages_?= =?UTF-8?Q?=e2=80=a6_pkgdb=2ec=3a2648=3a_UNIQUE_constraint_failed=3a_package?= =?UTF-8?Q?s=2ename?= --------------L50hv4823D0IKtDUPNXIBQcO Content-Type: multipart/mixed; boundary="------------M1EI8QfPGO0WJFXmdttlwRJf" --------------M1EI8QfPGO0WJFXmdttlwRJf Content-Type: multipart/alternative; boundary="------------w5Fx561BReNIzIGwTADEPuMZ" --------------w5Fx561BReNIzIGwTADEPuMZ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 IEZyb20gPGh0dHBzOi8vcGFzdGViaW4uY29tL3Jhdy91UEV4WUdoYT46DQoNCnBrZzogc3Fs aXRlIGVycm9yIHdoaWxlIGV4ZWN1dGluZyBVUERBVEUgcGFja2FnZXMgU0VUIG5hbWU9J3B5 Mzktc2V0dXB0b29scycgV0hFUkUgaWQ9NDQ3ODQgaW4gZmlsZSBwa2dkYi5jOjI2NDg6IFVO SVFVRSBjb25zdHJhaW50IGZhaWxlZDogcGFja2FnZXMubmFtZQ0KcGtnOiBzcWxpdGUgZXJy b3Igd2hpbGUgZXhlY3V0aW5nIFVQREFURSBwYWNrYWdlcyBTRVQgbmFtZT0ncHkzOS1zcWxp dGUzJyBXSEVSRSBpZD00NTcxMSBpbiBmaWxlIHBrZ2RiLmM6MjY0ODogVU5JUVVFIGNvbnN0 cmFpbnQgZmFpbGVkOiBwYWNrYWdlcy5uYW1lDQoNClBsZWFzZSwgc2hvdWxkIEkgYmUgY29u Y2VybmVkPw0KDQpDb250ZXh0OiANCjxodHRwczovL2dpdGh1Yi5jb20vZnJlZWJzZC9mcmVl YnNkLXBvcnRzL2Jsb2IvZjExN2YyYzQ4NTUyNzkyNzQzYTc0YTkzMWE0OWU3NmZjNGE5YzBm Ny9VUERBVElORyNMOC1MNDA+DQoNClRJQQ0KDQo= --------------w5Fx561BReNIzIGwTADEPuMZ Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable pkg: sqlite error while executing UPDATE packages =E2=80=A6 pkgdb.c:2648: UNIQUE constraint failed: packages.name

From <https://pastebin.com/raw/uPExYGha>: 

pkg: sqlite error while executing UPDATE packages SET name=3D'py=
39-setuptools' WHERE id=3D44784 in file pkgdb.c:2648: UNIQUE constraint f=
ailed: packages.name
pkg: sqlite error while executing UPDATE packages SET name=3D'py39-sqlite=
3' WHERE id=3D45711 in file pkgdb.c:2648: UNIQUE constraint failed: packa=
ges.name

Please, should I be concerned?

Context: <https://github.com/freebsd/freebsd-ports/blob/f117f2c48552792743a74a= 931a49e76fc4a9c0f7/UPDATING#L8-L40>

TIA

--------------w5Fx561BReNIzIGwTADEPuMZ-- --------------M1EI8QfPGO0WJFXmdttlwRJf Content-Type: application/pgp-keys; name="OpenPGP_0xB767486F4A18D40B.asc" Content-Disposition: attachment; filename="OpenPGP_0xB767486F4A18D40B.asc" Content-Description: OpenPGP public key Content-Transfer-Encoding: quoted-printable -----BEGIN PGP PUBLIC KEY BLOCK----- xsFNBGKYt7ABEAClu83dJ3ZKfVgPOk9YKRv0Z+dl2b88+k9R4vwAmElgguYdKE7y hnQNhhWMv9vi6AFrBMc2oJdVHJ2OrXfwpELBFIgiSMEWNsC4e+Z3HtSajcl+pFZs P7ciiSoycj/w3wIVkAZoVGbhyIbNG7fbCEJ8q81TbfsGypV3bRmbZVvGNecBguYi ooBtz2Qht1p3itXMkIA6P9pSYDl+6QddZLyUUAjAnFv2QDoYSHLnaDUWw4oONZsB 0SKVu8jMIBh4uJZoYEOvdvc9jQQdOpA2CAgA6ulfm42Ikr9lKBUUCtjqiWAhJ7iX OTyHAIdR4Mf8alCE6tdTq6dHdIt+GktTY7oYNyL23aD3C7I5waU0SFXvJcOMG10Q LfwYQMOQoYQ9XJ0U5A28WYiDcylDdUWT7SappP1e1ZMeJWWOy14mxxNzHaJSI4rK 8P/p5tp3Q7SSC4k5gMh9zKba3K2ApCWNbVLGvXsJeQkZZNvu70tE81eyAHI5iZcB 6D7WaHysBUmsKaEpbcmm1ZThTnGL0SHEl5to5Jab5Fg6O+Cnly5sVz5lX/v8Aosx kKNei7SCVqXOVtteQeGxWbXWbhPgbMyc0Gi3DuxBI/yvJ43k/rJysQlLGLWfJx/U XprwLluCPDK9EvKEB+fD1Z349uzp1sKr3ihpySbyKI8fpudftnAz4EsoCwARAQAB zSZHcmFoYW0gUGVycmluIDxncmFoYW1wZXJyaW5AZ21haWwuY29tPsLBlAQTAQoA PhYhBFk/5bLDBwftvJcvCrdnSG9KGNQLBQJimMMBAhsDBQkFo5qABQsJCAcDBRUK CQgLBRYDAgEAAh4FAheAAAoJELdnSG9KGNQLbHAQAJi998y42bEbq5HmABYovmAE tQj33YSUWyc9QRmAHpN8Er3lTKsgmZcVChB5Fu/dgo2oYynDjlVpA7+wiSmg4AG7 8mOYbg/e19XMhrH0keDKqZXFkU+G7agR0mF09qvpQZ9MTJYZ2u7FtytZK665Ufip OdV8eGn2hFC/WynjUwEzKyryBgbbLAEbfOPeZNry4h2ZPWbtTvx/PE/VX3Vh2oGq Yx69DCGz+0xEhy62ZKbkX5SL8LUf/1WViyCVzsHasFxmFxYPWIfBy8ayQ7xapz7M cSXSQyu4oDT4qh9eZiGP9/aAcZKHcV6t9y77JGhUJ/5O1sANKMa3YhgimE+Z86LH Ya1IH774PHj1nAXBwS+Cj/1l/NQoQcyjvOj8zuCsMJVaLMb6B46YsReP4+3yBLpy eBC//t6zWPbgAkWWVjROC0dXUAMTFpnA6NZe3UghG+Nc4fnCLGOhc2nyWFYHIaYV 6Hv1ITFSem9DdeNnR1CFm1VMTJ7i7TuqYM+WZTkoUsTf4c46hS/ZNJZSCxh0s9yY r+BYk3XBbd+ElaZ1dJE6cuSVdw15+P2hDnprurxC4byl4YFkn+UAVvQsOgeq6aSH LOHX0weYu1OLoiPYsTdyGhne72+kDhEEdFD5aHdQPFrbQIrqWLV0a04++0ZwGpNv XtgnWhDdAQJDwGsSSwbLzQ1HcmFoYW0gUGVycmluwsGXBBMBCgBBAhsDBQkFo5qA BQsJCAcDBRUKCQgLBRYDAgEAAh4FAheAFiEEWT/lssMHB+28ly8Kt2dIb0oY1AsF AmKYw7gCGQEACgkQt2dIb0oY1Auymg//QS3QI6HGNSwB4C+4Lp3mKfe24aPxb/VD CdBOixlZuTyS/x9xKZhGBMx3mwMziiCuq+Omc7kFWziNdrfsmMitEqnuxQHgDPCr FluUGxvRD3Z1adErV6H6HkS0oMe3W6j7k/DsV4B8U+FIC4l78ybPQoi3ESN3bro2 nBT3QJ3Snd2XQ62uYanMqnu7GMdzTWyD+VclKc2Or06Gv8UhcRnJVqwteu/OvYpy gxsF5TB5XORbCicbunB6k5BlEwxcVun//B1AApNSrnnOFTFd94vR17dJDhG80pfO FFQccbmLVTowC2WvV1HWg+csCXYXqH0usGXgiZwMFoANgHxhGc90cAUXZszHKN9J vV9RZNX3s4oVTC+GGFHs6YsqPchHMTpRny50WauvTlUCeHOh+pXdQfnYfcVl80LI DQYk0Zk6GcOcy8uAM9m/o5TSJajaZ2t5NyfZMrnHsRXymzw9F4Zr5V5xu0nzLwmn ypW2o6WbMLdgR/vghxOIMX4y9YuxV8ZSPJMHNW7O6tmTc3RKzHAjRO7OzZFXJoEK MQ8GRozYILrw8wtwLR6lnQtrWbFl+zjGz9mlE3LALZQ60FX2Zbxhd7NxlNztIXdj J6xCx2dSIAK+elUu0YBATRIQky/340uiig70m+2i2gKyshffEUolJzdDeunNKQhI RE6I0tTmF0vNKEdyYWhhbSBQZXJyaW4gPGdyYWhhbXBlcnJpbkBmcmVlYnNkLm9y Zz7CwZQEEwEKAD4WIQRZP+WywwcH7byXLwq3Z0hvShjUCwUCYrckXQIbAwUJBaOa gAULCQgHAwUVCgkICwUWAwIBAAIeBQIXgAAKCRC3Z0hvShjUC4ThD/9KoMqppx7i /NZ5pVM2mECi2uVLkXbDQ3sUy77RE7WKvv+lSwutdmse1lMN6hNvnJNBOO9GpPY3 qtUdH3BKOMEncPn9D5fvBPgoBSTDHJ/0zXWi7CD7EemC4VsvcFEaqWEkrdsuv04f wvEQ3eTwSF/gvjBPLvjxQWoLomFoboWhGXawFgb63/VAxLZtcIXb2YW3eMeZstSe DIaIMnWDIJSOAWHfbsR1RnNHgoDmK8JW14svtCSKnYrlQOPxGvGVH5Bes2WQcVXs 8Ci1WcODJsIUR40LamI8Re85qXtFthHh37ADmsOW6KnPilSYF0SZMdhjFGwBy7VG v/Ecs5Z11kAcwc6rbq8H1uPxy/C5d2VoVGnvNVtYGsPuYGoActEG4Ud8v8y9a2bX 9YkgLtFZHTLSSWaePmpFws4kxsdmpvWDFprkz9229t8DobMIab91x+cwFc1jX7ED tE6cIWA1qZ2oxzlERYmHs4mggo0Bl8+61O7Lngsz2fjVeywn/V2yt9Pg75MiQeJT UEWVEupjk+GlATOj4EIlYNT5EUGlGg6WfPKewyMvrvK09Z6o1VotMVlnhkAARjT0 SQJbiHvc8hmtBO//k5qtcRnAFjREZ1XZdfPSWAMVQ+RvTBsASIHWMk/K8C01a7A1 kZcHE0XH2Iz443IZfAQ4M78jpy0QSl9XY87BTQRimLewARAA0W9bWboewz2BE9MC un3u6MG2IDPkXyoZnKxoEdhyPTNquvtFihfyE54IFnSFthHHOM9m6C8/3MLzxgku /2MWTOtSpJRgsLku6tbNOF5xw1h7hcX10D8wHVZjTt22KDGWyYx17OrAdruZLIsD 8GjAFlmhpL4ko3OacLxwok5l+bx+QgY/1YvuREsl9/LyuCTOUv5uKLiP+jPW4shY Iplfr971cgsSQk9YCPYOKBiIdaquUuN929X4oZ+Mhz3/FzisgaQP0HMCzjVYgaiS +Z5zsabId+OKzcZ9kewnEc84nDlfntiGzHpuJcDVkJWSqEaLSl2YvS6jeZsp0gWK gFHaGbptEIp1k/RdtgdEHseTx9cwLfYtlvdVXZHDwdy8JEV49O8nEbbEs6YDwOny 3OgLKFhbJR5fJFTjuXiSAOMYY5T2vlvJYLkB2dIl/ubgL9ngIF0drMAA7hz7hDTR UrZrIADJfDjjoLau+cgOU6ciM8TLl1fTZqdFXyGlDPyHS3ZsYXNaQnN9tJeX2DB1 SxQEXlhG0o9kB/GM1n6VxyHoLrVlmBGx/Uog14EvSqCpgiVf0Gvsev2/Mt6Tmb5y Gwg2spwtmK+dLPIEWvZG+eCRPGfqfK9elN0hLCtz7VItERdHudXWpwlR66xOvx2r dl1Dv+p52IFYBTqy2qOhof1TLPMAEQEAAcLBfAQYAQoAJhYhBFk/5bLDBwftvJcv CrdnSG9KGNQLBQJimLewAhsMBQkFo5qAAAoJELdnSG9KGNQL+6oP/2IwmYPFV8jM 17LICEKUTiiqoeVdFAUkJazN7auLVocoNB1TLoEI9DpvojT7BBDhh5JurcoRzM5S hqQHP5dIgDPvLcCMoOOGKOfg3HxV6zjE208PU/Yw7FjpDgZLMctvYmIYKaqVnQwZ 4V76yafxTQIl/An86yDmXhT8nQ6BIigRFwMX3mvaOSfyXlZ2YlHqIhXu4uvJ2RrG +CcYT3MzX6ltdrdC5ef4m47M4OQYI14i2qNCqm1jYeG0uQlcB/dDq/uaqloM1j3g Yrs/qzdkFxP1f3y+OBhI9WCgEgqpmomEYI6ERbm89WqtcAlzF2NyKneOdua7HFIE uxwcW25Z8k6HVD2mpjf9p0s3JhPz5MfDAKQ0oGQiIbNEUwIPvwKF+B1C1da0hE0M DKwRELfOE8OVuax7L1yq+GRLCVKWzy1mEyErKdt5x0fr2bS/1IPjlgphwu1+w9tc ZP8VSeLANUSyQSnQh7Z8gOFJ7/5DUtSlRsR5yE1csNWu9UCQA7uKrHbTObugsmFI aoTNaLHlrVeo/kIvCgvxuAtwIGX9On3tn1ZeNs9oK02my+GwuhUFzME19nbJuTWp Fo1AplC/LsLEBO2QOMysaBGCNWFfatW4q6c53GEbqa9apzKIIDFB1qtCAWLIRUKx DvD3lVGQcO/xnwHod2q4HcNkLu+PEwss =3DY36E -----END PGP PUBLIC KEY BLOCK----- --------------M1EI8QfPGO0WJFXmdttlwRJf-- --------------L50hv4823D0IKtDUPNXIBQcO-- --------------WA27xGhYZLitXwArO9zecK17 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEEWT/lssMHB+28ly8Kt2dIb0oY1AsFAmK6DDgFAwAAAAAACgkQt2dIb0oY1AtX pQ/5AYv9C1uSFyM+ZZnuDPyzYNRHVuHGN7SympQl+9h1NYm5VzyWxLl/h/qBJ4qhvwxqUxRjso91 24GiJAR95RjKXaVZSr6bEUM3oaEfXR9tNnQGL+yPjW1kureynpT76QYtRoB4WwxhRjsuqVGVlkJW AWn6iUHZUUOWt59kPI05DKuxWfdvMAbw/CqSf7dbON8W9eTPkkRP/bDXtgeWiZS1uS4psZKdusG4 9TQ//407B8feIS1635ZNqzwlny9V+u9XVxYa96V0vC13pxzzqwFxK+C1tKxg8y0SknSkFmOgJisY vtC+bnhUtmhZGXgaQym0cUbFk2pTs6yxITw1SL1/fpr7ydM9Xb3KjOBCX+rv52SeT8B4jtxAvat/ noSwqOPcpHjn99S41wjLIKXxo/kvK29U/ad4O3qqp0s841700FIMwwY0REQlBxp32I0iclNVAKvK wB8KVMu4imOzbH38GsWmDBllzG5QHgurboBiYlQxum47MezUxYhMJYttbpkxRnrYGs/aYdjg4N67 WrsSGxt9/H/oTFMeALiNgEgpsQK7rUH846wfi+FB43ovt8sSYGvutD35C0rgQ7V0mgQGQovoKiX/ Tv5XkasCSIj83zRqztlokCAfwqX7akq/+LdPxa4JAW/O/WIKx9wXyVRfuDO1veByyAtKxUAipH5c 274= =WXMn -----END PGP SIGNATURE----- --------------WA27xGhYZLitXwArO9zecK17--