org.springframework.transaction.UnexpectedRollbackException 解决

2023-11-17

1、异常

org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only

	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:870)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:707)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:633)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:386)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.ybw.mybatis.transactional.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$d32577fe.saveUserAndPerson3(<generated>)
	at com.ybw.mybatis.transactional.service.UserServiceTest.saveUserAndPerson3(UserServiceTest.java:30)
	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.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:686)
	at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
	at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)
	at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:212)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:208)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:137)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:71)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:135)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1249)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1249)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:248)
	at org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$5(DefaultLauncher.java:211)
	at org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:226)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:199)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:132)
	at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:71)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)

2、代码示例

https://gitee.com/xixingzhe2/learn/tree/master/mybatis/mybatis-transactional

执行UserServiceTest的saveUserAndPerson3，报错

[DEBUG] 2021-05-20 10:32:31.832 [main] org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
[DEBUG] 2021-05-20 10:32:31.848 [main] org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c50cd7d]
[DEBUG] 2021-05-20 10:32:31.910 [main] o.m.s.t.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@3a4f8e8a] will be managed by Spring
[DEBUG] 2021-05-20 10:32:31.926 [main] c.y.m.t.mapper.UserMapper.insert - ==>  Preparing: INSERT INTO user ( name, age ) VALUES ( ?, ? )
[DEBUG] 2021-05-20 10:32:32.004 [main] c.y.m.t.mapper.UserMapper.insert - ==> Parameters: 张三3(String), 13(Integer)
[DEBUG] 2021-05-20 10:32:32.020 [main] c.y.m.t.mapper.UserMapper.insert - <==    Updates: 1
[DEBUG] 2021-05-20 10:32:32.066 [main] org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c50cd7d]
[DEBUG] 2021-05-20 10:32:32.082 [main] org.mybatis.spring.SqlSessionUtils - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c50cd7d] from current transaction
[DEBUG] 2021-05-20 10:32:32.082 [main] c.y.m.t.mapper.PersonMapper.insert - ==>  Preparing: INSERT INTO person ( name, age ) VALUES ( ?, ? )
[DEBUG] 2021-05-20 10:32:32.082 [main] c.y.m.t.mapper.PersonMapper.insert - ==> Parameters: 王五2(String), 22(Integer)
[DEBUG] 2021-05-20 10:32:32.082 [main] c.y.m.t.mapper.PersonMapper.insert - <==    Updates: 1
[DEBUG] 2021-05-20 10:32:32.098 [main] org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c50cd7d]
[ERROR] 2021-05-20 10:32:32.098 [main] c.y.m.t.service.impl.UserServiceImpl - UserServiceImpl saveUserAndPerson3:
java.lang.ArithmeticException: / by zero
	at com.ybw.mybatis.transactional.service.impl.PersonServiceImpl.savePerson3(PersonServiceImpl.java:51)
	at com.ybw.mybatis.transactional.service.impl.PersonServiceImpl$$FastClassBySpringCGLIB$$99c0c938.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.ybw.mybatis.transactional.service.impl.PersonServiceImpl$$EnhancerBySpringCGLIB$$34862a60.savePerson3(<generated>)
	at com.ybw.mybatis.transactional.service.impl.UserServiceImpl.saveUserAndPerson3(UserServiceImpl.java:63)
	at com.ybw.mybatis.transactional.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$d0dc2902.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.ybw.mybatis.transactional.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$d32577fe.saveUserAndPerson3(<generated>)
	at com.ybw.mybatis.transactional.service.UserServiceTest.saveUserAndPerson3(UserServiceTest.java:30)
	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.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:686)
	at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
	at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)
	at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:212)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:208)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:137)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:71)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:135)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1249)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1249)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:248)
	at org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$5(DefaultLauncher.java:211)
	at org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:226)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:199)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:132)
	at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:71)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)
[DEBUG] 2021-05-20 10:32:32.098 [main] org.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c50cd7d]
[DEBUG] 2021-05-20 10:32:32.098 [main] org.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c50cd7d]

