【Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout excee】

于 2024-07-18 15:32:03 发布
阅读量249 收藏
点赞数 3
文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Semanteme/article/details/140524487
版权 
        at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:90)
        at jdk.proxy2/jdk.proxy2.$Proxy203.updateById(Unknown Source)
        at com.baomidou.mybatisplus.extension.toolkit.Db.lambda$updateById$f80350bc$1(Db.java:167)
        at com.baomidou.mybatisplus.extension.toolkit.SqlHelper.execute(SqlHelper.java:339)
        at com.baomidou.mybatisplus.extension.toolkit.Db.updateById(Db.java:167)
        at com.baomidou.mybatisplus.extension.toolkit.Db.saveOrUpdate(Db.java:250)
        at com.mcc.common.mybatis.core.mapper.BaseMapperPlus.insertOrUpdate(BaseMapperPlus.java:95)
        at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:732)
        at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:163)
        at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:90)
        at jdk.proxy2/jdk.proxy2.$Proxy203.insertOrUpdate(Unknown Source)
        at com.mcc.order.service.impl.MccShareOrderServiceImpl.updateShareOrder(MccShareOrderServiceImpl.java:137)
        at jdk.internal.reflect.GeneratedMethodAccessor498.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:716)
        at com.mcc.order.service.impl.MccShareOrderServiceImpl$$SpringCGLIB$$0.updateShareOrder(<generated>)
        at com.mcc.order.event.listener.OrderMessageListener.onApplicationEvent(OrderMessageListener.java:66)
        at com.mcc.order.event.listener.OrderMessageListener.onApplicationEvent(OrderMessageListener.java:30)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:185)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:178)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:156)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:451)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:384)
        at com.mcc.order.mq.consumer.ChargeOrderInfoConsumer.process(ChargeOrderInfoConsumer.java:39)
        at org.springframework.cloud.function.context.catalog.SimpleFunctionRegistry$FunctionInvocationWrapper.invokeConsumer(SimpleFunctionRegistry.java:1055)
        at org.springframework.cloud.function.context.catalog.SimpleFunctionRegistry$FunctionInvocationWrapper.doApply(SimpleFunctionRegistry.java:753)
        at org.springframework.cloud.function.context.catalog.SimpleFunctionRegistry$FunctionInvocationWrapper.apply(SimpleFunctionRegistry.java:592)
        at org.springframework.cloud.stream.function.PartitionAwareFunctionWrapper.apply(PartitionAwareFunctionWrapper.java:92)
        at org.springframework.cloud.stream.function.FunctionConfiguration$FunctionWrapper.apply(FunctionConfiguration.java:823)
        at org.springframework.cloud.stream.function.FunctionConfiguration$FunctionToDestinationBinder$1.handleMessageInternal(FunctionConfiguration.java:654)
        at org.springframework.integration.handler.AbstractMessageHandler.doHandleMessage(AbstractMessageHandler.java:105)
        at org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:73)
        at org.springframework.integration.dispatcher.AbstractDispatcher.tryOptimizedDispatch(AbstractDispatcher.java:132)
        at org.springframework.integration.dispatcher.UnicastingDispatcher.doDispatch(UnicastingDispatcher.java:133)
        at org.springframework.integration.dispatcher.UnicastingDispatcher.dispatch(UnicastingDispatcher.java:106)
        at org.springframework.integration.channel.AbstractSubscribableChannel.doSend(AbstractSubscribableChannel.java:72)
        at org.springframework.integration.channel.AbstractMessageChannel.sendInternal(AbstractMessageChannel.java:378)
        at org.springframework.integration.channel.AbstractMessageChannel.sendWithMetrics(AbstractMessageChannel.java:349)
        at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:329)
        at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:302)
        at org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:187)
        at org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:166)
        at org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:47)
        at org.springframework.messaging.core.AbstractMessageSendingTemplate.send(AbstractMessageSendingTemplate.java:109)
        at org.springframework.integration.endpoint.MessageProducerSupport.lambda$sendMessage$1(MessageProducerSupport.java:262)
        at io.micrometer.observation.Observation.observe(Observation.java:499)
        at org.springframework.integration.endpoint.MessageProducerSupport.sendMessage(MessageProducerSupport.java:262)
        at org.springframework.integration.amqp.inbound.AmqpInboundChannelAdapter.access$400(AmqpInboundChannelAdapter.java:69)
        at org.springframework.integration.amqp.inbound.AmqpInboundChannelAdapter$Listener.lambda$onMessage$0(AmqpInboundChannelAdapter.java:369)
        at org.springframework.retry.support.RetryTemplate.doExecute(RetryTemplate.java:344)
        at org.springframework.retry.support.RetryTemplate.execute(RetryTemplate.java:233)
        at org.springframework.integration.amqp.inbound.AmqpInboundChannelAdapter$Listener.onMessage(AmqpInboundChannelAdapter.java:365)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:1682)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.actualInvokeListener(AbstractMessageListenerContainer.java:1604)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:1592)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:1583)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.executeListenerAndHandleException(AbstractMessageListenerContainer.java:1528)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.lambda$executeListener$8(AbstractMessageListenerContainer.java:1506)
        at io.micrometer.observation.Observation.observe(Observation.java:499)
        at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.executeListener(AbstractMessageListenerContainer.java:1506)
        at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.doReceiveAndExecute(SimpleMessageListenerContainer.java:1082)
        at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.receiveAndExecute(SimpleMessageListenerContainer.java:1018)
        at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer$AsyncMessageProcessingConsumer.mainLoop(SimpleMessageListenerContainer.java:1420)
        at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer$AsyncMessageProcessingConsumer.run(SimpleMessageListenerContainer.java:1322)
        at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:124)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912)
        at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
        at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
        at jdk.internal.reflect.GeneratedMethodAccessor509.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
        at jdk.proxy2/jdk.proxy2.$Proxy265.update(Unknown Source)
        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
        at jdk.internal.reflect.GeneratedMethodAccessor378.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:61)
        at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
        at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
        at jdk.proxy2/jdk.proxy2.$Proxy264.update(Unknown Source)
        at jdk.internal.reflect.GeneratedMethodAccessor378.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
        at jdk.proxy2/jdk.proxy2.$Proxy264.update(Unknown Source)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
        ... 69 common frames omitted

