狗二哈 2019-12-10 21:38 采纳率: 0%
浏览 894
已结题

微信小程序本地测试没问题,体验版没问题,审核时报错被驳回

问题描述:

之前给公司做了个小程序,上线之后没有问题,审核也通过了,近期有需求做了一些更改(改动不大),这是背景。

然后这次提交审核之后,被驳回了,原因是小程序无法正常使用,看了下审核反馈的截图,登录未成功,报错了。

我立马用体验版测试,因为体验版就是审核的代码,后台连接的服务器程序也是完全一致的,结果亮点来了,我体验版**完美运行**

后来又测试了本地版本,又用了各种方式测试了体验版本,都没有问题,再次提交审核,不出意外,又毙了。。

拉出审核人员登录时的后台日志:

================================================================================================================================================================================================================================================
==========================日志开始======================
================================================================================================================================================================================================================================================
开始计时:07:42:04.389
URI         : /fleetif/fleet/loginFleet
Controller  : com.organ.controller.fleet.FleetLoginController
Method      : loginFleet
Method Type : POST
contentType : application/json
Params    : {"tel":"10001000","checkCode":"1234"}
[DEBUG] 2019-12-09 19:42:04 AbstractMessageConverterMethodArgumentResolver.java DEBUG method:org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodArgumentResolver.readWithMessageConverters(AbstractMessageConverterMethodArgumentResolver.java:197)
Read [class com.organ.entity.fleet.FleetUser] as "application/json;charset=UTF-8" with [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@47b74fce]
[DEBUG] 2019-12-09 19:42:04 SqlSessionUtils.java DEBUG method:org.mybatis.spring.SqlSessionUtils.getSqlSession(SqlSessionUtils.java:109)
Creating a new SqlSession
[DEBUG] 2019-12-09 19:42:04 SqlSessionUtils.java DEBUG method:org.mybatis.spring.SqlSessionUtils.getSqlSession(SqlSessionUtils.java:145)
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@18c7d16e] was not registered for synchronization because synchronization is not active
[DEBUG] 2019-12-09 19:42:04 DataSourceUtils.java DEBUG method:org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)
Fetching JDBC Connection from DataSource
[DEBUG] 2019-12-09 19:42:04 SpringManagedTransaction.java DEBUG method:org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:88)
JDBC Connection [org.apache.commons.dbcp.PoolableConnection@22754112] will not be managed by Spring
[DEBUG] 2019-12-09 19:42:04 BaseJdbcLogger.java DEBUG method:org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:139)
==>  Preparing: SELECT id, user_name userName, tel, user_type userType, state, balance, balance_state balanceState, parent_id parentId, check_code checkCode, create_time createTime, is_del isDel, unit_price_0 unitPrice0, unit_price_10 unitPrice10 FROM `fleet_user` WHERE tel = ? AND is_del = ? 
[DEBUG] 2019-12-09 19:42:04 SQLErrorCodeSQLExceptionTranslator.java DEBUG method:org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:281)
Unable to translate SQLException with Error code '0', will now try the fallback translator
[DEBUG] 2019-12-09 19:42:04 SqlSessionUtils.java DEBUG method:org.mybatis.spring.SqlSessionUtils.closeSqlSession(SqlSessionUtils.java:173)
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@18c7d16e]
[DEBUG] 2019-12-09 19:42:04 DataSourceUtils.java DEBUG method:org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:329)
Returning JDBC Connection to DataSource
[DEBUG] 2019-12-09 19:42:04 DataSourceUtils.java DEBUG method:org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:299)
Could not close JDBC Connection
java.sql.SQLException: Already closed.
    at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
    at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
    at org.springframework.jdbc.datasource.DataSourceUtils.doCloseConnection(DataSourceUtils.java:343)
    at org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:330)
    at org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:296)
    at org.mybatis.spring.transaction.SpringManagedTransaction.close(SpringManagedTransaction.java:125)
    at org.apache.ibatis.executor.BaseExecutor.close(BaseExecutor.java:83)
    at org.apache.ibatis.executor.CachingExecutor.close(CachingExecutor.java:61)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.close(DefaultSqlSession.java:210)
    at org.mybatis.spring.SqlSessionUtils.closeSqlSession(SqlSessionUtils.java:175)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:375)
    at com.sun.proxy.$Proxy51.selectOne(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
    at com.sun.proxy.$Proxy59.findFleetUser(Unknown Source)
    at com.organ.service.fleet.FleetUserService.findFleetUser(FleetUserService.java:39)
    at com.organ.service.fleet.FleetUserService$$FastClassBySpringCGLIB$$888fc21f.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:669)
    at com.organ.service.fleet.FleetUserService$$EnhancerBySpringCGLIB$$726af94b.findFleetUser(<generated>)
    at com.organ.controller.fleet.FleetLoginController.loginFleet(FleetLoginController.java:104)
    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:133)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
    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:967)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at com.organ.filter.PostRequestFilter.doFilter(PostRequestFilter.java:35)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    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:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.logging.log4j.core.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:66)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
    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:748)
