fantacy2001 commented on issue #6753:
URL: https://github.com/apache/shardingsphere/issues/6753#issuecomment-671313193
> @fantacy2001 Can you show more stack info of shardingjdbc?
2020-08-10 19:57:45 [DEBUG] [main] -
org.mybatis.spring.SqlSessionUtils.getSqlSession():104 - Creating a new
SqlSession
2020-08-10 19:57:45 [DEBUG] [main] -
org.mybatis.spring.SqlSessionUtils.getSqlSession():140 - SqlSession
[org.apache.ibatis.session.defaults.DefaultSqlSession@583c416c] was not
registered for synchronization because synchronization is not active
2020-08-10 19:57:45 [DEBUG] [main] -
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection():110 -
Fetching JDBC Connection from DataSource
2020-08-10 19:57:45 [DEBUG] [main] -
org.mybatis.spring.transaction.SpringManagedTransaction.openConnection():86 -
JDBC Connection
[org.apache.shardingsphere.shardingjdbc.jdbc.core.connection.ShardingConnection@4140d677]
will not be managed by Spring
2020-08-10 19:57:45 [DEBUG] [main] -
com.jd.jcloud.wms.inventory.dao.stockFreeze.StockFreezeDetailDao.updateByStockFreezeDetailList.debug():139
- ==> Preparing: update stock_freeze_detail set row_status=case WHEN (id=?)
THEN ? WHEN (id=?) THEN ? WHEN (id=?) THEN ? end, update_user=case WHEN (id=?)
THEN ? WHEN (id=?) THEN ? WHEN (id=?) THEN ? end, update_time=case WHEN (id=?)
THEN ? WHEN (id=?) THEN ? WHEN (id=?) THEN ? end where tenant_id = ? and id in
( ? , ? , ? )
2020-08-10 19:57:45 [DEBUG] [main] -
com.jd.jcloud.wms.inventory.dao.stockFreeze.StockFreezeDetailDao.updateByStockFreezeDetailList.debug():139
- ==> Preparing: update stock_freeze_detail set row_status=case WHEN (id=?)
THEN ? WHEN (id=?) THEN ? WHEN (id=?) THEN ? end, update_user=case WHEN (id=?)
THEN ? WHEN (id=?) THEN ? WHEN (id=?) THEN ? end, update_time=case WHEN (id=?)
THEN ? WHEN (id=?) THEN ? WHEN (id=?) THEN ? end where tenant_id = ? and id in
( ? , ? , ? )
2020-08-10 19:57:45 [DEBUG] [main] -
com.jd.jcloud.wms.inventory.dao.stockFreeze.StockFreezeDetailDao.updateByStockFreezeDetailList.debug():139
- ==> Parameters: 3(Long), 2(Integer), 4(Long), 2(Integer), 10(Long),
2(Integer), 3(Long), ll(String), 4(Long), ll(String), 10(Long), ll(String),
3(Long), 2020-08-10 19:57:45.21(Timestamp), 4(Long), 2020-08-10
19:57:45.21(Timestamp), 10(Long), 2020-08-10 19:57:45.21(Timestamp),
jd(String), 3(Long), 4(Long), 10(Long)
2020-08-10 19:57:45 [DEBUG] [main] -
com.jd.jcloud.wms.inventory.dao.stockFreeze.StockFreezeDetailDao.updateByStockFreezeDetailList.debug():139
- ==> Parameters: 3(Long), 2(Integer), 4(Long), 2(Integer), 10(Long),
2(Integer), 3(Long), ll(String), 4(Long), ll(String), 10(Long), ll(String),
3(Long), 2020-08-10 19:57:45.21(Timestamp), 4(Long), 2020-08-10
19:57:45.21(Timestamp), 10(Long), 2020-08-10 19:57:45.21(Timestamp),
jd(String), 3(Long), 4(Long), 10(Long)
2020-08-10 19:57:45 [DEBUG] [main] -
com.jd.octopus.sharding.algorithm.mod.impl.DbModShardingAlgorithm.doSharding():33
- 获取数据库名：ds_ms0
2020-08-10 19:57:45 [INFO] [main] - ShardingSphere-SQL.log():74 - Logic SQL:
update stock_freeze_detail
set row_status=case WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ? end,
update_user=case WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ? end,
update_time=case WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ? end
where tenant_id = ?
and id in
(
?
,
?
,
?
)
2020-08-10 19:57:45 [INFO] [main] - ShardingSphere-SQL.log():74 -
SQLStatement:
UpdateStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.UpdateStatement@1938f3b3,
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@bfe3907),
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@bfe3907)
2020-08-10 19:57:45 [INFO] [main] - ShardingSphere-SQL.log():74 - Actual
SQL: ds_0 ::: update stock_freeze_detail
set row_status=case WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ? end,
update_user=case WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ? end,
update_time=case WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ?
WHEN (id=?)
THEN ? end
where tenant_id = ?
and id in
(
?
,
?
,
?
) ::: [3, 2, 4, 2, 10, 2, 3, ll, 4, ll, 10, ll, 3,
2020-08-10T19:57:45.210+0800, 4, 2020-08-10T19:57:45.210+0800, 10,
2020-08-10T19:57:45.210+0800, jd, 3, 4, 10]
2020-08-10 19:57:45 [DEBUG] [main] -
com.jd.jcloud.wms.inventory.dao.stockFreeze.StockFreezeDetailDao.updateByStockFreezeDetailList.():
- <== Updates: 3
2020-08-10 19:57:45 [DEBUG] [main] -
com.jd.jcloud.wms.inventory.dao.stockFreeze.StockFreezeDetailDao.updateByStockFreezeDetailList.debug():139
- <== Updates: 3
2020-08-10 19:57:45 [DEBUG] [main] -
org.mybatis.spring.SqlSessionUtils.closeSqlSession():168 - Closing non
transactional SqlSession
[org.apache.ibatis.session.defaults.DefaultSqlSession@583c416c]
2020-08-10 19:57:45 [DEBUG] [main] -
org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection():327 -
Returning JDBC Connection to DataSource
2020-08-10 19:57:45 [DEBUG] [main] -
org.springframework.test.context.support.DirtiesContextTestExecutionListener.afterTestMethod():86
- After test method: context [DefaultTestContext@17497425 testClass =
StockFreezeDetailDaoTest, testInstance =
com.jd.jcloud.wms.dao.StockFreezeDetailDaoTest@f0da945, testMethod =
testUpdateByStockFreezeDetailList@StockFreezeDetailDaoTest, testException =
[null], mergedContextConfiguration = [MergedContextConfiguration@4803b726
testClass = StockFreezeDetailDaoTest, locations =
'{classpath*:spring/config/spring-config.xml,
classpath*:spring/config/spring-config-sharding.xml}', classes = '{}',
contextInitializerClasses = '[]', activeProfiles = '{}',
propertySourceLocations = '{}', propertySourceProperties = '{}', contextLoader
= 'org.springframework.test.context.support.DelegatingSmartContextLoader',
parent = [null]]], class dirties context [false], class mode [null], method
dirties context [false].
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
