kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: Any query returns error 'null'
Date Sat, 27 May 2017 06:08:54 GMT
What's your Kylin version? Cannot analyze the stack trace without it.

On Thu, May 25, 2017 at 11:04 AM, jianhui.yi <jianhui.yi@zhiyoubao.com>
wrote:

> Hi all:
>
> My kylin cube is ready, But I run any queries that report the following
> errors´╝îWhen I restart kylin service will be normal, after a period of
> time there will be such a mistake
>
>
>
> 2017-05-25 10:27:41,440 INFO  [Query a00e9afa-b676-4932-a67b-61f9cb91543e-51505]
> service.QueryService:286 :
>
> ==========================[QUERY]===============================
>
> Query Id: a00e9afa-b676-4932-a67b-61f9cb91543e
>
> SQL: SELECT count(*) from FACT_ORDER_DETAIL d
>
> User: ADMIN
>
> Success: false
>
> Duration: 0.0
>
> Project: dw_fs
>
> Realization Names: []
>
> Cuboid Ids: []
>
> Total scan count: 0
>
> Total scan bytes: 0
>
> Result row count: 0
>
> Accept Partial: false
>
> Is Partial Result: false
>
> Hit Exception Cache: false
>
> Storage cache used: false
>
> Message: Error while executing SQL "SELECT count(*) from FACT_ORDER_DETAIL
> d": null
>
> ==========================[QUERY]===============================
>
>
>
> 2017-05-25 10:27:41,441 ERROR [http-bio-7070-exec-134]
> controller.BasicController:54 :
>
> org.apache.kylin.rest.exception.InternalErrorException: Error while
> executing SQL "SELECT count(*) from FACT_ORDER_DETAIL d": null
>
>         at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:400)
>
>         at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
>
>         at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
>
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>
>         at java.lang.reflect.Method.invoke(Method.java:606)
>
>         at org.springframework.web.method.support.InvocableHandlerMethod.
> doInvoke(InvocableHandlerMethod.java:221)
>
>         at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
>
>         at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
>
>         at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
>
>         at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
>
>         at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
>
>         at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
>
>         at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
>
>         at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:951)
>
>         at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
>
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
>
>         at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
>
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
>
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:303)
>
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>
>         at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> WsFilter.java:52)
>
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
>
>         at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>
>         at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.access.
> ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.session.
> SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.savedrequest.
> RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.context.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.java:87)
>
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>
>         at org.springframework.security.web.FilterChainProxy.
> doFilterInternal(FilterChainProxy.java:192)
>
>         at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
>
>         at org.springframework.web.filter.DelegatingFilterProxy.
> invokeDelegate(DelegatingFilterProxy.java:343)
>
>         at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
>
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:209)
>
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:244)
>
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>
>         at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
>
>         at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
>
>         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
>
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
>
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
>
>         at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
>
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
>
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
>
>         at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
>
>         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
>
>         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
>
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1145)
>
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:615)
>
>         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
>
>         at java.lang.Thread.run(Thread.java:745)
>
>
>
>
>
>
>
> I tried to check the kylin metadata, the following problems, but I have
> deleted that model
>
>
>
> 2017-05-25 10:29:18,045 ERROR [main MetadataManager:538]: Error to load
> DataModel at /model_desc/M_V_SCENIC.json
>
> java.lang.IllegalStateException: Error to load /model_desc/M_V_SCENIC.json
>
>        at org.apache.kylin.metadata.MetadataManager.reloadDataModelDescAt(
> MetadataManager.java:558)
>
>        at org.apache.kylin.metadata.MetadataManager.reloadAllDataModel(
> MetadataManager.java:536)
>
>        at org.apache.kylin.metadata.MetadataManager.init(
> MetadataManager.java:284)
>
>        at org.apache.kylin.metadata.MetadataManager.<init>(
> MetadataManager.java:113)
>
>        at org.apache.kylin.metadata.MetadataManager.getInstance(
> MetadataManager.java:83)
>
>        at org.apache.kylin.cube.model.CubeDesc.init(CubeDesc.java:556)
>
>        at org.apache.kylin.cube.CubeDescManager.loadCubeDesc(
> CubeDescManager.java:188)
>
>        at org.apache.kylin.cube.CubeDescManager.reloadAllCubeDesc(
> CubeDescManager.java:305)
>
>        at org.apache.kylin.cube.CubeDescManager.<init>(
> CubeDescManager.java:109)
>
>        at org.apache.kylin.cube.CubeDescManager.getInstance(
> CubeDescManager.java:81)
>
>        at org.apache.kylin.cube.CubeManager.reloadCubeLocalAt(
> CubeManager.java:762)
>
>        at org.apache.kylin.cube.CubeManager.loadAllCubeInstance(
> CubeManager.java:740)
>
>        at org.apache.kylin.cube.CubeManager.<init>(CubeManager.java:143)
>
>        at org.apache.kylin.cube.CubeManager.getInstance(
> CubeManager.java:107)
>
>        at org.apache.kylin.tool.MetadataCleanupJob.cleanup(
> MetadataCleanupJob.java:97)
>
>        at org.apache.kylin.tool.MetadataCleanupJob.run(
> MetadataCleanupJob.java:79)
>
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
>
>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84)
>
>        at org.apache.kylin.tool.MetadataCleanupJob.main(
> MetadataCleanupJob.java:177)
>
> Caused by: java.lang.IllegalArgumentException: Column not found by
> V_SCENIC_CATEGORY_ORDER.CALENDAR_DATE
>
>        at org.apache.kylin.metadata.model.DataModelDesc.
> findColumn(DataModelDesc.java:240)
>
>        at org.apache.kylin.metadata.model.ModelDimensionDesc.init(
> ModelDimensionDesc.java:66)
>
>        at org.apache.kylin.metadata.model.DataModelDesc.
> initDimensionsAndMetrics(DataModelDesc.java:381)
>
>        at org.apache.kylin.metadata.model.DataModelDesc.init(
> DataModelDesc.java:302)
>
>        at org.apache.kylin.metadata.MetadataManager.reloadDataModelDescAt(
> MetadataManager.java:554)
>
>        ... 18 more
>
>
>
> Thanks!
>
>
>

Mime
View raw message