From nobody Tue Aug 30 21:19:01 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 4MHKtr13JTz4bLng for ; Tue, 30 Aug 2022 21:19:16 +0000 (UTC) (envelope-from tatsuki_makino@hotmail.com) Received: from APC01-TYZ-obe.outbound.protection.outlook.com (mail-tyzapc01olkn2091.outbound.protection.outlook.com [40.92.107.91]) (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 4MHKtp6DPJz3ZYh for ; Tue, 30 Aug 2022 21:19:14 +0000 (UTC) (envelope-from tatsuki_makino@hotmail.com) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=gBjHUMVMTieb2WnN1iUx1GUHwt4p7QTKafmLf5sj3yeEdHx5/hXtiXC72pN0AdDDOUppHOwfy3CT3LHMLSymhqF4NMNd8lWbzKPRhHGT1BbK+7vl3byAIae8oVd470rECY0Omk7Va/aXhnv4zXXu7mWqFsU9M6B96SmbIqaxhc7xr70DWoHK7NpeZg50QaDCykt6MXqlAGHy849AzxvcPSzRC+gCg7oYZYSRjyqUUAhqPTZp21AeaxM6vPMiKTdCATRDoQSWxjOiaUhwpDDYc81hxJpMsVAFdrckCRDD3LcZbNmXGIE4zJY0qNfX0UdokCa1Mu2NVtrZNGlAZP1i5w== 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=Mfxi4K0jqgLCqSHjGh3+oHvrLI23ue5gBnBV7HIndCg=; b=VxaUrF1Hbqsf7ah3Du1NMgSy/O9MdbjS7TexQZ/e0wqCzMeIfoo1/gBEAKDng6lVlA0PxLCuqMAAlYHvI0Rw5OrL8ZV8+jysIccTNaKLl239pvwuuTTWKIsO8YQEvF303A5P8WktpqonyCjDa32KgwsEWEcxHeD6JJ/iaEg5s8GLZYSjXYe/U4p1Dl6Pv4EvFkXpMr51tudCFuJ1A4rJk705sJiE5ZJii4lUVRizlIH/01wbNYoihnv44mTB4BxqtGg1I4Wacx6mUNA5CdqH5+sqAXgQ0IgQhVYvVMwdaM6EsYihQd3I7wRpLVKcj5wj/ZKV1eW6jmfE11Lg4hW/dw== 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=Mfxi4K0jqgLCqSHjGh3+oHvrLI23ue5gBnBV7HIndCg=; b=ehloScg3yjXDqj1ys082QovDhIv6GfCACLqLWCBFpYkdTJP8pEnCYw9cLc/iH3oNKANE7afKiCkub2dHS4XuKqqUIpU+YfY6y25ZJg4gH0oeJy5mLJElrMbm4g0Aa9Pvn62jD7sElr7Lnr1eRrXjwMsFjylQrrE/MWcvH582iVci3WWYdQdODpJ+NORkE43hYJr+rnq9s8npBhq+ayFXr6nJhc+lwtO05OpQpQQUXlBBEJmkmJV/o0A9wczDK/HPXYInD/ae4tqa+aPGHVsRg5BrPtTWJLMVc+UxyNlGeZ4PtBIUBFdzgwFTGhyc+rIWUMQEiITFrJ1X/cl5zPlxUA== 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:19:10 +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:19:10 +0000 Subject: Re: Recover from a corrupt pkg DB To: Kevin Oberman , FreeBSD Ports ML References: From: Tatsuki Makino Message-ID: Date: Wed, 31 Aug 2022 06:19:01 +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: [hvkZpezbnmMaYilqY+WBxhBidP7VN9pD] X-ClientProxiedBy: TYCP286CA0065.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:31a::6) To PSAPR03MB5639.apcprd03.prod.outlook.com (2603:1096:301:66::13) X-Microsoft-Original-Message-ID: <8995778b-2722-5ce6-4e34-8be62d07f102@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: 52f24c6a-9919-4ddc-b146-08da8acd478a X-MS-Exchange-SLBlob-MailProps: pLz3uIP/38lbZvHBDcm5bjJ41Prj1yC3N2TGo025uKnVu8R7EuhqKDQ2+8HSypuTwXO+8jxWIFsYCSTSOjNrNLNVJKJey+L/0uUV9Fn+fAomnELt/C3mxPRIjtZslAHV2nZ5UWbodggMQRlN6QVFxft7EEyBHVQ0bVdiat+4sEXSv1Ifq0a+3XpRzQW2enTfZndwbp/gNm2JagD7DZ+r7C1KOow+PGP9JnztyS/BtZZu+0TYRazh/BNM2X8qYAcNmscxR8bkKjE5XU1vxvBI06ua2obAudr2W9DTKQuEgn3ZkCqN0C3RIW07elKUtx+pq2PcRc5bVzOMxqqjlLc2PcE2aCNeMvX2MMfOyAQCF2kDRSeRLC+KtA8f9y7q5nCWOI3Q4S+FCTZEhLV6Lb0PlYla+AlFplGK2BLkGH0N/cFQi/TlP8CJlS/p6l2qK50TU1sm0SCio/rzFTGyhjdHWC4BqrRe0GfeL/BBvFW+jJX/QXZTP0w/Ohx8dh+q8R7GYSeUPf0MJmODYOYqk+Jpkq5XyDruslEIAfl5Htj3WsqlCSC9KRFInvwCigAf4qd8HokjCR1IPn+1PCshlzhzJBvMNMd4HOGyPv4AdbTeZzLxRUN9PmufsIFg3+Z91QRwEMDDggjXEczehcZPx8qnQg== X-MS-TrafficTypeDiagnostic: SG2PR03MB3641:EE_ X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: Wmq6imKmbH4HKb24IxwKq7drEpdwJGFoHIsKi+V1Ws3Vuvx3UDRo67t6BzdSirn5A8iFt5CTi/kXbXggYFd/nXmyXAGiq58OB6hHl5ik/wW/jAyAI/GlChKIlRk19K1C2YaB4R91ODBKbxBptui5v7qcm75pWhPHjh10kNjbbt3pYc6nt8vwO7m4mNbqERp2QoobmB7TkbZ7s3Yr94EroFWSvvjYeTohEm9sk1dPlKP0wLD39hPFAXE76bAS5apDfihvXwQlO4nkuWshXuS/RegRRO2MToBCvOjDq88ts1qvh7jgCK+/XoMMTtlZiWuyUyHYXK/4kOQGDheHt1W3xDsRWTs+m9yA35Hapn947pWd/Q965MVZ0XJXFTz6bcSNkogKbXIswm8ndErkfYx8LugtgrCEsLqvIQ/wQzg8n8NAoX/EeQ79Ilh6gRHoVtGdOpYpvfy9p0K9gUx/SBZulgYI1e/39zW1IxZ06GEhsegGNe66BU5ZCg/jdMc7FAaQqrizxjKM63zJS4ukHZiq7dGhtMdaz13lmfMpQTG3rwW+IEwxg5pWcFXGDfwGbayUVGRPb3B69q5iEhYs9GIwORq9tZtblIqH2gXa6XfnlmsbNbpbJIOTasCJTVyHwdN6mUaYWEmPkLk2lXqensNkBBbGeeL+llIDrWCmFFBIJgfuvo+5hBwZjK04CJ/uVUOh X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?blk3ZVREQVZWMWdEQW14d3huK0p3ZFJsY21qblRLM3hXaEh5SFZxUXhMUWlN?= =?utf-8?B?ZzJpOWV3YzhLNTl5YWU4TjhDc0dZR3JLQ3kwK0hqSDg1dWZLazlqejBsZi8x?= =?utf-8?B?UW1qR1BXcmliNWNRZWFxL3RVdFd1WHdQNkNkR2V6eU84Mk9lOVJSUlcvWi9z?= =?utf-8?B?d0o3VEJJSkNjSHN0NVpBQnhMbGt4QXZpZWxBbVN1Ykt6UmZoQzh2ZWd3c25t?= =?utf-8?B?cEdiY1IzSHAwUDBrelF3Mm8vRHgrdzZPVjl6dGZkZEFYa2hEeGZhUEdnd0dW?= =?utf-8?B?NFJxRDJWVUZuQ3Z6S0UvajlGRjZuYzNKTGk3TlhGS01Qa3U3cjhYdDJ1bTdD?= =?utf-8?B?eGhOSXRVM1lXNDk4aGJSbFkrUUxQSFNkMnN6SGdHSWNVblhPOW5VK0Z1Y2Vw?= =?utf-8?B?bnBZT2lDVlI3QTBKVTlIL1RaVUZud3BGSHhNSzRGbXZ1aThGdVFwMnUyaWNi?= =?utf-8?B?enh1L20zdk93ZGFDdFMwd0Y2akRzbm9aa0NtUGNCL1FVN01hZlBLV0VUeHRP?= =?utf-8?B?TEZVQjFnSlNKaS95R2k3aWpIUFZKT0ZzQXk1NlFub2x2Mms2TVdDWURUWGNQ?= =?utf-8?B?SVQwcjZuSjhUd2wzQnRDQTI4c3QyRXArcFc5REt6UE9uZzNTZ1FXYlBiNzRv?= =?utf-8?B?b0kxSFhKYWlHWUcrbTdBOVU0ZDdMMWppb1hwQVk0c0xlTlNaL2FrY2FCcXF3?= =?utf-8?B?V0haL2pCSUhweWVZaDZENko5NXlYeUxCY1VqZEEvNldYUGVtbC92Njg3UDNK?= =?utf-8?B?YTZBaTNPVGhOZkUwTWlpM25YbENNVDltcHppU09IQkphRW1tcUlmQno5MWps?= =?utf-8?B?czY4QU5BbXJyckVVU2R0Vkxkc2RSUWZRNDNNaTRnNlZrMmZKV3F5YXdCNUZQ?= =?utf-8?B?YW5tMlNZSUx1MytycElEWmNtWjlWRVBHWGVjODRUQ0VubkdnVFE0aXpuRzRG?= =?utf-8?B?cHl5OTdQMHJDdk9qS041elpueHJteWdiSkptNnNvK2N4OVBCRFVhSUl2a042?= =?utf-8?B?QTI1VjVmZVBOaXErVGhYQy91QTRFbXdPRnVqVlFjTjQwNHorSmJ5TnFWaTk0?= =?utf-8?B?VmJTTTJ4Um1rVXlSRjl0TFJYU1c0b01NZWc4MEx6anV1MXRtTGZNYkRaOXpU?= =?utf-8?B?NVBQVEw0YWdGUU1uNkhzSnNkOWg1OUUvOTAzdjJwakhGZDFxcjNIUi9CQ2ZJ?= =?utf-8?B?SVBsc2Rud2ExOGNDV0pTRW02TlVBMzhiSG0vbUwxQitIR2Zmek4vaFJvWGw1?= =?utf-8?B?dUl4QU1qNGRQakNtK0NjbjlXdUN0QW1pU3p1ZjkrblZVaUQ5M2hSYjllVXRu?= =?utf-8?B?R0NOSkk2SG5TeVR1c0k0OUhFb1JsMjUxSnpWWjN1NGlmc2dvc2ZVVmtvbUtS?= =?utf-8?B?N0d1SE5xYlFRRmpiK054YkJad1VXMnVxd0o2SWVaeWdzSlBSZ0dOR1V5MzFN?= =?utf-8?B?Z1o5S0ZzdGt1ZUdqMmE2dDV1OTdHUG5RbVo5U3RZUm5LZUVzZ1l6citld1dm?= =?utf-8?B?eWlUUFppRUVvdklnNTFxUzBKNVMycmhkQk9GOWdOelNheHdIbHhmK3dqSUkz?= =?utf-8?B?UjZSdDlXa0hoaytxdXo2SWFZUFVTR3didExHUU1sV1BFeUc4aGFMYnNDVTdm?= =?utf-8?B?VWZsNHk0SVorejFvZ1FSRWZDdEVweTRYdXkwNmpjSENuYTZNTGZ0VFdRSDcr?= =?utf-8?B?cWViOU15VFc2dEppRHd2UnNKOE40RjJCc3pKOEdaMVVXMlhJUVFCTXZWRTI1?= =?utf-8?Q?Y3IxQjRMTZMg7wiDpg=3D?= X-OriginatorOrg: sct-15-20-4734-24-msonline-outlook-c0b75.templateTenant X-MS-Exchange-CrossTenant-Network-Message-Id: 52f24c6a-9919-4ddc-b146-08da8acd478a 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:19:10.3621 (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: 4MHKtp6DPJz3ZYh X-Spamd-Bar: - Authentication-Results: mx1.freebsd.org; dkim=pass header.d=hotmail.com header.s=selector1 header.b=ehloScg3; 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.91 as permitted sender) smtp.mailfrom=tatsuki_makino@hotmail.com X-Spamd-Result: default: False [-1.82 / 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.96)[-0.962]; DMARC_POLICY_ALLOW(-0.50)[hotmail.com,none]; NEURAL_HAM_MEDIUM(-0.37)[-0.372]; R_SPF_ALLOW(-0.20)[+ip4:40.92.0.0/15]; R_DKIM_ALLOW(-0.20)[hotmail.com:s=selector1]; MIME_GOOD(-0.10)[text/plain]; MLMMJ_DEST(0.00)[freebsd-ports@freebsd.org]; FREEMAIL_ENVFROM(0.00)[hotmail.com]; FREEMAIL_TO(0.00)[gmail.com,freebsd.org]; MIME_TRACE(0.00)[0:+]; FROM_EQ_ENVFROM(0.00)[]; ASN(0.00)[asn:8075, ipnet:40.80.0.0/12, country:US]; DKIM_TRACE(0.00)[hotmail.com:+]; RCPT_COUNT_TWO(0.00)[2]; FREEMAIL_FROM(0.00)[hotmail.com]; FROM_HAS_DN(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[40.92.107.91:from]; RCVD_COUNT_THREE(0.00)[3]; TO_DN_ALL(0.00)[]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_TLS_LAST(0.00)[]; DWL_DNSWL_NONE(0.00)[hotmail.com:dkim] X-ThisMailContainsUnwantedMimeParts: N 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.