Error 1766: The system variable cannot be set when there is an ongoing transaction
Error Code
SQLSTATE
Error
Description
1766
HY000
ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
The system variable %s cannot be set when there is an ongoing transaction.
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 1765: The system variable cannot be set in stored functions or triggersNextError 1767: The system variable @@SESSION.GTID_NEXT has the value which is not listed in @@SESSION.G
Last updated
Was this helpful?