MariaDB Error Codes 1400 to 1499
Error 1400: XAER_OUTSIDE: Some work is done outside global transactionError 1401: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistError 1402: XA_RBROLLBACK: Transaction branch was rolled backError 1403: There is no such grant defined for user on host on routineError 1404: Failed to grant EXECUTE and ALTER ROUTINE privilegesError 1405: Failed to revoke all privileges to dropped routineError 1406: Data too long for column at rowError 1407: Bad SQLSTATEError 1408: ready for connections. Version: socket: port:Error 1409: Can't load value from file with fixed size rows to variableError 1410: You are not allowed to create a user with GRANTError 1411: Incorrect value for functionError 1412: Table definition has changed, please retry transactionError 1413: Duplicate handler declared in the same blockError 1414: OUT or INOUT argument for routine is not a variable or NEW pseudo-variable in BEFORE triError 1415: Not allowed to return a result set fromError 1416: Cannot get geometry object from data you send to the GEOMETRY fieldError 1417: A routine failed and has neither NO SQL nor READS SQL DATA in its declarationError 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration anError 1419: You do not have the SUPER privilege and binary logging is enabledError 1420: You can't execute a prepared statement which has an open cursor associated with itError 1421: The statement has no open cursorError 1422: Explicit or implicit commit is not allowed in stored function or triggerError 1423: Field of view underlying table doesn't have a default valueError 1424: Recursive stored functions and triggers are not allowed.Error 1425: Too big scale specified for columnError 1426: Too big precision specified for columnError 1427: For float(M,D, double(M,D or decimal(M,D, M must be >= DError 1428: You can't combine write-locking of system tables with other tables or lock typesError 1429: Unable to connect to foreign data sourceError 1430: There was a problem processing the query on the foreign data sourceError 1431: The foreign data source you are trying to reference does not existError 1432: Can't create federated table. The data source connection string is not in the correct foError 1433: The data source connection string is not in the correct formatError 1434: Can't create federated table. Foreign data src errorError 1435: Trigger in wrong schemaError 1436: Thread stack overrunError 1437: Routine body is too longError 1438: Cannot drop default keycacheError 1439: Display width out of range for columnError 1440: XAER_DUPID: The XID already existsError 1441: Datetime function: field overflowError 1442: Can't update table in stored function/trigger because it is already used by statement whError 1443: The definition of table prevents operation on tableError 1444: The prepared statement contains a stored routine call that refers to that same statementError 1445: Not allowed to set autocommit from a stored function or triggerError 1446: Definer is not fully qualifiedError 1447: View has no definer information (old table format)Error 1448: You need the SUPER privilege for creation view with definerError 1449: The user specified as a definer does not existError 1450: Changing schema from is not allowed.Error 1451: Cannot delete or update a parent row: a foreign key constraint failsError 1452: Cannot add or update a child row: a foreign key constraint failsError 1453: Variable must be quoted with ..., or renamedError 1454: No definer attribute for triggerError 1455: has an old format, you should re-create the object(s)Error 1456: Recursive limit (as set by the max_sp_recursion_depth variable) was exceeded for routineError 1457: Failed to load routineError 1458: Incorrect routine nameError 1459: Table upgrade required. Please do "REPAIR TABLE" or dump/reload to fix it!Error 1460: AGGREGATE is not supported for stored functionsError 1461: Can't create more than max_prepared_stmt_count statementsError 1462: contains view recursionError 1463: Non-grouping field is used in clauseError 1464: The used table type doesn't support SPATIAL indexesError 1465: Triggers can not be created on system tablesError 1466: Leading spaces are removed from nameError 1467: Failed to read auto-increment value from storage engineError 1468: user nameError 1469: host nameError 1470: String is too long for (should be no longer than )Error 1471: The target table of the is not insertable-intoError 1472: Table is differently defined or of non-MyISAM type or doesn't existError 1473: Too high level of nesting for selectError 1474: Name has become ''Error 1475: First character of the FIELDS TERMINATED string is ambiguousError 1476: The foreign server you are trying to create already existsError 1477: The foreign server name you are trying to reference does not exist. Data source errorError 1478: Table storage engine does not support the create optionError 1479: Syntax error: PARTITIONING requires definition of VALUES for each partitionError 1480: Only PARTITIONING can use VALUES in partition definitionError 1481: MAXVALUE can only be used in last partition definitionError 1482: Subpartitions can only be hash partitions and by keyError 1483: Must define subpartitions on all partitions if on one partitionError 1484: Wrong number of partitions defined, mismatch with previous settingError 1485: Wrong number of subpartitions defined, mismatch with previous settingError 1486: Constant/Random expression in (sub)partitioning function is not allowedError 1487: Expression in RANGE/LIST VALUES must be constantError 1488: Field in list of fields for partition function not found in tableError 1489: List of fields is only allowed in KEY partitionsError 1490: The partition info in the frm file is not consistent with what can be written into the fError 1491: The function returns the wrong typeError 1492: For partitions each partition must be definedError 1493: VALUES LESS THAN value must be strictly increasing for each partitionError 1494: VALUES value must be of same type as partition functionError 1495: Multiple definition of same constant in list partitioningError 1496: Partitioning can not be used stand-alone in queryError 1497: The mix of handlers in the partitions is not allowed in this version of MariaDBError 1498: For the partitioned engine it is necessary to define allError 1499: Too many partitions (including subpartitions) were defined
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?