SQLite Error Mapping¶
This page lists how native SQLite database or driver errors are represented as TsSqlErrorReason values. The table uses the same row catalog and row order as the other native database pages, so a - means this semantic case is not currently mapped for SQLite.
Database error shows the values exposed through databaseErrorCode and databaseErrorNumber when both are available. Connector-only signals include the connector inline. SQL_UNKNOWN is intentionally the last row.
Exact mapper-known codes are listed individually. Broad class, range, or message-pattern fallbacks are kept when the mapper intentionally handles an open-ended family of errors; if the same native code appears in more than one row, the driver message determines the final mapped reason.
| Category | Reason | Database error | Filled fields |
|---|---|---|---|
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType unique |
SQLITE_CONSTRAINT_UNIQUE / 2067: unique constraint violationSQLITE_CONSTRAINT_PRIMARYKEY / 1555: unique constraint violationSQLITE_CONSTRAINT_ROWID / 2579: unique constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType not null |
SQLITE_CONSTRAINT_NOTNULL / 1299: not null constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType foreign key |
SQLITE_CONSTRAINT_FOREIGNKEY / 787: foreign key constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType check |
SQLITE_CONSTRAINT_CHECK / 275: check constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType exclusion |
- | - |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType restrict |
- | - |
| Constraints | SQL_CONSTRAINT_VIOLATED |
SQLITE_CONSTRAINT / 19: constraint violationSQLITE_CONSTRAINT_COMMITHOOK / 531: constraint violationSQLITE_CONSTRAINT_FUNCTION / 1043: constraint violationSQLITE_CONSTRAINT_TRIGGER / 1811: constraint violationSQLITE_CONSTRAINT_VTAB / 2323: constraint violationSQLITE_CONSTRAINT_PINNED / 2835: constraint violation |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType too long |
SQLITE_TOOBIG / 18: too long |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType out of range |
better-sqlite3, bun:sqlite, node:sqlite, and sqlite-wasm integer/bigint range messages: out of range | errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid value |
SQLITE_MISMATCH / 20: invalid valueSQLITE_CONSTRAINT_DATATYPE / 3091: invalid value |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid format |
- | - |
| Values | SQL_INVALID_VALUEerrorType invalid encoding |
- | - |
| Values | SQL_INVALID_VALUEerrorType invalid json |
- | - |
| Values | SQL_INVALID_VALUEerrorType invalid xml |
- | - |
| Values | SQL_INVALID_VALUEerrorType invalid regular expression |
- | - |
| Values | SQL_INVALID_VALUEerrorType null not allowed |
- | - |
| Values | SQL_INVALID_VALUEerrorType sequence limit |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType missing |
missing parameter messages; node:sqlite missing option/key messages: missing parameter | parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType too many |
too many SQL variables / parameter messages: too many parameter | parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType wrong count |
wrong number/count of bind parameters messages: wrong count parameter | parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid name |
ERR_INVALID_STATE: invalid name parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid index |
SQLITE_RANGE / 25: invalid index parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid type |
ERR_INVALID_ARG_TYPE: invalid type parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid value |
invalid bind parameter value messages: invalid value parameter | parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid binding |
ERR_SQLITE_NOT_TAGGED_CALL (Bun SQL): invalid binding parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType not bindable |
parameters are not allowed/not bindable messages: not bindable parameter | parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType already bound |
already bound parameter messages: already bound parameter | parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETER |
fallback SQLite bind parameter messages: invalid parameter | databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType database |
unknown database message: database not found | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType schema |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType table or view |
no such table message: table or view not found | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType column |
no such column message: column not found | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType routine |
no such function / user-defined function message: routine not found | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType sequence |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType collation |
SQLITE_ERROR_MISSING_COLLSEQ / 257: collation not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType index |
no such index message: index not found | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType trigger |
no such trigger message: trigger not found | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType cursor |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType prepared statement |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType role |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUND |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType database |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType schema |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType table or view |
table or view already exists message: table or view already exists | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType column |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType routine |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType sequence |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType index |
index already exists message: index already exists | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType trigger |
trigger already exists message: trigger already exists | objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType cursor |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType prepared statement |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTS |
- | - |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType invalid state |
SQLITE_SCHEMA / 17: invalid state |
objectStateErrorTypeobjectType when inferredschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType wrong object type |
wrong object type messages for view/table operations: wrong object type | objectStateErrorTypeobjectType when inferredschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType object in use |
- | - |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType dependent objects still exist |
- | - |
| Statement | SQL_SYNTAX_ERROR |
SQLITE_ERROR / 1: syntax error when the message contains SQLite syntax markers |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIERidentifierErrorType ambiguous |
ambiguous column name message: ambiguous identifier | identifier when inferredidentifierType when inferredidentifierErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIERidentifierErrorType duplicate |
duplicate column name message: duplicate identifier | identifier when inferredidentifierType when inferredidentifierErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIER |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType incomplete statement |
incomplete input message: incomplete statement | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid definition |
foreign key mismatch / malformed schema definition messages: invalid definition | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType type mismatch |
datatype mismatch message: type mismatch | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid statement context |
statement not allowed in current SQLite context messages: invalid statement context | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid identifier |
invalid identifier/name messages: invalid identifier | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid reference |
ON CONFLICT clause does not match any PRIMARY KEY or UNIQUE constraint | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid grouping |
aggregate/grouping misuse messages: invalid grouping | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid windowing |
window-function misuse messages: invalid windowing | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid recursion |
recursive query misuse messages: invalid recursion | statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid locator |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType case not found |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid argument |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENT |
SQLITE_ERROR / 1: invalid SQL statement when the message has no more specific SQLite diagnostic |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_DIVISION_BY_ZERO |
- | - |
| Execution | SQL_CARDINALITY_VIOLATION |
sub-select returns too many columns message: cardinality violation | databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_ROUTINE_ERROR |
user-defined function raised exception message: routine error | databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType invalid state |
SQLITE_ERROR_SNAPSHOT / 769: invalid stateERR_SQLITE_INVALID_TRANSACTION_STATE (Bun SQL): invalid state |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType aborted |
SQLITE_ABORT_ROLLBACK / 516: aborted |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType active transaction |
cannot VACUUM / change WAL / start transaction within transaction messages: active transaction | transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType serialization failure |
SQLITE_BUSY_SNAPSHOT / 517: serialization failure |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType deadlock |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType transaction rolled back |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType outcome unknown |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType invalid savepoint |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType unsupported operation |
- | - |
| Transactions | NOT_IN_TRANSACTION |
cannot commit/rollback: no transaction is active message and direct transaction checks: not in transaction | driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields |
| Transactions | NESTED_TRANSACTION_NOT_SUPPORTED |
cannot start a transaction within a transaction message and direct nested transaction checks: nested transaction not supported | driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields |
| Transactions | FORBIDDEN_CONCURRENT_USAGE |
SQL statements in progress / database or statement busy messages: concurrent query runner usage | driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields |
| Transactions | TRANSACTION_LEVEL_NOT_SUPPORTED |
raised directly by query runners that reject the isolation level | transactionLevel |
| Transactions | TRANSACTION_ACCESS_MODE_NOT_SUPPORTED |
raised directly by query runners that reject the transaction access mode | accessMode |
| Timeouts | SQL_TIMEOUTtimeoutType connection |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType lock |
SQLITE_LOCKED / 6: lock timeoutSQLITE_LOCKED_SHAREDCACHE / 262: lock timeoutSQLITE_LOCKED_VTAB / 518: lock timeoutSQLITE_PROTOCOL / 15: lock timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType statement |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType transaction |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType idle transaction |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType cancelled |
SQLITE_ABORT / 4 (Bun SQL): cancelled timeoutSQLITE_ABORT / 4: cancelled timeoutSQLITE_INTERRUPT / 9 (Bun SQL): cancelled timeoutSQLITE_INTERRUPT / 9: cancelled timeoutERR_SQLITE_QUERY_CANCELLED (Bun SQL): cancelled timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType database file busy |
SQLITE_BUSY / 5: database file busy timeoutSQLITE_BUSY_RECOVERY / 261: database file busy timeoutSQLITE_BUSY_TIMEOUT / 773: database file busy timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType connection lost |
SQLITE_MISUSE / 21: connection lost when the message says the database handle is closedERR_SQLITE_CONNECTION_CLOSED (Bun SQL): connection lostSQLITE_CONNECTION_CLOSED (Bun SQL): connection lost |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType temporarily unavailable |
- | - |
| Connections | SQL_CONNECTION_ERRORerrorType invalid connection configuration |
SQLITE_CANTOPEN / 14: invalid connection configurationSQLITE_CANTOPEN_NOTEMPDIR / 270: invalid connection configurationSQLITE_CANTOPEN_ISDIR / 526: invalid connection configurationSQLITE_CANTOPEN_FULLPATH / 782: invalid connection configurationSQLITE_CANTOPEN_CONVPATH / 1038: invalid connection configurationSQLITE_CANTOPEN_DIRTYWAL / 1294: invalid connection configurationSQLITE_CANTOPEN_SYMLINK / 1550: invalid connection configurationSQLITE_NOTADB / 26: invalid connection configuration |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType pool error |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType memory |
SQLITE_NOMEM / 7: memory resource limitSQLITE_IOERR_NOMEM / 3082: memory resource limitERR_MEMORY_ALLOCATION_FAILED: memory resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType disk |
SQLITE_FULL / 13: disk resource limitSQLITE_IOERR_SHMSIZE / 4874: disk resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType temp space |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType connections |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType pool |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType cpu |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType file size |
SQLITE_NOLFS / 22: file size resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHED |
too many variables/columns/terms messages; expanded SQL too large messages: resource limit reached | resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_AUTHENTICATION_ERROR |
- | - |
| Access | SQL_AUTHORIZATION_ERROR |
SQLITE_AUTH / 23: authorization errorSQLITE_AUTH_USER / 279: authorization errorSQLITE_IOERR_AUTH / 7178: authorization error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_PERMISSION_DENIED |
SQLITE_PERM / 3: permission denied |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_READ_ONLY_VIOLATION |
SQLITE_READONLY / 8: read-only violationSQLITE_READONLY_RECOVERY / 264: read-only violationSQLITE_READONLY_CANTLOCK / 520: read-only violationSQLITE_READONLY_ROLLBACK / 776: read-only violationSQLITE_READONLY_DBMOVED / 1032: read-only violationSQLITE_READONLY_CANTINIT / 1288: read-only violationSQLITE_READONLY_DIRECTORY / 1544: read-only violation |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType configuration file |
- | - |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType lock file |
- | - |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType runtime parameter |
node:sqlite extension loading/config messages; bun:sqlite authorizer callback messages: runtime parameter configuration error | configurationErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType read |
SQLITE_IOERR_READ / 266: read I/O errorSQLITE_IOERR_SHORT_READ / 522: read I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType write |
SQLITE_IOERR_WRITE / 778: write I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType fsync |
SQLITE_IOERR_FSYNC / 1034: fsync I/O errorSQLITE_IOERR_DIR_FSYNC / 1290: fsync I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType truncate |
SQLITE_IOERR_TRUNCATE / 1546: truncate I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType file stat |
SQLITE_IOERR_FSTAT / 1802: file stat I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType lock |
SQLITE_IOERR_LOCK / 3850: lock I/O errorSQLITE_IOERR_RDLOCK / 2314: lock I/O errorSQLITE_IOERR_CHECKRESERVEDLOCK / 3594: lock I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType unlock |
SQLITE_IOERR_UNLOCK / 2058: unlock I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType delete |
SQLITE_IOERR_DELETE / 2570: delete I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType file not found |
SQLITE_IOERR_DELETE_NOENT / 5898: file not found I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType access |
SQLITE_IOERR_ACCESS / 3338: access I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType shared memory |
SQLITE_IOERR_SHMOPEN / 4618: shared memory I/O errorSQLITE_IOERR_SHMLOCK / 5130: shared memory I/O errorSQLITE_IOERR_SHMMAP / 5386: shared memory I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType seek |
SQLITE_IOERR_SEEK / 5642: seek I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType mmap |
SQLITE_IOERR_MMAP / 6154: mmap I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType path |
SQLITE_IOERR_GETTEMPPATH / 6410: path I/O errorSQLITE_IOERR_CONVPATH / 6666: path I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType atomic write |
SQLITE_IOERR_BEGIN_ATOMIC / 7434: atomic write I/O errorSQLITE_IOERR_COMMIT_ATOMIC / 7690: atomic write I/O errorSQLITE_IOERR_ROLLBACK_ATOMIC / 7946: atomic write I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType close |
SQLITE_IOERR_CLOSE / 4106: close I/O errorSQLITE_IOERR_DIR_CLOSE / 4362: close I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType reserved extension |
SQLITE_IOERR_VNODE / 6922: reserved extension I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType unknown |
SQLITE_IOERR / 10: unknown I/O errorSQLITE_IOERR_BLOCKED / 2826: unknown I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| External | SQL_EXTERNAL_DATA_SOURCE_ERROR |
ERR_LOAD_SQLITE_EXTENSION: external data source error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Features | SQL_FEATURE_NOT_SUPPORTED |
Bun SQL no reservation / distributed transaction / arrays / readonly transaction mode messages: feature not supported | databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType database file |
SQLITE_CORRUPT / 11: database file corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType index |
SQLITE_CORRUPT_INDEX / 779: index corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType sequence |
SQLITE_CORRUPT_SEQUENCE / 523: sequence corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType virtual table |
SQLITE_CORRUPT_VTAB / 267: virtual table corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType filesystem |
SQLITE_IOERR_CORRUPTFS / 8458: filesystem corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType checksum |
SQLITE_IOERR_DATA / 8202: checksum corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Internal | SQL_INTERNAL_ERRORerrorType engine internal |
SQLITE_OK / 0: engine internalSQLITE_INTERNAL / 2: engine internalSQLITE_NOTFOUND / 12: engine internalSQLITE_EMPTY / 16: engine internalSQLITE_FORMAT / 24: engine internalSQLITE_NOTICE / 27: engine internalSQLITE_WARNING / 28: engine internalSQLITE_ROW / 100: engine internalSQLITE_DONE / 101: engine internalSQLITE_OK_LOAD_PERMANENTLY / 256: engine internalSQLITE_NOTICE_RECOVER_WAL / 283: engine internalSQLITE_WARNING_AUTOINDEX / 284: engine internalSQLITE_ERROR_RETRY / 513: engine internalSQLITE_NOTICE_RECOVER_ROLLBACK / 539: engine internal |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Internal | SQL_INTERNAL_ERRORerrorType api misuse |
SQLITE_MISUSE / 21: api misuse when the message does not say the database handle is closed |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Fallback | SQL_UNKNOWN |
SQL.SQLError (Bun SQL): unknown SQL error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |