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.
