优化记录(10)： MySQLTransactionRollbackException 如何处理：

一、看错误日志：

java.lang.reflect.InvocationTargetException: null  
  at sun.reflect.GeneratedMethodAccessor848.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
    at cn.com..XXX..XXX..XXX.interceptor.SqlStatementInterceptor.intercept(SqlStatementInterceptor.java:58)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
    at com.sun.proxy.$Proxy279.update(Unknown Source)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
    at sun.reflect.GeneratedMethodAccessor860.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
    at com.sun.proxy.$Proxy118.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.$Proxy128.updatePersonStatus(Unknown Source)
    at cn.com..XXX..XXX..XXX.service.impl.biztrainpersoninfo.UpdatePersonBookingStatusServiceImpl.updatePersonAssociationStatus(UpdatePersonBookingStatusServiceImpl.java:142)
    at cn.com..XXX..XXX...XXX.service.impl.biztrainpersoninfo.UpdatePersonBookingStatusServiceImpl$$FastClassBySpringCGLIB$$d214b659.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at cn.com..XXX..XXX..XXX.service.impl.biztrainpersoninfo.UpdatePersonBookingStatusServiceImpl$$EnhancerBySpringCGLIB$$36a0bda0.updatePersonAssociationStatus(<generated>)
    at org.apache.dubbo.common.bytecode.Wrapper316.invokeMethod(Wrapper316.java)
    at org.apache.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:47)
    at org.apache.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:84)
    at org.apache.dubbo.config.invoker.DelegateProviderMetaDataInvoker.invoke(DelegateProviderMetaDataInvoker.java:56)
    at org.apache.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:56)
    at org.apache.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:77)
    at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
    at org.apache.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:46)
    at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
    at org.apache.dubbo.monitor.support.MonitorFilter.invoke$original$6um8Dk25(MonitorFilter.java:91)
    at org.apache.dubbo.monitor.support.MonitorFilter.invoke$original$6um8Dk25$accessor$uXnC035D(MonitorFilter.java)
    at org.apache.dubbo.monitor.support.MonitorFilter$auxiliary$gS4q9tWr.call(Unknown Source)
    at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)
    at org.apache.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java)
    at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
    at org.apache.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:52)
    at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
    at org.apache.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:192)
    at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
    at org.apache.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)
    at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
    at org.apache.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:41)
    at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
    at org.apache.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:129)
    at org.apache.dubbo.rpc.protocol.FilterNode.invoke(FilterNode.java:61)
    at org.apache.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:148)
    at org.apache.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:100)
    at org.apache.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:175)
    at org.apache.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:51)
    at org.apache.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:57)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.dubbo.common.threadlocal.InternalRunnable.run(InternalRunnable.java:41)
    at java.lang.Thread.run(Thread.java:748)

二、处理办法

这个问题应该是mysql事务回滚异常，超过锁等待超时；尝试重新启动事务

此次产生原因：

• 执行DML语句时，用时长导致表锁。

问题排查步骤：

1、查询所有表事务：执行的sql中是否有你的表

SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX

2、查询的结果中，如何存在锁住的目标对象表，则需要用kill 命令将其杀掉

kill 进程ID; // 进程ID,时 第一步的查询结果 trx_mysql_thread_id 字段结果

3、 查询是否存在其他锁的情况

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;  // 正在锁的事务查询
​
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; // 正在等待锁的事务查询语句