smartbix.SmartbiXException: SQL错误 -> Query execution was interrupted, maximum statement execution time exceeded
at smartbix.SmartbiXException.create(SmartbiXException.java:68)
at smartbix.GridDataUtil$2.hasNext(GridDataUtil.java:605)
at smartbix.CacheDataIterator.(CacheDataIterator.java:107)
at smartbix.CacheDataIterator.wrap(CacheDataIterator.java:30)
at smartbix.augmenteddataset.bo.AugmentedSQLExecutor.lambda$execute$7(AugmentedSQLExecutor.java:180)
at smartbi.cachemanager.ehcache.EhCacheCacheManager.get(EhCacheCacheManager.java:52)
at smartbi.cachemanager.CommonCacheService.get(CommonCacheService.java:59)
at smartbix.augmenteddataset.bo.AugmentedSQLExecutor.execute(AugmentedSQLExecutor.java:191)
at smartbix.augmenteddataset.smartcube.IntegrationExecutorSvcImpl.executeSQL(IntegrationExecutorSvcImpl.java:717)
at smartbix.augmenteddataset.smartcube.IntegrationExecutorSvcImpl.executeIteratorSql(IntegrationExecutorSvcImpl.java:553)
at smartbix.smartcube.integration.IntegrationExecutorManager$.executeIteratorSql(IntegrationExecutorManager.scala:56)
at smartbix.smartcube.queryengine.engine.SQLExecutor._executeSQL(QueryExecutor.scala:211)
at smartbix.smartcube.queryengine.engine.SQLExecutor.getData$1(QueryExecutor.scala:162)
at smartbix.smartcube.queryengine.engine.SQLExecutor._execute(QueryExecutor.scala:196)
at smartbix.smartcube.queryengine.engine.SQLExecutor.execute(QueryExecutor.scala:123)
at smartbix.smartcube.queryengine.engine.QueryExecutor$.execute(QueryExecutor.scala:39)
at smartbix.smartcube.queryengine.CubeQueryService$.queryData(QueryService.scala:53)
at smartbix.smartcube.gateway.report.ReportQueryService$.queryData(ReportQueryService.scala:51)
at smartbix.smartcube.gateway.report.ReportQueryService.queryData(ReportQueryService.scala)
at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.lambda$executeForSmartCubeByDataset$3(AugmentedDataSetQueryServiceAdapter.java:310)
at smartbi.monitor.MetricHelper$.withSpan(MetricHelper.scala:148)
at smartbi.monitor.MetricHelper.withSpan(MetricHelper.scala)
at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.executeForSmartCubeByDataset(AugmentedDataSetQueryServiceAdapter.java:301)
at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.executeForSmartCube(AugmentedDataSetQueryServiceAdapter.java:290)
at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.getDataIterator(AugmentedDataSetQueryServiceAdapter.java:194)
at smartbix.augmenteddataset.service.AugmentedDataSetQueryServiceAdapter.execute(AugmentedDataSetQueryServiceAdapter.java:173)
at smartbix.augmenteddataset.service.SmartbiXAugmentedDataSet.execute(SmartbiXAugmentedDataSet.java:163)
at smartbix.service.ProviderService.executeQuery(ProviderService.java:164)
at smartbix.dataset.service.QueryService.executeQuery(QueryService.java:34)
at smartbix.dataset.service.QueryService$$FastClassBySpringCGLIB$$611408c2.invoke()
at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)
at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at smartbixlibs.org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:49)
at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)
at smartbix.dataset.service.QueryService$$EnhancerBySpringCGLIB$$8bf6421c.executeQuery()
at smartbix.analysisquery.service.AbstractPortletExecutor.refresh(AbstractPortletExecutor.java:75)
at smartbix.analysis.detailedquery.service.DetailedQueryService.getData(DetailedQueryService.java:236)
at smartbix.analysis.detailedquery.service.DetailedQueryService$$FastClassBySpringCGLIB$$711f4978.invoke()
at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)
at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)
at smartbix.analysis.detailedquery.service.DetailedQueryService$$EnhancerBySpringCGLIB$$ebdfec39.getData()
at smartbix.analysis.detailedquery.controller.DetailedQueryController.queryData(DetailedQueryController.java:235)
at sun.reflect.GeneratedMethodAccessor5389.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at smartbixlibs.org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at smartbixlibs.org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at smartbixlibs.org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at smartbixlibs.org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:903)
at smartbixlibs.org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:809)
at smartbixlibs.org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at smartbixlibs.org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)
at smartbixlibs.org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
at smartbixlibs.org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at smartbixlibs.org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
at smartbixlibs.org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbix.smartbi.filter.SmartbiXTraceFilter.doFilter(SmartbiXTraceFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbixlibs.org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:94)
at smartbixlibs.org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:250)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:277)
at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:277)
at smartbi.aichat.AIChatFilter.doFilter(AIChatFilter.java:56)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:277)
at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:280)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:128)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:92)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.LogFilter.doFilter(LogFilter.java:112)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.freequery.filter.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at smartbi.framework.SmartbiApplicationFilter.executeFilterChain(SmartbiApplicationFilter.java:117)
at smartbi.framework.SmartbiApplicationFilter.doFilter(SmartbiApplicationFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:383)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.lang.Thread.run(Thread.java:750)
Caused by: java.sql.SQLException: Query execution was interrupted, maximum statement execution time exceeded
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1992)
at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:366)
at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic.java:346)
at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6303)
at com.zaxxer.hikari.pool.HikariProxyResultSet.next(HikariProxyResultSet.java)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
at smartbix.GridDataUtil$2.hasNext(GridDataUtil.java:602)
... 127 more
