Error 1422: Explicit or implicit commit is not allowed in stored function or trigger

You are viewing an old version of this article. View the current version here.

Error Code	SQLSTATE	Error	Description
1422	HY000	ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG	Explicit or implicit commit is not allowed in stored function or trigger.

Possible Causes and Solutions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

Comments

Comments loading...

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

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

Error 1422: Explicit or implicit commit is not allowed in stored function or trigger

Contents

Possible Causes and Solutions

Comments

Products

Services

Pricing

Resources

About Us

Download MariaDB