采用Saber+bladex boot 2.5.0 搭建程序 出现大量 java.sql.SQLException: connection closed

Blade 未结 2 157
tdinfo
tdinfo 剑童 2022-09-25 19:50

一、该问题的重现步骤是什么?

1. 启动或者重新部署,系统运行正常

2. 运行一段时间后,不定,比如半天后,开始出现java.sql.SQLException: connection closed

3. 随着时间增加,出现频率增大,最后系统基本不可用


由于不知道在哪里可以充值财富值,没法悬赏,如果解决,可以直接协商报酬


二、你期待的结果是什么?实际看到的又是什么?

不出现这种异常,系统长期运行平稳

三、你正在使用的是什么产品,什么版本?在什么操作系统上?

Saber+bladex boot 2.5.0  在天翼云容器上部署, 采用tomcat运行

数据库连接池配置如下

druid:

      initial-size: 5

      max-active: 30

      min-idle: 2

      # MySql、PostgreSQL校验

      validation-query: select 1

      max-wait: 60000

      validation-query-timeout: 2000

      test-on-borrow: true

      test-on-return: false

      test-while-idle: true

      remove-abandoned: true

      log-abandoned: true

      remove-abandoned-timeout-millis: 60000

      time-between-eviction-runs-millis: 60000

      min-evictable-idle-time-millis: 300000

四、请提供详细的错误堆栈信息,这很重要。

08370  ================   Response End   ================

308371

308372  2022-09-23 16:43:38.987 ERROR 7 --- [apr-8080-exec-2] o.s.c.l.e.BladeRestExceptionTranslator   : 服务器异常

308373

308374  org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 

308375  ### Error querying database.  Cause: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))]; SQL state [null]; error code [0]; connection closed; nested exception is java.sql.SQLException: connection closed

308376  ### The error may exist in file [/usr/local/tomcat/webapps/am-service/WEB-INF/classes/org/springblade/modules/system/mapper/DictMapper.xml]

308377  ### The error may involve org.springblade.modules.system.mapper.DictMapper.getList

308378  ### The error occurred while executing a query

308379  ### Cause: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))]; SQL state [null]; error code [0]; connection closed; nested exception is java.sql.SQLException: connection closed

308380          at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) ~[mybatis-spring-2.0.4.jar:2.0.4]

308381          at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) ~[mybatis-spring-2.0.4.jar:2.0.4]

308382          at com.sun.proxy.$Proxy123.selectList(Unknown Source) ~[na:na]

308383          at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223) ~[mybatis-spring-2.0.4.jar:2.0.4]

308384          at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177) ~[mybatis-plus-core-3.3.2.jar:3.3.2]

308385          at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78) ~[mybatis-plus-core-3.3.2.jar:3.3.2]

308386          at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96) ~[mybatis-plus-core-3.3.2.jar:3.3.2]

308387          at com.sun.proxy.$Proxy240.getList(Unknown Source) ~[na:na]

308388          at org.springblade.modules.system.service.impl.DictServiceImpl.getList(DictServiceImpl.java:75) ~[classes/:na]

308389          at org.springblade.modules.system.service.impl.DictServiceImpl$$FastClassBySpringCGLIB$$7ccbfab5.invoke(<generated>) ~[classes/:na]

308390          at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308391          at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308392          at org.springblade.modules.system.service.impl.DictServiceImpl$$EnhancerBySpringCGLIB$$ee2d564.getList(<generated>) ~[classes/:na]

308393          at org.springblade.modules.system.controller.DictController.dictionary(DictController.java:159) ~[classes/:na]

308394          at org.springblade.modules.system.controller.DictController$$FastClassBySpringCGLIB$$558c2c59.invoke(<generated>) ~[classes/:na]

308395          at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308396          at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:750) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308397          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308398          at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308399          at org.springblade.core.log.aspect.RequestLogAspect.aroundApi(RequestLogAspect.java:111) ~[blade-starter-log-2.5.1.RELEASE.jar:na]

308400          at sun.reflect.GeneratedMethodAccessor238.invoke(Unknown Source) ~[na:na]

308401          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_275]

308402          at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_275]

308403          at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308404          at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308405          at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308406          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308407          at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308408          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308409          at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308410          at org.springblade.modules.system.controller.DictController$$EnhancerBySpringCGLIB$$8e1aae28.dictionary(<generated>) ~[classes/:na]