org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only

	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:870)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:707)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:633)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:386)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.ybw.mybatis.transactional.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$d32577fe.saveUserAndPerson3(<generated>)
	at com.ybw.mybatis.transactional.service.UserServiceTest.saveUserAndPerson3(UserServiceTest.java:30)
	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.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:686)
	at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
	at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)
	at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:212)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:208)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:137)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:71)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:135)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1249)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1249)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:248)
	at org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$5(DefaultLauncher.java:211)
	at org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:226)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:199)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:132)
	at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:71)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)

3、原因分析

saveUserAndPerson3和savePerson3都是@Transactional，@Transactional默认传播属性为PROPAGATION_REQUIRED，PROPAGATION_REQUIRED的意思是，当前有事务，则使用当前事务，当前无事务则创建事务。
saveUserAndPerson3会创建一个事务，savePerson3与saveUserAndPerson3使用同一个事务，savePerson3出现异常后，将当前事务标志位回滚，由于在saveUserAndPerson3中做了trycatch处理，程序没有终止而是继续往下走，当事务commit时，check状态，发现，需要事务回滚，所以才会出现不可预知的事务异常:因为事务被标志位回滚，所以事务回滚。

总结：

saveUserAndPerson3与savePerson3共用一个事务，savePerson3将事务标志为回滚，saveUserAndPerson3中commit这个事务，然后，出现事务已经被标志回滚（savePerson3标志的）的异常信息。

4、解决

savePerson3的注解使用@Transactional(rollbackFor = Exception.class,propagation = Propagation.REQUIRES_NEW)，saveUserAndPerson3，就可以正常提交了。

REQUIRES_NEW：创建一个新事务，如果当前存在事务，将这个事务挂起。也就是说如果当前存在事务，那么将当前的事务挂起，并开启一个新事务去执行REQUIRES_NEW标志的方法。

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)

mysql

org.springframework.transaction.UnexpectedRollbackException 解决的相关文章

使用 EXPLAIN 进行 MYSQL 存储过程调用

如何分析和使用 EXPLAIN 来调用我的存储过程我需要优化查询时间但是似乎没有地方可以执行 EXPLAIN 调用 proc name 你可以试试 set profiling 1 call proc name show profiles
MySql 查询在选择中将 NULL 替换为空字符串

如何用空字符串替换 select 中的 NULL 值输出 NULL 值看起来不太专业这是非常不寻常的根据我的语法我希望它能够工作我希望能得到一个解释为什么没有 select CASE prereq WHEN prereq IS
执行许多插入重复键更新错误：未使用所有参数

所以我一直在尝试使用 python 2 7 15 使用 mysql connector 执行此查询但由于某种原因它似乎不起作用并且总是返回错误并非所有参数都被使用表更新有一个主键即 ID 这是我尝试运行此 SQL 的查询 sql
在 MySQL 中分割逗号分隔值

我正在尝试将字符串中以逗号分隔的值拆分为多列样本数据 COL1 COL2 COL3 000002 000003 000042 09 31 51 007 004 007 预期输出 Pno Cno Sno 000002 09 007 000
php 崩溃后 mysql 表被锁定

我有一个 MySQL DB 和一个 innoDB 表我有一个 php 页面用于连接锁定表进行一些更新然后解锁表 PHP 页面通过 wamp 与 apache 一起提供 php页面将文件上传到数据库我决定通过上传一个大小大于分配给
PMA 4.5.2.0 file_exists()：open_basedir 限制生效

从 PPA 在我的 Ubuntu 服务器上安装 phpMyAdmin 后 https launchpad net nijel archive ubuntu phpmyadmin https launchpad net nijel archi
从 PDO 准备好的语句中获取原始 SQL 查询字符串

在准备好的语句上调用 PDOStatement execute 时有没有办法让原始 SQL 字符串执行出于调试目的这将非常有用我假设您的意思是您想要最终的 SQL 查询并将参数值插入其中我知道这对于调试很有用但这不是准备好的语
#1045 - 用户“root”@“localhost”的访问被拒绝（使用密码：YES）

这可能看起来多余但我无法找到正确的解决方案我无法使用 mysql 控制台登录 mysql 它要求输入密码但我不知道我实际输入的内容有办法获取密码或更改密码吗这就是我的 config inc 的样子当我尝试打开 phpmyadmi
从数据库 MYSQL 和 Codeigniter 获取信息

