麦粉社区
>
帖子详情

ETL运行 提示等待队列已满,请稍后再试! 这个麦友有遇到过吗....

数据准备 发表于 2023-11-16 11:10
发表于 2023-11-16 11:10:39
本帖最后由 小马哥 于 2023-11-17 09:26 编辑

问题分两个阶段,


第一个阶段,服务器迁移,关机再开机,过两天发现ETL运行失败,提示ETL运行 提示等待队列已满,请稍后再试!(已解决)


 



 


第二个阶段 ETL可运行了,但是前端页面显示一直运行中;



查看日志报未知错误


Http status code:406
Http response:{"message":"未知错误 -> Request method 'PUT' not supported","type":"smartbix.SmartbiXException","code":null,"stackTrace":"smartbix.SmartbiXException: 未知错误 -> Request method 'PUT' not supported\n\tat smartbix.SmartbiXException.create(SmartbiXException.java:64)\n\tat smartbix.ExceptionResult.(ExceptionResult.java:60)\n\tat smartbix.spring.SmartbiXExceptionHandler.handleInvalidRequest(SmartbiXExceptionHandler.java:50)\n\tat sun.reflect.GeneratedMethodAccessor1708.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat smartbixlibs.org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\n\tat smartbixlibs.org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\n\tat smartbixlibs.org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\n\tat smartbixlibs.org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(ExceptionHandlerExceptionResolver.java:385)\n\tat smartbixlibs.org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException(AbstractHandlerMethodExceptionResolver.java:59)\n\tat smartbixlibs.org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException(AbstractHandlerExceptionResolver.java:131)\n\tat smartbixlibs.org.springframework.web.servlet.DispatcherServlet.processHandlerException(DispatcherServlet.java:1222)\n\tat smartbixlibs.org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1034)\n\tat smartbixlibs.org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:984)\n\tat smartbixlibs.org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)\n\tat smartbixlibs.org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\n\tat smartbixlibs.org.springframework.web.servlet.FrameworkServlet.doPut(FrameworkServlet.java:883)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:655)\n\tat smartbixlibs.org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:733)\n\tat smartbi.extension.Extension.processMatchServlet(Extension.java:619)\n\tat smartbi.extension.ExtensionFilter.processInternal(ExtensionFilter.java:247)\n\tat smartbi.extension.ExtensionFilter.access$000(ExtensionFilter.java:47)\n\tat smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:184)\n\tat smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)\n\tat smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)\n\tat smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)\n\tat smartbix.smartbi.filter.SmartbiXTraceFilter.doFilter(SmartbiXTraceFilter.java:46)\n\tat smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)\n\tat smartbixlibs.org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)\n\tat smartbixlibs.org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\n\tat smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)\n\tat smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)\n\tat smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)\n\tat smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:205)\n\tat smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:83)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:82)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat smartbi.framework.RedisSessionFilter.doFilter(Smartbi:137)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)\n\tat org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\n\tat org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:353)\n\tat org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616)\n\tat org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)\n\tat org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)\n\tat org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1629)\n\tat org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\n\tat org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: smartbixlibs.org.springframework.web.HttpRequestMethodNotSupportedException: Request method 'PUT' not supported\n\tat smartbixlibs.org.springframework.web.servlet.mvc.method.RequestMappingInfoHandlerMapping.handleNoMatch(RequestMappingInfoHandlerMapping.java:205)\n\tat smartbixlibs.org.springframework.web.servlet.handler.AbstractHandlerMethodMapping.lookupHandlerMethod(AbstractHandlerMethodMapping.java:375)\n\tat smartbixlibs.org.springframework.web.servlet.handler.AbstractHandlerMethodMapping.getHandlerInternal(AbstractHandlerMethodMapping.java:314)\n\tat smartbixlibs.org.springframework.web.servlet.handler.AbstractHandlerMethodMapping.getHandlerInternal(AbstractHandlerMethodMapping.java:61)\n\tat smartbixlibs.org.springframework.web.servlet.handler.AbstractHandlerMapping.getHandler(AbstractHandlerMapping.java:353)\n\tat smartbixlibs.org.springframework.web.servlet.DispatcherServlet.getHandler(DispatcherServlet.java:1160)\n\tat smartbixlibs.org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:940)\n\t... 47 more\n"}
2023-11-17 08:58:06.530 [988] INFO flow.DistributionFlow.finish:195 - Flow finished,(id:I4028488b018bd792d7920900018bd79ac76a0003,name:ceas啊)
2023-11-17 08:58:06.530 [988] INFO node.GenericNode.finish:198 - Node finished, took 0.405 s.(id:9f95d69dfc426b2e78c47ab84c59267e,name:JDBC_DATASOURCE)
发表于 2023-11-16 11:10:54
这个怎么解决呢
回复

使用道具 举报

发表于 2023-11-16 11:22:34
看这里呀 调度满了就会有这个提示,等有空了就可以执行了
9240565558ac640805.png
  •   小马哥
    我的版本是
    Build: 2022-04-22 18:07:47
    Version:9.7.72810.22175
    TAG:Hotfix_SmartbiV97_20220420
    
    V9.7  没有这个功能。我现在是要停也没地方停
    2023-11-16 11:31| 回复
  •   小马哥
    因为机房迁移服务器中途断电,服务器开启之后以为会正常运行,过两天发现数据不对,才发现出现这个提示
    SQL数据集抽取数据的话是正常的,ETL这个提示。
    2023-11-16 11:39| 回复
  •   小马哥
    因为机房迁移服务器中途断电,服务器开启之后以为会正常运行,过两天发现数据不对,才发现出现这个提示
    SQL数据集抽取数据的话是正常的,ETL这个提示。
    2023-11-16 11:40| 回复
  •   窝瓜大战猕猴桃
     回复 小马哥
    我看wikiV97新版本应该也是有这个功能的,但是22年的版本就不知道了
    数挖引擎和BI没有部署在伊泰机器上吗,有可能断电的时候导致数挖引擎和BI的内容没有同步,要不同时重启看看
    2023-11-16 11:49| 回复
  •   小马哥
     回复 窝瓜大战猕猴桃
    没有呢  现在通过系统监控——实验监控,可以看到排队实验,这个排队怎么清空掉,就是这个队列满了
    2023-11-16 13:13| 回复
  • 还有6条回复,点击查看

回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

13回帖数 0关注人数 589浏览人数
最后回复于:2023-11-16 11:22
快速回复 返回顶部 返回列表