SELECT * from information_schema.INNODB_TRX;

查找到死锁的事务id

结束进程
在这里插入图片描述

Semanteme
关注
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found when trying to get lo
道阻且长,行则将至 行而不辍,未来可期
07-20 1605
主要的异常日志信息。一个简单地删除和插入操作逻辑居然会导致锁表，诡异的情况。需要定位解决一下，频繁的如此操作，复现率很高！
生产异常 Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceed
h952520296的博客
10-11 2822
4、由于是生产，急需处理业务数据，所以临时解决方案，是先kill 掉，未能提交事务的线程，目前的解决方案，就是手动kill掉长期挂起，未提交的事务。
Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded；
qq_37217985的博客
07-26 2141
1.报错 Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction出现的原因：（1）你在执行更新当前表的sql时，另外一块代码提前更新这张表的数据，并开启事务，sql还未提交，你提交当前表sql就会报错异常（2）你可能使用数据库管理工具开启了事务，并且未提交（例如navicat）
解决生产异常 Cause com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException Lock wait timeout exceed
zhiyikeji的博客
05-14 2789
1.情景复现 早上起来发现自己的错误日志提醒疯狂提示，错误如下： ; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction 2.解决过程 我们使用Navicat或者直接用
解决异常com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceede
shejiataoBlog
07-08 4123
解决异常com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceede
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ….. this is incompatible with sq
12-14
1、写在开头 标题之前我想说一下Linux的mysql真的实在是太坑了。太坑了。总是会出现这样那样的你想不到的问题。崩溃了。首先来罗列一下我遇到过的...Cause:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExcepti
IDEA中使用mysql报错Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException
qq_41058569的博客
01-14 831
1、mysql的版本在8.0以后，数据库驱动配置时，需要在代码url的链接里面指定serverTimezone。否则就会出现异常： Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException 2、使用配置文件报错：No suitable driver
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction问题怎么解决
10-27
出现Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction错误通常是由于数据库锁定超时引起的。以下是一些可能的解决方法： 1....
Spring连接Mysql报Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link fai错
王大师企业官方博客
12-12 2179
系列文章分类 学习目标： 1、一周掌握 JAVA入门知识 2、掌握基础入门C#知识 3、手把手教你vbs脚本制作 4、强大的 IDEA编程利器 Spring连接Mysql报错学习目标：前言一、Spring链接数据库报错二、报错的代码三、解决方案总结 前言 年轻人不讲武德 一、Spring链接数据库报错 报错信息 Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
08-14 5369
跑项目时报错：Table xxxxx’ doesn’t exist
解决mysql锁表问题com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceede
热门推荐
victo_chao的博客
05-18 1万+
报错如下： 在navicat中执行如下语句： 1、查询是否锁表 show open tables where in_use>0; 2、查询进程 show processlist 查询到相对应的进程，然后 kill id 3、查看正在锁的事务 select * from information_schema.innodb_locks; 4、查看等待锁的事务 select * from information_schema.innodb_lock_waits; 找到锁表的进程： 找
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded； try rest
qq_44275894的博客
05-11 2596
** 背景： 现场同事电话反馈，核酸数据上报任务异常了，好几台服务器都显示报错。 问题： 报错主要原因是事务回滚了 com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction 排查 //当前运行的所有事务 SELECT * FROM information_schema.INNODB_TRX; //当前出现的锁 SELEC
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException:
越努力越幸运~~ Java领域从业者；CSDN新兴创新博主；Java领域优质创作者；书写奋斗者故事;欢迎交流学习进步；
09-07 8917
死锁发生了。Lock wait timeout exceeded; 超过锁定等待超时，也就是死锁了，两个线程同时争夺资源，没有先后顺序，这就造成了死锁。产生死锁的原因有很多，更容易在多线程、线程池、多条sql操作同一张表分开来写。有必要对这些容易产生死锁的接口用jemet性能测试。文中告诉你，错误来自UPDATE mch_user SET is_admin=? WHERE id=?### 这条，当然sql语句没有错，id是主键索引，is_admin就一普通字段。它说错误可能存在com.shuwei.me
排查生产环境：MySQLTransactionRollbackException数据库死锁
最新发布
itScholar001的博客
02-04 2946
一. 问题现状。
updating database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wa
qq_52497401的博客
11-30 528
查询，您可以获得当前活动的 InnoDB 事务的详细信息，从而帮助您分析和监视事务的运行情况以及可能的锁等待问题。这对于调优和故障排除是有用的。是一个系统表，它包含了有关当前正在运行的 InnoDB 事务的信息。用于检索 InnoDB 存储引擎中当前活动的事务信息。然后 kill掉这个线程 在重新测试。这个 SQL 查询语句。
MySQLTransactionRollbackException: Lock wait timeout exceede； try restarting transaction
m0_47637225的博客
07-20 3250
记录一次mysql表被锁的经历。Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值