重现步骤




2024-02-27 14:59:48.576 [db-starrocks housekeeper] WARN  com.zaxxer.hikari.pool.ProxyLeakTask - [TID: N/A] - Connection leak detection triggered for com.mysql.cj.jdbc.ha.FailoverConnectionProxy@4dd320e7 on thread http-nio-9110-exec-4, stack trace follows
java.lang.Exception: Apparent connection leak detected
        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
        at com.baomidou.dynamic.datasource.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:42)
        at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
        at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
        at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
        at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
        at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
        at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
        at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
        at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
        at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)
        at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
        at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)
        at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
        at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
        at jdk.internal.reflect.GeneratedMethodAccessor1244.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
        at jdk.proxy2/jdk.proxy2.$Proxy253.insert(Unknown Source)
        at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
        at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59)
        at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
        at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
        at jdk.proxy2/jdk.proxy2.$Proxy254.batchInsert(Unknown Source)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
        at jdk.proxy2/jdk.proxy2.$Proxy255.batchInsert(Unknown Source)
        at com.zhcxkj.center.bi.infrastructure.gateway.impl.performance.AmzProductPerformanceGateway.batchInsert(AmzProductPerformanceGateway.java:109)
        at com.zhcxkj.center.bi.domain.service.performance.AmzProductPerformanceDomainService.batchInsert(AmzProductPerformanceDomainService.java:64)
        at com.zhcxkj.center.bi.application.executor.performance.AddAmzProductPerformanceCmdExe.executor(AddAmzProductPerformanceCmdExe.java:53)
        at com.zhcxkj.center.bi.application.service.performance.ProductPerformanceApplicationService.insertProductPerformance(ProductPerformanceApplicationService.java:99)
        at com.zhcxkj.center.bi.adapter.controller.performance.AmzProductPerformanceController.insertProductPerformance(AmzProductPerformanceController.java:92)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1070)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
        at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.base/java.lang.Thread.run(Thread.java:833)

