MySQL数据更新中断后事务锁定

最新推荐文章于 2023-05-03 21:21:43 发布
最新推荐文章于 2023-05-03 21:21:43 发布
阅读量2.2k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/FanJizhi/article/details/73289875
版权
问题：数据在更新的时候强制停止后，再次操作报异常：Lock wait timeout exceeded; try restarting transaction


问题描述：

### Error updating database.  Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: UPDATE  dis_order_traffic                   SET traffic_no = ? ,                                     remarks = ? ,                                                                           status = ? ,                                  vehicle_no = ? ,                 member_name = ? ,                                             update_by = ? ,                                                    update_date = ? ,                                       del_flag = ? ,                                     company_id = ?              WHERE            id = ?
### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
org.springframework.dao.CannotAcquireLockException: 
### Error updating database.  Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: UPDATE  dis_order_traffic                   SET traffic_no = ? ,                                     remarks = ? ,                                                                           status = ? ,                                  vehicle_no = ? ,                 member_name = ? ,                                             update_by = ? ,                                                    update_date = ? ,                                       del_flag = ? ,                                     company_id = ?              WHERE            id = ?
### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:259)
	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:371)
	at com.sun.proxy.$Proxy23.update(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:254)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:54)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	at com.sun.proxy.$Proxy50.update(Unknown Source)
	at com.cl.runtime.service.CrudService.save(CrudService.java:101)
	at com.cl.runtime.service.CrudService$$FastClassBySpringCGLIB$$7767ab0.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:654)
	at com.zyyw.pscq.modules.dispatch.service.OrderTrafficService$$EnhancerBySpringCGLIB$$1f1634fb.save(<generated>)
	at com.cl.runtime.service.CrudService$$FastClassBySpringCGLIB$$7767ab0.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:654)
	at com.zyyw.pscq.modules.dispatch.service.OrderTrafficService$$EnhancerBySpringCGLIB$$b089fdd1.save(<generated>)
	at com.zyyw.pscq.modules.dispatch.service.DeliveryTaskService.createTraffic(DeliveryTaskService.java:101)
	at com.zyyw.pscq.modules.dispatch.service.DeliveryTaskService$$FastClassBySpringCGLIB$$91d7c9af.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:654)
	at com.zyyw.pscq.modules.dispatch.service.DeliveryTaskService$$EnhancerBySpringCGLIB$$ca7ed831.createTraffic(<generated>)
	at com.zyyw.pscq.modules.dispatch.service.DeliveryTaskService$$FastClassBySpringCGLIB$$91d7c9af.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:654)
	at com.zyyw.pscq.modules.dispatch.service.DeliveryTaskService$$EnhancerBySpringCGLIB$$c6eebd47.createTraffic(<generated>)
	at com.zyyw.pscq.modules.dispatch.web.DeliveryTaskController.save(DeliveryTaskController.java:384)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	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:648)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	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:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:118)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62)
	at com.sun.proxy.$Proxy132.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
	at com.sun.proxy.$Proxy130.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	... 106 more
解决办法：


去事务表中查看正在锁定的事务线程：


SELECT * FROM information_schema.INNODB_TRX;


然后查看线程信息：


show full processlist;


发现：


+---------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+---------------------------+---------------------------+
| trx_id  | trx_state | trx_started         | trx_requested_lock_id | trx_wait_started | trx_weight | trx_mysql_thread_id | trx_query | trx_operation_state | trx_tables_in_use | trx_tables_locked | trx_lock_structs | trx_lock_memory_bytes | trx_rows_locked | trx_rows_modified | trx_concurrency_tickets | trx_isolation_level | trx_unique_checks | trx_foreign_key_checks | trx_last_foreign_key_error | trx_adaptive_hash_latched | trx_adaptive_hash_timeout |
+---------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+---------------------------+---------------------------+
| 60F3D22 | RUNNING   | 2017-06-14 16:04:19 | NULL                  | NULL             |          1 |                 321 | NULL      | NULL                |                 0 |                 0 |                1 |                   376 |               0 |                 0 |                       0 | REPEATABLE READ     |                 1 |                      1 | NULL                       |                         0 |                     10000 |
| 60F2F35 | RUNNING   | 2017-06-14 15:49:04 | NULL                  | NULL             |          5 |                 289 | NULL      | NULL                |                 0 |                 0 |                3 |                   376 |               1 |                 2 |                       0 | REPEATABLE READ     |                 1 |                      1 | NULL                       |                         0 |                     10000 |
+---------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+---------------------------+---------------------------+
2 rows in set


