From nobody Sat Feb 25 14:29:14 2023 X-Original-To: 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 4PP8K650Wlz3tDWS for ; Sat, 25 Feb 2023 14:29:14 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (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 "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4PP8K63KGwz4dFY for ; Sat, 25 Feb 2023 14:29:14 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1677335354; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=UVL0/3U5Qd31/bBiWC9FQsf6NQ7efucALxmb+JgxBkE=; b=Mt352ylDN3J74hg5qCmaW5JzyGxQBQ6TuFvNnwcTecI8iMXWw0z4P6QOiZLrH1QrM9Lg7z QDtZE8VZPzCCofraCS6scCR0S1Xy150lwZav+YIIIGlqezBWL/GnmX9U2TTZU01XC9uP0o D8YICHf5X2GbigPyRrH+8D4Z9niT25Rm0TnpCmEQeY1dMtsJl0mrF5Phj1wBOB345bXuGn VcyCgBtvCk3FU+L25EZ8J35o9m3mBfY6E6ra/ZiW5oa6CrijuXuVFdBcq9lBHzctt5xkTC 7OWf0+37hTR/UFk4F3xAvIbnJYEjRTAviSfeJMwWs3EVAf+EHemr7u21oLgqLw== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1677335354; a=rsa-sha256; cv=none; b=akoy4v+bBw7Y8pTOExoaIAZlt8XNg661gmH/5GcRPgaKpT1K+PFIkZF4X/gPi7JkXWouf+ Gl5dJbZrcgu76Ix+OrqnL8XDZnY7p4BgeaVYOPSwXI47kqye+ofkC1T9PCnn417sAdkGMB Ci/3ia318C2jUpI5IkH5x8q649pkILe4tNF1dZ09EtikzknoOEAhwc7wLwPuiRHU7JsPjG 8nkEKvd0OLbCotxSXGJfiHcp9Uxmlure8AnBAPu6uV9T3fqNVx823ktNVlO9bE5jboFOWX UhuWQDR/Jvesf4Tqr74oMvvz1Bv/i68byca8ZmFicqKXgNUtxOl0TvYH6OKnzg== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (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 did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4PP8K62JClz16df for ; Sat, 25 Feb 2023 14:29:14 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 31PETEl3044633 for ; Sat, 25 Feb 2023 14:29:14 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 31PETEQL044632 for pkg@FreeBSD.org; Sat, 25 Feb 2023 14:29:14 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: [Bug 269810] ports-mgmt/pkg: how to restore pkg database Date: Sat, 25 Feb 2023 14:29:14 +0000 X-Bugzilla-Reason: CC X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: mfv@bway.net X-Bugzilla-Status: In Progress X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: grahamperrin@freebsd.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated 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 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D269810 --- Comment #2 from mfv@bway.net --- Hello Graham, Thanks for the quick response. I tried: 'xzcat /var/backups/pkg.sql.xz | p= kg shell' but ended up with the exact same result. Here is a directory listing of /var/db/pkg: -rw-r--r-- 1 root wheel 158 2023.Feb.16 19:56:30 FreeBSD.meta -rw-r--r-- 1 root wheel 58,900,480 2023.Feb.25 08:53:06 local.sqlite -rw-r--r-- 1 root wheel 63,741,952 2023.Feb.23 13:13:34 local.sqlite.= one -rw-r--r-- 1 root wheel 54,980,608 2023.Feb.16 19:56:30=20 repo-FreeBSD.sqlite -rw-r--r-- 1 root wheel 0 2023.Feb.18 09:46:13=20 repo-FreeBSD.sqlite-journal -r--r--r-- 1 root wheel 7,449,709 2023.Feb.25 07:51:28 vuln.xml -r--r--r-- 1 root wheel 6,316,391 2020.Aug.25 16:53:50 vuln.xml.org local.sqlite.one is the original file and local.sqlite was created by the x= zcat command. There original file is 4,841,472 bytes larger than the file creat= ed by '/usr/local/etc/periodic/daily/411.pkg-backup'. Let me know if I should send additionl data/information. Cheers ... Marek --=20 You are receiving this mail because: You are on the CC list for the bug.=