SQLite Forum

pragma integrity_check; Error: disk I/O error
Login
Hi,

while checking a places.sqlite Mozilla's bookmarks DB, I got 

pragma integrity_check;
Error: disk I/O error

that's on Windows 10 though [sqlite3 dll+tools SQLite 3.36.0 2021-06-18], whereas on (Debian, SQLite 3.16.2 2017-01-06) Linux the check yields just 'ok'.

then following hunchs from othe bugs citing I/O error, tried:

sqlite> vacuum;
sqlite> pragma integrity_check;
*** in database main ***
Page 35: unable to get the page. error code=266
Page 34: unable to get the page. error code=266
Page 1275 is never used
Page 1276 is never used
(many times more) ...
Error: disk I/O error

whereas on Linux same sequence yields just 'ok'. Then again

sqlite> vacuum;
Error: disk I/O error

retrying full check

sqlite> pragma integrity_check;
Error: disk I/O error

retrying by single table

sqlite> .tables
moz_anno_attributes    moz_historyvisits      moz_keywords
moz_annos              moz_hosts              moz_meta
moz_bookmarks          moz_inputhistory       moz_origins
moz_bookmarks_deleted  moz_items_annos        moz_places
sqlite> pragma integrity_check(moz_bookmarks);
ok
sqlite> pragma integrity_check(moz_places);
ok
sqlite> pragma integrity_check(moz_annos);
ok
sqlite> pragma integrity_check(moz_anno_attributes);
ok
sqlite> pragma integrity_check(moz_bookmarks_deleted);
ok
sqlite> pragma integrity_check(moz_historyvisits);
ok
sqlite> pragma integrity_check(moz_hosts);
ok
sqlite> pragma integrity_check(moz_items_annos);
ok
sqlite> pragma integrity_check(moz_origins);
ok

but all again fails

sqlite> pragma integrity_check;
Error: disk I/O error

the fs is NTFS, if that matters. Any cues?
thx