MySQL Error MY-013229 – ER_SERVER_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_SERVER_GTID_UNSAFE_CREATE_DROP_TEMP_TABLE_IN_TRX_IN_SBR
was added in 8.0.13.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

MySQL Error Message Could not read CA key file: %s Reason for the Error ER_X509_CANT_READ_CA_KEY was added in 8.0.2.
MySQL Error Message Read invalid event from master: ‘%s’, master could be corrupt but a more likely cause of this...
MySQL Error Message %s Reason for the Error ER_IB_MSG_315 was added in 8.0.11.