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 505:本日 1:昨日 0

Counter: 505, today: 1, yesterday: 0

トップ   編集 凍結 差分 履歴 添付 複製 名前変更 リロード   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2022-05-14 (土) 08:24:19