死锁待解决

最新推荐文章于 2023-09-13 16:34:06 发布
最新推荐文章于 2023-09-13 16:34:06 发布
阅读量196 收藏
点赞数
分类专栏： mysql错误 文章标签： java mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/big_pei/article/details/123575425
版权 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: UPDATE `crm0`.`toufang_user`             SET `age_group` = ?,             `level` = ?,             `progress` = ?             WHERE                 `phone` = ? and type = ? limit 1
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
; SQL []; Deadlock found when trying to get lock; try restarting transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction

org.springframework.dao.DeadlockLoserDataAccessException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: UPDATE `crm0`.`toufang_user`             SET `age_group` = ?,             `level` = ?,             `progress` = ?             WHERE                 `phone` = ? and type = ? limit 1
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
; SQL []; Deadlock found when trying to get lock; try restarting transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:263)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy59.update(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy112.updateExtend(Unknown Source)
	at com.edu.modules.toufanguser.service.impl.AdUserServiceImpl.updateTouFangUser(AdUserServiceImpl.java:558)
	at com.edu.modules.toufanguser.service.impl.AdUserServiceImpl$$FastClassBySpringCGLIB$$5034e2b3.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
	at com.edu.modules.toufanguser.service.impl.AdUserServiceImpl$$EnhancerBySpringCGLIB$$d787a23d.updateTouFangUser(<generated>)
	at com.edu.modules.toufanguser.controller.FormCauseController.updateTouFangUser(FormCauseController.java:81)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)

死锁待解决

BIG_PEI
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
对于死锁的处理
11-07
本文将详细探讨死锁的概念、产生的原因、预防措施以及解决策略。 #### 死锁定义 死锁是指在多任务系统中，两个或多个进程因竞争资源而造成的一种僵局现象，在这种情况下，每个进程都在等待另一个进程释放它所需要...
Mysql8.0.17版本不能自动创建activiti表的坑
weixin_30297281的博客
09-23 959
maven项目如下： 配置好数据库，和activiti的配置之后，开始执行流程部署 package com.yuanqiao.first_activiti.deployment; import java.util.List; import org.activiti.engine.ProcessEngine; import org.activit...
工作流异常 Error while clossing command context java.lang.NullPointerException: null
qq_65292317的博客
10-19 3260
工作流异常 Error while clossing command context java.lang.NullPointerException: null
activiti 任务complete的时候 出现Error while closing command context异常
热门推荐
zeng520331的专栏
10-24 2万+
activiti 在提交任务complete的时候 出现Error while closing command context异常。 原因是工作流程修改以后，没有保存，没有重新发布流程。
activiti6报错org.activiti.engine.impl.interceptor.CommandContext - Error while closing command context
weixin_45818332的博客
01-11 1785
activiti6报错org.activiti.engine.impl.interceptor.CommandContext - Error while closing command context。null
Activiti7没有自动建表，每次启动报表不存在【Error while closing command context】
三两肉的博客
09-13 8332
Error while closing command context Activiti7没有自动建表，每次启动报表不存在
使用c语言实现的死锁检测组件.zip
最新发布
06-14
本教程将通过C语言来实现一个死锁检测组件，这对于理解死锁原理以及如何预防和解决死锁问题具有极大的帮助。 首先，我们要了解死锁的基本条件：互斥条件、占有并等待、无剥夺和循环等待。互斥条件意味着资源只能由...
已待解决user 的IO问题
10-22
在“0914已待解决user 的IO问题”这个压缩包文件中，可能包含了特定用户遇到的IO问题的具体细节，例如代码示例、日志文件或错误报告。通过分析这些内容，我们可以更深入地了解问题所在，并提供针对性的解决方案。...
C#使用队列(Queue)解决简单的并发问题
09-03
在并发环境中，多个线程可能同时尝试访问同一资源，这可能导致数据竞争、死锁等问题。在上述的抢购场景中，如果没有合适的同步机制，可能会导致多个用户同时购买同一商品，违反了先到先得的原则。通过使用队列，我们...
操作系统：第3章进程调度与死锁2.ppt
07-13
检测和解除死锁则需要通过算法识别死锁状态，并采取撤销进程、回滚事务或资源剥夺等策略来解决。 总的来说，处理机调度和死锁管理是操作系统中复杂且关键的组件，需要兼顾用户需求和系统效率，以实现高效的资源分配...
MyBatis foreach循环批量修改数据时报错
Theman_6的博客
07-28 751
报错如下 org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n
记录一次activiti启动报错ERROR (CommandContext.java:171)- Error while closing command context
yjt520557的博客
12-01 8293
启动工作流项目时候报错 ERROR (CommandContext.java:171)- Error while closing command context java.lang.NullPointerException: null at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:1030) at org.activiti.engine.impl.db.DbSqlSession.perfor.
报错:Error while closing command context org.activiti.engine.ActivitiException
weixin_43891731的博客
12-18 1万+
[ERROR] [2019-12-18 17:55:16] org.activiti.engine.impl.interceptor.CommandContext.close(171) | Error while closing command context org.activiti.engine.ActivitiException: no activiti tables in db. set ...
activiti办理出错
{竹子}
11-21 4377
activiti5.22.0，办理任务时出错， taskService.complete(taskId); 错误信息： [11-21 14:45:52] ERROR CommandContext [main]: Error while closing command context org.activiti.engine.ActivitiException: A delegated tas
【解决】SpringBoot 2+ Activiti 7出现：The deployment contains process definitions with the same key
李知-斜杠青年
01-19 6972
目前，网络上大部分的Activiti版本基本都是ACtiviti6.0 ，学习与SpringBoot 2.1.1 整合Activiti 7.0.0.Beta5整合的时候，很多东西需要一步步去探索。作为一个新手，需要不断的积累。 本文为SpringBoot 2.0 和Activiti 7 整合的第一个错误，比较简单，记录如下：
Activiti给bpmn添加监听的大坑
weixin_43844343的博客
12-03 5621
如果使用Activiti给流程添加监听后，启动项目运行时报了Error while closing command context错误，那么你可以看看以下内容 问题：错误是如何产生的呢？ 分析： ：我们知道使用spring可以通过注解注入对象，把对象交统一交给spring管理，那么看上图，我们会想加了注解肯定就是交给spring了吧，但是经过测试，打印的service为什么会是null呢？ ...
mybatis批量修改＜foreach＞报错
qq_42308456的博客
04-17 693
实际原因是mybatis不会识别“；”，需要修改连接数据库配置，使用批量修改时，报语法错误；检查sql语句没问题，
解决org.springframework.dao.DeadlockLoserDataAccessException
aituochang1886的博客
08-16 6935
添加链接池后批量添加更新出现了死锁 org.springframework.dao.DeadlockLoserDataAccessException: ### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found wh...
处理机调度与死锁：从高级到低级
预防死锁的方法包括避免循环等待和资源预分配，而死锁的检测则用于发现并解决系统中的死锁问题。" 操作系统是计算机系统的核心组成部分，处理机调度是其关键功能之一，确保系统资源的有效利用和高效运行。在操作...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值