ShardingSphere：配置分库分表策略后查询报错：NotFoundDataTableException: table is not found.
·
场景
1、t_mb_sessionmsg4rpt，t_mb_sessionservicerpt表需要进行分库分表查询
2、对以上两个表配置了分库策略以及分表策略
3、dao查询时分库正常，分表异常
注：程序用的是自定义数据源，配置不是通用的，但可以确定已经配置了分库策略以及分表策略
异常信息
2026-05-19 15:14:45.065 - [DEBUG] - [Thread-21] - [c.f.m.r.MbSessionMsg4RptMapper.getSessionService - line:137]: ==> Preparing: SELECT t1.openId, t1.sessionId, t1.originId, t1.originType, t1.agentId, t1.endTime, t1.extField, t1.serviceId, t2.nickName, t2.orderNo AS orderNum FROM t_mb_sessionmsg4rpt AS t1 INNER JOIN t_mb_sessionservicerpt AS t2 ON t1.sessionId = t2.sessionId AND t2.vdnId = ? WHERE t1.vdnId = ? AND t1.originType = 'WECHATCP' AND t1.subTableDate BETWEEN ? AND ? AND t1.AgentRepLyCount >= ? AND t1.RequestCount >= ? GROUP BY t1.sessionId, t1.openId;
2026-05-19 15:14:45.066 - [DEBUG] - [Thread-21] - [c.f.m.r.MbSessionMsg4RptMapper.getSessionService - line:137]: ==> Parameters: 9(Integer), 9(Integer), 2026-05-14 00:00:00.0(Timestamp), 2026-05-14 00:00:00.0(Timestamp), 2(Integer), 2(Integer)
2026-05-19 15:14:45.066 - [INFO ] - [Thread-21] - [c.f.d.algorithm.ModuloShardingDatabaseAlgorithm - line:20]: databases collection is [[ireport0, ireport1]], precise sharding value is [PreciseShardingValue(logicTableName=t_mb_sessionmsg4rpt, columnName=vdnId, value=9)]
2026-05-19 15:14:45.066 - [INFO ] - [Thread-21] - [c.f.d.algorithm.ModuloShardingDatabaseAlgorithm - line:25]: use databases name is [ireport1]
2026-05-19 15:14:45.066 - [INFO ] - [Thread-21] - [c.f.d.algorithm.DateTimeShardingTableAlgorithm - line:46]: range table collection is [[t_mb_sessionmsg4rpt]], range sharding value is [RangeShardingValue(logicTableName=t_mb_sessionmsg4rpt, columnName=subTableDate, valueRange=[2026-05-14 00:00:00.0..2026-05-14 00:00:00.0])]
2026-05-19 15:14:45.067 - [INFO ] - [Thread-21] - [c.f.d.algorithm.DateTimeShardingTableAlgorithm - line:67]: use table name is [[]]
2026-05-19 15:14:45.076 - [ERROR] - [Thread-21] - [com.xxx.thread.CsSendSatTaskThread - line:179]: 创建满意度调查发送任务出现异常：enested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.xxx.exception.NotFoundDataTableException: table is not found.
### The error may exist in file [/home/xxx/devtest/online/tomcat8-online_admin-8989/webapps/online_admin/WEB-INF/classes/mappings/report/MbSessionMsg4RptMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT t1.openId, t1.sessionId, t1.originId, t1.originType, t1.agentId, t1.endTime, t1.extField, t1.serviceId, t2.nickName, t2.orderNo AS orderNum FROM t_mb_sessionmsg4rpt AS t1 INNER JOIN t_mb_sessionservicerpt AS t2 ON t1.sessionId = t2.sessionId AND t2.vdnId = ? WHERE t1.vdnId = ? AND t1.originType = 'WECHATCP' AND t1.subTableDate BETWEEN ? AND ? AND t1.AgentRepLyCount >= ? AND t1.RequestCount >= ? GROUP BY t1.sessionId, t1.openId;
### Cause: com.xxx.exception.NotFoundDataTableException: table is not found.
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.xxx.exception.NotFoundDataTableException: table is not found.
### The error may exist in file [/home/xxx/devtest/online/tomcat8-online_admin-8989/webapps/online_admin/WEB-INF/classes/mappings/report/MbSessionMsg4RptMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT t1.openId, t1.sessionId, t1.originId, t1.originType, t1.agentId, t1.endTime, t1.extField, t1.serviceId, t2.nickName, t2.orderNo AS orderNum FROM t_mb_sessionmsg4rpt AS t1 INNER JOIN t_mb_sessionservicerpt AS t2 ON t1.sessionId = t2.sessionId AND t2.vdnId = ? WHERE t1.vdnId = ? AND t1.originType = 'WECHATCP' AND t1.subTableDate BETWEEN ? AND ? AND t1.AgentRepLyCount >= ? AND t1.RequestCount >= ? GROUP BY t1.sessionId, t1.openId;
### Cause: com.xxx.exception.NotFoundDataTableException: table is not found.
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy119.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
at com.sun.proxy.$Proxy301.getSessionService(Unknown Source)
at sun.reflect.GeneratedMethodAccessor329.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241)
at com.sun.proxy.$Proxy302.getSessionService(Unknown Source)
at com.xxx.service.report.impl.MbSessionMsg4RptServiceImpl.getSessionService(MbSessionMsg4RptServiceImpl.java:42)
at com.xxx.service.report.impl.MbSessionMsg4RptServiceImpl$$FastClassBySpringCGLIB$$394c6772.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at com.xxx.datasource.DataSourceAspect.around(DataSourceAspect.java:47)
at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)
at com.xxx.service.report.impl.MbSessionMsg4RptServiceImpl$$EnhancerBySpringCGLIB$$526b38a8.getSessionService(<generated>)
at com.xxx.thread.CsSendSatTaskThread.createSendSatTask(CsSendSatTaskThread.java:115)
at com.xxx.thread.CsSendSatTaskThread.run(CsSendSatTaskThread.java:52)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.xxx.exception.NotFoundDataTableException: table is not found.
### The error may exist in file [/home/xxx/devtest/online/tomcat8-online_admin-8989/webapps/online_admin/WEB-INF/classes/mappings/report/MbSessionMsg4RptMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT t1.openId, t1.sessionId, t1.originId, t1.originType, t1.agentId, t1.endTime, t1.extField, t1.serviceId, t2.nickName, t2.orderNo AS orderNum FROM t_mb_sessionmsg4rpt AS t1 INNER JOIN t_mb_sessionservicerpt AS t2 ON t1.sessionId = t2.sessionId AND t2.vdnId = ? WHERE t1.vdnId = ? AND t1.originType = 'WECHATCP' AND t1.subTableDate BETWEEN ? AND ? AND t1.AgentRepLyCount >= ? AND t1.RequestCount >= ? GROUP BY t1.sessionId, t1.openId;
### Cause: com.xxx.exception.NotFoundDataTableException: table is not found.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at sun.reflect.GeneratedMethodAccessor152.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:427)
... 40 common frames omitted
Caused by: com.xxx.exception.NotFoundDataTableException: table is not found.
at com.xxx.datasource.algorithm.DateTimeShardingTableAlgorithm.doSharding(DateTimeShardingTableAlgorithm.java:69)
at org.apache.shardingsphere.core.strategy.route.standard.StandardShardingStrategy.doSharding(StandardShardingStrategy.java:70)
at org.apache.shardingsphere.core.strategy.route.standard.StandardShardingStrategy.doSharding(StandardShardingStrategy.java:59)
at org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.routeTables(ShardingStandardRoutingEngine.java:214)
at org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.route0(ShardingStandardRoutingEngine.java:195)
at org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.routeByShardingConditionsWithCondition(ShardingStandardRoutingEngine.java:121)
at org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.routeByShardingConditions(ShardingStandardRoutingEngine.java:115)
at org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.getDataNodes(ShardingStandardRoutingEngine.java:96)
at org.apache.shardingsphere.sharding.route.engine.type.standard.ShardingStandardRoutingEngine.route(ShardingStandardRoutingEngine.java:74)
at org.apache.shardingsphere.sharding.route.engine.ShardingRouteDecorator.decorate(ShardingRouteDecorator.java:69)
at org.apache.shardingsphere.sharding.route.engine.ShardingRouteDecorator.decorate(ShardingRouteDecorator.java:53)
at org.apache.shardingsphere.underlying.route.DataNodeRouter.executeRoute(DataNodeRouter.java:91)
at org.apache.shardingsphere.underlying.route.DataNodeRouter.route(DataNodeRouter.java:76)
at org.apache.shardingsphere.underlying.pluggble.prepare.PreparedQueryPrepareEngine.route(PreparedQueryPrepareEngine.java:54)
at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.executeRoute(BasePrepareEngine.java:96)
at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.prepare(BasePrepareEngine.java:83)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.prepare(ShardingPreparedStatement.java:183)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.execute(ShardingPreparedStatement.java:143)
at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
at com.sun.proxy.$Proxy291.execute(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:108)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy381.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
... 46 common frames omitted
日志分析
2026-05-19 15:14:45.065 - [DEBUG] - [Thread-21] - [c.f.m.r.MbSessionMsg4RptMapper.getSessionService - line:137]: ==> Preparing: SELECT t1.openId, t1.sessionId, t1.originId, t1.originType, t1.agentId, t1.endTime, t1.extField, t1.serviceId, t2.nickName, t2.orderNo AS orderNum FROM t_mb_sessionmsg4rpt AS t1 INNER JOIN t_mb_sessionservicerpt AS t2 ON t1.sessionId = t2.sessionId AND t2.vdnId = ? WHERE t1.vdnId = ? AND t1.originType = 'WECHATCP' AND t1.subTableDate BETWEEN ? AND ? AND t1.AgentRepLyCount >= ? AND t1.RequestCount >= ? GROUP BY t1.sessionId, t1.openId;
2026-05-19 15:14:45.066 - [DEBUG] - [Thread-21] - [c.f.m.r.MbSessionMsg4RptMapper.getSessionService - line:137]: ==> Parameters: 9(Integer), 9(Integer), 2026-05-14 00:00:00.0(Timestamp), 2026-05-14 00:00:00.0(Timestamp), 2(Integer), 2(Integer)
2026-05-19 15:14:45.066 - [INFO ] - [Thread-21] - [c.f.d.algorithm.ModuloShardingDatabaseAlgorithm - line:20]: databases collection is [[ireport0, ireport1]], precise sharding value is [PreciseShardingValue(logicTableName=t_mb_sessionmsg4rpt, columnName=vdnId, value=9)]
2026-05-19 15:14:45.066 - [INFO ] - [Thread-21] - [c.f.d.algorithm.ModuloShardingDatabaseAlgorithm - line:25]: use databases name is [ireport1]
2026-05-19 15:14:45.066 - [INFO ] - [Thread-21] - [c.f.d.algorithm.DateTimeShardingTableAlgorithm - line:46]: range table collection is [[t_mb_sessionmsg4rpt]], range sharding value is [RangeShardingValue(logicTableName=t_mb_sessionmsg4rpt, columnName=subTableDate, valueRange=[2026-05-14 00:00:00.0..2026-05-14 00:00:00.0])]
2026-05-19 15:14:45.067 - [INFO ] - [Thread-21] - [c.f.d.algorithm.DateTimeShardingTableAlgorithm - line:67]: use table name is [[]]
从以上信息可以看出
1、分库是正常的
2、分表异常，仅找到了源表，并没有列出分表
排查
1、已配置分库策略以及分表策略
2、已配置绑定表规则表
3、已确认分表字段无误
4、确认数据库存在分表
原因
配置了分库策略
如果需要分库分表的话，只需要配置分表策略就行了，不需要再配置分库策略
解决
去除分库策略，仅保留分表策略
改正后日志如下，可正常分库分表
2026-05-19 15:24:50.418 - [DEBUG] - [Thread-20] - [c.f.m.r.MbSessionMsg4RptMapper.getSessionService - line:137]: ==> Preparing: SELECT t1.openId, t1.sessionId, t1.originId, t1.originType, t1.agentId, t1.endTime, t1.extField, t1.serviceId, t2.nickName, t2.orderNo AS orderNum FROM t_mb_sessionmsg4rpt AS t1 INNER JOIN t_mb_sessionservicerpt AS t2 ON t1.sessionId = t2.sessionId AND t2.vdnId = ? WHERE t1.vdnId = ? AND t1.originType = 'WECHATCP' AND t1.subTableDate BETWEEN ? AND ? AND t1.AgentRepLyCount >= ? AND t1.RequestCount >= ? GROUP BY t1.sessionId, t1.openId;
2026-05-19 15:24:50.420 - [DEBUG] - [Thread-20] - [c.f.m.r.MbSessionMsg4RptMapper.getSessionService - line:137]: ==> Parameters: 9(Integer), 9(Integer), 2026-05-14 00:00:00.0(Timestamp), 2026-05-14 00:00:00.0(Timestamp), 2(Integer), 2(Integer)
2026-05-19 15:24:50.423 - [INFO ] - [Thread-20] - [c.f.d.algorithm.ModuloShardingDatabaseAlgorithm - line:20]: databases collection is [[ireport0, ireport1]], precise sharding value is [PreciseShardingValue(logicTableName=t_mb_sessionmsg4rpt, columnName=vdnId, value=9)]
2026-05-19 15:24:50.424 - [INFO ] - [Thread-20] - [c.f.d.algorithm.ModuloShardingDatabaseAlgorithm - line:25]: use databases name is [ireport1]
2026-05-19 15:24:50.424 - [INFO ] - [Thread-20] - [c.f.d.algorithm.DateTimeShardingTableAlgorithm - line:46]: range table collection is [[t_mb_sessionmsg4rpt_202601, t_mb_sessionmsg4rpt_202602, t_mb_sessionmsg4rpt_202603, t_mb_sessionmsg4rpt_202604, t_mb_sessionmsg4rpt_202605, t_mb_sessionmsg4rpt_202606, t_mb_sessionmsg4rpt_202607, t_mb_sessionmsg4rpt_202608, t_mb_sessionmsg4rpt_202609, t_mb_sessionmsg4rpt_202701, t_mb_sessionmsg4rpt_202702, t_mb_sessionmsg4rpt_202703, t_mb_sessionmsg4rpt_202704, t_mb_sessionmsg4rpt_202705, t_mb_sessionmsg4rpt_202706, t_mb_sessionmsg4rpt_202707, t_mb_sessionmsg4rpt_202708, t_mb_sessionmsg4rpt_202709, t_mb_sessionmsg4rpt_202801, t_mb_sessionmsg4rpt_202802, t_mb_sessionmsg4rpt_202803, t_mb_sessionmsg4rpt_202804, t_mb_sessionmsg4rpt_202805, t_mb_sessionmsg4rpt_202806, t_mb_sessionmsg4rpt_202807, t_mb_sessionmsg4rpt_202808, t_mb_sessionmsg4rpt_202809, t_mb_sessionmsg4rpt_202901, t_mb_sessionmsg4rpt_202902, t_mb_sessionmsg4rpt_202903, t_mb_sessionmsg4rpt_202904, t_mb_sessionmsg4rpt_202905, t_mb_sessionmsg4rpt_202906, t_mb_sessionmsg4rpt_202907, t_mb_sessionmsg4rpt_202908, t_mb_sessionmsg4rpt_202909, t_mb_sessionmsg4rpt_203001, t_mb_sessionmsg4rpt_203002, t_mb_sessionmsg4rpt_203003, t_mb_sessionmsg4rpt_203004, t_mb_sessionmsg4rpt_203005, t_mb_sessionmsg4rpt_203006, t_mb_sessionmsg4rpt_203007, t_mb_sessionmsg4rpt_203008, t_mb_sessionmsg4rpt_203009, t_mb_sessionmsg4rpt_203101, t_mb_sessionmsg4rpt_203102, t_mb_sessionmsg4rpt_203103, t_mb_sessionmsg4rpt_203104, t_mb_sessionmsg4rpt_203105, t_mb_sessionmsg4rpt_203106, t_mb_sessionmsg4rpt_203107, t_mb_sessionmsg4rpt_203108, t_mb_sessionmsg4rpt_203109, t_mb_sessionmsg4rpt_203201, t_mb_sessionmsg4rpt_203202, t_mb_sessionmsg4rpt_203203, t_mb_sessionmsg4rpt_203204, t_mb_sessionmsg4rpt_203205, t_mb_sessionmsg4rpt_203206, t_mb_sessionmsg4rpt_203207, t_mb_sessionmsg4rpt_203208, t_mb_sessionmsg4rpt_203209, t_mb_sessionmsg4rpt_203301, t_mb_sessionmsg4rpt_203302, t_mb_sessionmsg4rpt_203303, t_mb_sessionmsg4rpt_203304, t_mb_sessionmsg4rpt_203305, t_mb_sessionmsg4rpt_203306, t_mb_sessionmsg4rpt_203307, t_mb_sessionmsg4rpt_203308, t_mb_sessionmsg4rpt_203309, t_mb_sessionmsg4rpt_203401, t_mb_sessionmsg4rpt_203402, t_mb_sessionmsg4rpt_203403, t_mb_sessionmsg4rpt_203404, t_mb_sessionmsg4rpt_203405, t_mb_sessionmsg4rpt_203406, t_mb_sessionmsg4rpt_203407, t_mb_sessionmsg4rpt_203408, t_mb_sessionmsg4rpt_203409, t_mb_sessionmsg4rpt_203501, t_mb_sessionmsg4rpt_203502, t_mb_sessionmsg4rpt_203503, t_mb_sessionmsg4rpt_203504, t_mb_sessionmsg4rpt_203505, t_mb_sessionmsg4rpt_203506, t_mb_sessionmsg4rpt_203507, t_mb_sessionmsg4rpt_203508, t_mb_sessionmsg4rpt_203509, t_mb_sessionmsg4rpt_203601, t_mb_sessionmsg4rpt_203602, t_mb_sessionmsg4rpt_203603, t_mb_sessionmsg4rpt_203604, t_mb_sessionmsg4rpt_203605, t_mb_sessionmsg4rpt_203606, t_mb_sessionmsg4rpt_203607, t_mb_sessionmsg4rpt_203608, t_mb_sessionmsg4rpt_203609, t_mb_sessionmsg4rpt_203701, t_mb_sessionmsg4rpt_203702, t_mb_sessionmsg4rpt_203703, t_mb_sessionmsg4rpt_203704, t_mb_sessionmsg4rpt_203705, t_mb_sessionmsg4rpt_203706, t_mb_sessionmsg4rpt_203707, t_mb_sessionmsg4rpt_203708, t_mb_sessionmsg4rpt_203709, t_mb_sessionmsg4rpt_203801, t_mb_sessionmsg4rpt_203802, t_mb_sessionmsg4rpt_203803, t_mb_sessionmsg4rpt_203804, t_mb_sessionmsg4rpt_203805, t_mb_sessionmsg4rpt_203806, t_mb_sessionmsg4rpt_203807, t_mb_sessionmsg4rpt_203808, t_mb_sessionmsg4rpt_203809, t_mb_sessionmsg4rpt_203901, t_mb_sessionmsg4rpt_203902, t_mb_sessionmsg4rpt_203903, t_mb_sessionmsg4rpt_203904, t_mb_sessionmsg4rpt_203905, t_mb_sessionmsg4rpt_203906, t_mb_sessionmsg4rpt_203907, t_mb_sessionmsg4rpt_203908, t_mb_sessionmsg4rpt_203909, t_mb_sessionmsg4rpt_204001, t_mb_sessionmsg4rpt_204002, t_mb_sessionmsg4rpt_204003, t_mb_sessionmsg4rpt_204004, t_mb_sessionmsg4rpt_204005, t_mb_sessionmsg4rpt_204006, t_mb_sessionmsg4rpt_204007, t_mb_sessionmsg4rpt_204008, t_mb_sessionmsg4rpt_204009, t_mb_sessionmsg4rpt_204101, t_mb_sessionmsg4rpt_204102, t_mb_sessionmsg4rpt_204103, t_mb_sessionmsg4rpt_204104, t_mb_sessionmsg4rpt_204105, t_mb_sessionmsg4rpt_204106, t_mb_sessionmsg4rpt_204107, t_mb_sessionmsg4rpt_204108, t_mb_sessionmsg4rpt_204109, t_mb_sessionmsg4rpt_204201, t_mb_sessionmsg4rpt_204202, t_mb_sessionmsg4rpt_204203, t_mb_sessionmsg4rpt_204204, t_mb_sessionmsg4rpt_204205, t_mb_sessionmsg4rpt_204206, t_mb_sessionmsg4rpt_204207, t_mb_sessionmsg4rpt_204208, t_mb_sessionmsg4rpt_204209, t_mb_sessionmsg4rpt_204301, t_mb_sessionmsg4rpt_204302, t_mb_sessionmsg4rpt_204303, t_mb_sessionmsg4rpt_204304, t_mb_sessionmsg4rpt_204305, t_mb_sessionmsg4rpt_204306, t_mb_sessionmsg4rpt_204307, t_mb_sessionmsg4rpt_204308, t_mb_sessionmsg4rpt_204309, t_mb_sessionmsg4rpt_204401, t_mb_sessionmsg4rpt_204402, t_mb_sessionmsg4rpt_204403, t_mb_sessionmsg4rpt_204404, t_mb_sessionmsg4rpt_204405, t_mb_sessionmsg4rpt_204406, t_mb_sessionmsg4rpt_204407, t_mb_sessionmsg4rpt_204408, t_mb_sessionmsg4rpt_204409, t_mb_sessionmsg4rpt_204501, t_mb_sessionmsg4rpt_204502, t_mb_sessionmsg4rpt_204503, t_mb_sessionmsg4rpt_204504, t_mb_sessionmsg4rpt_204505, t_mb_sessionmsg4rpt_204506, t_mb_sessionmsg4rpt_204507, t_mb_sessionmsg4rpt_204508, t_mb_sessionmsg4rpt_204509, t_mb_sessionmsg4rpt_204601, t_mb_sessionmsg4rpt_204602, t_mb_sessionmsg4rpt_204603, t_mb_sessionmsg4rpt_204604, t_mb_sessionmsg4rpt_204605, t_mb_sessionmsg4rpt_204606, t_mb_sessionmsg4rpt_204607, t_mb_sessionmsg4rpt_204608, t_mb_sessionmsg4rpt_204609, t_mb_sessionmsg4rpt_204701, t_mb_sessionmsg4rpt_204702, t_mb_sessionmsg4rpt_204703, t_mb_sessionmsg4rpt_204704, t_mb_sessionmsg4rpt_204705, t_mb_sessionmsg4rpt_204706, t_mb_sessionmsg4rpt_204707, t_mb_sessionmsg4rpt_204708, t_mb_sessionmsg4rpt_204709, t_mb_sessionmsg4rpt_204801, t_mb_sessionmsg4rpt_204802, t_mb_sessionmsg4rpt_204803, t_mb_sessionmsg4rpt_204804, t_mb_sessionmsg4rpt_204805, t_mb_sessionmsg4rpt_204806, t_mb_sessionmsg4rpt_204807, t_mb_sessionmsg4rpt_204808, t_mb_sessionmsg4rpt_204809, t_mb_sessionmsg4rpt_204901, t_mb_sessionmsg4rpt_204902, t_mb_sessionmsg4rpt_204903, t_mb_sessionmsg4rpt_204904, t_mb_sessionmsg4rpt_204905, t_mb_sessionmsg4rpt_204906, t_mb_sessionmsg4rpt_204907, t_mb_sessionmsg4rpt_204908, t_mb_sessionmsg4rpt_204909, t_mb_sessionmsg4rpt_205001, t_mb_sessionmsg4rpt_205002, t_mb_sessionmsg4rpt_205003, t_mb_sessionmsg4rpt_205004, t_mb_sessionmsg4rpt_205005, t_mb_sessionmsg4rpt_205006, t_mb_sessionmsg4rpt_205007, t_mb_sessionmsg4rpt_205008, t_mb_sessionmsg4rpt_205009, t_mb_sessionmsg4rpt_205101, t_mb_sessionmsg4rpt_205102, t_mb_sessionmsg4rpt_205103, t_mb_sessionmsg4rpt_205104, t_mb_sessionmsg4rpt_205105, t_mb_sessionmsg4rpt_205106, t_mb_sessionmsg4rpt_205107, t_mb_sessionmsg4rpt_205108, t_mb_sessionmsg4rpt_205109, t_mb_sessionmsg4rpt_205201, t_mb_sessionmsg4rpt_205202, t_mb_sessionmsg4rpt_205203, t_mb_sessionmsg4rpt_205204, t_mb_sessionmsg4rpt_205205, t_mb_sessionmsg4rpt_205206, t_mb_sessionmsg4rpt_205207, t_mb_sessionmsg4rpt_205208, t_mb_sessionmsg4rpt_205209, t_mb_sessionmsg4rpt_205301, t_mb_sessionmsg4rpt_205302, t_mb_sessionmsg4rpt_205303, t_mb_sessionmsg4rpt_205304, t_mb_sessionmsg4rpt_205305, t_mb_sessionmsg4rpt_205306, t_mb_sessionmsg4rpt_205307, t_mb_sessionmsg4rpt_205308, t_mb_sessionmsg4rpt_205309, t_mb_sessionmsg4rpt_205401, t_mb_sessionmsg4rpt_205402, t_mb_sessionmsg4rpt_205403, t_mb_sessionmsg4rpt_205404, t_mb_sessionmsg4rpt_205405, t_mb_sessionmsg4rpt_205406, t_mb_sessionmsg4rpt_205407, t_mb_sessionmsg4rpt_205408, t_mb_sessionmsg4rpt_205409, t_mb_sessionmsg4rpt_205501, t_mb_sessionmsg4rpt_205502, t_mb_sessionmsg4rpt_205503, t_mb_sessionmsg4rpt_205504, t_mb_sessionmsg4rpt_205505, t_mb_sessionmsg4rpt_205506, t_mb_sessionmsg4rpt_205507, t_mb_sessionmsg4rpt_205508, t_mb_sessionmsg4rpt_205509, t_mb_sessionmsg4rpt_205601, t_mb_sessionmsg4rpt_205602, t_mb_sessionmsg4rpt_205603, t_mb_sessionmsg4rpt_205604, t_mb_sessionmsg4rpt_205605, t_mb_sessionmsg4rpt_205606, t_mb_sessionmsg4rpt_205607, t_mb_sessionmsg4rpt_205608, t_mb_sessionmsg4rpt_205609, t_mb_sessionmsg4rpt_205701, t_mb_sessionmsg4rpt_205702, t_mb_sessionmsg4rpt_205703, t_mb_sessionmsg4rpt_205704, t_mb_sessionmsg4rpt_205705, t_mb_sessionmsg4rpt_205706, t_mb_sessionmsg4rpt_205707, t_mb_sessionmsg4rpt_205708, t_mb_sessionmsg4rpt_205709, t_mb_sessionmsg4rpt_205801, t_mb_sessionmsg4rpt_205802, t_mb_sessionmsg4rpt_205803, t_mb_sessionmsg4rpt_205804, t_mb_sessionmsg4rpt_205805, t_mb_sessionmsg4rpt_205806, t_mb_sessionmsg4rpt_205807, t_mb_sessionmsg4rpt_205808, t_mb_sessionmsg4rpt_205809, t_mb_sessionmsg4rpt_205901, t_mb_sessionmsg4rpt_205902, t_mb_sessionmsg4rpt_205903, t_mb_sessionmsg4rpt_205904, t_mb_sessionmsg4rpt_205905, t_mb_sessionmsg4rpt_205906, t_mb_sessionmsg4rpt_205907, t_mb_sessionmsg4rpt_205908, t_mb_sessionmsg4rpt_205909, t_mb_sessionmsg4rpt_206001, t_mb_sessionmsg4rpt_206002, t_mb_sessionmsg4rpt_206003, t_mb_sessionmsg4rpt_206004, t_mb_sessionmsg4rpt_206005, t_mb_sessionmsg4rpt_206006, t_mb_sessionmsg4rpt_206007, t_mb_sessionmsg4rpt_206008, t_mb_sessionmsg4rpt_206009, t_mb_sessionmsg4rpt_206101, t_mb_sessionmsg4rpt_206102, t_mb_sessionmsg4rpt_206103, t_mb_sessionmsg4rpt_206104, t_mb_sessionmsg4rpt_206105, t_mb_sessionmsg4rpt_206106, t_mb_sessionmsg4rpt_206107, t_mb_sessionmsg4rpt_206108, t_mb_sessionmsg4rpt_206109, t_mb_sessionmsg4rpt_206201, t_mb_sessionmsg4rpt_206202, t_mb_sessionmsg4rpt_206203, t_mb_sessionmsg4rpt_206204, t_mb_sessionmsg4rpt_206205, t_mb_sessionmsg4rpt_206206, t_mb_sessionmsg4rpt_206207, t_mb_sessionmsg4rpt_206208, t_mb_sessionmsg4rpt_206209, t_mb_sessionmsg4rpt_206301, t_mb_sessionmsg4rpt_206302, t_mb_sessionmsg4rpt_206303, t_mb_sessionmsg4rpt_206304, t_mb_sessionmsg4rpt_206305, t_mb_sessionmsg4rpt_206306, t_mb_sessionmsg4rpt_206307, t_mb_sessionmsg4rpt_206308, t_mb_sessionmsg4rpt_206309, t_mb_sessionmsg4rpt_206401, t_mb_sessionmsg4rpt_206402, t_mb_sessionmsg4rpt_206403, t_mb_sessionmsg4rpt_206404, t_mb_sessionmsg4rpt_206405, t_mb_sessionmsg4rpt_206406, t_mb_sessionmsg4rpt_206407, t_mb_sessionmsg4rpt_206408, t_mb_sessionmsg4rpt_206409, t_mb_sessionmsg4rpt_206501, t_mb_sessionmsg4rpt_206502, t_mb_sessionmsg4rpt_206503, t_mb_sessionmsg4rpt_206504, t_mb_sessionmsg4rpt_206505, t_mb_sessionmsg4rpt_206506, t_mb_sessionmsg4rpt_206507, t_mb_sessionmsg4rpt_206508, t_mb_sessionmsg4rpt_206509, t_mb_sessionmsg4rpt_206601, t_mb_sessionmsg4rpt_206602, t_mb_sessionmsg4rpt_206603, t_mb_sessionmsg4rpt_206604, t_mb_sessionmsg4rpt_206605, t_mb_sessionmsg4rpt_206606, t_mb_sessionmsg4rpt_206607, t_mb_sessionmsg4rpt_206608, t_mb_sessionmsg4rpt_206609, t_mb_sessionmsg4rpt_202610, t_mb_sessionmsg4rpt_202611, t_mb_sessionmsg4rpt_202612, t_mb_sessionmsg4rpt_202710, t_mb_sessionmsg4rpt_202711, t_mb_sessionmsg4rpt_202712, t_mb_sessionmsg4rpt_202810, t_mb_sessionmsg4rpt_202811, t_mb_sessionmsg4rpt_202812, t_mb_sessionmsg4rpt_202910, t_mb_sessionmsg4rpt_202911, t_mb_sessionmsg4rpt_202912, t_mb_sessionmsg4rpt_203010, t_mb_sessionmsg4rpt_203011, t_mb_sessionmsg4rpt_203012, t_mb_sessionmsg4rpt_203110, t_mb_sessionmsg4rpt_203111, t_mb_sessionmsg4rpt_203112, t_mb_sessionmsg4rpt_203210, t_mb_sessionmsg4rpt_203211, t_mb_sessionmsg4rpt_203212, t_mb_sessionmsg4rpt_203310, t_mb_sessionmsg4rpt_203311, t_mb_sessionmsg4rpt_203312, t_mb_sessionmsg4rpt_203410, t_mb_sessionmsg4rpt_203411, t_mb_sessionmsg4rpt_203412, t_mb_sessionmsg4rpt_203510, t_mb_sessionmsg4rpt_203511, t_mb_sessionmsg4rpt_203512, t_mb_sessionmsg4rpt_203610, t_mb_sessionmsg4rpt_203611, t_mb_sessionmsg4rpt_203612, t_mb_sessionmsg4rpt_203710, t_mb_sessionmsg4rpt_203711, t_mb_sessionmsg4rpt_203712, t_mb_sessionmsg4rpt_203810, t_mb_sessionmsg4rpt_203811, t_mb_sessionmsg4rpt_203812, t_mb_sessionmsg4rpt_203910, t_mb_sessionmsg4rpt_203911, t_mb_sessionmsg4rpt_203912, t_mb_sessionmsg4rpt_204010, t_mb_sessionmsg4rpt_204011, t_mb_sessionmsg4rpt_204012, t_mb_sessionmsg4rpt_204110, t_mb_sessionmsg4rpt_204111, t_mb_sessionmsg4rpt_204112, t_mb_sessionmsg4rpt_204210, t_mb_sessionmsg4rpt_204211, t_mb_sessionmsg4rpt_204212, t_mb_sessionmsg4rpt_204310, t_mb_sessionmsg4rpt_204311, t_mb_sessionmsg4rpt_204312, t_mb_sessionmsg4rpt_204410, t_mb_sessionmsg4rpt_204411, t_mb_sessionmsg4rpt_204412, t_mb_sessionmsg4rpt_204510, t_mb_sessionmsg4rpt_204511, t_mb_sessionmsg4rpt_204512, t_mb_sessionmsg4rpt_204610, t_mb_sessionmsg4rpt_204611, t_mb_sessionmsg4rpt_204612, t_mb_sessionmsg4rpt_204710, t_mb_sessionmsg4rpt_204711, t_mb_sessionmsg4rpt_204712, t_mb_sessionmsg4rpt_204810, t_mb_sessionmsg4rpt_204811, t_mb_sessionmsg4rpt_204812, t_mb_sessionmsg4rpt_204910, t_mb_sessionmsg4rpt_204911, t_mb_sessionmsg4rpt_204912, t_mb_sessionmsg4rpt_205010, t_mb_sessionmsg4rpt_205011, t_mb_sessionmsg4rpt_205012, t_mb_sessionmsg4rpt_205110, t_mb_sessionmsg4rpt_205111, t_mb_sessionmsg4rpt_205112, t_mb_sessionmsg4rpt_205210, t_mb_sessionmsg4rpt_205211, t_mb_sessionmsg4rpt_205212, t_mb_sessionmsg4rpt_205310, t_mb_sessionmsg4rpt_205311, t_mb_sessionmsg4rpt_205312, t_mb_sessionmsg4rpt_205410, t_mb_sessionmsg4rpt_205411, t_mb_sessionmsg4rpt_205412, t_mb_sessionmsg4rpt_205510, t_mb_sessionmsg4rpt_205511, t_mb_sessionmsg4rpt_205512, t_mb_sessionmsg4rpt_205610, t_mb_sessionmsg4rpt_205611, t_mb_sessionmsg4rpt_205612, t_mb_sessionmsg4rpt_205710, t_mb_sessionmsg4rpt_205711, t_mb_sessionmsg4rpt_205712, t_mb_sessionmsg4rpt_205810, t_mb_sessionmsg4rpt_205811, t_mb_sessionmsg4rpt_205812, t_mb_sessionmsg4rpt_205910, t_mb_sessionmsg4rpt_205911, t_mb_sessionmsg4rpt_205912, t_mb_sessionmsg4rpt_206010, t_mb_sessionmsg4rpt_206011, t_mb_sessionmsg4rpt_206012, t_mb_sessionmsg4rpt_206110, t_mb_sessionmsg4rpt_206111, t_mb_sessionmsg4rpt_206112, t_mb_sessionmsg4rpt_206210, t_mb_sessionmsg4rpt_206211, t_mb_sessionmsg4rpt_206212, t_mb_sessionmsg4rpt_206310, t_mb_sessionmsg4rpt_206311, t_mb_sessionmsg4rpt_206312, t_mb_sessionmsg4rpt_206410, t_mb_sessionmsg4rpt_206411, t_mb_sessionmsg4rpt_206412, t_mb_sessionmsg4rpt_206510, t_mb_sessionmsg4rpt_206511, t_mb_sessionmsg4rpt_206512, t_mb_sessionmsg4rpt_206610, t_mb_sessionmsg4rpt_206611, t_mb_sessionmsg4rpt_206612]], range sharding value is [RangeShardingValue(logicTableName=t_mb_sessionmsg4rpt, columnName=subTableDate, valueRange=[2026-05-14 00:00:00.0..2026-05-14 00:00:00.0])]
2026-05-19 15:24:50.425 - [INFO ] - [Thread-20] - [c.f.d.algorithm.DateTimeShardingTableAlgorithm - line:67]: use table name is [[t_mb_sessionmsg4rpt_202605]]
2026-05-19 15:24:50.470 - [DEBUG] - [Thread-20] - [c.f.m.r.MbSessionMsg4RptMapper.getSessionService - line:137]: <== Total: 0
汇聚全球AI编程工具，助力开发者即刻编程。
更多推荐
4
0- 0
已为社区贡献3条内容
所有评论(0)