From nobody Tue Jun 28 04:10:44 2022 X-Original-To: freebsd-ports@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 E89458669FE; Tue, 28 Jun 2022 04:10:58 +0000 (UTC) (envelope-from tatsuki_makino@hotmail.com) Received: from APC01-TYZ-obe.outbound.protection.outlook.com (mail-tyzapc01olkn2011.outbound.protection.outlook.com [40.92.107.11]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mail.protection.outlook.com", Issuer "DigiCert Cloud Services CA-1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4LXB3P3JYsz3kN8; Tue, 28 Jun 2022 04:10:57 +0000 (UTC) (envelope-from tatsuki_makino@hotmail.com) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=N9McuQmGhWm6BrvKwjA3I0aV5v3DUuF7EJlrXpv/1XTLN+ERuD26k/D7pc5jMU3fnqG414XyTO/+/Huol1DrtCmR/IyoA0pRofDt26eZY5Xgwkyjobircetac79rRzElXK0GUyeEQ0FnhxZqOw6e2co18Kk61W7zTGqe8xCRML6DYwA1JwxXfOVQgQtEYtOWR/UUy0HfBWyeJxLLfPrONE0ek8FhdkMP6kCqWxJzylbsidXS6v5q1KiVj1s6pJjKC2Zc25L2BvXKBNHSi6+9ykg/If2KcfAyidwl1i/p3mjxc4UoLljhCHF982EKq7C8y0gyGpUAgJF92WQbTxaksQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=f/sovk4mn8VP84uim3ILH4Y0d2T1G1VoIrJ77zLxxVc=; b=J5ahPtfT9+PR66RHLUgIPyoFMVM3YtIY8ZK2enh7ImzfFEv6WzJHG2TPqynjnAB6uOh5nCu5SABQZdyRjpdtDC3biw7n8/bWTTunUcgtF/hilU+S3oTTsVAVkxbIiHSs2kY+rQGjeibi3gJMQj5qmf69/Rbi6Iq7Val4dZH1T6yIrCt6eFyytjavtEk5XDOqES8Qoe5zg35WNTa85azx/aUerL5H1s6bFxYbok9q3fzvlnJvkf3VuWbfDGwuEteVd4iwybqrN02+Vqv+pUHKTLg5/e8sHKpST0WBoa+STpInh0Us5p+Ik6NriHBYrt5a81vCOdZJ4fCG9IK5n6tRxw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=f/sovk4mn8VP84uim3ILH4Y0d2T1G1VoIrJ77zLxxVc=; b=LxxFSSLiioIQP3Dp9uuC0cGZBLMdUv0WejXmLeb7c+mclNQg0jmvbV0XXnOmiji0J6cur0hZ4+XHglJRMqCNRYNk15gYVPb1qZfCKYIkf70F+hFy2SpMBJilJoZNTOrdjNWIGSrhCutXhj698aLAlwUSDauJuKTPcETpcdW2xBN3slYmW6BbipLi4CMYwHDXajAPheniDp0Pfm9zpukRWcI82OBgFnd4e06HFu9iSZ62Yh1goiOlXWO74lDQT+XwUXeYXjaK1FVOXszASUhLo0c6D76QzLMQBTWMGI37IJ3qPm1xsSH5c0dxkU4BFgmkDnG1HiOeY+D5RwuARx5t9Q== Received: from PSAPR03MB5639.apcprd03.prod.outlook.com (2603:1096:301:66::13) by SG2PR03MB4277.apcprd03.prod.outlook.com (2603:1096:4:86::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5395.11; Tue, 28 Jun 2022 04:10:47 +0000 Received: from PSAPR03MB5639.apcprd03.prod.outlook.com ([fe80::41ce:b9b4:104b:69aa]) by PSAPR03MB5639.apcprd03.prod.outlook.com ([fe80::41ce:b9b4:104b:69aa%7]) with mapi id 15.20.5395.013; Tue, 28 Jun 2022 04:10:47 +0000 Subject: =?UTF-8?Q?Re:_pkg:_sqlite_error_while_executing_UPDATE_packages_?= =?UTF-8?Q?=e2=80=a6_pkgdb.c:2648:_UNIQUE_constraint_failed:_packages.name?= To: Graham Perrin , freebsd-pkg@freebsd.org, freebsd-ports@freebsd.org References: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org> From: Tatsuki Makino Message-ID: Date: Tue, 28 Jun 2022 13:10:44 +0900 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101 Firefox/52.0 SeaMonkey/2.49.4 In-Reply-To: <14b7dabc-7390-9e16-1de2-d72e2ba23510@freebsd.org> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-TMN: [B/XVuQ3zdwbCXMEnm0kESJYUAKdjXUXM] X-ClientProxiedBy: TY1PR01CA0196.jpnprd01.prod.outlook.com (2603:1096:403::26) To PSAPR03MB5639.apcprd03.prod.outlook.com (2603:1096:301:66::13) X-Microsoft-Original-Message-ID: <92a569d4-b27a-79e8-3b70-aae476e52e0a@hotmail.com> List-Id: Porting software to FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-ports List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: bae635e4-2f4a-4916-bc2f-08da58bc2d55 X-MS-Exchange-SLBlob-MailProps: NS9Gj58uCj2Ea28GF7DF9szhF9vewUbtA/RKuSLa6Rp9Gf6nEnkV+iSo8Psw16u3ncU1iPvRGXlM3POKOrg0IBeUUqPb9JR+iunfUQ5TjDwTJkvAwc3sEemcwDk991HSJBBD/Eit10C/HCiVYnEqo2+d4R2jD8HZGF4yQNmKfKaJf84V9aSQms3VG2Jw30+HOouos7foPieJykdf0eo9xld/5mS7PFYhn3f/07v/EjdblbOyPCQJ8vWuPb9mtjVJ086GEpzJEKP27nhuPm41hN5jtFud2SugCpqdiLnk7fBX3YatqR4TFyNqxVDOlVjRXSIvZALzgaL8E4KVk/k4pAeAh/Ibln/6CZ2prW14dTzlPm0fyggHMwKD3ebED/jM1c2YMbMrERmx/14Umhs5TPurYHqAeHSjyLUDHakDm2dvRoKzkT9j8WhWHAaQOnv4L3NtX8zsSwvdUmxhiehLdA4hVEVwkaVowGNITUYOQRC/SK8kvjx4OSmyOt6iUDrQ7gzgLIHBAJP6V0fzlWay+gNN8ZN5o9oOugbzK5mke80XAbZKmDFpP+tQtB1ewrPadLTmGiGhinnsVU0ysydUYCtiymDMV/ZzhxUywvARxShmiLuelFU0BlnAoi9Qwouc4F/ALQzz8sdzLIztMx134Gwaug2aXPOQ8ut/ytVzeuLFLZQQqRXuFUROeRXj1AWm1yEHSy/Qt37UG2NNVXj1yQ== X-MS-TrafficTypeDiagnostic: SG2PR03MB4277:EE_ X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: UK04PWLZ+bVlQVCqcE3BivIdkVtk8awhHC7uPV+Tp8S7wS2hlvd9AZeZ5pZ0SV+kHO9YmKWpV+Uy4MzeRr3YvnhL3WNb4H6cPiYSDL5PiB5teZvTOzLB9Sb/nqBq3+jbP+jQAv9oKolKop2ZkOSGiB2xJDLq5Aez+ea2y9MFLNIUUUnR7TrtYuUsj0iblvSZOwPVKZnb07p91QCCRMU8dijJ73nUc59Fw/OmWIc1Zd7jQ4/MS6i3HFJtVVLWYFjMTtfS3O7goxyL5xq4dEYKILPz2DtnaRVlh6MR0iUNeduGfOGjB/VPLz2a+UCfP9aWWjJX9jzrl2yVH+ApF6qAMDwE6J/joDYEnOtyJj9hClb9dP/pckvRQEJbzwd+s6C5Jar95X5cPwTRT8bpLuapYo8QmP1B1CAhR5maltX0MkRnJWMVlR6zGO38EmRjR4gub4QpvCTXAg2yEzludU9DfFqLSPuiJsmUJU/NF9nE+RkDR/1wKwC/Ovv87Xob+7jZjTo7fRxL/GODhyDToH2L8tBoPuYSnFsuk42yhODizsNDzf4um626kcYNt9MEqVKpPq/AK39hykRION/cX/HnUbATqZGTjnh0Pud98IMfvrlYr3QdVgAN0Xpte/b2bqHd+4QESfxalIALIjJ/pZWtEA== X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?NUZqSHBnbXMxZVRnYkFPRFJSOGp2ZndPSU1Wakt3MWJ1aFUreDgyU0dJa0pz?= =?utf-8?B?YTNqV2VEdnBwZnpsT3QwT1JSdWV1TG1UNnpyb05rYVBLbkYvbE9DQlNzdEhS?= =?utf-8?B?c0pxRzZWVjNBMU1BM2xudTYvTndmWlhSajJNOWFhVys1RWhja015N3IvZHhj?= =?utf-8?B?ZEtyeUVQWFJKSkFUekVzM3RWZCsxTmF6akM0ZVBMR3RuczRWQ1hoT3NVVXIr?= =?utf-8?B?a1VaVGoxWVo1MmljMDNwRC9yVlZqSmZnT3o2Qm90NHlLMlEvY3FKNlpjRTE5?= =?utf-8?B?S2tMaUNVOVRkeG83VWNHSnlXS1JOV3pxa25VUjB3czdQTmZPTkxodWpkMjh5?= =?utf-8?B?Mjh6eE90MXZTWFVUUWF0TXh2S090WjR4RGhSZHdudCtnWUFOeE9PMW9NSGNm?= =?utf-8?B?V2U3WFJKVzFXVE00a0swODFFN0VQSDNMWW93aTdGYkNoNlc3cjZIK3NLVm8r?= =?utf-8?B?cXF6OFY4dTVUd1Z0aWFJTHd1MWlDNG84eE42bVpLT0gyY1hqOE5ZTmd4djZo?= =?utf-8?B?SGp4REZKR2VjdEJFc0NCUkpBcTNYSC9RT3F4VkM2Ynp1dldKdzJKenFrZXRU?= =?utf-8?B?N2E3VlpRL1BHQUFwWmZDd1FRRGxZRytZSENPM1JGdjhSK3Fta2JWL0tGQ0Iy?= =?utf-8?B?VjRUUzFDQkhtQnpHSm9JTlEwdlFqN3N1VXQvL0xyQlRkeWw3MVZBaGJUU0tk?= =?utf-8?B?c24zS205eXNzMzlOZm12c3lzWE9TYm9pK2RmWFFWTEwrOVNrWnozbGM0QmY1?= =?utf-8?B?SjBac280UEpoT1pmZHpYV1JENUw4bjI4Yy9BdVVSUjhIaUhtQ0tyV29mZEdt?= =?utf-8?B?MFhJQXNDOGR0V3l5S2p2OGhpWTlSbzUzMUJleGJnaUQyaHZJR2QzbVVpaEIz?= =?utf-8?B?QUlacTRIYWZqUjBkekpST3Y0N1J4bW9QYkE0Y1JkMXMvbjd1eVlha1hHc2pr?= =?utf-8?B?UldqNkp1SU9md1VVVkhFOXdBVU43d1p3QXExZXUxdEdhc3dHdG9xL2gwdVFK?= =?utf-8?B?WWtpT1BUai9MQ0U4aTZVdFpPZTRia2ZER1NVWXJaQkpFK2JhL0tMNEo5NTVz?= =?utf-8?B?WC9zSzZHM1FEVW9wUkFVRGxvb3BCRHFrZWRuaVFrVE9aaFJoTE1UZHZxbnVp?= =?utf-8?B?TFRyZ1ZjQldoalRHdWtpNE1KY3FEY1NrbWM5eDlNLzl1cVhIamRCejFqTmJK?= =?utf-8?B?UDNEaENnSm55R0xPaHpUb1Z1dm1jMGhFK1VEZFUrUmFveC90OWdxa1Y5eHI2?= =?utf-8?B?Zk5INkJZRGtEZ0kvY0lqVUFpK2lDQU5IOXIzRTF1QzlwT24rVm5Ya2hvSlBG?= =?utf-8?B?YnBOc1d2S3Y4N1FRRVRDOUpMMkN5bGxqVmZ0T3RjbWVvSFBWNU1KWGw2U0lt?= =?utf-8?B?MDhxcmtUVTNBZzRnTm1LV1lubHo0QzJsdmc3YkFtanpJVDlhMkZHUWd1cDJ2?= =?utf-8?B?WjhTVU40NTlTaUVhK21SekhNYWkzWVdKa1MxOTZaYjVWaGIzZ3F1cFBkWTBI?= =?utf-8?B?dTY3TWVYUUQ5NlRieGE5VFA4ekY0RkVtZjZRY3k2ald5RmhFN28vUkxIZHo5?= =?utf-8?B?Sm5tQWMyNEFoWERnWG9jT28zdTdGRWo1QVorbzZDWU5jaWpQQ3hPWjExVHVm?= =?utf-8?B?NjRmNFE2aTQ4Um4zQUpwTVZ0eXV0cFAwV2orcU5aRmtNN0F5N2FTcHVRanNJ?= =?utf-8?B?Z2E2dUhMdE90ZlhyL1JQY25aNE9EVFg4SDZ4RlE3NVhhcUpKZFFGL2dkS0Er?= =?utf-8?Q?0SGNFXta2VzU2HhhRY=3D?= X-OriginatorOrg: sct-15-20-4734-24-msonline-outlook-c0b75.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: bae635e4-2f4a-4916-bc2f-08da58bc2d55 X-MS-Exchange-CrossTenant-AuthSource: PSAPR03MB5639.apcprd03.prod.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 28 Jun 2022 04:10:47.1834 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: SG2PR03MB4277 X-Rspamd-Queue-Id: 4LXB3P3JYsz3kN8 X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=hotmail.com header.s=selector1 header.b=LxxFSSLi; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=hotmail.com; spf=pass (mx1.freebsd.org: domain of tatsuki_makino@hotmail.com designates 40.92.107.11 as permitted sender) smtp.mailfrom=tatsuki_makino@hotmail.com X-Spamd-Result: default: False [-2.27 / 15.00]; TO_DN_SOME(0.00)[]; FREEMAIL_FROM(0.00)[hotmail.com]; R_SPF_ALLOW(-0.20)[+ip4:40.92.0.0/15]; RCVD_COUNT_THREE(0.00)[3]; DKIM_TRACE(0.00)[hotmail.com:+]; DMARC_POLICY_ALLOW(-0.50)[hotmail.com,none]; NEURAL_HAM_SHORT(-1.00)[-1.000]; FREEMAIL_TO(0.00)[gmail.com,freebsd.org]; FROM_EQ_ENVFROM(0.00)[]; RCVD_TLS_LAST(0.00)[]; MIME_TRACE(0.00)[0:+]; ARC_ALLOW(-1.00)[microsoft.com:s=arcselector9901:i=1]; ASN(0.00)[asn:8075, ipnet:40.80.0.0/12, country:US]; FREEMAIL_ENVFROM(0.00)[hotmail.com]; DWL_DNSWL_NONE(0.00)[hotmail.com:dkim]; NEURAL_HAM_MEDIUM(-0.77)[-0.765]; FORGED_MUA_SEAMONKEY_MSGID_UNKNOWN(2.50)[]; R_DKIM_ALLOW(-0.20)[hotmail.com:s=selector1]; FROM_HAS_DN(0.00)[]; RCPT_COUNT_THREE(0.00)[3]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[text/plain]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[40.92.107.11:from]; MLMMJ_DEST(0.00)[freebsd-ports,freebsd-pkg]; RWL_MAILSPIKE_POSSIBLE(0.00)[40.92.107.11:from] X-ThisMailContainsUnwantedMimeParts: N Hello. Graham Perrin wrote on 2022/06/28 04:59: > 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 These are python ports with USE_PYTHON=allflavors (or installed with BUILD_ALL_PYTHON_FLAVORS defined). The error is that a port with the same name is already installed by the USES=python:3.9 port, so it cannot be duplicated. Can anyone provide a more detailed explanation from this cause? :) Regards.