Meaning Kylin should be more robust on error cases. Let me see what can be done...
On Sat, May 27, 2017 at 2:19 PM, jianhui.yi <jianhui...@zhiyoubao.com> wrote: > Kylin version is 2.0 on cdh5.7 ,no other stack trace. > > I used metastore reset to fix it, then rebuild model and cube. > > May be caused by a previous metadata error. > > Thanks > > > > *发件人:* Li Yang [mailto:liy...@apache.org] > *发送时间:* 2017年5月27日 14:09 > *收件人:* user@kylin.apache.org > *主题:* Re: Any query returns error 'null' > > > > What's your Kylin version? Cannot analyze the stack trace without it. > > > > On Thu, May 25, 2017 at 11:04 AM, jianhui.yi <jianhui...@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! > > > > >