spring嵌套事务,日志,流程记录

2021-09-01 14:23:13.908 DEBUG 6192 --- [nio-8010-exec-1] o.s.j.d.DataSourceTransactionManager     : Creating new transaction with name [com.ryan.practice.redislock.service.tran.ServiceA.addWillDeleteUser]: PROPAGATION_REQUIRED,ISOLATION_READ_COMMITTED,-java.lang.Exception
2021-09-01 14:23:13.909 DEBUG 6192 --- [nio-8010-exec-1] o.s.j.d.DataSourceTransactionManager     : Acquired Connection [HikariProxyConnection@1082933369 wrapping com.mysql.jdbc.JDBC4Connection@74c074e5] for JDBC transaction
2021-09-01 14:23:13.911 DEBUG 6192 --- [nio-8010-exec-1] o.s.jdbc.datasource.DataSourceUtils      : Changing isolation level of JDBC Connection [HikariProxyConnection@1082933369 wrapping com.mysql.jdbc.JDBC4Connection@74c074e5] 

2021-09-01 14:23:13.912 DEBUG 6192 --- [nio-8010-exec-1] o.s.j.d.DataSourceTransactionManager     : Switching JDBC Connection [HikariProxyConnection@1082933369 wrapping com.mysql.jdbc.JDBC4Connection@74c074e5] to manual commit
2021-09-01 14:23:13.919 DEBUG 6192 --- [nio-8010-exec-1] org.mybatis.spring.SqlSessionUtils       : Creating a new SqlSession
2021-09-01 14:23:13.923 DEBUG 6192 --- [nio-8010-exec-1] org.mybatis.spring.SqlSessionUtils       : Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4bf8dfc9]
2021-09-01 14:23:15.216 DEBUG 6192 --- [nio-8010-exec-1] o.m.s.t.SpringManagedTransaction         : JDBC Connection [HikariProxyConnection@1082933369 wrapping com.mysql.jdbc.JDBC4Connection@74c074e5] will be managed by Spring
2021-09-01 14:23:15.225 DEBUG 6192 --- [nio-8010-exec-1] c.r.p.r.mapper.UserMapper.insert         : ==>  Preparing: INSERT INTO t_user ( id, user_name, age, is_delete ) VALUES ( ?, ?, ?, ? ) 
2021-09-01 14:23:15.240 DEBUG 6192 --- [nio-8010-exec-1] c.r.p.r.mapper.UserMapper.insert         : ==> Parameters: 1432952171097329666(Long), May(String), 18(Integer), 0(Integer)
2021-09-01 14:23:15.366 DEBUG 6192 --- [nio-8010-exec-1] c.r.p.r.mapper.UserMapper.insert         : <==    Updates: 1
2021-09-01 14:23:15.366 DEBUG 6192 --- [nio-8010-exec-1] org.mybatis.spring.SqlSessionUtils       : Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4bf8dfc9]

2021-09-01 14:23:15.367 DEBUG 6192 --- [nio-8010-exec-1] o.s.j.d.DataSourceTransactionManager     : Creating nested transaction with name [com.ryan.practice.redislock.service.tran.ServiceA.updateWillDeleteUser]
2021-09-01 14:23:15.374 DEBUG 6192 --- [nio-8010-exec-1] org.mybatis.spring.SqlSessionUtils       : Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4bf8dfc9] from current transaction
2021-09-01 14:23:15.406 DEBUG 6192 --- [nio-8010-exec-1] c.r.p.r.mapper.UserMapper.update         : ==>  Preparing: UPDATE t_user SET is_delete=? WHERE user_name=? 
2021-09-01 14:23:15.407 DEBUG 6192 --- [nio-8010-exec-1] c.r.p.r.mapper.UserMapper.update         : ==> Parameters: 1(Integer), May(String)
2021-09-01 14:23:15.462 DEBUG 6192 --- [nio-8010-exec-1] c.r.p.r.mapper.UserMapper.update         : <==    Updates: 26
2021-09-01 14:23:15.462 DEBUG 6192 --- [nio-8010-exec-1] org.mybatis.spring.SqlSessionUtils       : Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4bf8dfc9]
2021-09-01 14:23:15.462 DEBUG 6192 --- [nio-8010-exec-1] o.s.j.d.DataSourceTransactionManager     : Rolling back transaction to savepoint

2021-09-01 14:23:15.463 DEBUG 6192 --- [nio-8010-exec-1] org.mybatis.spring.SqlSessionUtils       : Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4bf8dfc9]
2021-09-01 14:23:15.464 DEBUG 6192 --- [nio-8010-exec-1] org.mybatis.spring.SqlSessionUtils       : Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4bf8dfc9]
2021-09-01 14:23:15.464 DEBUG 6192 --- [nio-8010-exec-1] org.mybatis.spring.SqlSessionUtils       : Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4bf8dfc9]
2021-09-01 14:23:15.464 DEBUG 6192 --- [nio-8010-exec-1] o.s.j.d.DataSourceTransactionManager     : Initiating transaction commit
2021-09-01 14:23:15.464 DEBUG 6192 --- [nio-8010-exec-1] o.s.j.d.DataSourceTransactionManager     : Committing JDBC transaction on Connection [HikariProxyConnection@1082933369 wrapping com.mysql.jdbc.JDBC4Connection@74c074e5]
2021-09-01 14:23:15.523 DEBUG 6192 --- [nio-8010-exec-1] o.s.jdbc.datasource.DataSourceUtils      : Resetting isolation level of JDBC Connection [HikariProxyConnection@1082933369 wrapping com.mysql.jdbc.JDBC4Connection@74c074e5] to 4
2021-09-01 14:23:15.524 DEBUG 6192 --- [nio-8010-exec-1] o.s.j.d.DataSourceTransactionManager     : Releasing JDBC Connection [HikariProxyConnection@1082933369 wrapping com.mysql.jdbc.JDBC4Connection@74c074e5] after transaction
2021-09-01 14:23:15.593 DEBUG 6192 --- [nio-8010-exec-1] m.m.a.RequestResponseBodyMethodProcessor : Using 'application/json', given [*/*] and supported [application/json, application/*+json, application/json, application/*+json]
2021-09-01 14:23:15.593 DEBUG 6192 --- [nio-8010-exec-1] m.m.a.RequestResponseBodyMethodProcessor : Writing [com.ryan.practice.redislock.common.api.ResponseData@64c198b5]
2021-09-01 14:23:15.625 DEBUG 6192 --- [nio-8010-exec-1] o.s.web.servlet.DispatcherServlet        : Completed 200 OK


jdbc connection -> new sqlsession -> 执行sql -> release transactional sqlsession -> creating nested transaction -> fetch sqlsession -> release transactional sqlsession -> transaction committing sqlsession -> 
initiating transaction commit -> commit jdbc transaction on connection -> resetting isolation level of jdbc connection -> release jdbc connection 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值