[DEBUG] 2019-12-09 19:42:04 AbstractMessageConverterMethodProcessor.java DEBUG method:org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:234)
Written [com.organ.controller.base.ResultData@13c8038d] as "application/json" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@47b74fce]
[DEBUG] 2019-12-09 19:42:04 LogInterceptor.java DEBUG method:com.organ.interceptor.LogInterceptor.postHandle(LogInterceptor.java:118)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CostTime  : 8ms
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[DEBUG] 2019-12-09 19:42:04 DispatcherServlet.java DEBUG method:org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1048)
Null ModelAndView returned to DispatcherServlet with name 'springDispatcherServlet': assuming HandlerAdapter completed request handling
[DEBUG] 2019-12-09 19:42:04 LogInterceptor.java DEBUG method:com.organ.interceptor.LogInterceptor.afterCompletion(LogInterceptor.java:142)
计时结束:07:42:04.397 耗时:8 URI:/fleetif/fleet/loginFleet
[DEBUG] 2019-12-09 19:42:04 LogInterceptor.java DEBUG method:com.organ.interceptor.LogInterceptor.afterCompletion(LogInterceptor.java:149)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[DEBUG] 2019-12-09 19:42:04 FrameworkServlet.java DEBUG method:org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1000)
Successfully completed request
[DEBUG] 2019-12-09 19:42:33 PostRequestFilter.java DEBUG method:com.organ.filter.PostRequestFilter.doFilter(PostRequestFilter.java:27)
------------------------PostRequestFilter doFilter execute!!!
[DEBUG] 2019-12-09 19:42:33 DispatcherServlet.java DEBUG method:org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:869)
DispatcherServlet with name 'springDispatcherServlet' processing POST request for [/fleetif/fleet/smsCode]
[DEBUG] 2019-12-09 19:42:33 AbstractHandlerMethodMapping.java DEBUG method:org.springframework.web.servlet.handler.AbstractHandlerMethodMapping.getHandlerInternal(AbstractHandlerMethodMapping.java:310)
Looking up handler method for path /fleet/smsCode
[DEBUG] 2019-12-09 19:42:33 AbstractHandlerMethodMapping.java DEBUG method:org.springframework.web.servlet.handler.AbstractHandlerMethodMapping.getHandlerInternal(AbstractHandlerMethodMapping.java:317)
Returning handler method [public java.lang.Object com.organ.controller.fleet.FleetLoginController.smsCode(javax.servlet.http.HttpServletRequest,java.util.Map<java.lang.String, java.lang.String>)]
[DEBUG] 2019-12-09 19:42:33 AbstractBeanFactory.java DEBUG method:org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:251)
Returning cached instance of singleton bean 'fleetLoginController'
[DEBUG] 2019-12-09 19:42:33 LogInterceptor.java DEBUG method:com.organ.interceptor.LogInterceptor.preHandle(LogInterceptor.java:90)

可以看到数据库报了个错,但是这个错什么原因目前查不出来,而且我们无法复现,我们测试一切正常,只要审核人员登录就会报这个错误。
有没有大神指导一下,现在头都大了。。。

  • 写回答

3条回答

  • dabocaiqq 2019-12-11 00:06
    关注
    评论

报告相同问题?

悬赏问题

  • ¥15 求帮我调试一下freefem代码
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图