SQLite Forum

pragma integrity_check; Error: disk I/O error
Login
nope, plain local filesystem.
Funny, quitted then reloaded the DB checked as per original post: last integrity_check got I/O error, now instead (started with -stats):

sqlite> pragma integrity_check;
ok
Memory Used:                         2245720 (max 2278664) bytes
Number of Outstanding Allocations:   690 (max 708)
Number of Pcache Overflow Bytes:     1386928 (max 1419696) bytes
Largest Allocation:                  658560 bytes
Largest Pcache Allocation:           32928 bytes
Lookaside Slots Used:                123 (max 123)
Successful lookaside attempts:       212
Lookaside failures due to size:      1
Lookaside failures due to OOM:       233
Pager Heap Usage:                    2050152 bytes
Page cache hits:                     977275
Page cache misses:                   139191
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   12024 bytes
Statement Heap/Lookaside Usage:      77840 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               6075238
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        77840

got 'ok' yet I/O error was expected, since nothing (in the DB) should have changed between quit/reload.
then re-tried with original copy of the DB, and got error again:

sqlite> pragma integrity_check;
Memory Used:                         2282200 (max 2291816) bytes
Number of Outstanding Allocations:   1119 (max 1129)
Number of Pcache Overflow Bytes:     1995760 (max 2004112) bytes
Largest Allocation:                  85120 bytes
Largest Pcache Allocation:           4256 bytes
Lookaside Slots Used:                123 (max 123)
Successful lookaside attempts:       212
Lookaside failures due to size:      1
Lookaside failures due to OOM:       227
Pager Heap Usage:                    2080408 bytes
Page cache hits:                     460749
Page cache misses:                   63695
Page cache writes:                   0
Page cache spills:                   0
Schema Heap Usage:                   12024 bytes
Statement Heap/Lookaside Usage:      77840 bytes
Fullscan Steps:                      0
Sort Operations:                     0
Autoindex Inserts:                   0
Virtual Machine Steps:               1881471
Reprepare operations:                0
Number of times run:                 1
Memory used by prepared stmt:        77840
Error: disk I/O error

any cues from above? is there a way to make sqlite3 spit some log?

thx