PageHelper插件在Linux系统不能正常使用问题

Question

本地正常配置使用

Mybaties sql语句

windows平台能正常请求接口，并能返回信息

Answer 1

下面是在linux系统执行接口，查看日志捕获的信息：

2017-07-20 12:15:56.636 DEBUG [http-bio-8012-exec-2][RequestContextFilter.java:114] - Bound request context to thread: org.apache.catalina.connector.RequestFacade@ffe7d11
2017-07-20 12:15:56.636 DEBUG [http-bio-8012-exec-2][DispatcherServlet.java:865] - DispatcherServlet with name 'dispatcherServlet' processing GET request for [/bdse-regional-flow-service-test/userInfo/getUserInfoList]
2017-07-20 12:15:56.637 DEBUG [http-bio-8012-exec-2][AbstractHandlerMethodMapping.java:310] - Looking up handler method for path /userInfo/getUserInfoList
2017-07-20 12:15:56.637 DEBUG [http-bio-8012-exec-2][AbstractHandlerMethodMapping.java:317] - Returning handler method [public void cn.ctyun.bigdata.bdse.regionalflow.controller.UserInfoController.getUserInfoList(javax.servlet.http.HttpServletResponse,java.lang.Integer,java.lang.Integer,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)]
2017-07-20 12:15:56.637 DEBUG [http-bio-8012-exec-2][AbstractBeanFactory.java:251] - Returning cached instance of singleton bean 'userInfoController'
2017-07-20 12:15:56.638 DEBUG [http-bio-8012-exec-2][DispatcherServlet.java:951] - Last-Modified value for [/bdse-regional-flow-service-test/userInfo/getUserInfoList] is: -1
2017-07-20 12:15:56.638 INFO [http-bio-8012-exec-2][AuthInterceptor.java:52] - 57BE8700D65F314D8CF811B19360F61D
2017-07-20 12:15:56.638 INFO [http-bio-8012-exec-2][AuthInterceptor.java:66] - AuthInterceptor preHandle request.getRequestURL= http://42.123.106.20/bdse-regional-flow-service-test/userInfo/getUserInfoList
2017-07-20 12:15:56.638 INFO [http-bio-8012-exec-2][AuthInterceptor.java:67] - AuthInterceptor preHandle http header user_uype= 2
2017-07-20 12:15:56.638 DEBUG [http-bio-8012-exec-2][AbstractBeanFactory.java:251] - Returning cached instance of singleton bean 'redisUtil'
SESSIONKEY_LOGININFO_CUSTOMER
2017-07-20 12:15:56.640 DEBUG [http-bio-8012-exec-2][RedisConnectionUtils.java:126] - Opening RedisConnection
2017-07-20 12:15:56.641 DEBUG [http-bio-8012-exec-2][RedisConnectionUtils.java:210] - Closing Redis Connection
2017-07-20 12:15:56.641 DEBUG [http-bio-8012-exec-2][RedisConnectionUtils.java:126] - Opening RedisConnection
2017-07-20 12:15:56.642 DEBUG [http-bio-8012-exec-2][RedisConnectionUtils.java:210] - Closing Redis Connection
1===10===null===null===null===null===null
null===null===null===null===null
2017-07-20 12:15:56.643 DEBUG [http-bio-8012-exec-2][SqlSessionUtils.java:97] - Creating a new SqlSession
2017-07-20 12:15:56.644 DEBUG [http-bio-8012-exec-2][SqlSessionUtils.java:148] - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@79e876ad] was not registered for synchronization because synchronization is not active
2017-07-20 12:15:56.644 DEBUG [http-bio-8012-exec-2][LoggingCache.java:62] - Cache Hit Ratio [SQL_CACHE]: 0.0
2017-07-20 12:15:56.646 DEBUG [http-bio-8012-exec-2][LoggingCache.java:62] - Cache Hit Ratio [SQL_CACHE]: 0.5
2017-07-20 12:15:56.649 DEBUG [http-bio-8012-exec-2][DataSourceUtils.java:110] - Fetching JDBC Connection from DataSource
2017-07-20 12:15:56.649 DEBUG [http-bio-8012-exec-2][SpringManagedTransaction.java:87] - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.jdbc.JDBC4Connection@3e1aeb3b]]] will not be managed by Spring
2017-07-20 12:15:56.650 DEBUG [http-bio-8012-exec-2][BaseJdbcLogger.java:181] - ==> Preparing: SELECT count(0) FROM (SELECT count(0) FROM regional_flow_user_info a JOIN regional_flow_province_info b ON a.user_province = b.pro_id JOIN regional_flow_city_info c ON a.user_city = c.city_id JOIN regional_flow_district_info d ON a.user_district = d.district_id WHERE user_state != 1) table_count
2017-07-20 12:15:56.650 DEBUG [http-bio-8012-exec-2][BaseJdbcLogger.java:181] - ==> Parameters:
2017-07-20 12:15:56.651 DEBUG [http-bio-8012-exec-2][BaseJdbcLogger.java:181] - <== Total: 1
2017-07-20 12:15:56.651 DEBUG [http-bio-8012-exec-2][BaseJdbcLogger.java:181] - ==> Preparing: SELECT count(0) FROM regional_flow_user_info a JOIN regional_flow_province_info b ON a.user_province = b.pro_id JOIN regional_flow_city_info c ON a.user_city = c.city_id JOIN regional_flow_district_info d ON a.user_district = d.district_id WHERE user_state != 1 LIMIT 10
2017-07-20 12:15:56.652 DEBUG [http-bio-8012-exec-2][BaseJdbcLogger.java:181] - ==> Parameters:
2017-07-20 12:15:56.652 DEBUG [http-bio-8012-exec-2][BaseJdbcLogger.java:181] - <== Total: 1
2017-07-20 12:15:56.653 DEBUG [http-bio-8012-exec-2][SqlSessionUtils.java:191] - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@79e876ad]
2017-07-20 12:15:56.653 DEBUG [http-bio-8012-exec-2][DataSourceUtils.java:327] - Returning JDBC Connection to DataSource
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: java.lang.NullPointerException

The error may exist in file [/home/super/data/tomcat-8012-regionflow/webapps/bdse-regional-flow-service-test/WEB-INF/classes/mybatis/UserInfoMapper.xml]

The error may involve cn.ctyun.bigdata.bdse.regionalflow.mapper.UserInfoMapper.findUserInfoList_COUNT

The error occurred while handling results

SQL: SELECT count(0) FROM regional_flow_user_info a JOIN regional_flow_province_info b ON a.user_province = b.pro_id JOIN regional_flow_city_info c ON a.user_city = c.city_id JOIN regional_flow_district_info d ON a.user_district = d.district_id WHERE user_state != 1 LIMIT 10

Cause: java.lang.NullPointerException

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy79.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy90.findUserInfoList(Unknown Source)
at cn.ctyun.bigdata.bdse.regionalflow.service.impl.UserInfoServiceImpl.findUserInfoList(UserInfoServiceImpl.java:56)
at cn.ctyun.bigdata.bdse.regionalflow.controller.UserInfoController.getUserInfoList(UserInfoController.java:336)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:115)
at org.springframework.boot.web.support.ErrorPageFilter.access$000(ErrorPageFilter.java:59)
at org.springframework.boot.web.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:90)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.boot.web.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)

Caused by: org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: java.lang.NullPointerException

The error may exist in file [/home/super/data/tomcat-8012-regionflow/webapps/bdse-regional-flow-service-test/WEB-INF/classes/mybatis/UserInfoMapper.xml]

The error may involve cn.ctyun.bigdata.bdse.regionalflow.mapper.UserInfoMapper.findUserInfoList_COUNT

The error occurred while handling results

SQL: SELECT count(0) FROM regional_flow_user_info a JOIN regional_flow_province_info b ON a.user_province = b.pro_id JOIN regional_flow_city_info c ON a.user_city = c.city_id JOIN regional_flow_district_info d ON a.user_district = d.district_id WHERE user_state != 1 LIMIT 10

Cause: java.lang.NullPointerException

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
... 68 more

Caused by: java.lang.NullPointerException
at com.github.pagehelper.dialect.AbstractHelperDialect.afterCount(AbstractHelperDialect.java:71)
at com.github.pagehelper.PageHelper.afterCount(PageHelper.java:73)
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:115)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy107.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
... 74 more
2017-07-20 12:15:56.656 ERROR [http-bio-8012-exec-2][UserInfoController.java:356] - nested exception is org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: java.lang.NullPointerException

The error may exist in file [/home/super/data/tomcat-8012-regionflow/webapps/bdse-regional-flow-service-test/WEB-INF/classes/mybatis/UserInfoMapper.xml]

The error may involve cn.ctyun.bigdata.bdse.regionalflow.mapper.UserInfoMapper.findUserInfoList_COUNT

The error occurred while handling results

SQL: SELECT count(0) FROM regional_flow_user_info a JOIN regional_flow_province_info b ON a.user_province = b.pro_id JOIN regional_flow_city_info c ON a.user_city = c.city_id JOIN regional_flow_district_info d ON a.user_district = d.district_id WHERE user_state != 1 LIMIT 10

Cause: java.lang.NullPointerException

2017-07-20 12:15:56.656 INFO [http-bio-8012-exec-2][AuthInterceptor.java:140] - 请求接口 /bdse-regional-flow-service-test/userInfo/getUserInfoList 处理时间：18ms
2017-07-20 12:15:56.656 DEBUG [http-bio-8012-exec-2][DispatcherServlet.java:1044] - Null ModelAndView returned to DispatcherServlet with name 'dispatcherServlet': assuming HandlerAdapter completed request handling
2017-07-20 12:15:56.656 DEBUG [http-bio-8012-exec-2][FrameworkServlet.java:1000] - Successfully completed request
2017-07-20 12:15:56.657 DEBUG [http-bio-8012-exec-2][RequestContextFilter.java:104] - Cleared thread-bound request context: org.apache.catalina.connector.Request