记忆角落

  • {{ item.name }}
  • Statement violates GTID consistency
  • 解决
  • 首页
  • 关于
  • 归档
  • 邻居
  • 捐赠

Statement violates GTID consistency

  • 郭良俊只狗
  • 2022-08-26
  • 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

© 2012 - 2023 记忆角落 网站统计
Theme by Wing
粤ICP备14056850号-1 又拍云CDN赞助