pkg info の履歴(No.1)

• 履歴一覧
• 差分 を表示
• 現在との差分 を表示
• ソース を表示
• pkg info へ行く。
  • 1 (2022-05-14 (土) 08:24:02)

CONTENTS

Lastmodified　2022-05-14 (土) 08:24:19

pkg info†

すると、

pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1086: database disk image is malformed†

と言われる。

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 中に、不意のシャットダウンが起こったためと推測。

＊修復 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 628：本日 1：昨日 0