# MariaDB Error Codes 1400 to 1499

- [Error 1400: XAER\_OUTSIDE: Some work is done outside global transaction](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1400.md)
- [Error 1401: XAER\_RMERR: Fatal error occurred in the transaction branch - check your data for consist](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1401.md)
- [Error 1402: XA\_RBROLLBACK: Transaction branch was rolled back](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1402.md)
- [Error 1403: There is no such grant defined for user on host on routine](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1403.md)
- [Error 1404: Failed to grant EXECUTE and ALTER ROUTINE privileges](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1404.md)
- [Error 1405: Failed to revoke all privileges to dropped routine](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1405.md)
- [Error 1406: Data too long for column at row](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1406.md)
- [Error 1407: Bad SQLSTATE](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1407.md)
- [Error 1408: ready for connections. Version: socket: port:](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1408.md)
- [Error 1409: Can't load value from file with fixed size rows to variable](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1409.md)
- [Error 1410: You are not allowed to create a user with GRANT](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1410.md)
- [Error 1411: Incorrect value for function](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1411.md)
- [Error 1412: Table definition has changed, please retry transaction](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1412.md)
- [Error 1413: Duplicate handler declared in the same block](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1413.md)
- [Error 1414: OUT or INOUT argument for routine is not a variable or NEW pseudo-variable in BEFORE tri](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1414.md)
- [Error 1415: Not allowed to return a result set from](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1415.md)
- [Error 1416: Cannot get geometry object from data you send to the GEOMETRY field](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1416.md)
- [Error 1417: A routine failed and has neither NO SQL nor READS SQL DATA in its declaration](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1417.md)
- [Error 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration an](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1418.md)
- [Error 1419: You do not have the SUPER privilege and binary logging is enabled](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1419.md)
- [Error 1420: You can't execute a prepared statement which has an open cursor associated with it](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1420.md)
- [Error 1421: The statement has no open cursor](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1421.md)
- [Error 1422: Explicit or implicit commit is not allowed in stored function or trigger](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1422.md)
- [Error 1423: Field of view underlying table doesn't have a default value](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1423.md)
- [Error 1424: Recursive stored functions and triggers are not allowed.](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1424.md)
- [Error 1425: Too big scale specified for column](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1425.md)
- [Error 1426: Too big precision specified for column](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1426.md)
- [Error 1427: For float(M,D, double(M,D or decimal(M,D, M must be >= D](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1427.md)
- [Error 1428: You can't combine write-locking of system tables with other tables or lock types](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1428.md)
- [Error 1429: Unable to connect to foreign data source](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1429.md)
- [Error 1430: There was a problem processing the query on the foreign data source](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1430.md)
- [Error 1431: The foreign data source you are trying to reference does not exist](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1431.md)
- [Error 1432: Can't create federated table. The data source connection string is not in the correct fo](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1432.md)
- [Error 1433: The data source connection string is not in the correct format](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1433.md)
- [Error 1434: Can't create federated table. Foreign data src error](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1434.md)
- [Error 1435: Trigger in wrong schema](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1435.md)
- [Error 1436: Thread stack overrun](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1436.md)
- [Error 1437: Routine body is too long](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1437.md)
- [Error 1438: Cannot drop default keycache](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1438.md)
- [Error 1439: Display width out of range for column](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1439.md)
- [Error 1440: XAER\_DUPID: The XID already exists](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1440.md)
- [Error 1441: Datetime function: field overflow](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1441.md)
- [Error 1442: Can't update table in stored function/trigger because it is already used by statement wh](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1442.md)
- [Error 1443: The definition of table prevents operation on table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1443.md)
- [Error 1444: The prepared statement contains a stored routine call that refers to that same statement](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1444.md)
- [Error 1445: Not allowed to set autocommit from a stored function or trigger](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1445.md)
- [Error 1446: Definer is not fully qualified](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1446.md)
- [Error 1447: View has no definer information (old table format)](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1447.md)
- [Error 1448: You need the SUPER privilege for creation view with definer](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1448.md)
- [Error 1449: The user specified as a definer does not exist](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1449.md)
- [Error 1450: Changing schema from is not allowed.](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1450.md)
- [Error 1451: Cannot delete or update a parent row: a foreign key constraint fails](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1451.md)
- [Error 1452: Cannot add or update a child row: a foreign key constraint fails](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1452.md)
- [Error 1453: Variable must be quoted with ..., or renamed](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1453.md)
- [Error 1454: No definer attribute for trigger](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1454.md)
- [Error 1455: has an old format, you should re-create the object(s)](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1455.md)
- [Error 1456: Recursive limit (as set by the max\_sp\_recursion\_depth variable) was exceeded for routine](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1456.md)
- [Error 1457: Failed to load routine](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1457.md)
- [Error 1458: Incorrect routine name](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1458.md)
- [Error 1459: Table upgrade required. Please do "REPAIR TABLE" or dump/reload to fix it!](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1459.md)
- [Error 1460: AGGREGATE is not supported for stored functions](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1460.md)
- [Error 1461: Can't create more than max\_prepared\_stmt\_count statements](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1461.md)
- [Error 1462: contains view recursion](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1462.md)
- [Error 1463: Non-grouping field is used in clause](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1463.md)
- [Error 1464: The used table type doesn't support SPATIAL indexes](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1464.md)
- [Error 1465: Triggers can not be created on system tables](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1465.md)
- [Error 1466: Leading spaces are removed from name](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1466.md)
- [Error 1467: Failed to read auto-increment value from storage engine](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1467.md)
- [Error 1468: user name](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1468.md)
- [Error 1469: host name](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1469.md)
- [Error 1470: String is too long for (should be no longer than )](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1470.md)
- [Error 1471: The target table of the is not insertable-into](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1471.md)
- [Error 1472: Table is differently defined or of non-MyISAM type or doesn't exist](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1472.md)
- [Error 1473: Too high level of nesting for select](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1473.md)
- [Error 1474: Name has become ''](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1474.md)
- [Error 1475: First character of the FIELDS TERMINATED string is ambiguous](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1475.md)
- [Error 1476: The foreign server you are trying to create already exists](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1476.md)
- [Error 1477: The foreign server name you are trying to reference does not exist. Data source error](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1477.md)
- [Error 1478: Table storage engine does not support the create option](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1478.md)
- [Error 1479: Syntax error: PARTITIONING requires definition of VALUES for each partition](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1479.md)
- [Error 1480: Only PARTITIONING can use VALUES in partition definition](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1480.md)
- [Error 1481: MAXVALUE can only be used in last partition definition](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1481.md)
- [Error 1482: Subpartitions can only be hash partitions and by key](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1482.md)
- [Error 1483: Must define subpartitions on all partitions if on one partition](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1483.md)
- [Error 1484: Wrong number of partitions defined, mismatch with previous setting](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1484.md)
- [Error 1485: Wrong number of subpartitions defined, mismatch with previous setting](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1485.md)
- [Error 1486: Constant/Random expression in (sub)partitioning function is not allowed](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1486.md)
- [Error 1487: Expression in RANGE/LIST VALUES must be constant](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1487.md)
- [Error 1488: Field in list of fields for partition function not found in table](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1488.md)
- [Error 1489: List of fields is only allowed in KEY partitions](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1489.md)
- [Error 1490: The partition info in the frm file is not consistent with what can be written into the f](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1490.md)
- [Error 1491: The function returns the wrong type](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1491.md)
- [Error 1492: For partitions each partition must be defined](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1492.md)
- [Error 1493: VALUES LESS THAN value must be strictly increasing for each partition](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1493.md)
- [Error 1494: VALUES value must be of same type as partition function](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1494.md)
- [Error 1495: Multiple definition of same constant in list partitioning](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1495.md)
- [Error 1496: Partitioning can not be used stand-alone in query](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1496.md)
- [Error 1497: The mix of handlers in the partitions is not allowed in this version of MariaDB](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1497.md)
- [Error 1498: For the partitioned engine it is necessary to define all](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1498.md)
- [Error 1499: Too many partitions (including subpartitions) were defined](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499/e1499.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-1400-to-1499.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.