From nobody Tue Aug 30 21:23:47 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 4MHL0B5Mg7z4bMLT for ; Tue, 30 Aug 2022 21:23:54 +0000 (UTC) (envelope-from tatsuki_makino@hotmail.com) Received: from APC01-TYZ-obe.outbound.protection.outlook.com (mail-tyzapc01olkn2035.outbound.protection.outlook.com [40.92.107.35]) (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 4MHL095qTqz3bH0 for ; Tue, 30 Aug 2022 21:23:53 +0000 (UTC) (envelope-from tatsuki_makino@hotmail.com) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=A3VoIBAFY2VlA9Z/9Sio2aFmA4G8RiQwgN8i7eVhGcV+fmA96zSM2+nfFbVk7ww6YWRG6Ssk3TxDhcP30Wobb+Sfb5gqZnB3snq5iO2+2lpOgWAIei7Evst+mX06+2MPcjMIcYiZaDRDaYorziD3CTglXh8+yx3i0TSLFDFMR/zEEoO9jB+Ma8qOdtquGF1VB3yidpxnbZdd/3AARyzuAGvKd4aW09RaqvgoVTwUkYoZNebY6k+pfzoDYFKkdM5wuReEfT9kSYAgFxJ6daW/Ynfv4S/McEwKff8Uu5jDj6yyk1t//UO7dvQuhnQpIfkytZM130adYcpJRqDkga7xpA== 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=JaFHnTgAyLRI49OmxqHi3XQOMSmi1qo3ba/8Kmq+ESs=; b=RUPJPX+RUF7ycmC2RtR7yCukQb04lPunm3EU6OPw5O3OEHvtHAvq+Xn4465z/ZEvDROsE2Ol0hwmeotBb39TJajKVlGK5rqS7aSNKcF73//PFc5KPIS7rYXpzICEJIhaSzvnqS6mVZhSwZgxbB7A6TA4BCFEgjsbjWD0tPteEUP2QAFiO6HffQsoq1qIcHlbIQtu2sX2itBYjmxTjG/w+DKvh8YpdtD3z9RBT/c7JM7Su8mare0OvVIOHTT+VVUsoWUmxFRYZIveoTjXs6UcYIC2EnoL78udPhs/mvt4ZZO1S3/reHnISeW+JeEuHWN1pg51Hij/KsF02hC0bo9IpA== 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=JaFHnTgAyLRI49OmxqHi3XQOMSmi1qo3ba/8Kmq+ESs=; b=XsLaOaFqhuzpXjuQSTG3w090rLT+tYcayZOY3njx8f5nI0Z/s60TsC1tKM71RmEZRdrHxGFeE8klDitzSvjrk7pgsofQqVpjbUAbEyiV7kUoM379A/IjCflcCc0nEEZAMHKaEJO46qrQozGMpudDfjKiUUvEoF9gCNJGKFbn0X6Mrvni03Ey3cW7tKA82qqpnIYpUpP/sBoklmLUi2uXJMLkvj16PNJ92qMeVWiliOUabQI7Eaq4VzHoZMYXQB2twoTyjWuKKX8hR3rGnylcIyiUKY1ejP+tY0rdI0aat3x00fWHIOPbBq0izoTu1ndCmKryxiFudhqC+TgjaknU6A== Received: from PSAPR03MB5639.apcprd03.prod.outlook.com (2603:1096:301:66::13) by SG2PR03MB3641.apcprd03.prod.outlook.com (2603:1096:4:23::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5588.10; Tue, 30 Aug 2022 21:23:50 +0000 Received: from PSAPR03MB5639.apcprd03.prod.outlook.com ([fe80::c13f:74fe:11e1:125e]) by PSAPR03MB5639.apcprd03.prod.outlook.com ([fe80::c13f:74fe:11e1:125e%5]) with mapi id 15.20.5588.010; Tue, 30 Aug 2022 21:23:50 +0000 Subject: Re: Recover from a corrupt pkg DB From: Tatsuki Makino To: Kevin Oberman , FreeBSD Ports ML References: Message-ID: Date: Wed, 31 Aug 2022 06:23:47 +0900 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101 Firefox/52.0 SeaMonkey/2.49.4 In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-TMN: [BucdWwKR9AxGDOFQZqERlLfWiIXIehov] X-ClientProxiedBy: TYBP286CA0028.JPNP286.PROD.OUTLOOK.COM (2603:1096:404:10a::16) To PSAPR03MB5639.apcprd03.prod.outlook.com (2603:1096:301:66::13) X-Microsoft-Original-Message-ID: <2bcc829f-bb34-5dcf-cdc8-195ada33e896@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: ec0baee4-ef30-48e4-4c16-08da8acdee4b X-MS-Exchange-SLBlob-MailProps: ypbm7dJ8ggT02JvwaWN0Sd7T+l+ASN93pvxzEBfGkFZgME8HcgFfAKkKATI8UTjTr5V5i6f+f0SCnfT+ovxsX34nckitP+4wad2rbEsgFyJkhGfq7bnD0ZyuJ1Kohsgvit+xE1a1vu8MjAlHHq9ud9eR4VQ4KPGzxxcaol5eosSGYdPKPPC9u720NTfmEr6jKU10Alsk42ozINZ504mqIRwNI9qytapppN9JgioDOR7kOVDuHxYlv3m4yo1tFCjEafInqb7eqNsvm4Dv1Z3lm2nq2p0qky/M4puycXFC1jKshTz0XEVKK2bYYXSujhxpRXSO87NqpiO9d7RvpX/+VcSI5G+aPEphlH+5ONKKWkH9PwH25PO56LPMnVSXoI1j8abMSDebFpvwMTiz4SR3OGnJEvgA20U59o3B7jE1JpZBju6JY1yc1kkiTAttSqGl583BPcay9FVQq+/rYIy5cJldqVDoaRjcnNsA92F6QbrWkts08r1Kiak8DYpO7S2TeT4wlM2+EJl9WEsfXe8ocjp78VP/Stf7XI6K3H/s4VexBcPpEW09chrlB96QRajT9qrpoy9pBcWv5OnvoUxkaPEAnAx9YjZgvo86fAhdhCc+Nue0iUYYPfuEVoKmXdpWSRacfTKsfmEGjwZM5hfup2Jz29zpF04qdCd4VwTNhHc= X-MS-TrafficTypeDiagnostic: SG2PR03MB3641:EE_ X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: lVs6AEhkAGA7XjbMLPT7TWdZQlbyW5sH8XMoYU21HlQKhLbkVZBkx+ziY2HGlmyOxDhl7ZZZ0urqTInkqw9SvP7Oa8I0bAUcpPLrI4hMZXxMDXyXiQSsgEwIPXy6gaan/aRYY2pDMUcI5WQRtHeTOUkb5MZxK5J1UEN/M98c2950DD65MlBoekmx5HwBitLlAPmQQpBo4rJlQVucNvMRIU+I1Nsr52yTJgp3Tisa8534TNSiStxgvqZRy8OPUZ0OAHH25Wtf5eNbcbKFinQLBNNFZfF9aTQuzbUroCd+dYaY8G/8SD6t25ps/yd4OHS9AN6VBUZAdWoqVKQCCwO5CtKxk9k12HiflhY+4lPf8quGufMoc5fqh5kqRHqwTgCO+uiBAGD0RdRLVAuifkFx5z14MKm00p+gAJLjmCKA6FoHnkc7c1IOYKYm6J7QzonaaGxQm85WxEOCpFdWhXM2qBbkbV8BGzegadVGOBjNs2Ecy6Sa4Kc8LLSiL44gePKnKLbgV0kSaNIzeShT0p1eBDnn0z2l8S57j/CFNy83GgiymgmjoOysMq7JdK53P4WYG7lNWHqfTG9tUH/YkdnaLwGpbvrfC/UR/zC9Ysq0ISPFUN13flk5LXpPDk6gmcrO64jDkSDQ1qwGmyKeB1K5H1DajL9W6Meibf4qHDZTrny+eMWp8hiQlTrmQj1D5hJX X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?KysrdkJCcjBXMzZSSGNyTzZvazNZWHQvU09hU3ZDN1YxblVDbWNYVDQ0Yjhp?= =?utf-8?B?Q24wTWdENGdHKzB4cE12ZWhtTnR2c0syVnJXWDJPcTFtbUwzVkJXNzlmdysv?= =?utf-8?B?MDZYV0RhVmRnNnEvUzVMaklYczF2Y2NMZ0JuNDQrZlNpeFlPWUhyR1piWGd1?= =?utf-8?B?dHhFNTJWdmMzZjZSKy80cFdHV2habWs2dXJSSi9RbmtrMU02RE9oMVBrb1Z6?= =?utf-8?B?VHVtQVRxcURlcUVBSmEwSlVsT2tZOHJNVXUrajFTT2x5VlU3WVJMQUoxRi9T?= =?utf-8?B?RnpJK1pWTDUreDE5NlZUaDJremFpbC96YkF2ZU51ZVZOUWp3em04VDYyZXI5?= =?utf-8?B?QStDMEV3NFR6NVRmV29GckZqK2J4R2NWYWdZcmVGdzB3dmZzMDR5ekZCb1FL?= =?utf-8?B?amVobElGS2F1b1d5RnlSd1hKdHVvc2FBait0M2FqOWNjS2VMRVlDWTROdmRV?= =?utf-8?B?aThBVm9wcmJjL3g2MlZIeW1ENFBJSncvOFg0eHBlYjhOZ0ZJZSs5TENVU2dv?= =?utf-8?B?WVVhcm5NSlpFTk1KOVNGeGNPS2phZWJjdUpvSWdvbjRoMkRrVUhoQ0dEbDdU?= =?utf-8?B?VkFhOGRKM1NTNWpNS3p4Q25GRGNwaDRwQ3RzUWpka0RtR1RDbEdIbXZzY2JI?= =?utf-8?B?cmU0dVE2eklKelpRY1BxbmZTOGlIbmt2MHhzbTREc3RqdUZ6RUt6dHpJSEVz?= =?utf-8?B?c2N5TFhUemwwMHo1d09yN25RQ2NsTGVjNmlMM2FhaHd2NzhGaFJ2TE9nTCtJ?= =?utf-8?B?ZFNjTzgzb2Q1VDNsNFh1NEdzUEM2czljc3ovSjY0cnJnbmt1SldZK0VvZkZy?= =?utf-8?B?M2ZaL0NyM1EyeCs1b3ZLM2hMTDhReEpYOHY5SUFKbnMwejhiamlIcWoxWlc5?= =?utf-8?B?QkFQNGNNalRHSDZqenRHY1I0TlMzWkx2Y2NHRnJ0ZHFYMTJVbkM1TzQzdVFx?= =?utf-8?B?WUtUWTJNYnRNVTc0Rkx2bG95dWhaVEdKcjFtN1VOU0o0TGV5NVVudzNia05V?= =?utf-8?B?TXVHSG5WYXR1QTdCV1VJOXB0Z2xCQ3ozNytNekJIaS91VXdqdUJON1JVOUdh?= =?utf-8?B?eWFEUHBtamFlcmloWU1MN3lUTXIrbXljL3dOZTlESWNYSlJyZzBhQVdXY05Z?= =?utf-8?B?bEF3ZUlOSW9yWlBnWXJLMUlONXBWS2EvOFU3Z0tPa2I0cWh3akdWZitEaWZq?= =?utf-8?B?TVBmMUsrak50cXZVRE1xRllBUVY3UWlMZ2I3MEs1YVpTbjRmTU5GdmdKeitl?= =?utf-8?B?NDFTTFNwWEM5ZFZ2aEFBTXdhVjFPZ2dHZ1FxWXhyMFFxczRtM3o4TllZaUNK?= =?utf-8?B?Sy8vT3kzV3hia08yK3VxUEowSmZqLzM1bDBVOC81SFh6SUdUK1h5QUNmaHRE?= =?utf-8?B?SEJ1Vlo4VFBXYktEYUR4ZmQxVWx2dXhrYmRpM0FWcU1CUDYrOEJOZUJTZVpi?= =?utf-8?B?aUMvam95SHBFWkJsTFNLWnIzam5VeUtGcldSenR2cHdmWUEzUDRkYmI4RFoy?= =?utf-8?B?U2dYQzE3L09hdy9pVmlnR0V2UVRxN3B4aElhU0RxZFhBREFYMUJwSWdiTXQx?= =?utf-8?B?SUJwd0tFV2NsdHVvSTN3Zk1STW1LSFVxblE3Mm9uaVhmWFdWTGhxS3JTVURz?= =?utf-8?B?UWNVWVZLTTJxOXlaRzhNNis1YkVhTWg2Z3l0OFoycm02NHc4RVlyMElscmM2?= =?utf-8?B?aGRDRU5uM284MytsODRENnNwQ256cUpyQVJ3VUc1OWd3T1oyL2FxYnVLcSsz?= =?utf-8?Q?TzVN0ax1yCC8E4UM4c=3D?= X-OriginatorOrg: sct-15-20-4734-24-msonline-outlook-c0b75.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: ec0baee4-ef30-48e4-4c16-08da8acdee4b X-MS-Exchange-CrossTenant-AuthSource: PSAPR03MB5639.apcprd03.prod.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 30 Aug 2022 21:23:49.9388 (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: SG2PR03MB3641 X-Rspamd-Queue-Id: 4MHL095qTqz3bH0 X-Spamd-Bar: - Authentication-Results: mx1.freebsd.org; dkim=pass header.d=hotmail.com header.s=selector1 header.b=XsLaOaFq; 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.35 as permitted sender) smtp.mailfrom=tatsuki_makino@hotmail.com X-Spamd-Result: default: False [-1.83 / 15.00]; FORGED_MUA_SEAMONKEY_MSGID_UNKNOWN(2.50)[]; ARC_ALLOW(-1.00)[microsoft.com:s=arcselector9901:i=1]; NEURAL_HAM_SHORT(-0.99)[-0.985]; NEURAL_HAM_LONG(-0.97)[-0.965]; DMARC_POLICY_ALLOW(-0.50)[hotmail.com,none]; NEURAL_HAM_MEDIUM(-0.38)[-0.381]; R_SPF_ALLOW(-0.20)[+ip4:40.92.0.0/15:c]; R_DKIM_ALLOW(-0.20)[hotmail.com:s=selector1]; MIME_GOOD(-0.10)[text/plain]; FREEMAIL_TO(0.00)[gmail.com,freebsd.org]; MLMMJ_DEST(0.00)[freebsd-ports@freebsd.org]; FROM_EQ_ENVFROM(0.00)[]; RCVD_TLS_LAST(0.00)[]; FREEMAIL_ENVFROM(0.00)[hotmail.com]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:8075, ipnet:40.80.0.0/12, country:US]; RCVD_IN_DNSWL_NONE(0.00)[40.92.107.35:from]; TO_DN_ALL(0.00)[]; DKIM_TRACE(0.00)[hotmail.com:+]; FROM_HAS_DN(0.00)[]; RCPT_COUNT_TWO(0.00)[2]; FREEMAIL_FROM(0.00)[hotmail.com]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_COUNT_THREE(0.00)[3]; DWL_DNSWL_NONE(0.00)[hotmail.com:dkim] X-ThisMailContainsUnwantedMimeParts: N Addition. Ports that need to be reinstalled can usually be found in pkg check -sna. Tatsuki Makino wrote on 2022/08/31 06:19: > Hello. > > I also just recently unlinked /var/db/pkg/local.sqlite to a place where it cannot be traced from the /var file system :) > To recover from that, there should already be a backup that others have mentioned, in which case the following command is all that is needed to restore it. > > xzcat /var/backups/pkg.sql.xz | pkg shell > > Now all that is left is to re-install the port that was installed after that backup was made, and you will most likely be back to normal. > After the backup is made, if the port tree is updated and there are any plist changes, no :) > > Regards. >