1 of 1

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