Debian Codegraph @

www/c3ref/c_abort_rollback.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="../sqlite.css" rel="stylesheet">
6 <title>Extended Result Codes</title>
7 <!-- path=../ -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="../index.html">
12 <img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="../index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='../about.html'>About</a>
23 <li class='desktoponly'><a href="../docs.html">Documentation</a>
24 <li class='desktoponly'><a href="../download.html">Download</a>
25 <li class='wideonly'><a href='../copyright.html'>License</a>
26 <li class='desktoponly'><a href="../support.html">Support</a>
27 <li class='desktoponly'><a href="../prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='../about.html'>About</a>
35 <li><a href='../docs.html'>Documentation</a>
36 <li><a href='../download.html'>Download</a>
37 <li><a href='../support.html'>Support</a>
38 <li><a href='../prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="../search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <!-- keywords: SQLITE_ABORT_ROLLBACK SQLITE_AUTH_USER SQLITE_BUSY_RECOVERY SQLITE_BUSY_SNAPSHOT SQLITE_BUSY_TIMEOUT SQLITE_CANTOPEN_CONVPATH SQLITE_CANTOPEN_DIRTYWAL SQLITE_CANTOPEN_FULLPATH SQLITE_CANTOPEN_ISDIR SQLITE_CANTOPEN_NOTEMPDIR SQLITE_CANTOPEN_SYMLINK SQLITE_CONSTRAINT_CHECK SQLITE_CONSTRAINT_COMMITHOOK SQLITE_CONSTRAINT_DATATYPE SQLITE_CONSTRAINT_FOREIGNKEY SQLITE_CONSTRAINT_FUNCTION SQLITE_CONSTRAINT_NOTNULL SQLITE_CONSTRAINT_PINNED SQLITE_CONSTRAINT_PRIMARYKEY SQLITE_CONSTRAINT_ROWID SQLITE_CONSTRAINT_TRIGGER SQLITE_CONSTRAINT_UNIQUE SQLITE_CONSTRAINT_VTAB SQLITE_CORRUPT_INDEX SQLITE_CORRUPT_SEQUENCE SQLITE_CORRUPT_VTAB SQLITE_ERROR_KEY SQLITE_ERROR_MISSING_COLLSEQ SQLITE_ERROR_RESERVESIZE SQLITE_ERROR_RETRY SQLITE_ERROR_SNAPSHOT SQLITE_ERROR_UNABLE SQLITE_IOERR_ACCESS SQLITE_IOERR_AUTH SQLITE_IOERR_BADKEY SQLITE_IOERR_BEGIN_ATOMIC SQLITE_IOERR_BLOCKED SQLITE_IOERR_CHECKRESERVEDLOCK SQLITE_IOERR_CLOSE SQLITE_IOERR_CODEC SQLITE_IOERR_COMMIT_ATOMIC SQLITE_IOERR_CONVPATH SQLITE_IOERR_CORRUPTFS SQLITE_IOERR_DATA SQLITE_IOERR_DELETE SQLITE_IOERR_DELETE_NOENT SQLITE_IOERR_DIR_CLOSE SQLITE_IOERR_DIR_FSYNC SQLITE_IOERR_FSTAT SQLITE_IOERR_FSYNC SQLITE_IOERR_GETTEMPPATH SQLITE_IOERR_IN_PAGE SQLITE_IOERR_LOCK SQLITE_IOERR_MMAP SQLITE_IOERR_NOMEM SQLITE_IOERR_RDLOCK SQLITE_IOERR_READ SQLITE_IOERR_ROLLBACK_ATOMIC SQLITE_IOERR_SEEK SQLITE_IOERR_SHMLOCK SQLITE_IOERR_SHMMAP SQLITE_IOERR_SHMOPEN SQLITE_IOERR_SHMSIZE SQLITE_IOERR_SHORT_READ SQLITE_IOERR_TRUNCATE SQLITE_IOERR_UNLOCK SQLITE_IOERR_VNODE SQLITE_IOERR_WRITE SQLITE_LOCKED_SHAREDCACHE SQLITE_LOCKED_VTAB SQLITE_NOTICE_RBU SQLITE_NOTICE_RECOVER_ROLLBACK SQLITE_NOTICE_RECOVER_WAL SQLITE_OK_LOAD_PERMANENTLY SQLITE_OK_SYMLINK SQLITE_READONLY_CANTINIT SQLITE_READONLY_CANTLOCK SQLITE_READONLY_DBMOVED SQLITE_READONLY_DIRECTORY SQLITE_READONLY_RECOVERY SQLITE_READONLY_ROLLBACK SQLITE_WARNING_AUTOINDEX {extended result code definitions} -->
119 <div class=nosearch>
120 <a href="../c3ref/intro.html"><h2>SQLite C Interface</h2></a>
121 <h2>Extended Result Codes</h2>
122 </div>
123 <blockquote><pre>
124 #define SQLITE_ERROR_MISSING_COLLSEQ (SQLITE_ERROR | (1&lt;&lt;8))
125 #define SQLITE_ERROR_RETRY (SQLITE_ERROR | (2&lt;&lt;8))
126 #define SQLITE_ERROR_SNAPSHOT (SQLITE_ERROR | (3&lt;&lt;8))
127 #define SQLITE_ERROR_RESERVESIZE (SQLITE_ERROR | (4&lt;&lt;8))
128 #define SQLITE_ERROR_KEY (SQLITE_ERROR | (5&lt;&lt;8))
129 #define SQLITE_ERROR_UNABLE (SQLITE_ERROR | (6&lt;&lt;8))
130 #define SQLITE_IOERR_READ (SQLITE_IOERR | (1&lt;&lt;8))
131 #define SQLITE_IOERR_SHORT_READ (SQLITE_IOERR | (2&lt;&lt;8))
132 #define SQLITE_IOERR_WRITE (SQLITE_IOERR | (3&lt;&lt;8))
133 #define SQLITE_IOERR_FSYNC (SQLITE_IOERR | (4&lt;&lt;8))
134 #define SQLITE_IOERR_DIR_FSYNC (SQLITE_IOERR | (5&lt;&lt;8))
135 #define SQLITE_IOERR_TRUNCATE (SQLITE_IOERR | (6&lt;&lt;8))
136 #define SQLITE_IOERR_FSTAT (SQLITE_IOERR | (7&lt;&lt;8))
137 #define SQLITE_IOERR_UNLOCK (SQLITE_IOERR | (8&lt;&lt;8))
138 #define SQLITE_IOERR_RDLOCK (SQLITE_IOERR | (9&lt;&lt;8))
139 #define SQLITE_IOERR_DELETE (SQLITE_IOERR | (10&lt;&lt;8))
140 #define SQLITE_IOERR_BLOCKED (SQLITE_IOERR | (11&lt;&lt;8))
141 #define SQLITE_IOERR_NOMEM (SQLITE_IOERR | (12&lt;&lt;8))
142 #define SQLITE_IOERR_ACCESS (SQLITE_IOERR | (13&lt;&lt;8))
143 #define SQLITE_IOERR_CHECKRESERVEDLOCK (SQLITE_IOERR | (14&lt;&lt;8))
144 #define SQLITE_IOERR_LOCK (SQLITE_IOERR | (15&lt;&lt;8))
145 #define SQLITE_IOERR_CLOSE (SQLITE_IOERR | (16&lt;&lt;8))
146 #define SQLITE_IOERR_DIR_CLOSE (SQLITE_IOERR | (17&lt;&lt;8))
147 #define SQLITE_IOERR_SHMOPEN (SQLITE_IOERR | (18&lt;&lt;8))
148 #define SQLITE_IOERR_SHMSIZE (SQLITE_IOERR | (19&lt;&lt;8))
149 #define SQLITE_IOERR_SHMLOCK (SQLITE_IOERR | (20&lt;&lt;8))
150 #define SQLITE_IOERR_SHMMAP (SQLITE_IOERR | (21&lt;&lt;8))
151 #define SQLITE_IOERR_SEEK (SQLITE_IOERR | (22&lt;&lt;8))
152 #define SQLITE_IOERR_DELETE_NOENT (SQLITE_IOERR | (23&lt;&lt;8))
153 #define SQLITE_IOERR_MMAP (SQLITE_IOERR | (24&lt;&lt;8))
154 #define SQLITE_IOERR_GETTEMPPATH (SQLITE_IOERR | (25&lt;&lt;8))
155 #define SQLITE_IOERR_CONVPATH (SQLITE_IOERR | (26&lt;&lt;8))
156 #define SQLITE_IOERR_VNODE (SQLITE_IOERR | (27&lt;&lt;8))
157 #define SQLITE_IOERR_AUTH (SQLITE_IOERR | (28&lt;&lt;8))
158 #define SQLITE_IOERR_BEGIN_ATOMIC (SQLITE_IOERR | (29&lt;&lt;8))
159 #define SQLITE_IOERR_COMMIT_ATOMIC (SQLITE_IOERR | (30&lt;&lt;8))
160 #define SQLITE_IOERR_ROLLBACK_ATOMIC (SQLITE_IOERR | (31&lt;&lt;8))
161 #define SQLITE_IOERR_DATA (SQLITE_IOERR | (32&lt;&lt;8))
162 #define SQLITE_IOERR_CORRUPTFS (SQLITE_IOERR | (33&lt;&lt;8))
163 #define SQLITE_IOERR_IN_PAGE (SQLITE_IOERR | (34&lt;&lt;8))
164 #define SQLITE_IOERR_BADKEY (SQLITE_IOERR | (35&lt;&lt;8))
165 #define SQLITE_IOERR_CODEC (SQLITE_IOERR | (36&lt;&lt;8))
166 #define SQLITE_LOCKED_SHAREDCACHE (SQLITE_LOCKED | (1&lt;&lt;8))
167 #define SQLITE_LOCKED_VTAB (SQLITE_LOCKED | (2&lt;&lt;8))
168 #define SQLITE_BUSY_RECOVERY (SQLITE_BUSY | (1&lt;&lt;8))
169 #define SQLITE_BUSY_SNAPSHOT (SQLITE_BUSY | (2&lt;&lt;8))
170 #define SQLITE_BUSY_TIMEOUT (SQLITE_BUSY | (3&lt;&lt;8))
171 #define SQLITE_CANTOPEN_NOTEMPDIR (SQLITE_CANTOPEN | (1&lt;&lt;8))
172 #define SQLITE_CANTOPEN_ISDIR (SQLITE_CANTOPEN | (2&lt;&lt;8))
173 #define SQLITE_CANTOPEN_FULLPATH (SQLITE_CANTOPEN | (3&lt;&lt;8))
174 #define SQLITE_CANTOPEN_CONVPATH (SQLITE_CANTOPEN | (4&lt;&lt;8))
175 #define SQLITE_CANTOPEN_DIRTYWAL (SQLITE_CANTOPEN | (5&lt;&lt;8)) /* Not Used */
176 #define SQLITE_CANTOPEN_SYMLINK (SQLITE_CANTOPEN | (6&lt;&lt;8))
177 #define SQLITE_CORRUPT_VTAB (SQLITE_CORRUPT | (1&lt;&lt;8))
178 #define SQLITE_CORRUPT_SEQUENCE (SQLITE_CORRUPT | (2&lt;&lt;8))
179 #define SQLITE_CORRUPT_INDEX (SQLITE_CORRUPT | (3&lt;&lt;8))
180 #define SQLITE_READONLY_RECOVERY (SQLITE_READONLY | (1&lt;&lt;8))
181 #define SQLITE_READONLY_CANTLOCK (SQLITE_READONLY | (2&lt;&lt;8))
182 #define SQLITE_READONLY_ROLLBACK (SQLITE_READONLY | (3&lt;&lt;8))
183 #define SQLITE_READONLY_DBMOVED (SQLITE_READONLY | (4&lt;&lt;8))
184 #define SQLITE_READONLY_CANTINIT (SQLITE_READONLY | (5&lt;&lt;8))
185 #define SQLITE_READONLY_DIRECTORY (SQLITE_READONLY | (6&lt;&lt;8))
186 #define SQLITE_ABORT_ROLLBACK (SQLITE_ABORT | (2&lt;&lt;8))
187 #define SQLITE_CONSTRAINT_CHECK (SQLITE_CONSTRAINT | (1&lt;&lt;8))
188 #define SQLITE_CONSTRAINT_COMMITHOOK (SQLITE_CONSTRAINT | (2&lt;&lt;8))
189 #define SQLITE_CONSTRAINT_FOREIGNKEY (SQLITE_CONSTRAINT | (3&lt;&lt;8))
190 #define SQLITE_CONSTRAINT_FUNCTION (SQLITE_CONSTRAINT | (4&lt;&lt;8))
191 #define SQLITE_CONSTRAINT_NOTNULL (SQLITE_CONSTRAINT | (5&lt;&lt;8))
192 #define SQLITE_CONSTRAINT_PRIMARYKEY (SQLITE_CONSTRAINT | (6&lt;&lt;8))
193 #define SQLITE_CONSTRAINT_TRIGGER (SQLITE_CONSTRAINT | (7&lt;&lt;8))
194 #define SQLITE_CONSTRAINT_UNIQUE (SQLITE_CONSTRAINT | (8&lt;&lt;8))
195 #define SQLITE_CONSTRAINT_VTAB (SQLITE_CONSTRAINT | (9&lt;&lt;8))
196 #define SQLITE_CONSTRAINT_ROWID (SQLITE_CONSTRAINT |(10&lt;&lt;8))
197 #define SQLITE_CONSTRAINT_PINNED (SQLITE_CONSTRAINT |(11&lt;&lt;8))
198 #define SQLITE_CONSTRAINT_DATATYPE (SQLITE_CONSTRAINT |(12&lt;&lt;8))
199 #define SQLITE_NOTICE_RECOVER_WAL (SQLITE_NOTICE | (1&lt;&lt;8))
200 #define SQLITE_NOTICE_RECOVER_ROLLBACK (SQLITE_NOTICE | (2&lt;&lt;8))
201 #define SQLITE_NOTICE_RBU (SQLITE_NOTICE | (3&lt;&lt;8))
202 #define SQLITE_WARNING_AUTOINDEX (SQLITE_WARNING | (1&lt;&lt;8))
203 #define SQLITE_AUTH_USER (SQLITE_AUTH | (1&lt;&lt;8))
204 #define SQLITE_OK_LOAD_PERMANENTLY (SQLITE_OK | (1&lt;&lt;8))
205 #define SQLITE_OK_SYMLINK (SQLITE_OK | (2&lt;&lt;8)) /* internal only */
206 </pre></blockquote>
207 <p>
208 In its default configuration, SQLite API routines return one of 30 integer
209 <a href="../rescode.html">result codes</a>. However, experience has shown that many of
210 these result codes are too coarse-grained. They do not provide as
211 much information about problems as programmers might like. In an effort to
212 address this, newer versions of SQLite (version 3.3.8 2006-10-09
213 and later) include
214 support for additional result codes that provide more detailed information
215 about errors. These <a href="../rescode.html#extrc">extended result codes</a> are enabled or disabled
216 on a per database connection basis using the
217 <a href="../c3ref/extended_result_codes.html">sqlite3_extended_result_codes()</a> API. Or, the extended code for
218 the most recent error can be obtained using
219 <a href="../c3ref/errcode.html">sqlite3_extended_errcode()</a>.
220 </p><p>See also lists of
221 <a href="../c3ref/objlist.html">Objects</a>,
222 <a href="../c3ref/constlist.html">Constants</a>, and
223 <a href="../c3ref/funclist.html">Functions</a>.</p>
224