DeadLock Lesson

最新推荐文章于 2022-04-02 09:18:58 发布
最新推荐文章于 2022-04-02 09:18:58 发布
阅读量2.2k 收藏
点赞数
分类专栏： J2EE
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Derek_Zhang_/article/details/38496933
版权

1. Problem

09:32:56,921  WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper:143 - SQL Error: 1213, SQLState: 40001
09:32:56,922 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144 - Deadlock found when trying to get lock; try restarting transaction
09:32:56,949  WARN org.apache.cxf.phase.PhaseInterceptorChain:452 - Application {http://impl.service.basbroker.integration.yystar.com/}BrokeragedbBetServiceService#{http://api.service.basbroker.integration.yystar.com/}isAbleToPlaceBet has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: could not execute statement
	at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162)
	at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJAXWSMethodInvoker.java:213)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:128)
	at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:178)
	at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:68)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)
	at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
	at java.util.concurrent.FutureTask.run(FutureTask.java:166)
	at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
	at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:107)
	at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:272)
	at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
	at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:239)
	at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:248)
	at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:222)
	at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:153)
	at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:167)
	at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:286)
	at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:206)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:262)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:208)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:947)
	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:680)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:722)
Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
	at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:411)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2966)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3477)
	at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
	at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203)
	at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183)
	at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167)
	at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
	at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
	at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
	at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204)
	at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189)
	at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
	at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:763)
	at org.hibernate.internal.SessionImpl.save(SessionImpl.java:755)
	at org.hibernate.internal.SessionImpl.save(SessionImpl.java:751)
	at com.yystar.integration.basbroker.dao.impl.BasSyncDao.saveHoldingTransaction(BasSyncDao.java:500)
	at sun.reflect.GeneratedMethodAccessor1545.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at com.sun.proxy.$Proxy27.saveHoldingTransaction(Unknown Source)
	at com.yystar.integration.basbroker.service.impl.BrokeragedbBetService.isAbleToPlaceBet(BrokeragedbBetService.java:135)
	at sun.reflect.GeneratedMethodAccessor660.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
	at com.sun.proxy.$Proxy29.isAbleToPlaceBet(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)
	at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
	... 41 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1064)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)
	... 88 more


2. Possible Cause:

(1) We have a CS application and a web application and a service interact with the database, and the legacy CS application's transaction isolation level is 'serializable'!

 _hedgingTransaction = HedgingdbConnection.BeginTransaction(IsolationLevel.Serializable);

(2) Both our CS application and BS application have long running transactions, which are prone to cause dead locks.

(3) We have a few long running transactions with reversed order database operation, some update table A first then table B, some update table B first then table A. Example in our project: create new bet and settle bet both are long running transactions, and the data operations are in reversed order.

Reference

[1] http://stackoverflow.com/questions/21777205/hibernate-deadlock-found-when-trying-to-obtain-lock