308411          at sun.reflect.GeneratedMethodAccessor445.invoke(Unknown Source) ~[na:na]

308412          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_275]

308413          at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_275]

308414          at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308415          at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308416          at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308417          at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:893) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308418          at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:798) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308419          at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308420          at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308421          at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308422          at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308423          at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308424          at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) [servlet-api.jar:na]

308425          at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308426          at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [servlet-api.jar:na]

308427          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.51]

308428          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308429          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.51]

308430          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308431          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308432          at org.springblade.core.tool.request.BladeRequestFilter.doFilter(BladeRequestFilter.java:49) [blade-core-tool-2.5.1.RELEASE.jar:na]

308433          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308434          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308435          at org.springblade.core.log.filter.LogTraceFilter.doFilter(LogTraceFilter.java:39) [blade-starter-log-2.5.1.RELEASE.jar:na]

308436          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308437          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308438          at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124) [druid-1.2.8.jar:1.2.8]

308439          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308440          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308441          at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308442          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308443          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308444          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308445          at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308446          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308447          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308448          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308449          at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:94) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308450          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308451          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308452          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308453          at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:128) [spring-boot-2.1.13.RELEASE.jar:2.1.13.RELEASE]

308454          at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66) [spring-boot-2.1.13.RELEASE.jar:2.1.13.RELEASE]

308455          at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:103) [spring-boot-2.1.13.RELEASE.jar:2.1.13.RELEASE]

308456          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308457          at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:121) [spring-boot-2.1.13.RELEASE.jar:2.1.13.RELEASE]

308458          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308459          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308460          at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308461          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308462          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.51]

308463          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.51]

308464          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [catalina.jar:8.5.51]

308465          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.51]

308466          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.51]

308467          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:8.5.51]

308468          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.51]

308469          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.51]

308470          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.51]

308471          at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:609) [tomcat-coyote.jar:8.5.51]

308472          at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.51]

308473          at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) [tomcat-coyote.jar:8.5.51]

308474          at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2041) [tomcat-coyote.jar:8.5.51]

308475          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_275]

308476          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_275]

308477          at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.51]

308478          at java.lang.Thread.run(Thread.java:748) [na:1.8.0_275]

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

308480  ### Error querying database.  Cause: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))]; SQL state [null]; error code [0]; connection closed; nested exception is java.sql.SQLException: connection closed

308481  ### The error may exist in file [/usr/local/tomcat/webapps/am-service/WEB-INF/classes/org/springblade/modules/system/mapper/DictMapper.xml]

308482  ### The error may involve org.springblade.modules.system.mapper.DictMapper.getList

308483  ### The error occurred while executing a query

308484  ### Cause: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))]; SQL state [null]; error code [0]; connection closed; nested exception is java.sql.SQLException: connection closed

308485          at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.4.jar:3.5.4]

308486          at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) ~[mybatis-3.5.4.jar:3.5.4]

308487          at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.4.jar:3.5.4]

308488          at sun.reflect.GeneratedMethodAccessor234.invoke(Unknown Source) ~[na:na]

308489          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_275]

308490          at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_275]

308491          at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.4.jar:2.0.4]

308492          ... 97 common frames omitted

308493  Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))]; SQL state [null]; error code [0]; connection closed; nested exception is java.sql.SQLException: connection closed

308494          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308495          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308496          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308497          at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308498          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308499          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308500          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308501          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308502          at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:763) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308503          at org.springblade.core.datascope.handler.BladeScopeModelHandler.getDataScopeByMapper(BladeScopeModelHandler.java:63) ~[blade-starter-datascope-2.5.1.RELEASE.jar:na]

308504          at org.springblade.core.datascope.handler.BladeDataScopeHandler.sqlCondition(BladeDataScopeHandler.java:51) ~[blade-starter-datascope-2.5.1.RELEASE.jar:na]

308505          at org.springblade.core.datascope.interceptor.DataScopeInterceptor.intercept(DataScopeInterceptor.java:114) ~[blade-starter-datascope-2.5.1.RELEASE.jar:na]

308506          at org.springblade.core.mp.plugins.QueryInterceptorExecutor.exec(QueryInterceptorExecutor.java:46) ~[blade-starter-mybatis-2.5.1.RELEASE.jar:na]

