MYSQL 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

[2019-04-21 10:17:20] [ERROR] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144] 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.

org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; 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 org.hibernate.exception.GenericJDBCException: 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.
at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:168)
at org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:685)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:567)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:478)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:272)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy. $P r o x y 3580. d o U p d a t e (U n k n o w n S o u r c e) a t c o m . j e e c g . c r m . c o n t r o l l e r . L e a d C o n t r o l l e r . d o U p d a t e (L e a d C o n t r o l l e r . j a v a : 1146) a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e 0 (N a t i v e M e t h o d) a t s u n . r e f l e c t . N a t i v e M e t h o d A c c e s s o r I m p l . i n v o k e (N a t i v e M e t h o d A c c e s s o r I m p l . j a v a : 62) a t s u n . r e f l e c t . D e l e g a t i n g M e t h o d A c c e s s o r I m p l . i n v o k e (D e l e g a t i n g M e t h o d A c c e s s o r I m p l . j a v a : 43) a t j a v a . l a n g . r e f l e c t . M e t h o d . i n v o k e (M e t h o d . j a v a : 498) a t o r g . s p r i n g f r a m e w o r k . w e b . m e t h o d . s u p p o r t . I n v o c a b l e H a n d l e r M e t h o d . d o I n v o k e (I n v o c a b l e H a n d l e r M e t h o d . j a v a : 221) a t o r g . s p r i n g f r a m e w o r k . w e b . m e t h o d . s u p p o r t . I n v o c a b l e H a n d l e r M e t h o d . i n v o k e F o r R e q u e s t (I n v o c a b l e H a n d l e r M e t h o d . j a v a : 137) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . m v c . m e t h o d . a n n o t a t i o n . S e r v l e t I n v o c a b l e H a n d l e r M e t h o d . i n v o k e A n d H a n d l e (S e r v l e t I n v o c a b l e H a n d l e r M e t h o d . j a v a : 104) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . m v c . m e t h o d . a n n o t a t i o n . R e q u e s t M a p p i n g H a n d l e r A d a p t e r . i n v o k e H a n d l e M e t h o d (R e q u e s t M a p p i n g H a n d l e r A d a p t e r . j a v a : 747) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . m v c . m e t h o d . a n n o t a t i o n . R e q u e s t M a p p i n g H a n d l e r A d a p t e r . h a n d l e I n t e r n a l (R e q u e s t M a p p i n g H a n d l e r A d a p t e r . j a v a : 676) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . m v c . m e t h o d . A b s t r a c t H a n d l e r M e t h o d A d a p t e r . h a n d l e (A b s t r a c t H a n d l e r M e t h o d A d a p t e r . j a v a : 85) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . D i s p a t c h e r S e r v l e t . d o D i s p a t c h (D i s p a t c h e r S e r v l e t . j a v a : 938) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . D i s p a t c h e r S e r v l e t . d o S e r v i c e (D i s p a t c h e r S e r v l e t . j a v a : 870) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . F r a m e w o r k S e r v l e t . p r o c e s s R e q u e s t (F r a m e w o r k S e r v l e t . j a v a : 961) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . F r a m e w o r k S e r v l e t . d o P o s t (F r a m e w o r k S e r v l e t . j a v a : 863) a t j a v a x . s e r v l e t . h t t p . H t t p S e r v l e t . s e r v i c e (H t t p S e r v l e t . j a v a : 650) a t o r g . s p r i n g f r a m e w o r k . w e b . s e r v l e t . F r a m e w o r k S e r v l e t . s e r v i c e (F r a m e w o r k S e r v l e t . j a v a : 837) a t j a v a x . s e r v l e t . h t t p . H t t p S e r v l e t . s e r v i c e (H t t p S e r v l e t . j a v a : 731) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . i n t e r n a l D o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 303) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . d o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 208) a t o r g . a p a c h e . t o m c a t . w e b s o c k e t . s e r v e r . W s F i l t e r . d o F i l t e r (W s F i l t e r . j a v a : 52) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . i n t e r n a l D o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 241) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . d o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 208) a t c o m . a l i b a b a . d r u i d . s u p p o r t . h t t p . W e b S t a t F i l t e r . d o F i l t e r (W e b S t a t F i l t e r . j a v a : 123) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . i n t e r n a l D o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 241) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . d o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 208) a t o r g . j e e c g f r a m e w o r k . c o r e . a o p . G Z i p F i l t e r . d o F i l t e r (G Z i p F i l t e r . j a v a : 114) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . i n t e r n a l D o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 241) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . d o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 208) a t o r g . s p r i n g f r a m e w o r k . w e b . f i l t e r . C h a r a c t e r E n c o d i n g F i l t e r . d o F i l t e r I n t e r n a l (C h a r a c t e r E n c o d i n g F i l t e r . j a v a : 88) a t o r g . s p r i n g f r a m e w o r k . w e b . f i l t e r . O n c e P e r R e q u e s t F i l t e r . d o F i l t e r (O n c e P e r R e q u e s t F i l t e r . j a v a : 107) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . i n t e r n a l D o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 241) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . d o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 208) a t o r g . s p r i n g f r a m e w o r k . o r m . h i b e r n a t e 4. s u p p o r t . O p e n S e s s i o n I n V i e w F i l t e r . d o F i l t e r I n t e r n a l (O p e n S e s s i o n I n V i e w F i l t e r . j a v a : 150) a t o r g . s p r i n g f r a m e w o r k . w e b . f i l t e r . O n c e P e r R e q u e s t F i l t e r . d o F i l t e r (O n c e P e r R e q u e s t F i l t e r . j a v a : 107) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . i n t e r n a l D o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 241) a t o r g . a p a c h e . c a t a l i n a . c o r e . A p p l i c a t i o n F i l t e r C h a i n . d o F i l t e r (A p p l i c a t i o n F i l t e r C h a i n . j a v a : 208) a t o r g . a p a c h e . c a t a l i n a . c o r e . S t a n d a r d W r a p p e r V a l v e . i n v o k e (S t a n d a r d W r a p p e r V a l v e . j a v a : 219) a t o r g . a p a c h e . c a t a l i n a . c o r e . S t a n d a r d C o n t e x t V a l v e . i n v o k e (S t a n d a r d C o n t e x t V a l v e . j a v a : 110) a t o r g . a p a c h e . c a t a l i n a . a u t h e n t i c a t o r . A u t h e n t i c a t o r B a s e . i n v o k e (A u t h e n t i c a t o r B a s e . j a v a : 494) a t o r g . a p a c h e . c a t a l i n a . c o r e . S t a n d a r d H o s t V a l v e . i n v o k e (S t a n d a r d H o s t V a l v e . j a v a : 169) a t o r g . a p a c h e . c a t a l i n a . v a l v e s . E r r o r R e p o r t V a l v e . i n v o k e (E r r o r R e p o r t V a l v e . j a v a : 104) a t o r g . a p a c h e . c a t a l i n a . v a l v e s . A c c e s s L o g V a l v e . i n v o k e (A c c e s s L o g V a l v e . j a v a : 1025) a t o r g . a p a c h e . c a t a l i n a . c o r e . S t a n d a r d E n g i n e V a l v e . i n v o k e (S t a n d a r d E n g i n e V a l v e . j a v a : 116) a t o r g . a p a c h e . c a t a l i n a . c o n n e c t o r . C o y o t e A d a p t e r . s e r v i c e (C o y o t e A d a p t e r . j a v a : 445) a t o r g . a p a c h e . c o y o t e . h t t p 11. A b s t r a c t H t t p 11 P r o c e s s o r . p r o c e s s (A b s t r a c t H t t p 11 P r o c e s s o r . j a v a : 1137) a t o r g . a p a c h e . c o y o t e . A b s t r a c t P r o t o c o l$ AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.AprEndpoint $S o c k e t W i t h O p t i o n s P r o c e s s o r . r u n (A p r E n d p o i n t . j a v a : 2511) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r . r u n W o r k e r (T h r e a d P o o l E x e c u t o r . j a v a : 1149) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r$ Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread $W r a p p i n g R u n n a b l e . r u n (T a s k T h r e a d . j a v a : 61) a t j a v a . l a n g . T h r e a d . r u n (T h r e a d . j a v a : 748) C a u s e d b y : o r g . h i b e r n a t e . e x c e p t i o n . G e n e r i c J D B C E x c e p t i o n : S t a t e m e n t v i o l a t e s G T I D c o n s i s t e n c y : U p d a t e s t o n o n - t r a n s a c t i o n a l t a b l e s c a n o n l y b e d o n e i n e i t h e r a u t o c o m m i t t e d s t a t e m e n t s o r s i n g l e - s t a t e m e n t t r a n s a c t i o n s, a n d n e v e r i n t h e s a m e s t a t e m e n t a s u p d a t e s t o t r a n s a c t i o n a l t a b l e s . a t o r g . h i b e r n a t e . e x c e p t i o n . i n t e r n a l . S t a n d a r d S Q L E x c e p t i o n C o n v e r t e r . c o n v e r t (S t a n d a r d S Q L E x c e p t i o n C o n v e r t e r . j a v a : 54) a t o r g . h i b e r n a t e . e n g i n e . j d b c . s p i . S q l E x c e p t i o n H e l p e r . c o n v e r t (S q l E x c e p t i o n H e l p e r . j a v a : 125) a t o r g . h i b e r n a t e . e n g i n e . j d b c . s p i . S q l E x c e p t i o n H e l p e r . c o n v e r t (S q l E x c e p t i o n H e l p e r . j a v a : 110) a t o r g . h i b e r n a t e . e n g i n e . j d b c . i n t e r n a l . p r o x y . A b s t r a c t S t a t e m e n t P r o x y H a n d l e r . c o n t i n u e I n v o c a t i o n (A b s t r a c t S t a t e m e n t P r o x y H a n d l e r . j a v a : 129) a t o r g . h i b e r n a t e . e n g i n e . j d b c . i n t e r n a l . p r o x y . A b s t r a c t P r o x y H a n d l e r . i n v o k e (A b s t r a c t P r o x y H a n d l e r . j a v a : 81) a t c o m . s u n . p r o x y .$ Proxy3599.executeUpdate(Unknown Source)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2856)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3297)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:275)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1127)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:325)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:559)
... 60 more
Caused by: 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.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2459)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2376)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2360)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2843)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1091)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:491)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:2841)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:194)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:256)
at sun.reflect.GeneratedMethodAccessor29420.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
... 76 more

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. org.springframework.orm.hibernate4.HibernateJdbcException - 国际版 Bing
https://cn.bing.com/search?FORM=U227DF&PC=U227&q=Statement+violates+GTID+consistency%3A+Updates+to+non-transactional+tables+can+only+be+done+in+either+autocommitted+statements+or+single-statement+transactions%2C+and+never+in+the+same+statement+as+updates+to+transactional+tables.+org.springframework.orm.hibernate4.HibernateJdbcException