hitman.banker
关注
专栏目录
hibernate中使用c3p0 导致数据库deadlock
dengmc的专栏
07-01 2513
参考： https://forum.hibernate.org/viewtopic.php?t=947246&highlight=apparent+deadlock+c3p0  1.选择合适的c3p0和hibernate版本c3p0-0.9.1-pre11.jarhibernate-3.2.0.ga.jar 2.设置c3p0的属性（不设置任何缓存）00 3.
quartz-2.0.X版本发行说明
superMario
09-03 946
Release Notes - Quartz Scheduler (Historical - Do Not File New Issues Here - See GitHub) - Version 2.0 Documentation [QTZ-76] - Document: Batch-acquiring of triggers [QTZ-77] - ...
悲观锁
hfhwan
08-14 103
悲观锁 悲观锁的实现，通常依赖于数据库机制，在整个过程中将数据锁定，其它任何用户都不能读取或修改 乐观锁 大多数基于数据版本记录机制（version）实现，一般是在数据库表中加入一个version字段 读取数据时将版本号一同读出，之后更新数据时版本号加一，如果提交数据时版本号小于或等于数据表中 的版本号，则认为数据是过期的，否则给予更新...
mysql innodb hibernate Deadlock
u012525920的专栏
09-28 991
org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.LockAcquisitionException: Deadlock found when trying to get lock; try restarting transaction; nested exception is javax.persiste
org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions解析
leese233的博客
04-02 4724
不要慌,该异常表示数据库某一个字段与实体类某一个字段不匹配,我当时数据库字段是syn_Flag, 在实体类中的映射字段却顺手写成synFlag,仔细检查一下就ok
微软内部资料-SQL性能优化3
11-27
Lesson 1: Concepts – Locks and Lock Manager 3 Lesson 2: Concepts – Batch and Transaction 31 Lesson 3: Concepts – Locks and Applications 51 Lesson 4: Information Collection and Analysis 63 Lesson 5:...
Go Quiz: 从Go面试题看锁的注意事项
perfume
03-12 647
Google工程师Valentin Deleplace出了2道关于锁的题目，拿出来和大家分享下。
Runtime源码剖析---图解Category
qq_42376419的博客
10-09 627
文章目录Runtime源码剖析---图解Category什么是Category？extensioncategory 与 extension 的区别Category的实质category_t 结构体分类如何存储在类对象中category运行期分类在运行期做了什么运行流程load与initialize的区别loadinitialize关联对象如何关联对象关联对象的实现原理 Runtime源码剖析—图解...
计算机算法常用术语中英对照（分为两部分 其中一部分表格形式 ）
weixin_30488085的博客
06-25 4875
第一部分 Data Structures 基本数据结构 Dictionaries 字典 Priority Queues 堆 Graph Data Structures 图 Set Data Structures 集合 Kd-Trees 线段树 Numerical Problems 数值问题 Solving Linear Equations 线性方程组 B...
org.hibernate.engine.jdbc.spi.SqlExceptionHelper - 无法转换为内部表示
weixin_42933882的博客
04-03 1万+
could not execute query; nested exception is org.hibernate.exception.GenericJDBCException: could not execute query SQL state [99999]; error code [17059]; could not execute query; nested exception is o...
org.hibernate.engine.jdbc.spi.SqlExceptionHelper l
weixin_34096182的博客
03-21 3397
2019独角兽企业重金招聘Python工程师标准>>> ...
org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Table 'XXX' doesn't exist
热门推荐
木子木泗的博客
01-09 3万+
　　在项目的hibernate.cfg.xml中，我配置好xml后让hibernate自动在mysql建表 <property name="hibernate.hbm2ddl.auto">update</property> 　　可是，运行的时候报错“org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Table ‘X...
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]SQL Error: 1064, SQLState: 42000问题的解决办法...
weixin_30858241的博客
01-16 2675
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]SQL Error: 1064, SQLState: 42000问题的解决办法。 出现这种情况的原因可能是表中的列名和MySQL的保留关键字发生了冲突。找到冲突的字段，修改即可。 也可能是列中存在空格，比如TOTAL_ REVENUE，下划线中存在空格，以至于加载列时报错。 转载于:https...
[ERROR][org.hibernate.engine.jdbc.spi.SqlExceptionHelper]Lock wait timeout
Efforts_To_Advanced的博客
01-08 1万+
hibernate数据库在进行多条数据插入数据库时报上述错误。查了很多解决方案，原因是代码中有事务没提交，导致锁，最后总结如下： sql = "select pks.orgId,so.name,sum(ifnull(pks.result01,0)+ifnull(pks.result02,0)+ifnull(pks.result03,0)+ifnull(pks.result04,0)+ifnull
java执行更新语句不起作用_java – 更新时出现Hibernate错误：无法执行语句,在’index = 1’附近使用正确的语法...
weixin_42521450的博客
02-27 531
我正在使用带有Hibernate和MySQL的netbeans开发桌面应用程序.当我向数据库添加一条新记录时,它完全正常工作但是当我尝试更新一个对象字段时,我有这个错误：could not execute statementINFO: HHH000010: On release of batch it still contained JDBC statementsJan 17, 2015 2:47...
hibernate中的奇葩错误
atgeretg的博客
12-17 6202
调用hibernate中的原生方法save()方法 public void save(T t) throws HibernateException { getSession().save(t); } 但是还是报错 Hibernate: insert into barshop.product (product_type, sto...
MySQL DeadLock故障排查实战解析
"MySQL DeadLock故障排查全过程记录" MySQL死锁（DeadLock）是数据库系统中常见的一个问题，当两个或多个事务在执行过程中，因争夺资源而造成的一种相互等待的现象，若无外力干涉它们将无法继续执行。在本案例中，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值