Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Error: "java.sql.SQLException: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context" (4346840)
Error: "java.sql.SQLException: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context"
설명
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.
원인
Foglight is using a clustered MySQL instance (group replication) as backend.
해결 방안
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.
