SQLite User Forum

Should we recreate database for these error codes SQLITE_INTERNAL/SQLITE_FORMAT/SQLITE_EMPTY/SQLITE_NOLFS ?
Login
Hello Everyone,

We are using sqlite version 3.22.0 in our application and I am seeing that we are recreating the database whenever we get below error codes : 

1) SQLITE_INTERNAL
2) SQLITE_FORMAT
3) SQLITE_EMPTY
4) SQLITE_NOLFS 

We are capturing the error string by calling this function sqlite3_errstr(int error_code) but for all the above mentioned error codes, I am getting null string because of the way mapping is done in the code currently. Hence not able to figure out yet what is the actual error code that we are hitting. While we figure out that, I wanted to know for what all error codes (mentioned above), we should be recreating the database.

P.S. : We want to avoid recreating database to prevent data loss.


Thank you.