308507          at org.springblade.core.mp.plugins.BladePaginationInterceptor.intercept(BladePaginationInterceptor.java:48) ~[blade-starter-mybatis-2.5.1.RELEASE.jar:na]

308508          at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.4.jar:3.5.4]

308509          at com.sun.proxy.$Proxy310.prepare(Unknown Source) ~[na:na]

308510          at sun.reflect.GeneratedMethodAccessor192.invoke(Unknown Source) ~[na:na]

308511          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_275]

308512          at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_275]

308513          at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) ~[mybatis-3.5.4.jar:3.5.4]

308514          at com.sun.proxy.$Proxy310.prepare(Unknown Source) ~[na:na]

308515          at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:92) ~[mybatis-plus-core-3.3.2.jar:3.3.2]

308516          at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:66) ~[mybatis-plus-core-3.3.2.jar:3.3.2]

308517          at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.5.4.jar:3.5.4]

308518          at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.4.jar:3.5.4]

308519          at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:111) ~[pagehelper-5.2.0.jar:na]

308520          at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.4.jar:3.5.4]

308521          at com.sun.proxy.$Proxy309.query(Unknown Source) ~[na:na]

308522          at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.4.jar:3.5.4]

308523          ... 102 common frames omitted

308524  Caused by: java.sql.SQLException: connection closed

308525          at com.alibaba.druid.pool.DruidPooledConnection.checkStateInternal(DruidPooledConnection.java:1190) ~[druid-1.2.8.jar:1.2.8]

308526          at com.alibaba.druid.pool.DruidPooledConnection.checkState(DruidPooledConnection.java:1181) ~[druid-1.2.8.jar:1.2.8]

308527          at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:364) ~[druid-1.2.8.jar:1.2.8]

308528          at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1556) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308529          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:615) ~[spring-jdbc-5.1.14.RELEASE.jar:5.1.14.RELEASE]

308530          ... 126 common frames omitted

308531

308532

308533  ==============  Sql Start  ==============

308534  Execute ID  :org.springblade.modules.system.mapper.LogErrorMapper.insert