如果你们需要其他信息上一个问题就在这里从数据库中获取信息 https stackoverflow com questions 13336744 fetching information from the database 另一个更新尽
高效插入和更新时检查唯一性

我的员工表中有 2 列每列值必须是唯一的 staff code staff name staff id staff code staff name 1 MGT Management 2 IT IT staff 当向表中插入或更新项目时我
如何使用 PHP 获取列中的所有值？

我一直在到处寻找这个问题但仍然找不到解决方案如何从 mySQL 列中获取所有值并将它们存储在数组中例如表名称客户列名称 ID 名称行数 5 我想获取此表中所有 5 个名称的数组我该如何去做呢我正在使用 PHP 我试图 SE
通过将行旋转为动态数量的列来在 MySQL 中创建摘要视图

我在 MySQL 中有一个表其中包含以下字段 id company name year state 同一客户和年份有多行以下是数据示例 id company name year state 1 companyA 2008 1 2 com
在JavaFX中如何在表视图中添加带有数据的组合框

我已经尝试了很多但无法将数据库中的所有值填充到我的组合框表格单元格中控制器 java public class controller GetConnection gc new GetConnection PreparedStatemen
如何在数据库中保存未来（！）日期

这个问题专门涉及未来的日期和时间对于过去的值 UTC 无疑是首选我想知道是否有人对拯救生命的最佳方法有建议futureMySQL 数据库中的日期和时间或者就此而言一般来说特别是在该列可以保存不同时区时间的情况下考虑到时区规则可
如何在 MacOS 上卸载 Mysql Shell

我错误地安装了 MySql Shellhttps dev mysql com doc mysql shell 8 0 en https dev mysql com doc mysql shell 8 0 en 在我的 MacBook Pro
MySql 从另一个表中减去一个表

我有两个表 A 包含所有数据表 B 从 A 中随机选择 25 的数据创建所以 A 和 B 具有完全相同的列也没有独特的列我想做的是从 A 中减去 B 有什么想法吗查看所有行A除了那些在B SELECT FROM A WHERE f
PHP + MySQL 队列

我需要一个充当队列的简单表我的 MySQL 服务器限制是我不能使用 InnoDB 表只能使用 MyISAM 客户工人将同时工作他们每次都需要接受不同的工作我的想法是执行以下操作伪代码 job lt SELECT FROM que
MySQL 选择第一个字符在哪里

如何选择单元格的第一个字符并使用它来定义返回的内容看看MySQL 字符串和控制流功能 http dev mysql com doc refman 5 1 en functions html 例如 SELECT IF LEFT myF
MySQL 中的 group_concat 性能问题

我添加了一个group concat到一个查询并杀死了性能添加之前和之后的解释计划是相同的所以我对如何优化它感到困惑这是查询的简化版本 SELECT curRow curRow 1 AS row number docID docTyp
安装后步骤未成功完成 MySQL Mac OS Sierra

pyEnv Anants MacBook Pro litibackend anantchandra brew postinstall mysql gt Postinstalling mysql gt usr local Cellar mys

随机推荐

CC2541低功耗测试实验

转载 https blog csdn net u014647208 article details 52574880 暂未进行验证仅做笔记以备不时之需实测得这样写 include
[已解决]Jupyter notebook的Nbextensions不显示可以用的拓展

Nbextensions只显示几个自带的扩展想装新的但是找不到入口解决方案第一步卸载已安装的执行下面两个指令 pip uninstall jupyter contrib nbextensions pip uninstall jup
DenseNet学习与实现

Densely Connected Convolutional Networks 提出了DenseNet 它用前馈的方式连接每一层与所有其他层 L层网络共有 L L 1
解决：org.codehaus.jackson.JsonParseException:Unexpected end-of-input: expected close marker for OBJEC

解决 org codehaus jackson JsonParseException Unexpected end of input expected close marker for OBJECT 文章目录解决 org codehaus
ora-01578: oracle 数据块损坏,Oracle ORA-01578坏块解决方法

