1*022f0052Schristos.Dd March 11, 2017 2c3d31e1aSchristos.Dt SQLITE_IOERR_READ 3 3c3d31e1aSchristos.Os 4c3d31e1aSchristos.Sh NAME 5c3d31e1aSchristos.Nm SQLITE_IOERR_READ , 6c3d31e1aSchristos.Nm SQLITE_IOERR_SHORT_READ , 7c3d31e1aSchristos.Nm SQLITE_IOERR_WRITE , 8c3d31e1aSchristos.Nm SQLITE_IOERR_FSYNC , 9c3d31e1aSchristos.Nm SQLITE_IOERR_DIR_FSYNC , 10c3d31e1aSchristos.Nm SQLITE_IOERR_TRUNCATE , 11c3d31e1aSchristos.Nm SQLITE_IOERR_FSTAT , 12c3d31e1aSchristos.Nm SQLITE_IOERR_UNLOCK , 13c3d31e1aSchristos.Nm SQLITE_IOERR_RDLOCK , 14c3d31e1aSchristos.Nm SQLITE_IOERR_DELETE , 15c3d31e1aSchristos.Nm SQLITE_IOERR_BLOCKED , 16c3d31e1aSchristos.Nm SQLITE_IOERR_NOMEM , 17c3d31e1aSchristos.Nm SQLITE_IOERR_ACCESS , 18c3d31e1aSchristos.Nm SQLITE_IOERR_CHECKRESERVEDLOCK , 19c3d31e1aSchristos.Nm SQLITE_IOERR_LOCK , 20c3d31e1aSchristos.Nm SQLITE_IOERR_CLOSE , 21c3d31e1aSchristos.Nm SQLITE_IOERR_DIR_CLOSE , 22c3d31e1aSchristos.Nm SQLITE_IOERR_SHMOPEN , 23c3d31e1aSchristos.Nm SQLITE_IOERR_SHMSIZE , 24c3d31e1aSchristos.Nm SQLITE_IOERR_SHMLOCK , 25c3d31e1aSchristos.Nm SQLITE_IOERR_SHMMAP , 26c3d31e1aSchristos.Nm SQLITE_IOERR_SEEK , 27c3d31e1aSchristos.Nm SQLITE_IOERR_DELETE_NOENT , 28c3d31e1aSchristos.Nm SQLITE_IOERR_MMAP , 29c3d31e1aSchristos.Nm SQLITE_IOERR_GETTEMPPATH , 30c3d31e1aSchristos.Nm SQLITE_IOERR_CONVPATH , 31e4827724Sabhinav.Nm SQLITE_IOERR_VNODE , 32e4827724Sabhinav.Nm SQLITE_IOERR_AUTH , 33c3d31e1aSchristos.Nm SQLITE_LOCKED_SHAREDCACHE , 34c3d31e1aSchristos.Nm SQLITE_BUSY_RECOVERY , 35c3d31e1aSchristos.Nm SQLITE_BUSY_SNAPSHOT , 36c3d31e1aSchristos.Nm SQLITE_CANTOPEN_NOTEMPDIR , 37c3d31e1aSchristos.Nm SQLITE_CANTOPEN_ISDIR , 38c3d31e1aSchristos.Nm SQLITE_CANTOPEN_FULLPATH , 39c3d31e1aSchristos.Nm SQLITE_CANTOPEN_CONVPATH , 40c3d31e1aSchristos.Nm SQLITE_CORRUPT_VTAB , 41c3d31e1aSchristos.Nm SQLITE_READONLY_RECOVERY , 42c3d31e1aSchristos.Nm SQLITE_READONLY_CANTLOCK , 43c3d31e1aSchristos.Nm SQLITE_READONLY_ROLLBACK , 44c3d31e1aSchristos.Nm SQLITE_READONLY_DBMOVED , 45c3d31e1aSchristos.Nm SQLITE_ABORT_ROLLBACK , 46c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_CHECK , 47c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_COMMITHOOK , 48c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_FOREIGNKEY , 49c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_FUNCTION , 50c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_NOTNULL , 51c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_PRIMARYKEY , 52c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_TRIGGER , 53c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_UNIQUE , 54c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_VTAB , 55c3d31e1aSchristos.Nm SQLITE_CONSTRAINT_ROWID , 56c3d31e1aSchristos.Nm SQLITE_NOTICE_RECOVER_WAL , 57c3d31e1aSchristos.Nm SQLITE_NOTICE_RECOVER_ROLLBACK , 58e4827724Sabhinav.Nm SQLITE_WARNING_AUTOINDEX , 59*022f0052Schristos.Nm SQLITE_AUTH_USER , 60*022f0052Schristos.Nm SQLITE_OK_LOAD_PERMANENTLY 61c3d31e1aSchristos.Nd Extended Result Codes 62c3d31e1aSchristos.Sh SYNOPSIS 63c3d31e1aSchristos.Fd #define SQLITE_IOERR_READ 64c3d31e1aSchristos.Fd #define SQLITE_IOERR_SHORT_READ 65c3d31e1aSchristos.Fd #define SQLITE_IOERR_WRITE 66c3d31e1aSchristos.Fd #define SQLITE_IOERR_FSYNC 67c3d31e1aSchristos.Fd #define SQLITE_IOERR_DIR_FSYNC 68c3d31e1aSchristos.Fd #define SQLITE_IOERR_TRUNCATE 69c3d31e1aSchristos.Fd #define SQLITE_IOERR_FSTAT 70c3d31e1aSchristos.Fd #define SQLITE_IOERR_UNLOCK 71c3d31e1aSchristos.Fd #define SQLITE_IOERR_RDLOCK 72c3d31e1aSchristos.Fd #define SQLITE_IOERR_DELETE 73c3d31e1aSchristos.Fd #define SQLITE_IOERR_BLOCKED 74c3d31e1aSchristos.Fd #define SQLITE_IOERR_NOMEM 75c3d31e1aSchristos.Fd #define SQLITE_IOERR_ACCESS 76c3d31e1aSchristos.Fd #define SQLITE_IOERR_CHECKRESERVEDLOCK 77c3d31e1aSchristos.Fd #define SQLITE_IOERR_LOCK 78c3d31e1aSchristos.Fd #define SQLITE_IOERR_CLOSE 79c3d31e1aSchristos.Fd #define SQLITE_IOERR_DIR_CLOSE 80c3d31e1aSchristos.Fd #define SQLITE_IOERR_SHMOPEN 81c3d31e1aSchristos.Fd #define SQLITE_IOERR_SHMSIZE 82c3d31e1aSchristos.Fd #define SQLITE_IOERR_SHMLOCK 83c3d31e1aSchristos.Fd #define SQLITE_IOERR_SHMMAP 84c3d31e1aSchristos.Fd #define SQLITE_IOERR_SEEK 85c3d31e1aSchristos.Fd #define SQLITE_IOERR_DELETE_NOENT 86c3d31e1aSchristos.Fd #define SQLITE_IOERR_MMAP 87c3d31e1aSchristos.Fd #define SQLITE_IOERR_GETTEMPPATH 88c3d31e1aSchristos.Fd #define SQLITE_IOERR_CONVPATH 89e4827724Sabhinav.Fd #define SQLITE_IOERR_VNODE 90e4827724Sabhinav.Fd #define SQLITE_IOERR_AUTH 91c3d31e1aSchristos.Fd #define SQLITE_LOCKED_SHAREDCACHE 92c3d31e1aSchristos.Fd #define SQLITE_BUSY_RECOVERY 93c3d31e1aSchristos.Fd #define SQLITE_BUSY_SNAPSHOT 94c3d31e1aSchristos.Fd #define SQLITE_CANTOPEN_NOTEMPDIR 95c3d31e1aSchristos.Fd #define SQLITE_CANTOPEN_ISDIR 96c3d31e1aSchristos.Fd #define SQLITE_CANTOPEN_FULLPATH 97c3d31e1aSchristos.Fd #define SQLITE_CANTOPEN_CONVPATH 98c3d31e1aSchristos.Fd #define SQLITE_CORRUPT_VTAB 99c3d31e1aSchristos.Fd #define SQLITE_READONLY_RECOVERY 100c3d31e1aSchristos.Fd #define SQLITE_READONLY_CANTLOCK 101c3d31e1aSchristos.Fd #define SQLITE_READONLY_ROLLBACK 102c3d31e1aSchristos.Fd #define SQLITE_READONLY_DBMOVED 103c3d31e1aSchristos.Fd #define SQLITE_ABORT_ROLLBACK 104c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_CHECK 105c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_COMMITHOOK 106c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_FOREIGNKEY 107c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_FUNCTION 108c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_NOTNULL 109c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_PRIMARYKEY 110c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_TRIGGER 111c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_UNIQUE 112c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_VTAB 113c3d31e1aSchristos.Fd #define SQLITE_CONSTRAINT_ROWID 114c3d31e1aSchristos.Fd #define SQLITE_NOTICE_RECOVER_WAL 115c3d31e1aSchristos.Fd #define SQLITE_NOTICE_RECOVER_ROLLBACK 116c3d31e1aSchristos.Fd #define SQLITE_WARNING_AUTOINDEX 117e4827724Sabhinav.Fd #define SQLITE_AUTH_USER 118*022f0052Schristos.Fd #define SQLITE_OK_LOAD_PERMANENTLY 119c3d31e1aSchristos.Sh DESCRIPTION 120e4827724SabhinavIn its default configuration, SQLite API routines return one of 30 121c3d31e1aSchristosinteger result codes. 122c3d31e1aSchristosHowever, experience has shown that many of these result codes are too 123c3d31e1aSchristoscoarse-grained. 124c3d31e1aSchristosThey do not provide as much information about problems as programmers 125c3d31e1aSchristosmight like. 126c3d31e1aSchristosIn an effort to address this, newer versions of SQLite (version 3.3.8 127*022f0052Schristosdateof:3.3.8 and later) include support for additional 128*022f0052Schristosresult codes that provide more detailed information about errors. 129e4827724SabhinavThese extended result codes are enabled or disabled 130e4827724Sabhinavon a per database connection basis using the sqlite3_extended_result_codes() 131c3d31e1aSchristosAPI. 132e4827724SabhinavOr, the extended code for the most recent error can be obtained using 133e4827724Sabhinavsqlite3_extended_errcode(). 134c3d31e1aSchristos.Sh SEE ALSO 135e4827724Sabhinav.Xr sqlite3_errcode 3 , 136e4827724Sabhinav.Xr sqlite3_extended_result_codes 3 137