历史记录  
  1. 2024-02-27 15:02:27, 由 夏秋生 创建。
  2. 2024-02-27 15:04:45, 由 覃光贤 解决,方案为 服务器原因 。
    修改了 解决方案,旧值为 "",新值为 "server"。
    修改了 解决版本,旧值为 "",新值为 "586"。
    修改了 解决日期,旧值为 "",新值为 "2024-02-27 15:04:14"。
    修改了 指派给 ,旧值为 "qinguangxian",新值为 "wangjiping"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "qinguangxian"。
    数据库问题,不知道什么原因
  3. 2024-02-27 16:39:42, 由 王极平 指派给 李冠。
    修改了 指派给,旧值为 "wangjiping",新值为 "liguan"。

    数据源改成hikari之后会出现这个问题


    参考资料

    https://docs.openkm.com/kcenter/view/okmkb/warning-in-update-or-creation-stage-javalangexception-apparent-connection-leak-detected.html

  4. 2024-02-27 16:43:36, 由 李冠 指派给 王极平。
    修改了 指派给,旧值为 "liguan",新值为 "wangjiping"。
    看一下慢SQL
  5. 2024-02-27 18:28:20, 由 王极平 指派给 夏秋生。
    修改了 指派给,旧值为 "wangjiping",新值为 "xiaqiusheng"。
    关闭
  6. 2024-02-27 18:28:42, 由 夏秋生 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "xiaqiusheng",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "xiaqiusheng"。
    修改了 关闭日期,旧值为 "",新值为 "2024-02-27 18:28:42"。
  7. 2024-02-28 16:17:33, 由 覃光贤 编辑。
    修改了 解决者 ,旧值为 "qinguangxian",新值为 "wangjiping"。
    修改了 重现步骤,区别为:
    005- 2024-02-27 14:59:48.576 [db-starrocks housekeeper] WARN com.zaxxer.hikari.pool.ProxyLeakTask - [TID: N/A] - Connection leak detection triggered for com.mysql.cj.jdbc.ha.FailoverConnectionProxy@4dd320e7 on thread http-nio-9110-exec-4, stack trace followsjava.lang.Exception: Apparent connection leak detected at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100) at com.baomidou.dynamic.datasource.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:42) at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source) at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source) at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) at jdk.internal.reflect.GeneratedMethodAccessor1244.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) at jdk.proxy2/jdk.proxy2.$Proxy253.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at jdk.proxy2/jdk.proxy2.$Proxy254.batchInsert(Unknown Source) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) at jdk.proxy2/jdk.proxy2.$Proxy255.batchInsert(Unknown Source) at com.zhcxkj.center.bi.infrastructure.gateway.impl.performance.AmzProductPerformanceGateway.batchInsert(AmzProductPerformanceGateway.java:109) at com.zhcxkj.center.bi.domain.service.performance.AmzProductPerformanceDomainService.batchInsert(AmzProductPerformanceDomainService.java:64) at com.zhcxkj.center.bi.application.executor.performance.AddAmzProductPerformanceCmdExe.executor(AddAmzProductPerformanceCmdExe.java:53) at com.zhcxkj.center.bi.application.service.performance.ProductPerformanceApplicationService.insertProductPerformance(ProductPerformanceApplicationService.java:99) at com.zhcxkj.center.bi.adapter.controller.performance.AmzProductPerformanceController.insertProductPerformance(AmzProductPerformanceController.java:92) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1070) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:833)
    005+ 2024-02-27 14:59:48.576 [db-starrocks housekeeper] WARN com.zaxxer.hikari.pool.ProxyLeakTask - [TID: N/A] - Connection leak detection triggered for com.mysql.cj.jdbc.ha.FailoverConnectionProxy@4dd320e7 on thread http-nio-9110-exec-4, stack trace followsjava.lang.Exception: Apparent connection leak detected at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100) at com.baomidou.dynamic.datasource.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:42) at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source) at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source) at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) at jdk.internal.reflect.GeneratedMethodAccessor1244.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) at jdk.proxy2/jdk.proxy2.$Proxy253.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at jdk.proxy2/jdk.proxy2.$Proxy254.batchInsert(Unknown Source) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) at jdk.proxy2/jdk.proxy2.$Proxy255.batchInsert(Unknown Source) at com.zhcxkj.center.bi.infrastructure.gateway.impl.performance.AmzProductPerformanceGateway.batchInsert(AmzProductPerformanceGateway.java:109) at com.zhcxkj.center.bi.domain.service.performance.AmzProductPerformanceDomainService.batchInsert(AmzProductPerformanceDomainService.java:64) at com.zhcxkj.center.bi.application.executor.performance.AddAmzProductPerformanceCmdExe.executor(AddAmzProductPerformanceCmdExe.java:53) at com.zhcxkj.center.bi.application.service.performance.ProductPerformanceApplicationService.insertProductPerformance(ProductPerformanceApplicationService.java:99) at com.zhcxkj.center.bi.adapter.controller.performance.AmzProductPerformanceController.insertProductPerformance(AmzProductPerformanceController.java:92) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1070) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:833)
    005- <p>2024-02-27 14:59:48.576 [db-starrocks housekeeper] WARN com.zaxxer.hikari.pool.ProxyLeakTask - [TID: N/A] - Connection leak detection triggered for com.mysql.cj.jdbc.ha.FailoverConnectionProxy@4dd320e7 on thread http-nio-9110-exec-4, stack trace follows<br />java.lang.Exception: Apparent connection leak detected<br /> at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)<br /> at com.baomidou.dynamic.datasource.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:42)<br /> at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)<br /> at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)<br /> at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)<br /> at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)<br /> at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)<br /> at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)<br /> at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)<br /> at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)<br /> at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)<br /> at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)<br /> at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)<br /> at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)<br /> at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)<br /> at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)<br /> at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)<br /> at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)<br /> at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)<br /> at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)<br /> at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)<br /> at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)<br /> at jdk.internal.reflect.GeneratedMethodAccessor1244.invoke(Unknown Source)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)<br /> at jdk.proxy2/jdk.proxy2.$Proxy253.insert(Unknown Source)<br /> at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)<br /> at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59)<br /> at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)<br /> at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)<br /> at jdk.proxy2/jdk.proxy2.$Proxy254.batchInsert(Unknown Source)<br /> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)<br /> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)<br /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)<br /> at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)<br /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)<br /> at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)<br /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)<br /> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)<br /> at jdk.proxy2/jdk.proxy2.$Proxy255.batchInsert(Unknown Source)<br /> at com.zhcxkj.center.bi.infrastructure.gateway.impl.performance.AmzProductPerformanceGateway.batchInsert(AmzProductPerformanceGateway.java:109)<br /> at com.zhcxkj.center.bi.domain.service.performance.AmzProductPerformanceDomainService.batchInsert(AmzProductPerformanceDomainService.java:64)<br /> at com.zhcxkj.center.bi.application.executor.performance.AddAmzProductPerformanceCmdExe.executor(AddAmzProductPerformanceCmdExe.java:53)<br /> at com.zhcxkj.center.bi.application.service.performance.ProductPerformanceApplicationService.insertProductPerformance(ProductPerformanceApplicationService.java:99)<br /> at com.zhcxkj.center.bi.adapter.controller.performance.AmzProductPerformanceController.insertProductPerformance(AmzProductPerformanceController.java:92)<br /> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)<br /> at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)<br /> at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)<br /> at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)<br /> at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)<br /> at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)<br /> at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1070)<br /> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)<br /> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)<br /> at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)<br /> at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)<br /> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)<br /> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)<br /> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)<br /> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)<br /> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)<br /> at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)<br /> at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)<br /> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)<br /> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)<br /> at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)<br /> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)<br /> at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)<br /> at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)<br /> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)<br /> at java.base/java.lang.Thread.run(Thread.java:833)<br /></p>
    005+ <p>2024-02-27 14:59:48.576 [db-starrocks housekeeper] WARN com.zaxxer.hikari.pool.ProxyLeakTask - [TID: N/A] - Connection leak detection triggered for com.mysql.cj.jdbc.ha.FailoverConnectionProxy@4dd320e7 on thread http-nio-9110-exec-4, stack trace follows<br />java.lang.Exception: Apparent connection leak detected<br /> at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)<br /> at com.baomidou.dynamic.datasource.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:42)<br /> at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)<br /> at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)<br /> at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)<br /> at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)<br /> at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)<br /> at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)<br /> at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)<br /> at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)<br /> at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)<br /> at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)<br /> at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)<br /> at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)<br /> at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)<br /> at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)<br /> at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)<br /> at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)<br /> at jdk.internal.reflect.GeneratedMethodAccessor221.invoke(Unknown Source)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)<br /> at jdk.proxy2/jdk.proxy2.$Proxy441.update(Unknown Source)<br /> at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)<br /> at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)<br /> at jdk.internal.reflect.GeneratedMethodAccessor1244.invoke(Unknown Source)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)<br /> at jdk.proxy2/jdk.proxy2.$Proxy253.insert(Unknown Source)<br /> at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)<br /> at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59)<br /> at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)<br /> at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)<br /> at jdk.proxy2/jdk.proxy2.$Proxy254.batchInsert(Unknown Source)<br /> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)<br /> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)<br /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)<br /> at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)<br /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)<br /> at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)<br /> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)<br /> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)<br /> at jdk.proxy2/jdk.proxy2.$Proxy255.batchInsert(Unknown Source)<br /> at com.zhcxkj.center.bi.infrastructure.gateway.impl.performance.AmzProductPerformanceGateway.batchInsert(AmzProductPerformanceGateway.java:109)<br /> at com.zhcxkj.center.bi.domain.service.performance.AmzProductPerformanceDomainService.batchInsert(AmzProductPerformanceDomainService.java:64)<br /> at com.zhcxkj.center.bi.application.executor.performance.AddAmzProductPerformanceCmdExe.executor(AddAmzProductPerformanceCmdExe.java:53)<br /> at com.zhcxkj.center.bi.application.service.performance.ProductPerformanceApplicationService.insertProductPerformance(ProductPerformanceApplicationService.java:99)<br /> at com.zhcxkj.center.bi.adapter.controller.performance.AmzProductPerformanceController.insertProductPerformance(AmzProductPerformanceController.java:92)<br /> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)<br /> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.base/java.lang.reflect.Method.invoke(Method.java:568)<br /> at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)<br /> at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)<br /> at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)<br /> at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)<br /> at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)<br /> at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)<br /> at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1070)<br /> at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)<br /> at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)<br /> at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)<br /> at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)<br /> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)<br /> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)<br /> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)<br /> at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)<br /> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)<br /> at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:769)<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)<br /> at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)<br /> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)<br /> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)<br /> at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)<br /> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)<br /> at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)<br /> at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)<br /> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)<br /> at java.base/java.lang.Thread.run(Thread.java:833)</p>
所属项目 技术中心-需求池
所属模块 /
所属计划
所属迭代 亚马逊产品线 - 虎鲸BI - 迭代32
Bug类型
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2024-02-28 16:17:33
截止日期 0000-00-00
上线时间 0000-00-00 00:00:00
上线时效 25
操作系统
浏览器
关键词
抄送给
所属迭代 亚马逊产品线 - 虎鲸BI - 迭代32
相关需求
相关任务
由谁创建 夏秋生 于 2024-02-27 15:02:26
影响环境 测试环境-测试反馈
由谁解决 王极平 于 2024-02-27 15:04:14
解决版本 虎鲸V2.0.3
解决方案 服务器原因
由谁关闭 夏秋生 于 2024-02-27 18:28:42
最后修改 覃光贤 于 2024-02-28 16:17:33
相关Bug