Return
-
Title
Error: "java.sql.SQLException: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context" -
Description
When trying to enable any cartridge following error appears in Foglgiht Management Server (FMS) logs:Java.sql.SQLException: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. -
Cause
Foglight is using a clustered MySQL instance (group replication) as backend. -
Resolution
Foglight does not support clustered MySQL instance as backend database.
Please use a non-clustered MySql instance or if clustering is mandatory use an Oracle RAC or Sql Server Always on Availability Groups.