mysql_56_GTID_in_a_nutshell.pdf
https://www.percona.com/sites/default/files/presentations/mysql_56_GTID_in_a_nutshell.pdf

mysql - Should I turn off GTID to fix this error? - Database Administrators Stack Exchange
https://dba.stackexchange.com/questions/189281/should-i-turn-off-gtid-to-fix-this-error/189437

Statement violates GTID consistency · Issue #172 · etianen/django-watson
https://github.com/etianen/django-watson/issues/172

spring batch 3.0.3 get "updates to tables using non-transactional storage engines such as MyISAM " with mysql 5.6 - Stack Overflow
https://stackoverflow.com/questions/29622004/spring-batch-3-0-3-get-updates-to-tables-using-non-transactional-storage-engine

replication - How to troubleshoot, find and fix query Percona 5.6 with error "SQLSTATE[HY000]: General error: 1785 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1" - Database Administrators Stack Exchange
https://dba.stackexchange.com/questions/102258/how-to-troubleshoot-find-and-fix-query-percona-5-6-with-error-sqlstatehy000

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 org.hibernate.exception.GenericJDBCException: 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 使用GTID主从复制后出现错误代码1785解决方法 - 程序园
http://www.voidcn.com/article/p-ajcjwjuo-sb.html

MySQL :: MySQL 5.6 Reference Manual :: 17.1.4.5 Global Transaction ID Options and Variables
https://dev.mysql.com/doc/refman/5.6/en/replication-options-gtids.html

