HomeMySQLMySQL Error 3748 – ER_CLIENT_GTID_UNSAFE_CREATE_DROP_TEMP_TABLE_IN_TRX_IN_SBR

MySQL Error 3748 – ER_CLIENT_GTID_UNSAFE_CREATE_DROP_TEMP_TABLE_IN_TRX_IN_SBR

MySQL Error Message

Statement violates GTID consistency: CREATE TEMPORARY
TABLE and DROP TEMPORARY TABLE are not allowed inside a
transaction or inside a procedure in a transactional context when
@@session.binlog_format=STATEMENT.

Reason for the Error

ER_CLIENT_GTID_UNSAFE_CREATE_DROP_TEMP_TABLE_IN_TRX_IN_SBR
was added in 8.0.13.

Share:

Leave a Reply

You May Also Like

MySQL Error Message Ignored the innodb-redo-log-capacity option in the Innodb read-only mode. Server is using active redo log files. Reason...
  • MySQL
  • November 17, 2022
MySQL Error Message This member is configured with a group_replication_paxos_single_leader option value of 1 and it is trying to join...
  • MySQL
  • November 17, 2022
MySQL Error Message Record has both instant and version bit set. Reason for the Error ER_CHECK_TABLE_INSTANT_VERSION_BIT_SET was added in 8.0.32.
  • MySQL
  • November 17, 2022