Date: Mon, 27 Jun 2022 20:59:52 +0100 From: Graham Perrin <grahamperrin@freebsd.org> To: freebsd-pkg@freebsd.org, freebsd-ports@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?= Message-ID: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org>
next in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------WA27xGhYZLitXwArO9zecK17
Content-Type: multipart/mixed; boundary="------------L50hv4823D0IKtDUPNXIBQcO";
protected-headers="v1"
From: Graham Perrin <grahamperrin@freebsd.org>
Reply-To: Graham Perrin <grahamperrin@gmail.com>
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
<html data-lt-installed=3D"true">
<head>
<meta http-equiv=3D"content-type" content=3D"text/html; charset=3DUTF=
-8">
<title>pkg: sqlite error while executing UPDATE packages =E2=80=A6
pkgdb.c:2648: UNIQUE constraint failed: packages.name</title>
</head>
<body>
<p>From <a class=3D"moz-txt-link-rfc2396E" href=3D"https://pastebin.c=
om/raw/uPExYGha"><https://pastebin.com/raw/uPExYGha></a>: <br>
</p>
<pre>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
</pre>
<p>Please, should I be concerned? <br>
</p>
<p>Context:
<a class=3D"moz-txt-link-rfc2396E" href=3D"https://github.com/freebsd/fre=
ebsd-ports/blob/f117f2c48552792743a74a931a49e76fc4a9c0f7/UPDATING#L8-L40"=
><https://github.com/freebsd/freebsd-ports/blob/f117f2c48552792743a74a=
931a49e76fc4a9c0f7/UPDATING#L8-L40></a></p>
<p>TIA<br>
</p>
</body>
<lt-container></lt-container>
</html>
--------------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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?14b7dabc-7390-9e16-1de2-d72e2ba23510>