pkg info の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• pkg info へ行く。
• pkg info の差分を削除

#author("2022-05-14T08:24:02+09:00","default:kuji","kuji")
#author("2022-05-14T08:24:19+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified　&lastmod;
----
*pkg info [#ka68f769]
すると、
**pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1086: database disk image is malformed [#s7d9f1d2]

と言われる。

 20220513:
   AFFECTS: devel/nexus2-oss
   AUTHOR: michael.osipov@siemens.com
 Fetching vuln.xml.xz: 100%  947 KiB 323.4kB/s    00:03
 pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1086: database disk image is malformed
 curl-7.83.0 is vulnerable:
   curl -- Multiple vulnerabilities
   CVE: CVE-2022-30115
   CVE: CVE-2022-27782
   CVE: CVE-2022-27781
   CVE: CVE-2022-27780
   CVE: CVE-2022-27779
   CVE: CVE-2022-27778
   WWW: https://vuxml.FreeBSD.org/freebsd/11e36890-d28c-11ec-a06f-d4c9ef517024.html

portupgrade 中に、不意のシャットダウンが起こったためと推測。

＊修復
**修復 [#aa543e94]
https://forums.freebsd.org/threads/sqlite-error-during-update.74066/

 # sqlite3 /var/db/pkg/local.sqlite
 SQLite version 3.38.2 2022-03-26 13:51:10
 Enter ".help" for usage hints.
 sqlite> .selftest
 Missing SELFTEST table - default checks only
 1: Expected: [ok]
 1:      Got: [row 292123 missing from index sqlite_autoindex_files_1|row 292124 missing from index sqlite_autoindex_files_1|row 292125 missing from index sqlite_autoindex_files_1|row 292126 missing from index sqlite_autoindex_files_1|row 292127 missing from index sqlite_autoindex_files_1|row 292128 missing from index sqlite_autoindex_files_1|row 292129 missing from index sqlite_autoindex_files_1|row 292130 missing from index sqlite_autoindex_files_1|row 292131 missing from index sqlite_autoindex_files_1|row 292132 missing from index sqlite_autoindex_files_1|row 292133 missing from index sqlite_autoindex_files_1|row 292134 missing from index sqlite_autoindex_files_1|row 292135 missing from index sqlite_autoindex_files_1|row 292136 missing from index sqlite_autoindex_files_1|row 292137 missing from index sqlite_autoindex_files_1|wrong # of entries in index sqlite_autoindex_files_1|wrong # of entries in index pkg_digest_id|wrong # of entries in index packages_name|wrong # of entries in index packages_origin|wrong # of entries in index packages_unique|wrong # of entries in index pkg_annotation_package_id|wrong # of entries in index sqlite_autoindex_pkg_annotation_1]
 1 errors out of 1 tests
 sqlite> REINDEX;
 sqlite> .selftest
 Missing SELFTEST table - default checks only
 0 errors out of 1 tests
 sqlite> .quit



----
Total access &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);