308535  Execute SQL :INSERT INTO blade_log_error (id, stack_trace, exception_name, message, file_name, line_number, service_id, server_ip, server_host, env, remote_ip, user_agent, request_uri, method, method_class, method_name, params, create_by, create_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

308536  Execute Time:1 ms

308537  ==============  Sql  End   ==============

308538

308539  2022-09-23 16:43:39.272  INFO 7 --- [pr-8080-exec-10] o.s.core.log.aspect.RequestLogAspect     : 

308540

308541  ================  Request Start  ================

308542  ===> GET: /am-service/blade-system/menu/buttons Parameters: {"user":{"clientId":"saber","userId":0,"account":"18990994121","userName":"","nickName":"","tenantId":"000000","oauthId":"","deptId":"-1","postId":"-1","roleId":"reward_deliver_yb,agent_door_yb,2019_dianxin,ybagent,new_sys_tel_prov,ybtranc_01,payobject_yb,2019_agent_0,cjlf,msscjhd1,ybhdjf,new_portal_agent_yibin,yb00705,new_sys_fzj_yb,yb.listcode_m,yb005,ybjht,yb_agent,yb003,yb004,ybgonggao,yb001,yb002","roleName":""}}

308543  ===Headers===  host: cooperation.paas.sc.ctc.com

308544  ===Headers===  connection: close

308545  ===Headers===  x-real-ip: 133.54.101.201

308546  ===Headers===  x-forwarded-for: 133.54.101.201

308547  ===Headers===  x-forwarded-proto: http

308548  ===Headers===  request-trace-id: 1eaa591a5b6e2b2a16ab0e4dda4bb8ab

308549  ===Headers===  accept: application/json, text/plain, */*

308550  ===Headers===  authorization: Basic c2FiZXI6c2FiZXJfc2VjcmV0

308551  ===Headers===  blade-auth: bearer eyJ0eXAiOiJKc29uV2ViVG9rZW4iLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJzeXNfdXNlci5vdXRsaW5rX2lkIjoiLTEiLCJzeXNfdXNlci51c2VyX2lkIjoieWIwMDcwNSIsInJvbGVfaWQiOiJyZXdhcmRfZGVsaXZlcl95YixhZ2VudF9kb29yX3liLDIwMTlfZGlhbnhpbix5YmFnZW50LG5ld19zeXNfdGVsX3Byb3YseWJ0cmFuY18wMSxwYXlvYmplY3RfeWIsMjAxOV9hZ2VudF8wLGNqbGYsbXNzY2poZDEseWJoZGpmLG5ld19wb3J0YWxfYWdlbnRfeWliaW4seWIwMDcwNSxuZXdfc3lzX2Z6al95Yix5Yi5saXN0Y29kZV9tLHliMDA1LHliamh0LHliX2FnZW50LHliMDAzLHliMDA0LHliZ29uZ2dhbyx5YjAwMSx5YjAwMiIsInBhcnR5X2lkIjoiMTAxOTE0MiIsInN5c191c2VyLmFyZWFfaWQiOiIxMTIwMCIsInN5c191c2VyLmxlYWRfdGFnIjoiMCIsInN5c191c2VyLmxhdG5faWQiOiIxMTIwMCIsInRva2VuX3R5cGUiOiJhY2Nlc3NfdG9rZW4iLCJhY2NvdW50IjoiMTg5OTA5OTQxMjEiLCJjbGllbnRfaWQiOiJzYWJlciIsImV4cCI6MTY2MzkyNjIxNywibmJmIjoxNjYzOTIyNjE3fQ.ADApmC_e6w_T5e6JJKO-zf_41IrJHSNMwiyPqexMiaM

308552  ===Headers===  user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4148.156 Safari/537.36

308553  ===Headers===  referer: http://cooperation.paas.sc.ctc.com/am/wel/index

308554  ===Headers===  accept-encoding: gzip, deflate

308555  ===Headers===  accept-language: zh-CN,zh;q=0.9

308556  ===Headers===  cookie: JSESSIONID=AC680C7ECAE0FDAE81AACF4530245A92; SYS_USER_ID=1ad64e0df4735afa0129be451427a919c27f2aa9b5d48147e22a70150a48587f; mssPortalPreLogin=0; MssSsoToken=eQDmPZffWi4188bZEtC5DDbyL4SLniG/Vxp/1nHY7PU=; JtSsoToken=hDmcFADm79I/n9x0qufwqqEtPHb4EU4t; saber-access-token=eyJ0eXAiOiJKc29uV2ViVG9rZW4iLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJzeXNfdXNlci5vdXRsaW5rX2lkIjoiLTEiLCJzeXNfdXNlci51c2VyX2lkIjoieWIwMDcwNSIsInJvbGVfaWQiOiJyZXdhcmRfZGVsaXZlcl95YixhZ2VudF9kb29yX3liLDIwMTlfZGlhbnhpbix5YmFnZW50LG5ld19zeXNfdGVsX3Byb3YseWJ0cmFuY18wMSxwYXlvYmplY3RfeWIsMjAxOV9hZ2VudF8wLGNqbGYsbXNzY2poZDEseWJoZGpmLG5ld19wb3J0YWxfYWdlbnRfeWliaW4seWIwMDcwNSxuZXdfc3lzX2Z6al95Yix5Yi5saXN0Y29kZV9tLHliMDA1LHliamh0LHliX2FnZW50LHliMDAzLHliMDA0LHliZ29uZ2dhbyx5YjAwMSx5YjAwMiIsInBhcnR5X2lkIjoiMTAxOTE0MiIsInN5c191c2VyLmFyZWFfaWQiOiIxMTIwMCIsInN5c191c2VyLmxlYWRfdGFnIjoiMCIsInN5c191c2VyLmxhdG5faWQiOiIxMTIwMCIsInRva2VuX3R5cGUiOiJhY2Nlc3NfdG9rZW4iLCJhY2NvdW50IjoiMTg5OTA5OTQxMjEiLCJjbGllbnRfaWQiOiJzYWJlciIsImV4cCI6MTY2MzkyNjIxNywibmJmIjoxNjYzOTIyNjE3fQ.ADApmC_e6w_T5e6JJKO-zf_41IrJHSNMwiyPqexMiaM; saber-refresh-token=eyJ0eXAiOiJKc29uV2ViVG9rZW4iLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ1c2VyX2lkIjoiMTAxOTE0MiIsInRva2VuX3R5cGUiOiJyZWZyZXNoX3Rva2VuIiwiY2xpZW50X2lkIjoic2FiZXIiLCJleHAiOjE2NjQ1Mjc0MTcsIm5iZiI6MTY2MzkyMjYxN30.Chw6tHtN3bpsc2EhwojN96onvh5kQCJS9Xe9QvlpSfI

308557  ================   Request End   ================

308558

308559

308560  ==============  Sql Start  ==============

308561  Execute ID  :com.td.ai.frame.modules.orgmanagement.mapper.AuditManageMapper.selectLists_COUNT

308562  Execute SQL :SELECT count(0) FROM dlmh.agt_audit t LEFT JOIN dlmh.agt_area ar ON ar.a_id = t.area_id LEFT JOIN dlmh.agt_audit_org org ON org.org_id = t.org_id LEFT JOIN dlmhcfg.unify_organization_am oa ON t.oa_org_id = oa.org_id LEFT JOIN dlmh.agt_audit_hall_type aaht ON aaht.id = t.hall_type LEFT JOIN dlmh.agt_agent aa ON aa.agent_id = t.agent_id WHERE 1 = 1 AND T.LATN_ID = ? AND T.NAME LIKE concat('%', ?::varchar, '%')

308563  Execute Time:8 ms

308564  ==============  Sql  End   ==============

308565

308566

308567  ==============  Sql Start  ==============

308568  Execute ID  :com.td.ai.frame.modules.orgmanagement.mapper.AuditManageMapper.selectLists

308569  Execute SQL :select t.audit_id, t.latn_id, t.area_id, ar.a_name areaName, t.audit_code, t.name, t.org_id, org.name orgName, t.oa_org_id, oa.org_name oaOrgName, t.hall_type, aaht.name hallTypeName, aaht.type, t.agent_id, aa.name agentName, t.initaudit_date, t.currentaudit_date, t.init_mantissa, t.audit_method, case when t.audit_method = '1'then '自动' when t.audit_method = '2' then '手动' else '未定义' end auditMethodName, t.duty_phone, t.duty_username, t.audit_period, t.enable, case when t.enable = 1 then '启用' else '禁用' end enableName, t.autocup_flag, case when t.autocup_flag = 1 then '是' else '否' end autocupFlagName, t.autocup_amount, t.is_prepay, case when t.is_prepay = '1' then '是' else '否' end isPrepayName, t.warning_mantissa, t.is_run_mantissa, t.remark, t.creator, t.create_time, t.modify_time, t.status, case when t.status = 1 then '正常' when t.status = 2 then '停用' when t.status = 3 then '暂停' end statusName, t.busi_status, case when t.busi_status = 1 then '' when t.busi_status = 2 then '低额提醒充值' when t.busi_status = 3 then '业务无法办理' end busiStatusName from dlmh.agt_audit t left join dlmh.agt_area ar on ar.a_id = t.area_id left join dlmh.agt_audit_org org on org.org_id = t.org_id left join dlmhcfg.unify_organization_am oa on t.oa_org_id = oa.org_id left join dlmh.agt_audit_hall_type aaht on aaht.id = t.hall_type left join dlmh.agt_agent aa on aa.agent_id = t.agent_id where 1=1 and T.LATN_ID =? AND T.NAME LIKE concat('%', ?::varchar, '%') order by t.create_time desc LIMIT ? 

五、若有更多详细信息,请在下面提供。




2条回答
  • 2022-09-26 17:07

    这个没有前因后果,很难帮忙排查。2.5版本是两年前发布的了,你们的项目是刚刚才做完部署发现的么?还是之前从来没有过问题,最近才出现的么?


    你们有没有用过多数据源或者说用过sharding-sphere,会有这种情况出现,可以看这个帖子:https://blog.csdn.net/zhuwei_clark/article/details/105554740


    还有就是需要去看一下服务器的内存和cpu占用情况,如果占用过多也会有这种情况出现。

    最后我们推荐还是用原生打包成jar的形式来部署试试,tomcat尤其是第三方平台的部署并没有jar那么省心

    0 讨论(0)
  • 2022-09-26 18:17

    是去年低开发的项目,前期由于项目发版多,没太出现这个问题,也没关注,后来平稳后,长期不重启就出现了这个问题,影响功能使用

    0 讨论(0)
提交回复