SQLite Forum

Is pragma integrity_check safe during app working?
Login
In rollback mode, if you try to write while PRAGMA integrity_check is running, you will get an SQLITE_BUSY error.  To avoid this error, you can:

  *  Run in WAL mode

  *  Set "PRAGMA busy_timeout=N" to cause the writes to wait for
      N milliseconds before giving up and returning SQLITE_BUSY.