MySQL问题：perror(1875),Statement violates GTID consistency

haughty_xiao

于 2017-07-13 16:13:04 发布

阅读量7k

点赞数 3

CC 4.0 BY-SA版权

分类专栏： MySQL 文章标签： MySQL 1875 GTID consistenc

本文链接：https://blog.csdn.net/poxiaonie/article/details/75073161

在版本升级的联调测试中遇到错误1875，问题源于同一SQL语句中混合操作了非事务表和事务表。通过模拟测试发现，更新非事务表（如MyISAM）需在autocomitted或单语句事务中进行，不能与事务表（如InnoDB）的操作混用。在将非事务表引擎更改为InnoDB后，问题得到解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

版本升级时，联调测试出现如下错误：
The error occurred while setting parameters
SQL: delete from tenant_token where user_id IN ( ? )
Cause: java.sql.SQLException: 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.
; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1785]; 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.; nested exception is java.sql.SQLException: 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.
从上述黑体可