线程编号：321,289出现了锁定，
KILL掉：kill 321;
kill 289;


解决。


ps:对数据库进行这些操作需要有较高的权限



参考：http://blog.csdn.net/mchdba/article/details/38313881

FanJizhi
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
解析MySQL8.0新特性——事务性数据字典与原子DDL
12-14
MySQL 8.0引入了两个重大改进：事务性数据字典和原子DDL，这两个特性显著增强了数据库管理系统在处理元数据和结构定义时的可靠性和一致性。 **事务性数据字典**： 在MySQL 8.0之前的版本中，数据字典信息分散在多个...
MYSQL事务终止时造成死锁
webnoties的专栏
07-05 1951
其实这个问题多数出现于自己写的框架源码中。在开源框架中一般都会顾及到这个问题的。解决方法就是自己没能力写框架，就不要装B乱写。 mysql_connectmysql_pconnect
MySQL update正在执行中突然断电，数据是否更改成功？
做一个乐于分享的程序员
11-04 1602
mysql redolog binlog
Mysql死锁问题如何排查和解决
最新发布
qq_43842093的博客
05-03 4126
发生死锁了，如何排查和解决呢？本文将跟你一起探讨这个问题准备好数据环境模拟死锁案发分析死锁日志分析死锁结果在分析死锁日志前，先做一下锁介绍，哈哈~最后，遇到死锁问题，我们应该怎么分析呢？模拟死锁场景查看死锁日志找出死锁SQLSQL加锁分析，这个可以去官网看哈分析死锁日志（持有什么锁，等待什么锁）熟悉锁模式兼容矩阵，InnoDB存储引擎中锁的兼容性矩阵。
【MySQL】MySQL事务死锁的处理
XLevon的博客
12-15 900
最近在操作mysql时，发现drop view一直执行没结果， 1、通过show processlist; 发现进程处于 “Waiting for table metadata lock”状态， 2、通过select trx_state, trx_started, trx_mysql_thread_id, trx_query from information_schema.innodb_trx; 发现有异常事务，譬如trx_started，事务执行的起始时间较长，则分析是否异常。 3、通..
mysql事务锁死_mysql事务锁锁死Lockwaittimeoutexceeded;tryrestartingtransaction解决
weixin_30372331的博客
01-28 625
问题现象：接口响应时间超长，耗时几十秒才返回错误提示，后台日志中出现Lock wait timeout exceeded; tryrestarting transaction的错误问题场景：1、在同一事务内先后对同一条数据进行插入和更新操作；2、多台服务器操作同一数据库；3、瞬时出现高并发现象；问题原因：1、在高并发的情况下，Spring事物造成数据库死锁，后续操作超时抛出异常。2、Mysql数据...
海量数据的MySQL数据集
07-16
InnoDB存储引擎是MySQL处理事务的主要引擎，它使用行级锁定来减少并发操作的冲突，并支持事务日志，以确保数据一致性。此外，MySQL的MyISAM引擎在读取密集型应用中表现良好，但不支持事务，因此根据应用场景选择合适...
MySQL修改数据表存储引擎的3种方法介绍
09-10
然后将原表数据插入新表，可以使用事务以确保数据一致性，并限制主键ID范围以提高效率： ```sql START TRANSACTION; INSERT INTO my_tmp_table SELECT * FROM my_table WHERE id BETWEEN start_id AND end_id; ...
MySQL 数据备份与还原的示例代码
09-09
- `--flushlog`：备份后将数据库的更新记录到日志中。 - `--noindices`：只备份数据文件，不备份索引文件。 - `--user`, `--password`, `--port`, `--socket`：分别用于指定用户名、密码、端口号和socket文件。 ...
Mysql 出现故障应用直接中断连接导致数据被锁（生产故障）详解
09-09
MySQL 数据库在运行过程中可能会遇到各种故障，其中一种常见的问题是应用程序突然中断连接，这可能导致数据被锁定，进而引发生产环境的故障。这种情况下，数据库的事务处理机制未能正常完成，从而影响了系统的正常...
mysql 事务等待锁超时分析
03-29
mysql 事务等待锁超时分析
mysql事务锁死解决
weixin_42547619的博客
08-24 972
在做mysql事务锁表的时候，未进行提交。会导致表进行锁死，无法操作活超时，此时执行 SHOW FULL PROCESSLIST 结果如 找到事务执行的db，看看等待时间最长的那个id，然后执行kill id即可大部分解决 ...
Mysql事务以及锁原理、死锁及解决方法
mashaokang1314的博客
03-25 1284
select for uodate 打开两个mysql客户端； 创建两张表,并且都插入几条用于测试的数据； create table client1( clientId int(2), sex int(2), name int(2) ); create table client2( clientId int(2) primary key , sex int(2), name int...
mysql更新和回滚造成锁表_数据库遇到的问题——事务操作时中断导致锁表
weixin_28746213的博客
01-19 1250
事务操作时中断导致锁表1.导致锁表的原因1.1首先是大前提我们正常的框架在service层都会有事物控制，比如我一个service层的方法要执行更新两张表，这两个表只有同时更新成功才算成功，如果有一个异常，事务回滚。1.2 我的操作这是源代码的部分，当debug到sysEleMaterialClassService.updateChildParentId();出现异常，然后在catch里我打了个断...
mysql怎么终止一个事务_用户如何明确终止当前的MySQL事务？
weixin_29479879的博客
02-02 5403
以下是可以明确结束当前MySQL事务的方法-通过COMMIT命令如果我们将运行COMMIT命令，则当前事务将明确结束。在这种情况下，更改将被提交。示例mysql>STARTTRANSACTION;mysql>INSERTINTOMarksValues(1,'Aarav','Maths',50);mysql>INSERTINTOMarksValues(2,'...
mysql停止更新时间,MySQL – 当UPDATE命令被中断时会发生什么？
weixin_39978257的博客
03-23 808
我通过My​​SQL命令行客户端发出了一个长时间运行的UPDATE查询(一个不正确的查询),并在几秒钟后用Ctrl-C将其停止.该命令尚未完成运行.我的数据库是否会针对某些条目进行更新,还是会在事务中发生并且所有内容都会回滚？mysql> ^CCtrl-C -- sending "KILL QUERY 12088743" to server ...Ctrl-C -- query aborte...
当MySQL事务中发生了网络异常
程序员麦冬的博客（公众号同名）
10-08 656
一、前言 在我们运维MySQL的时候，总会遇到各种情况导致程序和MySQL之间的会话异常中断，比如 假如强制关闭应用 假如client机器突然崩溃宕机/断电 假如网络发生抖动/网卡发生故障 机房级别断网 那么此时正在MySQL中执行的事务会何表现？ 二、实践 设计一个案例模拟client 在MySQL中执行事务，但是client机器突然down机，导致会话异常中断。 client 192.168.56.102 MySQL 192.168.56.101 client 连接db 执行 select
mysql 开发中重启中断事务，导致表事务等待超时解决方法
qq_22744093的博客
07-18 626
代码】mysql开发中重启中断事务，导致表事务等待超时解决方法。
MySql终止当前事务，终止当前执行语句。
zsh
01-17 3274
Mysql终止当前事务，终止当前执行语句。 第一步：查询执行语句。 第二步：kill。
最新mysql面试题整理大厂必备，你能答对几个？
03-29
12. **日志系统**：MySQL的日志主要包括二进制日志（binlog）和重做日志（redo log），前者用于复制和恢复，后者用于事务持久化。 13. **redo log与binlog的区别**：redo log记录事务对InnoDB数据页的更改，用于...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值