Sfoglia tutti i 150 codici di errore Errori SQL/Database con cause, soluzioni ed esempi.
Akousa08001The client could not establish a connection to the database server.
08003The specified database connection does not exist or has been closed.
08006An established database connection was unexpectedly lost.
22001A string value is too long for the target column.
22003A numeric value is outside the range of the target column's data type.
22007A date, time, or timestamp value is in an invalid format.
22008A datetime value is outside the valid range for the field.
22012A division by zero was attempted in a SQL expression.
22P02A value could not be converted to the required data type.
23502An INSERT or UPDATE attempted to set a NOT NULL column to NULL.
23503An INSERT or UPDATE violates a foreign key constraint.
23505An INSERT or UPDATE violates a unique constraint or primary key.
23514An INSERT or UPDATE violates a CHECK constraint on the table.
23P01An INSERT or UPDATE violates an exclusion constraint.
25001The command cannot be executed inside an active transaction.
25006An attempt was made to modify data in a read-only transaction.
25P02A command was issued in a transaction that has already failed.
28000The authentication credentials are invalid.
28P01The password provided for authentication is incorrect.
3D000The specified database does not exist.
3F000The specified schema does not exist in the database.
40001The transaction was rolled back due to a serialization conflict.
40P01Two or more transactions are waiting for each other's locks, creating a deadlock.
42000The SQL statement contains a syntax error or violates an access rule.
42501The current user does not have the required privilege.
42601The SQL statement contains a syntax error.
42602An identifier name in the SQL statement is invalid.
42701A column name appears more than once where it must be unique.
42702A column reference is ambiguous because it exists in multiple tables.
42703The specified column does not exist in the table or result set.
42704The specified database object (type, operator, function) does not exist.
42710An object with the specified name already exists.
42712A table alias is used more than once in the same query.
42804The data types in the expression are incompatible.
42830The foreign key definition is invalid due to type mismatch or missing unique constraint.
42883The function with the specified name and argument types does not exist.
42P01The specified table or view does not exist.
42P02A prepared statement parameter is referenced but not defined.
42P03A cursor with the specified name already exists.
42P04A database with the specified name already exists.
42P06A schema with the specified name already exists.
42P07A table with the specified name already exists in the schema.
42P10A column reference in GROUP BY, ORDER BY, or DISTINCT ON is invalid.
42P16The table definition is invalid.
42P18The data type of an expression could not be determined.
53100The database server's disk is full.
53200The database server ran out of memory.
53300The maximum number of database connections has been reached.
54000A database implementation limit was exceeded.
54001The SQL statement is too complex for the database to process.
54011The number of columns exceeds the database limit.
54023Too many arguments were passed to a function.
55000The database object is not in the required state.
55006The database object is currently in use and cannot be modified.
55P03The requested lock could not be acquired without waiting.
57014The query was canceled by the user or a timeout.
57P01The database server is shutting down.
57P02The database server crashed and is restarting.
57P03The database server is not ready to accept connections.
58000An operating system error occurred during a database operation.
58030A disk I/O error occurred during a database operation.
P0001An application-defined exception was raised in PL/pgSQL.
P0002A SELECT INTO in PL/pgSQL returned no rows when exactly one was expected.
P0003A SELECT INTO in PL/pgSQL returned more than one row.
MySQL 1005MySQL cannot create the table due to a constraint or configuration error.
MySQL 1007The database cannot be created because it already exists.
MySQL 1044The user does not have access to the specified database.
MySQL 1045Authentication failed with the provided credentials.
MySQL 1049The specified database does not exist.
MySQL 1054The specified column does not exist in the table.
MySQL 1062An INSERT or UPDATE would create a duplicate value in a unique index.
MySQL 1064The SQL statement contains a syntax error.
MySQL 1146The referenced table does not exist in the database.
MySQL 1215MySQL cannot create the foreign key due to a definition mismatch.
MySQL 1217A foreign key constraint prevents deletion of a parent row.
MySQL 1264A numeric value exceeds the valid range for the column.
MySQL 1366The string contains characters invalid for the column's character set.
MySQL 1451A foreign key prevents modification of a referenced parent row.
MySQL 1452A foreign key prevents adding a child row because the parent does not exist.
MySQL 1213A deadlock was detected between concurrent transactions.
MySQL 1205A lock wait exceeded the configured timeout.
MySQL 2002MySQL client cannot connect through the local socket file.
MySQL 2003The client cannot establish a TCP connection to the server.
MySQL 2006The connection to the MySQL server was lost.
MySQL 2013The connection was lost during a query.
MySQL 1040The maximum number of MySQL connections has been exceeded.
MySQL 1114The table has reached its maximum size.
MySQL 1153The query or result exceeds max_allowed_packet.
MySQL 1227The operation requires a privilege the user does not have.
MySQL 1236The replication slave encountered an error reading the binary log.
SQLITE_BUSY (5)The database file is locked by another connection or process.
SQLITE_LOCKED (6)A table within the database is locked by the same connection.
SQLITE_NOMEM (7)SQLite could not allocate enough memory.
SQLITE_READONLY (8)The database is opened in read-only mode or the filesystem is read-only.
SQLITE_INTERRUPT (9)The operation was interrupted by sqlite3_interrupt().
SQLITE_IOERR (10)A disk I/O error occurred while reading or writing the database.
SQLITE_CORRUPT (11)The database file is corrupted.
SQLITE_FULL (13)The insert failed because the disk or database size limit was reached.
SQLITE_CANTOPEN (14)SQLite cannot open the database file.
SQLITE_SCHEMA (17)The schema changed between preparing and executing a statement.
SQLITE_TOOBIG (18)A string or BLOB value exceeds SQLite's maximum size.
SQLITE_CONSTRAINT (19)An INSERT, UPDATE, or DELETE violated a constraint.
SQLITE_MISMATCH (20)The data type does not match what was expected.
SQLITE_MISUSE (21)The SQLite API was used incorrectly.
SQLITE_RANGE (25)A parameter index passed to sqlite3_bind is out of range.
SQLITE_NOTADB (26)The file is not a valid SQLite database.
SQLITE_ERROR (1)A generic SQL error or missing database occurred.
SQLITE_PERM (3)The requested access mode for the database file is not allowed.
SQLITE_ABORT (4)The operation was aborted by a callback function.
SQLITE_NOTFOUND (12)An internal routine returned not found. Not commonly seen in application code.
SQLITE_WARNING (28)SQLite encountered a non-critical issue and issued a warning.
02000The SQL statement completed but returned or affected no rows.
01000A non-critical warning was issued during SQL execution.
0A000The requested SQL feature is not supported by this database.
22004A NULL value was encountered where it is not permitted.
22023A parameter value is invalid for the operation.
22026The string length does not match the expected fixed length.
23001A restrict rule prevented the deletion or update of a referenced row.
24000A cursor operation was attempted in an invalid state.
26000The prepared statement name does not exist.
2B000Privileges cannot be revoked because dependent privileges exist.
2D000A transaction termination command was invalid in the current context.
34000The specified cursor name does not exist or is invalid.
38000An exception occurred in an external function or procedure.
39000An external function was invoked incorrectly.
42809The named object is not the expected type for the operation.
42846The value cannot be automatically converted to the required type.
42P20The window function specification is invalid.
42611A column definition in CREATE TABLE or ALTER TABLE is invalid.
MySQL 1048An INSERT or UPDATE tried to set a NOT NULL column to NULL.
MySQL 1060A column name appears more than once in the table definition.
MySQL 1071The index key length exceeds the storage engine maximum.
MySQL 1091The column or key to drop does not exist.
MySQL 1118The row size exceeds the storage engine maximum.
MySQL 1136The INSERT column count does not match the values count.
MySQL 1142The user lacks the required table-level privilege.
MySQL 1149The SQL statement contains a syntax error (legacy format).
MySQL 1292A value was truncated or is invalid during type conversion.
MySQL 1364A NOT NULL field was not given a value and has no default.
MySQL 1406The data value exceeds the column's maximum length.
MySQL 2014MySQL client commands are being issued out of order.
MySQL 1169A write to a unique index with IGNORE was skipped.
MySQL 1461The maximum number of prepared statements has been reached.
SQLITE_AUTH (23)The authorizer callback denied the operation.
SQLITE_FORMAT (24)This error code is reserved and not currently used by SQLite.
SQLITE_NOLFS (22)The platform does not support large files required by the database.
SQLITE_PROTOCOL (15)A database locking protocol error occurred.
SQLITE_EMPTY (16)The database file exists but contains no tables.
MySQL 1025An error occurred while renaming a table or dropping a foreign key.
MySQL 1065An empty query was sent to the MySQL server.