On 14.09.2016 13:26 Simon Slavin wrote: > Check the hard disk format for format errors (fsck). > > Run "PRAGMA integrity_check" on the database file. > > Is the database file on a disk inside the computer running the SQLite calls, > or is it accessed across a network ? > > Do you use any PRAGMAs in your program ? Seems to be on a local ext4 file system on some kind of hardware RAID. Integrity check is done nightly (only quick check) and does not seem to find any issues.
I'd expect corruptions to affect sqlite3_step as well and earlier. This IO error only occurs for sqlite3_prepare_v2. Additionally the user reports the problem starting to occur when using SQLite 3.12.0 and no such issues with 3.7.17. When using 3.7.17 it also did not checkpoint the WAL file in a separate thread (that is wal_autocheckpoint was on). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users