You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by "Python-IBM (via GitHub)" <gi...@apache.org> on 2023/03/01 02:07:07 UTC

[GitHub] [shardingsphere] Python-IBM opened a new issue, #24393: Mybatis joint table INNER JOIN paging query execution count reported null exception

Python-IBM opened a new issue, #24393:
URL: https://github.com/apache/shardingsphere/issues/24393

   **1. Application version**
   shardingsphere-jdbc：5.2.0
   mysql：5.7
   mybatis-plus: 3.4.1
   Spring Boot: 2.3.12
   
   **2.Query exception**
   2023-03-01 09:47:05.665 DEBUG [http-nio-9702-exec-5][1630746447933083648] c.y.f.m.m.R.selectJoinForPage_mpCount ==>  Preparing: SELECT COUNT(*) FROM `reg_bill_info` rbi INNER JOIN `reg_bill_trans` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ?
   2023-03-01 09:47:05.720 DEBUG [http-nio-9702-exec-5][1630746447933083648] c.y.f.m.m.R.selectJoinForPage_mpCount ==> Parameters: 1556603137911963649(String)
   2023-03-01 09:47:05.728 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Logic SQL: SELECT COUNT(*) FROM `reg_bill_info` rbi INNER JOIN `reg_bill_trans` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ?
   2023-03-01 09:47:05.729 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL SQLStatement: MySQLSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=1, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=128, stopIndex=128, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), projections=ProjectionsSegment(startIndex=7, stopIndex=14, projections=[AggregationProjectionSegment(startIndex=7, stopIndex=14, type=COUNT, innerExpression=(*), parameters=[], alias=Optional.empty)], distinctRow=false), from=JoinTableSegment(startIndex=21, stopIndex=104, alias=Optional.empty, left=SimpleTableSegment(tableName=TableNameSegment(startIndex=21, stopIndex=35, identifier=IdentifierValue(value=reg_bill_info, quoteCharacter=BACK_QUOTE)), owner=Optional.empty, alias=Optional[rbi]), joinType=INNER, right=SimpleTableSegment(tableName=TableNameSegment(startIndex=52, stopIndex=67, identifier=Identifi
 erValue(value=reg_bill_trans, quoteCharacter=BACK_QUOTE)), owner=Optional.empty, alias=Optional[rbt]), condition=BinaryOperationExpression(startIndex=76, stopIndex=104, left=ColumnSegment(startIndex=76, stopIndex=88, identifier=IdentifierValue(value=BILL_ID, quoteCharacter=BACK_QUOTE), owner=Optional[OwnerSegment(startIndex=76, stopIndex=78, identifier=IdentifierValue(value=rbi, quoteCharacter=NONE), owner=Optional.empty)]), right=ColumnSegment(startIndex=92, stopIndex=104, identifier=IdentifierValue(value=BILL_ID, quoteCharacter=BACK_QUOTE), owner=Optional[OwnerSegment(startIndex=92, stopIndex=94, identifier=IdentifierValue(value=rbt, quoteCharacter=NONE), owner=Optional.empty)]), operator==, text=rbi.`BILL_ID` = rbt.`BILL_ID`), using=[]), where=Optional[WhereSegment(startIndex=106, stopIndex=128, expr=BinaryOperationExpression(startIndex=112, stopIndex=128, left=ColumnSegment(startIndex=112, stopIndex=124, identifier=IdentifierValue(value=BILL_ID, quoteCharacter=BACK_QUOTE), owner
 =Optional[OwnerSegment(startIndex=112, stopIndex=114, identifier=IdentifierValue(value=rbi, quoteCharacter=NONE), owner=Optional.empty)]), right=ParameterMarkerExpressionSegment(startIndex=128, stopIndex=128, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), operator==, text=rbi.`BILL_ID` = ?))], groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combines=[]), table=Optional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
   2023-03-01 09:47:05.730 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2021` rbi INNER JOIN `reg_bill_trans_2021` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.730 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2021` rbi INNER JOIN `reg_bill_trans_2022` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.730 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2021` rbi INNER JOIN `reg_bill_trans_2023` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.730 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2022` rbi INNER JOIN `reg_bill_trans_2021` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.731 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2022` rbi INNER JOIN `reg_bill_trans_2022` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.731 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2022` rbi INNER JOIN `reg_bill_trans_2023` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.731 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2023` rbi INNER JOIN `reg_bill_trans_2021` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.731 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2023` rbi INNER JOIN `reg_bill_trans_2022` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.731 INFO  [http-nio-9702-exec-5][1630746447933083648] ShardingSphere-SQL Actual SQL: yk_sharding ::: SELECT COUNT(*) FROM `reg_bill_info_2023` rbi INNER JOIN `reg_bill_trans_2023` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ? ::: [1556603137911963649]
   2023-03-01 09:47:05.780 ERROR [http-nio-9702-exec-5][] o.a.c.c.C.[.[.[.[dispatcherServlet] Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
   ### Error querying database.  Cause: java.lang.NullPointerException
   ### The error may involve com.demo.message.mapper.RegBillTransMapper.selectJoinForPage_mpCount
   ### The error occurred while handling results
   ### SQL: SELECT COUNT(*) FROM `reg_bill_info` rbi INNER JOIN `reg_bill_trans` rbt ON rbi.`BILL_ID` = rbt.`BILL_ID` WHERE rbi.`BILL_ID` = ?
   ### Cause: java.lang.NullPointerException] with root cause
   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:51)
   	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:520)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.getResultSet(ShardingSpherePreparedStatement.java:462)
   	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.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:69)
   	at com.sun.proxy.$Proxy103.getResultSet(Unknown Source)
   	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getFirstResultSet(DefaultResultSetHandler.java:237)
   	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:187)
   	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.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.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
   	at com.sun.proxy.$Proxy101.query(Unknown Source)
   	at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:69)
   	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
   	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
   	at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:165)
   	at com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor.willDoQuery(PaginationInnerInterceptor.java:134)
   	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:59)
   	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
   	at com.sun.proxy.$Proxy100.query(Unknown Source)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
   	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
   	at com.sun.proxy.$Proxy79.selectList(Unknown Source)
   	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:122)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:87)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
   	at com.sun.proxy.$Proxy82.selectJoinForPage(Unknown Source)
   	at com.demo.message.controller.DemoController.queryRegBillTransPage(DemoController.java:106)
   	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:190)
   	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
   	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
   	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
   	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
   	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
   	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
   	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
   	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
   	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
   	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
   	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
   	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
   	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
   	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
   	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
   	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
   	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
   	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
   	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
   	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
   	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
   	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
   	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
   	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   	at java.lang.Thread.run(Thread.java:750)
   


-- 
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