EC
🐬

MySQL Error Numbers

MySQL 8.01,998 codes

MySQL error numbers with SQL fix examples

Showing 1,995 of 1,995 errors
CodeMessage
1044Access denied for user to database→
1045Access denied for user (using password)→
1046No database selected→
1048Column cannot be null→
1049Unknown database→
1050Table already exists→
1051Unknown table→
1054Unknown column in field list→
1062Duplicate entry for key→
1064You have an error in your SQL syntax→
1071Specified key was too long; max key length is 767 bytes→
1114The table is full→
1136Column count doesn't match value count→
1146Table doesn't exist→
1153Got a packet bigger than 'max_allowed_packet' bytes→
1175You are using safe update mode and tried to update a table without a WHERE using a KEY column→
1205Lock wait timeout exceeded; try restarting transaction→
1213Deadlock found when trying to get lock; try restarting transaction→
1215Cannot add foreign key constraint→
1216Cannot add or update a child row: a foreign key constraint fails→
1217Cannot delete or update a parent row: a foreign key constraint fails→
1264Out of range value for column→
1292Incorrect datetime value→
1366Incorrect integer value for column→
1406Data too long for column→
1040Too many connections→
1052Column in field list is ambiguous→
1060Duplicate column name→
1067Invalid default value for column→
1068Multiple primary key defined→
1130Host is not allowed to connect to this MySQL server→
1193Unknown system variable→
1203User has exceeded the max_user_connections resource→
1222The used SELECT statements have a different number of columns→
1227Access denied; you need SUPER privilege for this operation→
1242Subquery returns more than 1 row→
1248Every derived table must have its own alias→
1265Data truncated for column→
1267Illegal mix of collations→
1305FUNCTION or PROCEDURE does not exist→
1364Field doesn't have a default value→
1451Cannot delete or update a parent row: a foreign key constraint fails→
1452Cannot add or update a child row: a foreign key constraint fails→
2002Can't connect to local MySQL server through socket→
2003Can't connect to MySQL server on host→
2006MySQL server has gone away→
2013Lost connection to MySQL server during query→
1040Too many connections — additional context→
1290Statement not allowed — read-only or safe-update mode active→
1305Stored procedure or function does not exist→
1364Field has no default value→
1406Data too long for column→
1449Definer of view/routine no longer exists→
1451Cannot delete — parent row referenced by child→
1452Cannot insert — child row has no matching parent→
3024Query execution was interrupted — timeout exceeded→
4031Client did not respond to server — connection closed→
1005Can't create table — usually a FK constraint error→
1006Can't create database — permissions or already exists→
1007Can't create database — database already exists→
1008Can't drop database — database doesn't exist→
1021Disk full — MySQL is waiting for space to be freed→
1022Can't write — duplicate key in table→
1026Error writing file (errno: N)→
1028Sort aborted→
1030Got error N from storage engine→
1031Table storage engine does not have this option→
1032Can't find record in table→
1036Table is read only→
1037Out of memory — restart server and try again→
1041Out of resources when opening file→
1053Server shutdown in progress→
1055Expression not in GROUP BY and not in aggregate — ONLY_FULL_GROUP_BY→
1058Column count doesn't match value count at row N→
1059Identifier name is too long (max 64 chars)→
1061Duplicate key name in CREATE/ALTER TABLE→
1063Incorrect column specifier for column→
1065Query was empty→
1066Not unique table/alias in query→
1072Key column doesn't exist in table→
1073BLOB column used in key specification without key length→
1074Specified key was too long; max key length is 3072 bytes→
1075Only one AUTO_INCREMENT column allowed and it must be a key→
1076Too many keys specified; max 64 keys allowed→
1080Incorrect usage of LOCK TABLES / GROUP BY→
1100Table was not locked with LOCK TABLES→
1101BLOB/TEXT/GEOMETRY/JSON column can't have a default value→
1102Incorrect database name→
1105Unknown error (catch-all)→
1109Unknown table in MULTI DELETE→
1115Unknown character set→
1116Too many tables — MySQL can only use 61 tables in a join→
1117Too many columns→
1118Row size too large (> 8126 bytes for InnoDB default row format)→
1121Incorrect table definition — only one auto column and it must be a key→
1131Anonymous users cannot change passwords→
1132Must have privileges to update tables in the mysql database→
1133Can't find any matching row in the user table→
1141There is no such grant defined for user on host→
1142Command denied to user for table→
1143SELECT command denied to user for column in table→
1144Illegal GRANT/REVOKE command→
1149SQL syntax error (detailed variant)→
1163Incorrect table name→
1166Incorrect column name→
1169Can't write because of unique constraint→
1170BLOB/TEXT column used in key specification without a key length→
1171All parts of a PRIMARY KEY must be NOT NULL→
1172Result consisted of more than one row (subquery)→
1173This table type requires a primary key→
1176Key name doesn't exist in table→
1179Command not allowed inside a transaction→
1180Got error during COMMIT→
1181Got error during ROLLBACK→
1182Got error during FLUSH_LOGS→
1183Got error during CHECKPOINT→
1184Aborted connection due to communication error→
1194Table is marked as crashed and should be repaired→
1195Table is marked as crashed and last repair failed→
1196Non-transactional tables could not be rolled back→
1197Multi-statement transaction exceeded max_binlog_cache_size→
1198Operation cannot be performed with a running slave→
1199Operation requires a running slave→
1200Server is not configured as a slave→
1201Could not initialize master info structure→
1202Could not create slave thread→
1204User already has more than max_user_connections active connections→
1206Total number of locks exceeds the lock table size→
1207Update in a read-only transaction→
1210Incorrect definition: storage engine differs from parent table→
1219Active locked tables or transaction prevents this command→
1220Table was locked with READ lock and cannot be updated→
1221Cannot combine WRITE locks for system and user tables→
1223Command not allowed with this MySQL version→
1224Too many files open during binary log purge→
1225Fatal error during binary log purge→
1226User exceeded max_user_connections resource limit→
1228Only constant expressions allowed with SET→
1229Lock wait timeout exceeded; try restarting transaction→
1230Variable has no default value→
1231Variable can't be set to the argument value→
1232Incorrect argument type to variable→
1233Variable can only be set, not read→
1234Incorrect usage or placement of option→
1235This version of MySQL doesn't yet support this feature→
1236Fatal error reading from binary log on master→
1237Slave SQL thread ignored query due to replicate table rules→
1238SESSION variable cannot be used with SET GLOBAL→
1239Incorrect foreign key definition→
1240Key reference and table reference do not match→
1241Operand should contain the expected number of columns→
1243Unknown prepared statement handler given to EXECUTE→
1244Help database is corrupt or does not exist→
1246Column charset implicitly converted→
1249Column in view with expression cannot be updated→
1250Target table for UPDATE is not updatable→
1251Command not allowed with this MySQL version→
1253COLLATION does not apply to CHARACTER SET→
1261Row truncated: fewer input columns than table columns→
1262Row truncated: more input columns than table columns→
1263Column set to default: NULL supplied to NOT NULL column→
1266Using storage engine fallback for table→
1268Illegal mix of collations for operation→
1269Cannot drop one or more of the requested users→
1270Can't revoke all privileges for one or more users→
1271Unknown system variable→
1272Slave is not supported in this build→
1273Slave is already running→
1274Slave already has been stopped→
1275Uncompressed data size too large→
1276ZLIB: Not enough memory→
1277ZLIB: Not enough room in the output buffer→
1278ZLIB: Input data corrupted→
1279Row was cut by GROUP_CONCAT()→
1280Invalid character string→
1281Foreign key not supported with partitioning→
1283Inconsistency in usage of column lists for partitioning→
1284UNIQUE KEY must include all partitioning columns→
1285Value list not allowed for this partition type→
1286Unknown storage engine→
1287Deprecated syntax will be removed in a future release→
1288The target table for UPDATE is not updatable→
1289Feature is disabled; MySQL was not built with required option→
1293Invalid default value for column→
1295Every derived table must have its own alias→
1296The query cache is disabled→
1297Stored procedure already exists→
1298Failed to store routine→
1299LEAVE/ITERATE can only be used inside a loop/block→
1300Redefining label→
1301End-label does not match begin-label→
1302Referring to uninitialized variable→
1303PROCEDURE uses a cursor — cannot use as a plain SELECT→
1304RETURN is only allowed in a FUNCTION→
1306Not allowed to return a result set from a trigger→
1309Query execution was interrupted→
1310Incorrect number of arguments for procedure→
1311Undefined CONDITION→
1312No RETURN found in FUNCTION→
1313FUNCTION ended without RETURN→
1314Cursor statement must be a SELECT→
1315Cursor SELECT must not have INTO→
1316Undefined CURSOR→
1317Cursor is already open→
1318Cursor is not open→
1319Undeclared variable→
1320Incorrect number of FETCH variables→
1321No data — zero rows fetched, selected, or processed→
1322Duplicate parameter name→
1323Duplicate variable name→
1324Duplicate condition name→
1325Duplicate cursor name→
1326Failed to ALTER PROCEDURE→
1327Subselect value not supported→
1328Statement not allowed in stored function or trigger→
1329Variable or condition must be declared before cursors or handlers→
1330Cursor must be declared before handlers→
1331Case not found for CASE statement→
1332Configuration file is too big→
1333Malformed file type header→
1339Case not found for CASE statement (SQL expression)→
1340Division by 0→
1341Truncated incorrect value→
1342Invalid use of group function→
1343Table has unsupported extension in CREATE/ALTER→
1344A table must have at least 1 column→
1346Unknown character set→
1349SELECT would examine more than max_join_size rows→
1354Column used in key specification without key length cannot be NULL→
1355Duplicate foreign key constraint name→
1356View is invalid→
1359Event already exists→
1360Failed to store event→
1361Unknown event→
1362Failed to alter event→
1363Failed to drop event→
1367Illegal value for type→
1368CHECK OPTION of view prevents this update→
1369CHECK OPTION failed on view→
1370execute/create/alter/drop command denied for routine→
1372Password hash should be a 41-digit hex number→
1374Illegal GRANT/REVOKE for table→
1382Duplicate unique key→
1383BLOB/TEXT column used in key without key length→
1384All parts of a PRIMARY KEY must be NOT NULL→
1385Result consists of more than one row→
1386This table type requires a primary key→
1388UPDATE without WHERE that uses a KEY column blocked by safe update mode→
1390Cannot change binary logging format inside a stored function or trigger→
1391Cannot use temporary table with partitions→
1396Operation not allowed on slave→
1397Incorrect foreign key definition for referenced table→
1399Operand should contain N column(s)→
1400Subquery returns more than 1 row→
1401Unknown prepared statement handler→
1402Help database is corrupt or does not exist→
1404Converting column to character set→
1410Client does not support authentication protocol→
1411All parts of a SPATIAL index must be NOT NULL→
1412Table definition has changed, please retry transaction→
1413Duplicate handler declared in the same block→
1414OUT or INOUT argument is not a variable→
1415Not allowed to return a result set from a function→
1416Cannot get geometry object from data sent to GEOMETRY field→
1418Function has none of DETERMINISTIC, NO SQL, or READS SQL DATA→
1419You do not have SUPER privilege and binary logging is enabled→
1422Explicit or implicit commit not allowed in stored function or trigger→
1424Recursive stored functions and triggers are not allowed→
1425Too big scale for column→
1426Too big precision for column→
1427For DECIMAL(M,D), M must be >= D→
1428Can't combine WRITE locks for system and user tables→
1429Unable to connect to foreign data source→
1430Problem processing query on the foreign data source→
1431Table upgrade required — use REPAIR TABLE→
1432AGGREGATE is not supported for stored functions→
1433Cannot create more prepared statements than max_prepared_stmt_count→
1434Recursive views are not allowed→
1435Non-grouping field used in HAVING clause→
1436Table type does not support SPATIAL indexes→
1437Triggers cannot be created on system tables→
1439Failed to read auto-increment value from storage engine→
1442Cannot update table already in use by the invoking statement→
1443View definition contains GROUP BY or aggregate — update prevented→
1444Prepared statement contains a stored routine that refers back to itself→
1445Cannot set autocommit from a stored function or trigger→
1446Definer is not fully qualified — must be user@host→
1447View definition references a user that does not exist→
1448Insufficient privileges to view procedure/function with column-level grants→
1454No such grant defined for user on host on routine→
1455Data source specified for FEDERATED table does not exist→
1456Cannot create FEDERATED table — connection string format is invalid→
1458Cannot create FEDERATED table due to misconfigured data source→
1460Thread stack overrun — insufficient stack space→
1461Routine body is too long→
1463Display width out of range for column→
1464XA transaction ID already exists→
1465Datetime field overflow in date/time function→
1468Prepared statement contains too many placeholders→
1470Failed to DROP stored procedure→
1471Failed to CREATE stored procedure→
1472Recursive stored procedure exceeded max_sp_recursion_depth→
1473Cannot load routine — mysql.proc is missing or corrupt→
1474Incorrect routine name — contains invalid characters→
1475Table needs to be rebuilt to enable fast alter→
1476Query execution was interrupted by KILL QUERY→
1479Got a packet bigger than max_allowed_packet bytes→
1480Invalid column reference in LOAD DATA INFILE→
1481Being purged log file is not an active log file→
1482XA transaction branch was rolled back due to timeout→
1483XA transaction branch was rolled back→
1484No such grant defined for user on host on routine (SQLSTATE 42000)→
1485Data too long for column type→
1486Only LIST/RANGE partitions can use VALUES IN/LESS THAN→
1487MAXVALUE can only be used in the last partition definition→
1488Mismatch with number of subpartitions→
1489All partitions must be subpartitioned when subpartitioning is used→
1490Wrong number of partitions — mismatch with previous setting→
1491Wrong number of subpartitions defined→
1492Constant, random, or timezone-dependent expressions not allowed in partition function→
1493Expression in LIST/RANGE VALUES must be constant→
1494Field in partition function not found in table→
1495List of fields is only allowed in KEY partitions→
1496Partition info in frm file is inconsistent→
1497Partitioning function is not appropriate for this partitioning type→
1498For LIST partitions each partition must be defined→
1499VALUES LESS THAN value must be strictly increasing for each partition→
1500VALUES value must be of same type as partition function→
1501Multiple definition of same condition in stored routine handler→
1502Column(s) not allowed here in handler context→
1504Mix of storage handlers in partitions is not allowed→
1505For RANGE partitions each partition must be defined→
1506Too many partitions defined→
1507Subpartitioning only allowed with RANGE/LIST + HASH/KEY combination→
1508Failed to create storage handler file→
1509BLOB field is not allowed in partition function→
1510PRIMARY KEY must include all columns in the partitioning function→
1511Number of partitions cannot be 0→
1512Partition management operations not possible on non-partitioned table→
1513Foreign key constraint is not supported for partitioned tables→
1514Specified partition does not exist→
1515Cannot remove all partitions — use DROP TABLE instead→
1516COALESCE PARTITION can only be used on HASH/KEY partitions→
1517REORGANIZE PARTITION cannot change the number of HASH/KEY partitions→
1518REORGANIZE PARTITION without parameters only valid on auto-partitioned HASH/KEY tables→
1519REMOVE PARTITIONING can only be used on RANGE/LIST partitions→
1520New partitions must have the correct number of subpartitions→
1521At least one partition must be added→
1522At least one partition must be coalesced→
1523More partitions to reorganize than there are partitions→
1524Duplicate partition name→
1525Not allowed to execute binary log events on this table→
1526Partitions to reorganize must be consecutive→
1527REORGANIZE PARTITION cannot change total RANGE except at last partition→
1528Partition function not supported for this handler→
1531Plugin is not loaded→
1532Incorrect value provided for a variable or option→
1533Table has no partition for the given value→
1544Event already exists→
1545Failed to store event info→
1546Unknown event→
1547Failed to alter event→
1548Failed to drop the event→
1549Event interval must be positive and not too large→
1550Event end date is before start date→
1551Event execution time is in the past and ON COMPLETION NOT PRESERVE is set→
1552Failed to open mysql.event table→
1553Event must define a schedule or execute-at time→
1554Column count of mysql.event is wrong — table may be corrupt→
1555Cannot load from mysql.event — table is probably corrupt→
1556Failed to delete the event from mysql.event→
1557Error during compilation of event body→
1558New event name is the same as the old name→
1559Event data is too long for the column→
1560Cannot drop index needed for a foreign key constraint→
1561Temp table open prevents switching out of row-based replication→
1562Stored function prevents switching out of row-based replication→
1563NDB cluster cannot switch binlog format→
1564Partitioned tables cannot be temporary tables→
1565Partition constant domain error→
1566Partition function is not allowed→
1567DDL log error→
1568NULL value not allowed in VALUES LESS THAN→
1569Wrong partition name→
1570Cannot change transaction characteristics mid-transaction→
1571Duplicate entry for auto-increment column→
1572Event scheduler queue modification error→
1573Event scheduler: error setting variable→
1574Partition merge error→
1575Cannot activate binary log→
1576Row-based replication not available→
1577Base64 decode error→
1578Event recursion is forbidden→
1579Error reading from the mysql.event table→
1580Only integer values allowed here→
1581Unsupported storage engine for log tables→
1582Bad statement for log table operation→
1583Cannot rename a log table when logging is active→
1584Wrong parameter count to native function→
1585Wrong parameters to native function→
1586Wrong parameters to stored function→
1587Native function name collision with stored function→
1588Duplicate entry with key name→
1589Too many open files during binary log purge→
1590Event cannot be deleted→
1591Event body compilation error→
1592Event with same name already exists→
1593Event data too long→
1594Cannot drop index: needed by a foreign key constraint→
1595Deprecated syntax warning with version reference→
1596Cannot write-lock a log table→
1597Cannot lock a log table→
1598Foreign key duplicate entry→
1599Column count mismatch in system table — run mysql_upgrade→
1600Temporary table prevents switching out of row-based replication (session-level)→
1601Stored function prevents switching binlog format (session-level)→
1602Partition column list error→
1603Wrong type for column value in partition definition→
1604Too many fields in partitioning function→
1605MAXVALUE cannot be used in VALUES IN→
1606Too many values in VALUES IN for LIST COLUMNS partition→
1607Row-based VALUES IN requires parenthesized tuple→
1608Field type not allowed as partition field→
1609Partition fields too long→
1610Statement cannot be logged: mixed row and statement engines→
1611ROW binlog mode but engine requires statement-based logging→
1612Unsafe statement with statement-only engine and STATEMENT binlog format→
1613Row injection impossible: engine requires statement logging→
1614STATEMENT binlog mode but engine requires row-based logging→
1615Row injection impossible in STATEMENT binlog mode→
1616Multiple engines with self-logging engine prevents safe binary logging→
1617Statement with LIMIT is unsafe for statement-based replication→
1618INSERT DELAYED is unsafe for statement-based replication→
1619Statement accessing system tables is unsafe for replication→
1620INSERT into auto-increment column with SELECT is unsafe for statement-based replication→
1621Statement using UDF is unsafe for statement-based replication→
1622Statement using system variable is unsafe for statement-based replication→
1623Statement using system function is unsafe for statement-based replication→
1624Unsafe statement: non-transactional table written after transactional table in transaction→
1625Message and statement are both unsafe for replication→
1626Column type conversion failed on replica→
1627Replica cannot create conversion for column→
1628Cannot change binlog_format inside an active transaction→
1629The path specified is too long→
1630Deprecated syntax used with no replacement available→
1631Native table structure is wrong for this version→
1632Incorrect usage of Performance Schema table→
1633INFORMATION_SCHEMA table was skipped due to timeout or lock→
1634Cannot change binlog_direct_non_transactional_updates inside an active transaction→
1635Cannot change binlog_direct_non_transactional_updates inside a stored function or trigger→
1636Spatial index requires a NOT NULL geometry column→
1637Index comment is too long→
1638Aborted waiting on metadata lock — another connection holds a conflicting lock→
1639Value is out of range for column type→
1640Wrong type of stored procedure variable used in LIMIT clause→
1641Statement accesses both transactional and a self-logging non-transactional engine→
1642Statement contains both safe and unsafe operations for statement-based replication→
1643Cannot change sql_log_bin inside an active transaction→
1644Cannot change sql_log_bin inside a stored function or trigger→
1645Failed to read from .par partition file→
1646VALUES in VALUES LESS THAN must be an integer or MAXVALUE→
1647Access denied for user (no password provided)→
1648SET PASSWORD is not supported for users with an authentication plugin→
1649GRANT would create a new account but user already exists with a different plugin→
1650Cannot truncate table referenced by a foreign key→
1651Plugin cannot be uninstalled — it is required by the server→
1652Heartbeat frequency is below the minimum allowed value→
1653Heartbeat frequency exceeds the maximum allowed value→
1654NDB replication schema error→
1655Error parsing conflict function specification in ndb_replication table→
1656Error writing to NDB exceptions table→
1657Table comment is too long→
1658Replica configuration error→
1659InnoDB full-text index limit reached→
1660InnoDB full-text index cannot be created on temporary tables→
1661InnoDB full-text FTS_DOC_ID column has wrong definition→
1662InnoDB full-text FTS_DOC_ID_INDEX index has wrong definition→
1663Online ALTER TABLE row log exceeded innodb_online_alter_log_max_size→
1664Unknown ALTER TABLE ALGORITHM value→
1665Unknown ALTER TABLE LOCK value→
1666Cannot run CHANGE MASTER when parallel replication has gaps→
1667Multi-threaded replication recovery failed→
1668Multi-threaded replication worker reset required→
1669Column count in internal system table does not match expected value→
1670Replica silently retried a transaction→
1671Cannot DISCARD TABLESPACE while foreign key checks are running→
1672Table schema does not match the tablespace being imported→
1673Table cannot be moved from the system tablespace→
1674I/O read error occurred→
1675I/O write error occurred→
1676Tablespace file is missing→
1677Tablespace already exists→
1678Tablespace has been discarded→
1679Internal error→
1680InnoDB IMPORT TABLESPACE failed→
1681Integer display width is deprecated and will be removed in a future release→
1682The ZEROFILL attribute is deprecated and will be removed in a future release→
1683InnoDB full-text auxiliary table name does not contain a hex table ID→
1684Old temporal columns found; they need to be upgraded to the new format→
1685Cannot execute DML or DDL while innodb_force_recovery > 0→
1686The initialization vector supplied to aes_encrypt is too short→
1687Plugin cannot be uninstalled because it is required→
1688Statement is unsafe because it is being split into multiple statements while a GTID is assigned→
1689Replica has more GTIDs than the source→
1690A required key is missing for table→
1691Named pipe access is granted to everyone (security risk)→
1692Unexpected GTIDs found on the replica that are not in the source binlog→
1693A list of fields is not allowed in HASH partitioning→
1694Inconsistent partition information for table→
1695PARTITION clause used on a non-partitioned table→
1696Cannot execute FLUSH statement in stored function or trigger→
1697Illegal REVOKE of a grant not held by user→
1698Generic error reported on the replication source→
1699Inconsistent error information returned from storage engine→
1700Storage engine is not loaded→
1701GET STACKED DIAGNOSTICS cannot be used outside a condition handler→
1702Legacy SQL syntax was automatically converted to the new syntax→
1703Statement is unsafe for replication with full-text parser plugin→
1704Cannot DISCARD or IMPORT tablespace for a temporary table→
1705Foreign key cascade depth exceeded maximum limit→
1706Column count of mysql.* table is wrong; please run mysql_upgrade→
1707Trigger does not have CREATED attribute in its definition→
1708Error in the body of an unknown trigger→
1709Index column size too large; the maximum column size is 767 bytes→
1710Error in the body of trigger→
1711Referenced trigger does not exist→
1712EXPLAIN is not supported for this statement→
1713Invalid column size or precision specified→
1714Missing storage engine CREATE option→
1715Storage engine is out of memory→
1716Cannot set password expiration for anonymous user→
1717The SQL thread must be stopped before issuing this command→
1718Full-text search is not supported in a materialised subquery→
1719InnoDB undo log is full; cannot rollback the transaction→
1720UNINSTALL PLUGIN is not permitted for this plugin→
1721INSTALL PLUGIN is not permitted for this plugin→
1722Unsafe statement: INSERT ... SELECT on a table with AUTO_INCREMENT→
1723Unsafe statement: CREATE TABLE ... SELECT on a table with AUTO_INCREMENT→
1724Unsafe statement: INSERT into table with two or more unique keys→
1725Table is being used in a foreign key check and cannot be modified→
1726Storage engine does not support the requested operation→
1727Unsafe statement: AUTO_INCREMENT column is not the first column in the index→
1728Cannot load from mysql system table; table may be corrupted→
1729MASTER_DELAY value is out of the valid range→
1730Only format description and row events are allowed in BINLOG statements→
1731Tables have different definitions for ALTER TABLE ... EXCHANGE PARTITION→
1732Exchange table must not be a partitioned table→
1733Exchange table must not be a temporary table→
1734Partition name expected but subpartition name given→
1735Unknown partition name specified→
1736Tables have different metadata for EXCHANGE PARTITION→
1737Found rows in the exchange table that do not match the partition definition→
1738binlog_cache_size is greater than max_binlog_cache_size→
1739Index hint ignored because it is not applicable to the query→
1740Cannot use EXCHANGE PARTITION when the table has foreign key constraints→
1741No such key value in referenced table→
1742Replication info data too long→
1743Network read event checksum failure→
1744Binlog file read event checksum failure→
1745Binlog statement cache size exceeds max binlog cache size→
1746Cannot update table in CREATE TABLE ... SELECT→
1747PARTITION clause used on non-partitioned table→
1748Row does not match any of the given partition set→
1749Named partition does not exist (unused code)→
1750Failed to change replication info repository→
1751Incomplete rollback — created temporary table not rolled back→
1752Incomplete rollback — dropped temporary table not restored→
1753Multi-threaded slave feature not supported→
1754MTS: number of updated databases exceeds limit→
1755MTS: event cannot be executed in parallel→
1756MTS: inconsistent data detected→
1757FULLTEXT indexes not supported on partitioned tables→
1758Invalid condition number in RESIGNAL/GET DIAGNOSTICS→
1759Sending passwords in plain text is insecure→
1760CHANGE MASTER TO without SSL is insecure→
1761Foreign key constraint violation — duplicate key with child info→
1762Foreign key constraint violation — no child table info available→
1763Cannot execute statement in a READ ONLY transaction→
1764Too many fields in SELECT→
1765Too many key parts specified→
1766Named database does not exist→
1767Cannot delete parent row — foreign key constraint→
1768Malformed communication packet→
1769Server is in read-only mode→
1770GTID_NEXT is set to an undefined GTID→
1771Variable cannot be set inside a stored procedure→
1772Cannot set gtid_purged when gtid_mode is OFF→
1773Cannot set gtid_purged when gtid_executed is not empty→
1774Cannot set gtid_purged while transactions are in-flight→
1775gtid_purged was changed→
1776gtid_executed was changed→
1777Binlog statement mode and no replicated tables→
1778ALTER TABLE operation not supported→
1779ALTER TABLE operation not supported — specific reason→
1780ALTER TABLE requires COPY algorithm→
1781ALTER TABLE INPLACE not supported with partitioning change→
1782INPLACE ALTER not supported when renaming a column with foreign key→
1783INPLACE ALTER not supported due to column type change→
1784INPLACE ALTER not supported with foreign key check→
1785INPLACE ALTER not supported with IGNORE→
1786INPLACE ALTER not supported — table has no primary key→
1787INPLACE ALTER not supported — AUTO_INCREMENT column change→
1788INPLACE ALTER not supported — hidden FTS document ID column→
1789INPLACE ALTER not supported — FULLTEXT index change→
1790INPLACE ALTER not supported — FULLTEXT-related reason→
1791sql_slave_skip_counter cannot be set in GTID mode→
1792Duplicate entry found in index — value unknown→
1793Identifier causes file path to be too long→
1794INPLACE ALTER not supported — NOT NULL constraint added→
1795Password must be changed before any other operation→
1796Row found in wrong partition→
1797MTS: event size exceeds slave_pending_jobs_size_max→
1798InnoDB FULLTEXT does not support user-defined parsers→
1799Binlog logical clock conflict→
1800Deprecated master info option used→
1801→
1802→
1803→
1804→
1805→
1806→
1807→
1808→
1809→
1810→
1811→
1812→
1813→
1814→
1815→
1816→
1817→
1818→
1819→
1820→
1821→
1822→
1823→
1824→
1825→
1826→
1827→
1828→
1829→
1830→
1831→
1832→
1833→
1834→
1835→
1836→
1837→
1838→
1839→
1840→
1841→
1842→
1843→
1844→
1845→
1846→
1847→
1848→
1849→
1850→
1851→
1852→
1853→
1854→
1855→
1856→
1857→
1858→
1859→
1860→
1861→
1862→
1863→
1864→
1865→
1866→
1867→
1868→
1869→
1870→
1871→
1872→
1873→
1874→
1875→
1876→
1877→
1878→
1879→
1880→
1881→
1882→
1883→
1884→
1885→
1886→
1887→
1888→
1889→
1890→
1891→
1892→
1893→
1894→
1895→
1896→
1897→
1898→
1899→
1900→
1901→
1902→
1903→
1904→
1905→
1906→
1907→
1908→
1909→
1910→
1911→
1912→
1913→
1914→
1915→
1916→
1917→
1918→
1919→
1920→
1921Error during compilation of event's body→
1922Same old and new event name→
1923Event data too long→
1924Cannot drop index needed in a foreign key constraint→
1925Deprecated syntax used; will be removed in a future version→
1926Cannot lock log table for write→
1927Cannot lock log table→
1928Foreign key constraint leads to a duplicate key→
1929Column count of table does not match; please update→
1930Temporary tables exist; cannot switch to row-based logging→
1931Stored function or trigger prevents switch out of row-based logging→
1932For LIST COLUMNS and RANGE COLUMNS partitioning, the column list must not be empty→
1933Incorrect type value for column→
1934Too many fields in partition function→
1935MAXVALUE cannot be used with LIST partitioning→
1936Too many values specified for column list→
1937Partition row expression can only contain a single column value→
1938Field is of a not allowed type for this type of partitioning→
1939The total length of the partition expression is too long→
1940Cannot mix transactional and non-transactional engines in the same transaction with this binlog format→
1941Cannot modify a table that is being used by a stored function or trigger→
1942The definition of a view prevents the underlying table from being updated→
1943Recursive stored procedure call is not supported→
1944Not allowed to set autocommit from a stored function or trigger→
1945Malformed DEFINER clause→
1946View '%s'.'%s' has no definer information in the view file→
1947Invoker does not have privilege to view the definer→
1948There is no such user→
1949Cannot change schema for a multi-schema transaction→
1950Cannot delete or update a parent row: a foreign key constraint fails→
1951Cannot add or update a child row: a foreign key constraint fails→
1952Variable already exists with this name→
1953Trigger does not have DEFINER information in the trigger file→
1954Table upgrade required. Please run "REPAIR TABLE `%s`" or dump/reload to fix it→
1955Recursive limit exceeded for stored procedure→
1956Failed to load routine. The table mysql.proc is missing, corrupt, or contains bad data→
1957Incorrect stored procedure name→
1958Table needs to be upgraded; run CHECK TABLE→
1959AGGREGATE is not supported for stored functions→
1960Can't create more than max_prepared_stmt_count statements→
1961View contains a recursive reference→
1962Non-grouping field is used in HAVING clause→
1963The storage engine for the table does not support BLOB/TEXT or GIS columns→
1964Spatial column %s is not defined→
1965Error in regular expression→
1966Incorrect value for column→
1967Illegal value for type→
1968CHECK OPTION on a non-updatable view→
1969Feature disabled; you need MySQL built with this feature→
1970The MySQL server is running with the --option option so it cannot execute this statement→
1971Column has duplicated value in SET/ENUM definition→
1972Truncated incorrect value→
1973Character set '%s' cannot be used in conjunction with collation '%s' to sort in order→
1974Variable is a LOCAL variable→
1975Variable is a GLOBAL variable→
1976Variable has no default value→
1977Variable cannot be set to the value of given expression→
1978Incorrect argument type to variable→
1979Variable can only be set, not read→
1980Incorrect usage of option→
1981This feature is not supported yet→
1982Fatal error reading binary log on master→
1983Replica ignored table due to replication filter→
1984Variable is global or local only→
1985Incorrect foreign key definition→
1986Key reference and table reference do not match→
1987Operand should contain N column(s)→
1988Subquery returns more than one row→
1989Unknown HANDLER statement→
1990MySQL help database is corrupt or missing→
1991Cyclic reference in stored routines or views→
1992Converting column to a different type→
1993Reference to field not allowed in this context→
1994Every derived table must have its own alias→
1995Select in a subquery is reduced→
1996Table name not allowed in this context→
1997Client does not support authentication protocol→
1998Spatial index on column with NULL values not allowed→
1999Collation and character set mismatch→
2000Aborting connection due to client error→
2001Network read error from master during replication→
2002Network write error to replica during replication→
2003Too many connections for this user→
2004Only constants are allowed here→
2005Deadlock found when trying to get lock→
2006View column list does not match SELECT→
2007Query cache cleanup warning→
2008No paths allowed for shared library→
2009Function already exists→
2010Cannot open shared library for UDF→
2011Cannot find function symbol in shared library→
2012Function is not defined→
2013Host is blocked due to too many connection errors→
2014Host is not allowed to connect→
2015Anonymous user cannot use password→
2016Password change not allowed for this user→
2017Password hash does not match→
2018Rows matched / changed / warnings info→
2019Cannot create new thread→
2020Column count does not match value count at row N→
2021Cannot reopen table in the same query→
2022Invalid use of NULL value→
2023Error in regular expression→
2024Mixing aggregate and non-aggregate columns without GROUP BY→
2025There is no such grant defined for user on host→
2026Table-level access denied→
2027Column-level access denied→
2028Illegal GRANT or REVOKE command→
2029Invalid hostname or username in GRANT→
2030Table does not exist→
2031No such grant for table→
2032Command not allowed with this MySQL version or configuration→
2033Syntax error in SQL statement→
2034INSERT DELAYED cannot change lock→
2035Too many delayed insert handler threads→
2036Aborting connection to database→
2037Got a packet bigger than max_allowed_packet→
2038Read error from named pipe→
2039Error from fcntl() on network socket→
2040Packets out of order from client→
3000→
3001→
3002→
3003→
3004→
3005→
3006→
3007→
3008→
3009→
3010→
3011→
3012→
3013→
3014→
3015→
3016→
3017→
3018→
3019→
3020→
3021→
3022→
3023→
3024→
3025→
3026→
3027→
3028→
3029→
3030→
3031→
3032→
3033→
3034→
3035→
3036→
3037→
3038→
3039→
3040→
3041→
3042→
3043→
3044→
3045→
3046→
3047→
3048→
3049→
3050→
3051→
3052→
3053→
3054→
3055→
3056→
3057→
3058→
3059→
3060No database selected→
3061Unsafe statement with full-text plugin in binlog→
3062Replication channel I/O thread must be stopped→
3063Open temporary tables must be zero for this operation→
3064MASTER_LOG_FILE specified without MASTER_LOG_POS→
3065Query execution was interrupted (maximum statement execution time exceeded)→
3066MAX_EXECUTION_TIME hint is ignored for non-SELECT statements→
3067Replication channel does not exist→
3068Replication channel already exists→
3069FOR CHANNEL clause required for multi-source replication→
3070Deprecated syntax warning→
3071Deprecated syntax with no replacement→
3072Wrong structure for native performance schema table→
3073Incorrect use of Performance Schema table→
3074INFORMATION_SCHEMA table was skipped→
3075Cannot change binlog_direct_non_transactional_updates inside a transaction→
3076Cannot change binlog_direct_non_transactional_updates inside a stored function or trigger→
3077Spatial index must be on a geometry column→
3078Index comment is too long→
3079Lock wait was aborted→
3080Data value is out of range for the column→
3081LIMIT clause requires an integer value→
3082Unsafe binlog statement: mixed engines with self-logging engine→
3083Unsafe mixed statement in binlog→
3084Cannot change sql_log_bin inside a transaction→
3085Cannot change sql_log_bin inside a stored function or trigger→
3086Failed to read partition .par file→
3087RANGE/LIST partition values must be integers→
3088Access denied (no password provided)→
3089SET PASSWORD not supported with this authentication plugin→
3090GRANT user already identified via a plugin→
3091TRUNCATE not allowed due to foreign key constraint→
3092Plugin cannot be uninstalled→
3093Slave heartbeat period below minimum→
3094Slave heartbeat period above maximum→
3095NDB replication schema error→
3096NDB conflict function parse error→
3097NDB exceptions table write error→
3098Table comment is too long→
3099Incorrect or missing replication slave configuration→
3100InnoDB full-text search limit exceeded→
3101ALTER TABLE with FK on generated column not supported in-place→
3102Cannot add foreign key on virtual generated column→
3103In-place ALTER not supported for this virtual column operation→
3104Invalid ON UPDATE/DELETE option for foreign key on generated column→
3105Cannot specify a value for a generated column→
3106Unsupported action on generated column→
3107Generated column references a column defined after it→
3108Column is used by a generated column and cannot be dropped→
3109Generated column cannot reference an AUTO_INCREMENT column→
3110Feature not available in this MySQL edition→
3111Cannot use SET PERSIST for this variable→
3112Variable cannot be set as command-line argument at server start→
3113Clone operation blocked by concurrent DDL→
3114Cannot set gtid_purged when GTID mode is OFF→
3115Cannot set gtid_purged when gtid_executed is not empty→
3116Cannot set gtid_purged when there are owned GTIDs→
3117gtid_purged was changed→
3118gtid_executed was changed→
3119Statement-based binlog mode cannot be used without replicated tables→
3120ALTER TABLE operation not supported for this reason→
3121ALTER TABLE copy algorithm not supported for this reason→
3122ALTER TABLE not supported because table is partitioned→
3123ALTER TABLE not supported: foreign key rename requires table copy→
3124ALTER TABLE not supported: column type change requires table copy→
3125ALTER TABLE not supported: foreign key check requires table copy→
3126ALTER TABLE IGNORE not supported with INPLACE algorithm→
3127ALTER TABLE not supported: table has no primary key→
3128ALTER TABLE not supported: AUTO_INCREMENT change requires table copy→
3129ALTER TABLE not supported: hidden FTS_DOC_ID column present→
3130ALTER TABLE not supported: changing FULLTEXT index requires table copy→
3131ALTER TABLE not supported: table has FULLTEXT index→
3132sql_slave_skip_counter cannot be set when GTID mode is ON→
3133Duplicate value in index but value is unknown→
3134Identifier causes too long file path→
3135ALTER TABLE not supported: adding NOT NULL requires table copy→
3136You must change your password before executing this statement→
3137Found row in wrong partition→
3138Multi-threaded slave: event size exceeds max pending jobs size→
3139InnoDB: FULLTEXT index does not use a parser plugin→
3140Deprecated syntax used (always deprecated)→
3141Row size exceeded allowed packet; skipped→
3142Conflicting declarations in stored program→
3143CASE statement has no matching WHEN clause and no ELSE→
3144ST_Contains function not implemented for this geometry type→
3145ST_Union function not implemented for this geometry type→
3146ST_Difference function not implemented for this geometry type→
3147ST_SymDifference function not implemented for this geometry type→
3148Too many values in table-level lookup→
3149Deprecated syntax used (note level)→
3150Integer display width is deprecated→
3151ZEROFILL attribute is deprecated→
3152JSON_TABLE: error processing field→
3153JSON_TABLE requires an alias→
3154JSON_TABLE: scalar value expected for column→
3155JSON_TABLE: multiple matches found for column path→
3156JSON_TABLE can only be used in the FROM clause→
3157Invalid JSON type→
3158Cannot convert string to the required character set→
3159Deprecated identifier used→
3160Deprecated internal function used→
3161Window function used in invalid context→
3162Window function cannot redefine ORDER BY from named window→
3163RANGE frame bound must be a constant→
3164Duplicate window name in WINDOW clause→
3165Derived window cannot define PARTITION BY if base window does→
3166Derived window cannot inherit a frame from a base window with ORDER BY→
3167Derived window cannot redefine ORDER BY of base window→
3168Window function cannot be used with this aggregation→
3169Window function result alias cannot be used in WHERE or GROUP BY→
3170Window functions cannot be nested→
3171ROWS mode window frame cannot use INTERVAL bounds→
3172Window specification ignores GROUP BY / ORDER BY from outer query→
3173Window function details available in EXPLAIN FORMAT=JSON→
3174Window function ignores frame specification→
3175RANGE window frame requires ORDER BY→
3176UNBOUNDED FOLLOWING can only be the frame end, not start→
3177EXCLUDE CURRENT ROW requires BETWEEN frame→
3178Illegal window frame end specification→
3179Window frame specification is illegal→
3180RANGE frame impossible for row type→
3181RANGE frame requires ORDER BY→
3182Illegal window frame start specification→
3183RANGE frame offset must be numeric→
3184RANGE frame offset must be interval for datetime ORDER BY→
3185Window frame specification is illegal (variant 2)→
3186Window function requires GROUP BY or ORDER BY→
3187Window ORDER BY mismatch with named window→
3188Illegal ORDER BY in window function→
3189Window functions not supported in this context→
3190Invalid number of arguments→
3191Field in GROUPING() is not in GROUP BY→
3192Named window misplaced or not found→
3193Invalid use of aggregate function→
3194Out of memory saving to data dictionary→
3195SET PERSIST_ONLY denied — insufficient privileges→
3196Command requires SUPER privilege→
3197File path violates secure_file_priv restriction→
3198Too many concurrent InnoDB transactions→
3199Replica requires full row image for this operation→
3200Replica requires row-based binary log format→
3201Replica does not support caching_sha2_password authentication→
3202SQL mode not supported in this context→
3203Function not allowed in generated column expression→
3204Invalid default expression for generated column→
3205Generated column comment exceeds maximum length→
3206Invalid foreign key option for generated column→
3207Column used by a default generated column cannot be dropped→
3208Incorrect column name→
3209Cannot modify GTID_EXECUTED — it is read-only→
3210Out of memory while computing InnoDB statistics→
3211Replication channel thread cannot stop→
3212InnoDB tablespace (.ibd) file is missing→
3213InnoDB redo log data missing→
3214Named tablespace is missing→
3215Incorrect file name→
3216Tablespace encryption error→
3217Cannot find encryption key in keyring→
3218Internal capacity exceeded→
3219Capacity exceeded in range optimizer→
3220Table needs rebuild after upgrade→
3221Deprecated syntax warning with version information→
3222Error reading master info (variant 2)→
3223Master info not found→
3224Duplicate constant value in LIST partition definition→
3225Mixed explicit and implicit values in ENUM partition→
3226HASH partition reorganization must use the same number of partitions→
3227Invalid lock service name or identifier→
3228Locking service deadlock detected→
3229Locking service lock acquisition timed out→
3230Invalid or malformed spatial data→
3231Unsupported argument type for spatial function→
3232Unknown GIS error→
3233Unknown GIS exception→
3234Spatial operation on geometries with different SRIDs→
3235Unsupported spatial operation for the given geometry types→
3236SRID mismatch in spatial aggregation function→
3237Bounding box geometry needs more points→
3238Invalid argument to spatial function→
3239Maximum number of points in geometry exceeded→
3240Too few records returned by subquery→
3241NULL value inserted into NOT NULL column→
3242ctype array is too short for character set→
3243Index cannot be used for this query→
3244Geometry byte order is wrong endianness→
3245Replication source password exceeds maximum length→
3246mysql.user table has old-length column→
3247MAX_WAIT_TIMEOUT is not supported for this statement→
3248Invalid use of OLD/NEW in trigger context→
3249Plugin installation failed→
3250Replication worker thread could not process event→
3251Replication filters cannot be deleted→
3252Replication filters table cannot be opened→
3253Replication IO thread delay option is not supported→
3254Replication SQL thread delay option is not supported→
3255No such replication filter→
3256CHANGE REPLICATION FILTER is prohibited→
3257Syntax error near COLLATE clause→
3258Collation does not match character set→
3259ORDER BY with aggregate in UNION context is not supported→
3260ORDER BY with aggregate in non-aggregate query context→
3261Replication channel does not support this option→
3262RESET MASTER TO value is out of range→
3263Unresolved window name in window function→
3264PARTITION BY cannot be used in a window reference→
3265Partition to reorganize before does not exist→
3266Window frame with RANGE requires ORDER BY with exactly one key→
3267RANGE frame with numeric offset requires numeric ORDER BY→
3268RANGE frame with interval offset requires datetime ORDER BY→
3269RANGE frame is not compatible with this ORDER BY type→
3270GIS function not supported for geographic SRS→
3271Spatial reference system not found→
3272Source CRS for ST_Transform is not supported→
3273Target CRS for ST_Transform is not supported→
3274ST_Transform source CRS is not geographic→
3275ST_Transform target CRS is not geographic→
3276SRS is not a Cartesian coordinate system→
3277SRS is not a geographic coordinate system→
3278Wrong coordinate system type for spatial function→
3279SRS definition has an invalid latitude of origin→
3280SRS definition has an invalid longitude of origin→
3281Spatial reference system not found (alternate context)→
3282SRS is not Cartesian (alternate context)→
3283Unsupported parameter type in prepared statement→
3284Invalid use of window function alias→
3285Derived table cannot be used in this context with CTE→
3286Recursive CTE must use UNION→
3287Recursive CTE must have non-recursive anchor first→
3288Recursive CTE recursive member cannot use aggregation→
3289Recursive CTE self-reference must be leftmost in JOIN→
3290Maximum recursion depth exceeded in recursive CTE→
3291Recursive CTE recursive member cannot use LIMIT→
3292Recursive CTE recursive member cannot use DISTINCT→
3293Recursive CTE recursive member cannot use window functions→
3294Optimizer hint is not applicable to this query→
3295Optimizer hint was ignored→
3296Variable cannot be set inside a transaction→
3297Variable is global only and cannot be set at session level→
3298Logfile group not found→
3299Invalid combination of options→
3300Consistent snapshot inconsistency→
3301InnoDB full-text auxiliary table ID is not a valid hex value→
3302Replica has the same server-id as the source — circular replication loop detected→
3303Replication connection timed out→
3304Failed to parse the Spatial Reference System WKT definition→
3305Spatial Reference System projection parameter is missing→
3306Spatial Reference System not found→
3307Spatial Reference System name cannot be NULL→
3308Spatial Reference System name cannot be an empty string→
3309SRS organization name cannot be NULL or empty→
3310Mandatory attribute missing from Spatial Reference System definition→
3311Multiple best-match Spatial Reference Systems found→
3312No usable geographic CRS found for the operation→
3313SRS organization and coordsys_id already defined for another SRID→
3314Spatial Reference System already exists→
3315Spatial Reference System SRID already exists→
3316Spatial Reference System not found; axis order may be incorrect→
3317No access to native function→
3318RESET MASTER TO value is out of range→
3319Resource group not found→
3320Failed to bind thread to resource group→
3321Invalid VCPU ID specified for resource group→
3322Invalid VCPU range specified for resource group→
3323Invalid thread priority value for resource group→
3324Operation not allowed on this resource group→
3325Resource group is busy and cannot be altered or dropped→
3326Resource group already exists→
3327Invalid use of FORCE INDEX→
3328Variable is set but not used→
3329Too many rows returned by FIND_IN_SET or similar function→
3330Cannot drop column that participates in a foreign key constraint→
3331InnoDB I/O capacity exceeded→
3332Cannot change or drop SRS that is used by a spatial column→
3333Invalid default value for ENUM column→
3334SRID used in non-spatial column context→
3335Spatial column requires an explicit SRID→
3336Cannot perform spatial operation on geometries with different SRIDs→
3337Native table structure is wrong; repair required→
3338Keyring UDF: keyring service is unavailable→
3339Keyring migration status message→
3340Keyring migration failed→
3341Access denied to keyring operation→
3342Keyring file has incorrect permissions→
3343Keyring file data is corrupt→
3344Invalid hash type for locking clause→
3345Cannot change child foreign key column→
3346Cannot change parent foreign key column→
3347Functional index cannot be created on a plain column reference→
3348Functional index cannot be used as or contain a PRIMARY KEY→
3349Functional index cannot use a JSON or geometry return-type function→
3350Functional index cannot reference AUTO_INCREMENT column→
3351Functional index expression cannot evaluate to NULL for all rows→
3352A row inserted into a functional index cannot produce a NULL key value→
3353Column cannot be dropped because it is used by a functional index→
3354Functional index cannot be created on a LOB (BLOB/TEXT) column→
3355Function is not allowed in a functional index expression→
3356Functional index cannot be a FULLTEXT index→
3357Functional index cannot be a spatial index→
3358Functional index key column has an incorrect type→
3359Functional index data column is itself a functional (generated) column→
3360Functional index not applicable→
3361FULLTEXT search not allowed with ROLLUP→
3362Missing ICU regular expression library file→
3363Privilege cannot be granted at this level→
3364Access denied to system schema→
3365Aggregate function not allowed in column default value→
3366Ambiguous field or line terminator in LOAD DATA→
3367Invalid ROW SEPARATOR in LOAD DATA→
3368Non-aggregated column in SELECT list with GROUP BY (v2)→
3369Non-aggregated column used with non-aggregate function in GROUP BY context→
3370Table does not belong to the specified tablespace→
3371Encrypted tablespace requires a keyring key→
3372Undo log encryption error→
3373Redo log encryption error→
3374Keyring plugin data is corrupt→
3375Invalid tablespace name→
3376Tablespace encryption not supported by the storage engine→
3377Tablespace cannot be encrypted→
3378Tablespace cannot be decrypted→
3379Source server treats UPDATE as an event→
3380CREATE TEMPORARY TABLE in transaction is unsafe with GTIDs→
3381Wrong usage of partition pruning→
3382Cannot lock system table in this context→
3383Cannot grant roles to anonymous user→
3384Role has not been granted to user→
3385Circular role grant detected→
3386Role already exists→
3387Role not found→
3388Roles cannot be granted to an anonymous user→
3389Malformed role name→
3390Role cycle detected in the role hierarchy→
3391Cannot revoke a mandatory role from user→
3392Dynamic privilege not registered→
3393Dynamic privilege already exists→
3394XA transactions are incompatible with replication filters→
3395Cannot grant system privilege to a mandatory role→
3396Table already exists in the specified tablespace→
3397Cannot drop tablespace when encryption is disabled→
3398Tablespace is missing (alternate error path)→
3399Tablespace is not a shared tablespace→
3400Cannot change tablespace access mode→
3401Cannot change tablespace type→
3402Invalid encryption request→
3403Cannot find table in foreign key cache→
3404Cannot find column in foreign key cache→
3405Cannot change foreign key child column (alternate path)→
3406Foreign key column not found in table→
3407Foreign key child table has no index for the constraint→
3408Foreign key parent table has no index for the referenced column→
3409Failed to add foreign key to system tables→
3410Cannot drop parent table: foreign key constraint exists→
3411Cannot open parent table for foreign key validation→
3412Wrong number of partitions for HASH partitioning→
3413User account renamed to deprecated form→
3414Partitioning not supported by storage engine (alternate path)→
3415Partition pruning not applicable for subpartitions→
3416Wrong value used in RANGE partition definition→
3417Wrong default partition for column value→
3418Wrong number of partition data values→
3419Wrong number of subpartition data values→
3420→
3421→
3422→
3423→
3424→
3425→
3426→
3427→
3428→
3429→
3430→
3431→
3432→
3433→
3434→
3435→
3436→
3437→
3438→
3439→
3440→
3441→
3442→
3443→
3444→
3445→
3446→
3447→
3448→
3449→
3450→
3451→
3452→
3453→
3454→
3455→
3456→
3457→
3458→
3459→
3460→
3461→
3462→
3463→
3464→
3465→
3466→
3467→
3468→
3469→
3470→
3471→
3472→
3473→
3474→
3475→
3476→
3477→
3478→
3479→
3480→
3481→
3482→
3483→
3484→
3485→
3486→
3487→
3488→
3489→
3490→
3491→
3492→
3493→
3494→
3495→
3496→
3497→
3498→
3499→
3500→
3501→
3502→
3503→
3504→
3505→
3506→
3507→
3508→
3509→
3510→
3511→
3512→
3513→
3514→
3515→
3516→
3517→
3518→
3519→
3520→
3521→
3522→
3523→
3524→
3525→
3526→
3527→
3528→
3529→
3530→
3531→
3532→
3533→
3534→
3535→
3536→
3537→
3538→
3539→
3540→
3541→
3542→
3543→
3544→
3545→
3546→
3547→
3548→
3549→
3550→
3551→
3552→
3553→
3554→
3555→
3556→
3557→
3558→
3559→
3560→
3561→
3562→
3563→
3564→
3565→
3566→
3567→
3568→
3569→
3570→
3571→
3572→
3573→
3574→
3575→
3576→
3577→
3578→
3579→
3580→
3581→
3582→
3583→
3584→
3585→
3586→
3587→
3588→
3589→
3590→
3591→
3592→
3593→
3594→
3595→
3596→
3597→
3598→
3599→
3600Partial revoke not supported with GRANT OPTION→
3601Partial revoke not supported with privilege aggregation→
3602Partial revoke already exists (variant 2)→
3603LOAD DATA access denied for user→
3604Default expression overrides GENERATED ALWAYS column→
3605Unexpected geometry type in spatial operation→
3606SRS definition missing mandatory attribute (variant 2)→
3607Geographic SRS not supported for this operation→
3608Cartesian SRS not supported for this operation→
3609Redundant constraint ignored→
3610Constant value in conditional expression→
3611Deprecated syntax in CASE expression→
3612Table function cannot be used over a UNION→
3613Spatial index expression not allowed here→
3614Cannot change nullable column to NOT NULL with existing NULL data→
3615Cannot drop column referenced by a functional index→
3616Trigger is incompatible with the foreign key constraint→
3617Deprecated collation found in dump file→
3618Resource group not found (variant 3)→
3619Failed to bind thread to resource group→
3620Online ALTER not supported for virtual column change→
3621Access denied — user account is locked→
3622Duplicate key in partial revoke grant table→
3623Deprecated user option in CREATE/ALTER USER→
3624Operation not permitted for anonymous user→
3625Invalid authentication option in user definition→
3626Multi-factor authentication not supported by this plugin→
3627Authentication factor not set for user→
3628Authentication factor mismatch→
3629Authentication factor not allowed for anonymous user→
3630Authentication factor requires device registration→
3631MFA method not registered→
3632MFA methods specified in invalid order→
3633MFA methods cannot be identical→
3634Authentication policy does not match required configuration→
3635Authentication factor cannot be FIDO2 for this usage→
3636This authentication position must use FIDO2→
3637FIDO device registration is required→
3638FIDO device registration did not complete successfully→
3639FIDO assertion verification failed→
3640FIDO device not found→
3641Dynamic privilege does not exist for this user→
3642Aggregate function not allowed in window function or lateral derived table→
3643JSON_TABLE column has multiple path expressions→
3644JSON_TABLE column missing required PATH→
3645JSON_TABLE must have an alias→
3646Data type not allowed in JSON_TABLE column→
3647JSON_TABLE column or nested path requires an alias (variant 2)→
3648InnoDB full-text search result cache limit exceeded→
3649Cannot create full-text index in InnoDB read-only mode→
3650InnoDB tablespace to drop was not found→
3651InnoDB undo tablespace is not empty→
3652Too many indexes defined on table (variant 2)→
3653Column count mismatch in SELECT (variant 2)→
3654Replica channel partially resumed after error→
3655Replica channel is not stopped→
3656Replica has exhausted all retries for the failed transaction→
3657Replication network packet exceeds max_allowed_packet→
3658replica_pending_jobs_size_max smaller than max_allowed_packet→
3659Replica wait for primary timeout exceeded→
3660→
3661→
3662→
3663→
3664→
3665→
3666→
3667→
3668→
3669→
3670→
3671→
3672→
3673→
3674→
3675→
3676→
3677→
3678→
3679→
3680→
3681→
3682→
3683→
3684→
3685→
3686→
3687→
3688→
3689→
3690→
3691→
3692→
3693→
3694→
3695→
3696→
3697→
3698→
3699→
3700→
3701→
3702→
3703→
3704→
3705→
3706→
3707→
3708→
3709→
3710→
3711→
3712→
3713→
3714→
3715→
3716→
3717→
3718→
3719→
3720→
3721→
3722→
3723→
3724→
3725→
3726→
3727→
3728→
3729→
3730→
3731→
3732→
3733→
3734→
3735→
3736→
3737→
3738→
3739→
3740→
3741→
3742→
3743→
3744→
3745→
3746→
3747→
3748→
3749→
3750→
3751→
3752→
3753→
3754→
3755→
3756→
3757→
3758→
3759→
3760→
3761→
3762→
3763→
3764→
3765→
3766→
3767→
3768→
3769→
3770→
3771→
3772→
3773→
3774→
3775→
3776→
3777→
3778→
3779→
3780→
3781→
3782→
3783→
3784→
3785→
3786→
3787→
3788→
3789→
3790→
3791→
3792→
3793→
3794→
3795→
3796→
3797→
3798→
3799→
3800→
3801→
3802→
3803→
3804→
3805→
3806→
3807→
3808→
3809→
3810→
3811→
3812→
3813→
3814→
3815→
3816→
3817→
3818→
3819→
3820→
3821→
3822→
3823→
3824→
3825→
3826→
3827→
3828→
3829→
3830→
3831→
3832→
3833→
3834→
3835→
3836→
3837→
3838→
3839→
3840→
3841→
3842→
3843→
3844→
3845→
3846→
3847→
3848→
3849→
3850→
3851→
3852→
3853→
3854→
3855→
3856→
3857→
3858→
3859→
3860→
3861→
3862→
3863→
3864→
3865→
3866→
3867→
3868→
3869→
3870→
3871→
3872→
3873→
3874→
3875→
3876→
3877→
3878→
3879→
3880→
3881→
3882→
3883→
3884→
3885→
3886→
3887→
3888→
3889→
3890→
3891→
3892→
3893→
3894→
3895→
3896→
3897→
3898→
3899→
3900→
3901→
3902→
3903→
3904→
3905→
3906→
3907→
3908→
3909→
3910→
3911→
3912→
3913→
3914→
3915→
3916→
3917→
3918→
3919→
3920→
3921→
3922→
3923→
3924→
3925→
3926→
3927→
3928→
3929→
3930→
3931→
3932→
3933→
3934→
3935→
3936→
3937→
3938→
3939→
3940→
3941→
3942→
3943→
3944→
3945→
3946→
3947→
3948→
3949→
3950→
3951→
3952→
3953→
3954→
3955→
3956→
3957→
3958→
3959→
3960→
3961→
3962→
3963→
3964→
3965→
3966→
3967→
3968→
3969→
3970→
3971→
3972→
3973→
3974→
3975→
3976→
3977→
3978→
3979→
3980→
3981→
3982→
3983→
3984→
3985→
3986→
3987→
3988→
3989→
3990→
3991→
3992→
3993→
3994→
3995→
3996→
3997→
3998→
3999→
4000→
4001→
4002→
4003→
4004→
4005→
4006→
4007→
4008→
4009→
4010→
4011→
4012→
4013→
4014→
4015→
4016→
4017→
4018→
4019→
4020→
4021→
4022→
4023→
4024→
4025→
4026→
4027→
4028→
4029→
4030→
4031→
4032→
4033→
4034→
4035→
4036→
4037→
4038→
4039→
4040→
4041→
4042→
4043→
4044→
4045→
4046→
4047→
4048→
4049→
4050→
4051→
4052→
4053→
4054→
4055→
4056→
4057→
4058→
4059→
4060→
4061→
4062→
4063→
4064→
4065→
4066→
4067→
4068→
4069→
4070→
4071→
4072→
4073→
4074→
4075→
4076→
4077→
4078→
4079→
4080InnoDB undo tablespace size is wrong→
4081InnoDB buffer pool load was aborted→
4082InnoDB buffer pool dump was aborted→
4083InnoDB change buffering is deprecated→
4084InnoDB online index rebuild failed→
4085InnoDB redo log encryption not supported in this configuration→
4086InnoDB undo log encryption not supported in this configuration→
4087InnoDB cannot read corrupted page→
4088InnoDB cannot write page to data file→
4089InnoDB cannot open data file→
4090InnoDB data directory is not writable→
4091InnoDB data file access denied→
4092InnoDB data file is unreadable→
4093InnoDB data file cannot be resized→
4094InnoDB tablespace encryption key inaccessible during upgrade→
4095InnoDB DB_ROW_ID column conflicts with foreign key→
4096Incompatible .cfg file version for tablespace import→
4097utf8 character set alias is deprecated→
4098TIMESTAMP with DEFAULT NULL is deprecated→
4099TIMESTAMP column has a deprecated default value→
4100YEAR(4) with zero date is deprecated→
4101ASC/DESC in GROUP BY is deprecated→
4102Aggregate functions with ROLLUP behave differently and are deprecated in this context→
4103SQL_CALC_FOUND_ROWS is deprecated→
4104FOUND_ROWS() is deprecated→
4105Implicit inner transaction rollback behavior is deprecated→
4106Invalid stored program name→
4107Stored program does not exist→
4108Stored program already exists→
4109Incorrect foreign key definition→
4110Foreign key columns changed via DDL→
4111Foreign key exists in an unrelated schema→
4112Foreign key columns are incompatible→
4113Foreign key on generated column is not supported→
4114Cannot add foreign key on virtual generated column→
4115Referenced foreign key column has no unique index→
4116Foreign key column is also a partition column→
4117Foreign key cannot use this index type→
4118Foreign key column data type mismatch→
4119Illegal or unsupported table option for storage engine→
4120Incorrect table definition→
4121Wrong object type for this operation→
4122Too many tables referenced in query→
4123Too many columns in table definition→
4124Column specification is too long for BLOB or TEXT→
4125String value is too long for column→
4126BLOB/TEXT column used without key length in index→
4127Column length is too large for the column type→
4128Row size too large for table definition→
4129Thread stack overrun during query execution→
4130Wrong usage of outer join in query→
4131NULL column used in unique index (check configuration)→
4132Cannot find a system record needed for the operation→
4133Table is full — no more room in the table file→
4134Wrong column type for range partitioning→
4135Incorrect column specification→
4136Subquery transformation was rejected by the optimizer→
4137Row count mismatch in table value constructor→
4138Feature not supported by the hypergraph optimizer→
4139Hypergraph optimizer failed to rewrite the query→