维帝博客 - Spring事务嵌套导致的异常,Transaction rolled back because it has been marked as rollback-only

### Transaction rolled back because it has been marked as rollback-only

#### 1. 原因

- 线上故障，后来定位异常，最终发现是spring事务嵌套的导致的，特此记录

##### 我追查了代码，发现是事务嵌套的问题，网上搜了很多,最终

[YourBatman](https://blog.csdn.net/f641385712/article/details/80445912?depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-4&utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-4 "YourBatman")的博客解决了我的问题

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/20211215142304280851fe75be4f6db09310f4781b0d4f/111.png)

##### 发生回滚（在类上添加了@Transactional注解，所以后面的方法都是有事务的）发生回滚（在类上添加了@Transactional注解，所以后面的方法都是有事务的）

###### 1. 嵌套事务的情况，发生异常正常回滚

- 添加transactional注解后当发生异常，回滚

新增文章分类

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/202112151425198c1667e45b8f46799295bea1b90a7455/111.png)

- 新增文章

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/20211215142545657a736e32b542a4921d5a8d7da38a0c/111.png)

- 测试

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/20211215142615d992bd2190304596b2d2013fbc5f9877/111.png)

#### 数据发生异常且正常回滚

##### 2. 嵌套事务的情况，发生异常报Transaction rolled back because it has been marked as rollback-only

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/202112151426533ce446a864c246ac965403c04be2a56e/111.png)

- 使用try catch包起来，然后报异常

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/2021121514271612065fe738414b83a8a821cec8f7000e/111.png)

- 解决方案：在catch中添加**TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();**

- 或者尽量不要在service中try catch

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/2021121514280287bd811e1c0d41faa4f185f35bf3a689/111.png)