circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Register Nowarrow-up-right
search
Download MariaDBContact Us

MariaDB Error Codes 1400 to 1499

Error 1400: XAER_OUTSIDE: Some work is done outside global transactionchevron-rightError 1401: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistchevron-rightError 1402: XA_RBROLLBACK: Transaction branch was rolled backchevron-rightError 1403: There is no such grant defined for user on host on routinechevron-rightError 1404: Failed to grant EXECUTE and ALTER ROUTINE privilegeschevron-rightError 1405: Failed to revoke all privileges to dropped routinechevron-rightError 1406: Data too long for column at rowchevron-rightError 1407: Bad SQLSTATEchevron-rightError 1408: ready for connections. Version: socket: port:chevron-rightError 1409: Can't load value from file with fixed size rows to variablechevron-rightError 1410: You are not allowed to create a user with GRANTchevron-rightError 1411: Incorrect value for functionchevron-rightError 1412: Table definition has changed, please retry transactionchevron-rightError 1413: Duplicate handler declared in the same blockchevron-rightError 1414: OUT or INOUT argument for routine is not a variable or NEW pseudo-variable in BEFORE trichevron-rightError 1415: Not allowed to return a result set fromchevron-rightError 1416: Cannot get geometry object from data you send to the GEOMETRY fieldchevron-rightError 1417: A routine failed and has neither NO SQL nor READS SQL DATA in its declarationchevron-rightError 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration anchevron-rightError 1419: You do not have the SUPER privilege and binary logging is enabledchevron-rightError 1420: You can't execute a prepared statement which has an open cursor associated with itchevron-rightError 1421: The statement has no open cursorchevron-rightError 1422: Explicit or implicit commit is not allowed in stored function or triggerchevron-rightError 1423: Field of view underlying table doesn't have a default valuechevron-rightError 1424: Recursive stored functions and triggers are not allowed.chevron-rightError 1425: Too big scale specified for columnchevron-rightError 1426: Too big precision specified for columnchevron-rightError 1427: For float(M,D, double(M,D or decimal(M,D, M must be >= Dchevron-rightError 1428: You can't combine write-locking of system tables with other tables or lock typeschevron-rightError 1429: Unable to connect to foreign data sourcechevron-rightError 1430: There was a problem processing the query on the foreign data sourcechevron-rightError 1431: The foreign data source you are trying to reference does not existchevron-rightError 1432: Can't create federated table. The data source connection string is not in the correct fochevron-rightError 1433: The data source connection string is not in the correct formatchevron-rightError 1434: Can't create federated table. Foreign data src errorchevron-rightError 1435: Trigger in wrong schemachevron-rightError 1436: Thread stack overrunchevron-rightError 1437: Routine body is too longchevron-rightError 1438: Cannot drop default keycachechevron-rightError 1439: Display width out of range for columnchevron-rightError 1440: XAER_DUPID: The XID already existschevron-rightError 1441: Datetime function: field overflowchevron-rightError 1442: Can't update table in stored function/trigger because it is already used by statement whchevron-rightError 1443: The definition of table prevents operation on tablechevron-rightError 1444: The prepared statement contains a stored routine call that refers to that same statementchevron-rightError 1445: Not allowed to set autocommit from a stored function or triggerchevron-rightError 1446: Definer is not fully qualifiedchevron-rightError 1447: View has no definer information (old table format)chevron-rightError 1448: You need the SUPER privilege for creation view with definerchevron-rightError 1449: The user specified as a definer does not existchevron-rightError 1450: Changing schema from is not allowed.chevron-rightError 1451: Cannot delete or update a parent row: a foreign key constraint failschevron-rightError 1452: Cannot add or update a child row: a foreign key constraint failschevron-rightError 1453: Variable must be quoted with ..., or renamedchevron-rightError 1454: No definer attribute for triggerchevron-rightError 1455: has an old format, you should re-create the object(s)chevron-rightError 1456: Recursive limit (as set by the max_sp_recursion_depth variable) was exceeded for routinechevron-rightError 1457: Failed to load routinechevron-rightError 1458: Incorrect routine namechevron-rightError 1459: Table upgrade required. Please do "REPAIR TABLE" or dump/reload to fix it!chevron-rightError 1460: AGGREGATE is not supported for stored functionschevron-rightError 1461: Can't create more than max_prepared_stmt_count statementschevron-rightError 1462: contains view recursionchevron-rightError 1463: Non-grouping field is used in clausechevron-rightError 1464: The used table type doesn't support SPATIAL indexeschevron-rightError 1465: Triggers can not be created on system tableschevron-rightError 1466: Leading spaces are removed from namechevron-rightError 1467: Failed to read auto-increment value from storage enginechevron-rightError 1468: user namechevron-rightError 1469: host namechevron-rightError 1470: String is too long for (should be no longer than )chevron-rightError 1471: The target table of the is not insertable-intochevron-rightError 1472: Table is differently defined or of non-MyISAM type or doesn't existchevron-rightError 1473: Too high level of nesting for selectchevron-rightError 1474: Name has become ''chevron-rightError 1475: First character of the FIELDS TERMINATED string is ambiguouschevron-rightError 1476: The foreign server you are trying to create already existschevron-rightError 1477: The foreign server name you are trying to reference does not exist. Data source errorchevron-rightError 1478: Table storage engine does not support the create optionchevron-rightError 1479: Syntax error: PARTITIONING requires definition of VALUES for each partitionchevron-rightError 1480: Only PARTITIONING can use VALUES in partition definitionchevron-rightError 1481: MAXVALUE can only be used in last partition definitionchevron-rightError 1482: Subpartitions can only be hash partitions and by keychevron-rightError 1483: Must define subpartitions on all partitions if on one partitionchevron-rightError 1484: Wrong number of partitions defined, mismatch with previous settingchevron-rightError 1485: Wrong number of subpartitions defined, mismatch with previous settingchevron-rightError 1486: Constant/Random expression in (sub)partitioning function is not allowedchevron-rightError 1487: Expression in RANGE/LIST VALUES must be constantchevron-rightError 1488: Field in list of fields for partition function not found in tablechevron-rightError 1489: List of fields is only allowed in KEY partitionschevron-rightError 1490: The partition info in the frm file is not consistent with what can be written into the fchevron-rightError 1491: The function returns the wrong typechevron-rightError 1492: For partitions each partition must be definedchevron-rightError 1493: VALUES LESS THAN value must be strictly increasing for each partitionchevron-rightError 1494: VALUES value must be of same type as partition functionchevron-rightError 1495: Multiple definition of same constant in list partitioningchevron-rightError 1496: Partitioning can not be used stand-alone in querychevron-rightError 1497: The mix of handlers in the partitions is not allowed in this version of MariaDBchevron-rightError 1498: For the partitioned engine it is necessary to define allchevron-rightError 1499: Too many partitions (including subpartitions) were definedchevron-right
PreviousError 1399: XAER_RMFAIL: The command cannot be executed when global transaction is in the stateNextError 1400: XAER_OUTSIDE: Some work is done outside global transaction

Last updated

Was this helpful?