mysql Statement violates GTID consistency 的坑 - SheaChen - 博客园
http://www.cnblogs.com/canmeng-cn/p/5969188.html

pinpoint-web not supporting mysql/percona enforce_gtid_consistency · Issue #4034 · naver/pinpoint
https://github.com/naver/pinpoint/issues/4034

MySQL问题：perror(1875),Statement violates GTID consistency - poxiaonie的博客 - CSDN博客
https://blog.csdn.net/poxiaonie/article/details/75073161

执行MySql更新报错：error code [1785] - Mergades - CSDN博客
https://blog.csdn.net/mergades/article/details/46808079

posted @ 2019-04-22 13:47 任国强阅读(3200) 评论(0) 编辑收藏举报

刷新页面返回顶部

登录后才能查看或发表评论，立即登录或者逛逛博客园首页

历史上的今天：
2011-04-22 这个网站的的，首页有特点。它能根据浏览器是否支持HTML5或者是Silverlight，来决定是启用HTML5的Video还是Silverlight播放视频。

公告

昵称：任国强
园龄： 15年11个月
粉丝： 63
关注： 2582

+加关注

2025年3月

日

一

二

三

四

五

六

rgqancy

波峰波谷，康波人生。棋在盘中走，人在波中行。波粒二象性（观察者理论）。

MYSQL 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

公告

搜索

常用链接

最新随笔

我的标签

积分与排名

随笔分类 (3004)

随笔档案 (2262)

文章档案 (14)

Flash

Game Development

Java

Linq

OPC

Silverlight/WPF

Swf

Web

电子书

分类学习

个人信息

基础知识

开源软件

企业信息化

组态软件

阅读排行榜

评论排行榜

推荐排行榜

最新评论

rgqancy

波峰波谷，康波人生。 棋在盘中走，人在波中行。 波粒二象性（观察者理论）。

MYSQL 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

公告

搜索

常用链接

最新随笔

我的标签

积分与排名

随笔分类 (3004)

随笔档案 (2262)

文章档案 (14)

Flash

Game Development

Java

Linq

OPC

Silverlight/WPF

Swf

Web

电子书

分类学习

个人信息

基础知识

开源软件

企业信息化

组态软件

阅读排行榜

评论排行榜

推荐排行榜

最新评论

波峰波谷，康波人生。棋在盘中走，人在波中行。波粒二象性（观察者理论）。