Statement violates GTID consistency – 记忆角落

Statement violates GTID consistency

/ 0评 / 0

Statement violates GTID consistency

报错信息: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.

解决

使用mysql版本为5.7,在配置文件my.cnf 中将

gtid_mode = ON
enforce_gtid_consistency = 1

修改成以下参数后,然后重启mysql,问题得到解决

gtid_mode = OFF
enforce_gtid_consistency = 0

gtid_mode 参数解析:https://blog.csdn.net/weihaodong0557/article/details/109598729

发表评论

您的电子邮箱地址不会被公开。