C API: Error Codes And Messages
(c3ref/errcode.html)
sqlite3_errcode(), sqlite3_extended_errcode(), sqlite3_errmsg(), sqlite3_errmsg16(), sqlite3_errstr(), sqlite3_error_offset()
... When the serialized threading mode is in use, it might be the
case that a second error occurs on a separate thread in between
the time of the first error and the call to these interfaces.
When that happens, the ...
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
1. File overwrite by a rogue thread or process
SQLite database files are ordinary disk files.
That means that any process can open the file and
overwrite it with garbage. There is nothing that the SQLite
library can do to defend against this.
|
C API: Name Of The Folder Holding Database Files
(c3ref/data_directory.html)
... It is not safe to read or modify this variable in more than one
thread at a time. It is not safe to read or modify this variable
if a database connection is being used at the same time in ...
|
SQLite Shared-Cache Mode
(sharedcache.html)
3. Thread Related Issues
In SQLite versions 3.3.0 through 3.4.2 when shared-cache mode is enabled,
a database connection may only be
used by the thread that called sqlite3_open() to create it.
And a connection could only share cache with ...
|
C API: Interrupt A Long-Running Query
(c3ref/interrupt.html)
sqlite3_is_interrupted()
... It is safe to call this routine from a thread different from the
thread that is currently running the database operation. But it
is not safe to call this routine with a database connection that
is closed or might close ...
|
C API: User Data For Functions
(c3ref/user_data.html)
sqlite3_user_data()
... This routine must be called from the same thread in which
the application-defined function is running.
See also lists of
Objects,
Constants, and
Functions.
|
C API: Name Of The Folder Holding Temporary Files
(c3ref/temp_directory.html)
... It is not safe to read or modify this variable in more than one
thread at a time. It is not safe to read or modify this variable
if a database connection is being used at the same time in ...
|
C API: Test For Auto-Commit Mode
(c3ref/get_autocommit.html)
sqlite3_get_autocommit()
... If another thread changes the autocommit status of the database
connection while this routine is running, then the return value
is undefined.
See also lists of
Objects,
Constants, and
Functions.
|
C API: Error Logging Interface
(c3ref/log.html)
sqlite3_log()
... To avoid deadlocks and other threading problems, the sqlite3_log() routine
will not use dynamically allocated memory. The log message is stored in
a fixed-length buffer on the stack. If the log message is longer than
a few hundred characters ...
|
SQLite Backup API
(backup.html)
3.1. File and Database Connection Locking
... This allows other threads
to use database connection pDb and other connections to write to the
underlying database file.
If another thread or process writes to the source database while this
function is sleeping, then SQLite detects this and usually ...
|
Page generated by FTS5 in about 73.59 ms.