本帖最后由 paulyi 于 2014 1 19 13 15 编辑一出问题时的情景我在自己测试数据库上给大表 tb table导完数据后建立索引时出现以下错误 ORA 01578 ORACLE data block corrupt
数字化时代-29：CSDN排名规则详细解读

最近在CSDN的总榜单上一直徘徊在1000名出头每周有二十多篇的新的原创文章总积分也在持续增长但排名一直没有进步我很好奇难道其他1000名左右的创造者的都这么疯狂每周都会发表20篇以上的文章于是怀着好奇心研读了一下CSDN排名
利用vue-cli脚手架创建项目

利用vue cli脚手架创建项目安装vue cli脚手架全局安装 npm install g vue cli 使用vue version查看是否安装完成显示对应版本号使用命令行创建 vue create 项目名称 default包含
几个高危端口

注意到检测系统显示的高危漏洞分别是22 135 139 445 3389端口今天就分别了解下这些端口一般情况下是干什么用的 22 22端口一般用于ssh的数据传输一般linux系统除非你直接在终端上操作不然你多半会通过ssh连接到l
吐血推荐！5款好用又骚气的神站！真的有毒！（附网址）

1 交互式元素周期表 https ptable com 喜欢化学的同学千万不要错过了这里可以在线学习交互式元素周期表想知道什么元素让你学习到丰富的化学元素知识 2 无聊巨作VII第二部 http www spielzeugz de h
使用StarUML创建类图

1 综述 What StarUML是一种生成类图和其他类型的UML图表的工具本文是一个使用StarUML创建类图 Java语言描述的简明手册 StarUML 简称SU 是一种创建UML类图并能够自动生成Java的 stub code
概说概要设计怎么做

概说概要设计怎么做 51CMM COM原创作者厦门巨龙软件工程有限公司卢琳生 2003 12 22 摘要本文是在概要设计实践和学习中的一些心得与学习笔记希望与大家分享如有不妥之处欢迎指正关键字概要设计结构化 OOD 正文
大数据学习-3.Linux下Web服务器的搭建与配置

文章目录简介一关闭防火墙和selinux 1 关闭防火墙 1 关闭selinux 二 Web服务器与配置 1 Apache 2 Nginx 简介本文主要介绍在CentOS下 Apache与Nginx 服务的搭建与配置一关闭防火墙
springboot redis Unsatisfied dependency expressed through method ‘redisTemplate‘ parameter 0

pom xml中导入包更换写
SpringBoot RabbitMq 六大模式

目录依赖配置简单队列模型代码示例工作队列模型代码示例订阅模式模型代码示例路由模式模型代码示例主题模式模型代码示例 RPC 依赖配置依赖
【华为机试在线训练】Day 10

自动售货系统题目描述 1 总体说明考生需要模拟实现一个简单的自动售货系统实现投币购买商品退币查询库存商品及存钱盒信息的功能系统初始化时自动售货机中商品为6种商品商品的单价参见1 1规格说明存钱盒内放置1元 2元 5元 10
POJ - 3259 Wormholes

While exploring his many farms Farmer John has discovered a number of amazing wormholes A wormhole is very peculiar beca
linux网络全景指南

自我介绍腾讯云网络高级工程师腾讯云网络核心开发人员欢迎微信搜索职场重生关注公众号职场重生后续更多精彩内容发布万字长文建议收藏引言本期分享一个比较常见的络问题丢包例如我们去ping 个站如果能ping通且站
python画散点图-python学习之matplotlib绘制散点图实例

要绘制单个点可使用函数scatter 并向其传递一对x和y坐标它将在指定位置绘制一个点使用scatter 绘制散点图 import matplotlib pyplot as plt plt scatter 2 4 plt show 下
visual studio 的各个版本下载地址，很全，从 6.0 一直到 vs2013，要的拿去吧

Microsoft Visual Studio 6 0 下载英文版360云盘下载 http l11 yunpan cn lk sVeBLC3bhumrI 英文版115网盘下载 http 115 com file bew2qrau 英文版迅
org.springframework.transaction.UnexpectedRollbackException 解决

1 异常 org springframework transaction UnexpectedRollbackException Transaction rolled back because it has been marked as r