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

Blade 未结

关注举报

 2  997

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.5版本是两年前发布的了，你们的项目是刚刚才做完部署发现的么？还是之前从来没有过问题，最近才出现的么？

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

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

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

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

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

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