MySQL Error MY-013098 – ER_RPL_GTID_UNSAFE_STMT_ON_NON_TRANS_TABLE

MySQL 20 Views 0 Min Read

MySQL Error Message

Statement violates GTID consistency: Updates to
non-transactional tables can only be done in either autocommitted
statements or single-statement transactions, and never in the same
statement as updates to transactional tables.

Reason for the Error

ER_RPL_GTID_UNSAFE_STMT_ON_NON_TRANS_TABLE
was added in 8.0.11.

Tags: