You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "QQ-JiangWang (via GitHub)" <gi...@apache.org> on 2024/05/15 11:50:12 UTC
[I] ComplexKeysShardingAlgorithm When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day：Caused by: java.lang.NullPointerException: null at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.getValueCaseSensitiveFromTables(GroupByMemoryMergedResult.java:135) [shardingsphere]
QQ-JiangWang opened a new issue, #31231:
URL: https://github.com/apache/shardingsphere/issues/31231
19:45:40.695 [http-nio-21541-exec-7] INFO ShardingSphere-SQL - [log,74] - Logic SQL: SELECT COUNT(*) AS total FROM alarm t INNER JOIN device d ON (d.id = t.device_id) INNER JOIN alarm_type `type` ON (`type`.id = t.type) WHERE `type`.is_show = 1 AND t.start_time BETWEEN ? AND ?
19:45:40.695 [http-nio-21541-exec-7] INFO ShardingSphere-SQL - [log,74] - SQLStatement: MySQLSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=2, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=185, stopIndex=185, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=191, stopIndex=191, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), projections=ProjectionsSegment(startIndex=7, stopIndex=23, projections=[AggregationProjectionSegment(startIndex=7, stopIndex=14, type=COUNT, innerExpression=(*), parameters=[], alias=Optional[total])], distinctRow=false), from=JoinTableSegment(startIndex=30, stopIndex=133, alias=Optional.empty, left=JoinTableSegment(startIndex=30, stopIndex=80, alias=Optional.empty, left=SimpleTableSegment(tableName=TableNameSegment(startIndex=30, stopIndex=34, identifier=IdentifierValue(value=alarm,
quoteCharacter=NONE)), owner=Optional.empty, alias=Optional[t]), joinType=INNER, right=SimpleTableSegment(tableName=TableNameSegment(startIndex=49, stopIndex=54, identifier=IdentifierValue(value=device, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional[d]), condition=BinaryOperationExpression(startIndex=62, stopIndex=79, left=ColumnSegment(startIndex=62, stopIndex=65, identifier=IdentifierValue(value=id, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=62, stopIndex=62, identifier=IdentifierValue(value=d, quoteCharacter=NONE), owner=Optional.empty)]), right=ColumnSegment(startIndex=69, stopIndex=79, identifier=IdentifierValue(value=device_id, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=69, stopIndex=69, identifier=IdentifierValue(value=t, quoteCharacter=NONE), owner=Optional.empty)]), operator==, text=d.id = t.device_id), using=[]), joinType=INNER, right=SimpleTableSegment(tableName=TableNameSegment(startIndex=93, stopIndex=102, identifier=Iden
tifierValue(value=alarm_type, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional[type]), condition=BinaryOperationExpression(startIndex=115, stopIndex=132, left=ColumnSegment(startIndex=115, stopIndex=123, identifier=IdentifierValue(value=id, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=115, stopIndex=120, identifier=IdentifierValue(value=type, quoteCharacter=BACK_QUOTE), owner=Optional.empty)]), right=ColumnSegment(startIndex=127, stopIndex=132, identifier=IdentifierValue(value=type, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=127, stopIndex=127, identifier=IdentifierValue(value=t, quoteCharacter=NONE), owner=Optional.empty)]), operator==, text=`type`.id = t.type), using=[]), where=Optional[WhereSegment(startIndex=135, stopIndex=191, expr=BinaryOperationExpression(startIndex=141, stopIndex=191, left=BinaryOperationExpression(startIndex=141, stopIndex=158, left=ColumnSegment(startIndex=141, stopIndex=154, identifier=IdentifierValue(value=is_
show, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=141, stopIndex=146, identifier=IdentifierValue(value=type, quoteCharacter=BACK_QUOTE), owner=Optional.empty)]), right=LiteralExpressionSegment(startIndex=158, stopIndex=158, literals=1), operator==, text=`type`.is_show = 1), right=BetweenExpression(startIndex=164, stopIndex=191, left=ColumnSegment(startIndex=164, stopIndex=175, identifier=IdentifierValue(value=start_time, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=164, stopIndex=164, identifier=IdentifierValue(value=t, quoteCharacter=NONE), owner=Optional.empty)]), betweenExpr=ParameterMarkerExpressionSegment(startIndex=185, stopIndex=185, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), andExpr=ParameterMarkerExpressionSegment(startIndex=191, stopIndex=191, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), not=false), operator=AND, text=`type`.is_show = 1 AND t.start_time BETWEEN ? AND ?))], gr
oupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty), table=Optional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
19:45:40.696 [http-nio-21541-exec-7] INFO ShardingSphere-SQL - [log,74] - Actual SQL: cemos ::: SELECT COUNT(*) AS total FROM alarm_20240512 t INNER JOIN device d ON (d.id = t.device_id) INNER JOIN alarm_type `type` ON (`type`.id = t.type) WHERE `type`.is_show = 1 AND t.start_time BETWEEN ? AND ? ::: [2024-05-12 00:00:00.0, 2024-05-13 18:59:59.0]
19:45:40.696 [http-nio-21541-exec-7] INFO ShardingSphere-SQL - [log,74] - Actual SQL: cemos ::: SELECT COUNT(*) AS total FROM alarm_20240513 t INNER JOIN device d ON (d.id = t.device_id) INNER JOIN alarm_type `type` ON (`type`.id = t.type) WHERE `type`.is_show = 1 AND t.start_time BETWEEN ? AND ? ::: [2024-05-12 00:00:00.0, 2024-05-13 18:59:59.0]
19:45:40.697 [hutool-cron-4] INFO ShardingSphere-SQL - [log,74] - Logic SQL: select
count(t.id)
from
device t
19:45:40.697 [hutool-cron-4] INFO ShardingSphere-SQL - [log,74] - SQLStatement: MySQLSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0, parameterMarkerSegments=[], commentSegments=[]), projections=ProjectionsSegment(startIndex=15, stopIndex=25, projections=[AggregationProjectionSegment(startIndex=15, stopIndex=25, type=COUNT, innerExpression=(t.id), parameters=[ColumnSegment(startIndex=21, stopIndex=24, identifier=IdentifierValue(value=id, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=21, stopIndex=21, identifier=IdentifierValue(value=t, quoteCharacter=NONE), owner=Optional.empty)])], alias=Optional.empty)], distinctRow=false), from=SimpleTableSegment(tableName=TableNameSegment(startIndex=48, stopIndex=53, identifier=IdentifierValue(value=device, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional[t]), where=Optional.empty, groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty), table=O
ptional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
19:45:40.697 [hutool-cron-4] INFO ShardingSphere-SQL - [log,74] - Actual SQL: cemos ::: select
count(t.id)
from
device t
19:45:41.899 [http-nio-21541-exec-7] ERROR c.i.s.c.a.i.e.ExceptionControllerAdvice - [throwableHandler,108] - throwableHandler error {}
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.NullPointerException
### The error may exist in com/insi/site/cemos/auth/domain/alarm/repository/mapper/AlarmMapper.xml
### The error may involve com.insi.site.cemos.auth.domain.alarm.repository.mapper.AlarmMapper.selectAlarmPage_mpCount
### The error occurred while handling results
### SQL: SELECT COUNT(*) AS total FROM alarm t INNER JOIN device d ON (d.id = t.device_id) INNER JOIN alarm_type `type` ON (`type`.id = t.type) WHERE `type`.is_show = 1 AND t.start_time BETWEEN ? AND ?
### Cause: java.lang.NullPointerException
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy140.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:119)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:84)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy165.selectAlarmPage(Unknown Source)
at com.insi.site.cemos.auth.domain.alarm.service.impl.AlarmServiceImpl.findAlarmPage(AlarmServiceImpl.java:103)
at com.insi.site.cemos.auth.domain.alarm.service.impl.AlarmServiceImpl$$FastClassBySpringCGLIB$$41c758.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:703)
at com.insi.site.cemos.auth.domain.alarm.service.impl.AlarmServiceImpl$$EnhancerBySpringCGLIB$$cca94e57.findAlarmPage(<generated>)
at com.insi.site.cemos.auth.application.service.DeviceAlarmAppService.findDeviceAlarmPage(DeviceAlarmAppService.java:119)
at com.insi.site.cemos.auth.interfaces.facade.AlarmApi.findDeviceAlarmPage(AlarmApi.java:41)
at com.insi.site.cemos.auth.interfaces.facade.AlarmApi$$FastClassBySpringCGLIB$$544d04af.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.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.insi.site.cemos.auth.interfaces.facade.AlarmApi$$EnhancerBySpringCGLIB$$39cb5e74.findDeviceAlarmPage(<generated>)
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.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:337)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:164)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:112)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:82)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.session.DisableEncodeUrlFilter.doFilterInternal(DisableEncodeUrlFilter.java:42)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:346)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:221)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:186)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.lang.Thread.run(Thread.java:750)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.NullPointerException
### The error may exist in com/insi/site/cemos/auth/domain/alarm/repository/mapper/AlarmMapper.xml
### The error may involve com.insi.site.cemos.auth.domain.alarm.repository.mapper.AlarmMapper.selectAlarmPage_mpCount
### The error occurred while handling results
### SQL: SELECT COUNT(*) AS total FROM alarm t INNER JOIN device d ON (d.id = t.device_id) INNER JOIN alarm_type `type` ON (`type`.id = t.type) WHERE `type`.is_show = 1 AND t.start_time BETWEEN ? AND ?
### Cause: java.lang.NullPointerException
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.GeneratedMethodAccessor113.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)
... 121 common frames omitted
Caused by: java.lang.NullPointerException: null
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.getValueCaseSensitiveFromTables(GroupByMemoryMergedResult.java:135)
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.getValueCaseSensitive(GroupByMemoryMergedResult.java:125)
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.init(GroupByMemoryMergedResult.java:73)
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.init(GroupByMemoryMergedResult.java:53)
at org.apache.shardingsphere.infra.merge.result.impl.memory.MemoryMergedResult.<init>(MemoryMergedResult.java:52)
at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.<init>(GroupByMemoryMergedResult.java:56)
at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.getGroupByMergedResult(ShardingDQLResultMerger.java:118)
at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.build(ShardingDQLResultMerger.java:88)
at org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.merge(ShardingDQLResultMerger.java:66)
at org.apache.shardingsphere.infra.merge.MergeEngine.executeMerge(MergeEngine.java:82)
at org.apache.shardingsphere.infra.merge.MergeEngine.merge(MergeEngine.java:71)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.mergeQuery(ShardingSpherePreparedStatement.java:517)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.getResultSet(ShardingSpherePreparedStatement.java:465)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getFirstResultSet(DefaultResultSetHandler.java:238)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:188)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
at com.sun.proxy.$Proxy223.query(Unknown Source)
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.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor.willDoQuery(PaginationInnerInterceptor.java:135)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:75)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy222.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
... 127 common frames omitted
<img width="963" alt="微信图片_20240515194757" src="https://github.com/apache/shardingsphere/assets/56721066/fb607154-e37c-43fe-b1ee-ed14f9a8ea51">
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ComplexKeysShardingAlgorithm,When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #31231:
URL: https://github.com/apache/shardingsphere/issues/31231#issuecomment-2212307979
`shardingsphere-jdbc-core-spring-boot-starter` is deprecated, please try new version and use ShardingSphere Driver.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ComplexKeysShardingAlgorithm When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day：Caused by: java.lang.NullPointerException: null at org.apache.shardingsphere.sharding.merge.dql.groupby.GroupByMemoryMergedResult.getValueCaseSensitiveFromTables(GroupByMemoryMergedResult.java:135) [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #31231:
URL: https://github.com/apache/shardingsphere/issues/31231#issuecomment-2116396712
@QQ-JiangWang Can you modify the title for search friendly?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ComplexKeysShardingAlgorithm,When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day [shardingsphere]
Posted by "QQ-JiangWang (via GitHub)" <gi...@apache.org>.
QQ-JiangWang commented on issue #31231:
URL: https://github.com/apache/shardingsphere/issues/31231#issuecomment-2116531637
That version? Is there a shardingsphere-jdbc-core-spring-boot-starter version?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ComplexKeysShardingAlgorithm,When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #31231:
URL: https://github.com/apache/shardingsphere/issues/31231#issuecomment-2174327478
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ComplexKeysShardingAlgorithm,When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #31231:
URL: https://github.com/apache/shardingsphere/issues/31231#issuecomment-2116494828
Hi @QQ-JiangWang, you can refer the latest version, we have added exception judgment here. Usually the metadata cannot be obtained because one of your actual tables does not exist, causing ShardingSphere to be unable to obtain metadata information.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ComplexKeysShardingAlgorithm,When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day [shardingsphere]
Posted by "QQ-JiangWang (via GitHub)" <gi...@apache.org>.
QQ-JiangWang commented on issue #31231:
URL: https://github.com/apache/shardingsphere/issues/31231#issuecomment-2116465790
@strongduanmu Please help to check this error, I debug the code, found that shardingsphere-jdbc-core-spring-boot-starter version 5.0.0, when initializing ShardingSphereSchema object, filter the table to be sharded, When querying multiple shard tables, ShardingSphereSchema object fails to obtain the shard table, prompting NullPointerException. Please help me check this error. I have debugged the code. When a shardingsphere-jdbc-core-spring-boot-starter version later than 5.0.0 is found, the ShardingSphereSchema object is initialized, and the shardingSphereschema object filters out the fragmented tables. ShardingSphereSchema This object cannot obtain the shard table, prompting a NullPointerException
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ComplexKeysShardingAlgorithm,When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day [shardingsphere]
Posted by "QQ-JiangWang (via GitHub)" <gi...@apache.org>.
QQ-JiangWang commented on issue #31231:
URL: https://github.com/apache/shardingsphere/issues/31231#issuecomment-2116517134
@strongduanmu Now how to solve this problem?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ComplexKeysShardingAlgorithm,When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #31231: ComplexKeysShardingAlgorithm,When time fragmentation occurs, an error message is displayed for querying multiple tables in one day, but the query succeeds in one day
URL: https://github.com/apache/shardingsphere/issues/31231
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org