From nobody Mon Nov 29 11:01:22 2021 X-Original-To: freebsd-current@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 86DBE18B66A8 for ; Mon, 29 Nov 2021 11:01:42 +0000 (UTC) (envelope-from dclarke@blastwave.org) Received: from mail.oetec.com (mail.oetec.com [108.160.241.186]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mail.oetec.com", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4J2j8j568fz3KR1 for ; Mon, 29 Nov 2021 11:01:41 +0000 (UTC) (envelope-from dclarke@blastwave.org) X-Spam-Status: No X-oetec-MailScanner-From: dclarke@blastwave.org X-oetec-MailScanner-SpamCheck: not spam, SpamAssassin (not cached, score=-3.099, required 6, autolearn=not spam, ALL_TRUSTED -1.00, BAYES_00 -1.90, DKIM_SIGNED 0.10, DKIM_VALID -0.10, DKIM_VALID_AU -0.10, DKIM_VALID_EF -0.10, URIBL_BLOCKED 0.00) X-oetec-MailScanner: Found to be clean X-oetec-MailScanner-ID: 1ATB1NHn011976 X-oetec-MailScanner-Information: Please contact oetec for more information Received: from [10.14.0.5] (static-198-54-132-56.cust.tzulo.com [198.54.132.56]) (authenticated bits=0) by mail.oetec.com (8.15.2/8.15.2/Debian-8) with ESMTPSA id 1ATB1NHn011976 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Mon, 29 Nov 2021 06:01:24 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=blastwave.org; s=default; t=1638183684; bh=zXeb2JzIpSqRWQ9evf4zepAsC8W0x2YTA4BFBLvMkkQ=; h=Date:To:From:Subject:From; b=h/CRcsqB1jaug3UYzb3rUwic7CAzTdt8lR9HOI/erG6WnoGWrHr9/2xKga/WlmcLP Gz2zNo6CKfCJklfNP9XL0Xuo/75dRRFcdffCch3ha/UceiuFYhdFOoYsPifI22dmPh clIASvj9gIaNZ/88qxhMzIg+6+dW/x3+lf+1DFUMBQTmavc4fVSKXlGm9BAWoWUiF5 M80oxcg/h9ssI3ws14lMlnUZeb/cTLEgOi27EcO6ETcjeoUpSN4wFd7x+V4PYeywYC PRgfeqOEQgW1GtF9ULnMy4OPU4hJTEwa81ZtKSYiCxoNOmDyhM4+eYqEJIQpTaSQ5i 5BL1yBNq4H7lw== Message-ID: <4d9d5406-c257-e5cb-d237-d26889468f62@blastwave.org> Date: Mon, 29 Nov 2021 06:01:22 -0500 List-Id: Discussions about the use of FreeBSD-current List-Archive: https://lists.freebsd.org/archives/freebsd-current List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-current@freebsd.org MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:95.0) Gecko/20100101 Thunderbird/95.0 To: FreeBSD Current Content-Language: en-US Subject: pkg sqlite database borked ( again ). How to restore? Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Rspamd-Queue-Id: 4J2j8j568fz3KR1 X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=blastwave.org header.s=default header.b="h/CRcsqB"; dmarc=pass (policy=quarantine) header.from=blastwave.org; spf=pass (mx1.freebsd.org: domain of dclarke@blastwave.org designates 108.160.241.186 as permitted sender) smtp.mailfrom=dclarke@blastwave.org X-Spamd-Result: default: False [-3.31 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; ARC_NA(0.00)[]; R_DKIM_ALLOW(-0.20)[blastwave.org:s=default]; MID_RHS_MATCH_FROM(0.00)[]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; R_SPF_ALLOW(-0.20)[+mx]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-current@freebsd.org]; RCVD_DKIM_ARC_DNSWL_MED(-0.50)[]; RCPT_COUNT_ONE(0.00)[1]; NEURAL_HAM_LONG(-0.98)[-0.978]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; TO_DN_ALL(0.00)[]; RCVD_IN_DNSWL_MED(-0.20)[108.160.241.186:from]; DKIM_TRACE(0.00)[blastwave.org:+]; DMARC_POLICY_ALLOW(-0.50)[blastwave.org,quarantine]; NEURAL_HAM_SHORT(-0.63)[-0.630]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; SUBJECT_ENDS_QUESTION(1.00)[]; ASN(0.00)[asn:812, ipnet:108.160.240.0/20, country:CA]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[] Reply-To: dclarke@blastwave.org From: Dennis Clarke via freebsd-current X-Original-From: Dennis Clarke X-ThisMailContainsUnwantedMimeParts: N I had another kernel panic on an AMD64 server. This has resulted in the pkg database being messed up. Also I was running a QEMU instance for aarch64 and that ended up with a messed up pkg database also. I saw some docs in section 4.4.8. Restoring the Package Database here: https://docs.freebsd.org/en/books/handbook/ports/#pkgng-intro However that does not work and issues a truely worthless error : europa# uname -apKU FreeBSD europa 14.0-CURRENT FreeBSD 14.0-CURRENT #6 main-n250839-be60d8f276f: Fri Nov 19 00:02:38 GMT 2021 root@europa:/usr/obj/usr/src/amd64.amd64/sys/GENERIC amd64 amd64 1400042 1400042 europa# europa# ls -lap /var/backups/pkg* -rw-r--r-- 1 root wheel 2714084 Nov 29 03:04 /var/backups/pkg.sql.xz -rw-r--r-- 1 root wheel 2714084 Nov 28 03:20 /var/backups/pkg.sql.xz.1 -rw-r--r-- 1 root wheel 2714084 Nov 27 03:03 /var/backups/pkg.sql.xz.2 -rw-r--r-- 1 root wheel 2714084 Nov 26 03:03 /var/backups/pkg.sql.xz.3 -rw-r--r-- 1 root wheel 2714084 Nov 25 03:29 /var/backups/pkg.sql.xz.4 -rw-r--r-- 1 root wheel 2712568 Nov 24 03:04 /var/backups/pkg.sql.xz.5 -rw-r--r-- 1 root wheel 2712568 Nov 23 03:03 /var/backups/pkg.sql.xz.6 -rw-r--r-- 1 root wheel 2711928 Nov 22 03:54 /var/backups/pkg.sql.xz.7 europa# So I took a backup from there that looked reasonable : europa# xz -dc /var/backups/pkg.sql.xz.3 > /var/db/pkg/local.sqlite.dump europa# europa# pkg backup -r /var/db/pkg/local.sqlite.dump Restoring database: Restoring: 100% pkg: sqlite error while executing backup step in file backup.c:98: not an error pkg: sqlite error -- (null) europa# echo $? 1 europa# I don't know what to make of that mess. Can I create a new blank sqlite3 database and then restore from that dump file or is there a method that works better? Also is there a blank sqlite3 database for pkg on the install media? -- Dennis Clarke RISC-V/SPARC/PPC/ARM/CISC UNIX and Linux spoken GreyBeard and suspenders optional