You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "apache_dev@163.com" <ap...@163.com> on 2017/09/14 07:39:45 UTC
How to clean up the invisible cube
Hi:
Sometime,When I delete a model, Prompt is referenced by cube, But I can't see the cube by webUI
So,how to delete this model?
apache_dev@163.com
Re: Re: How to clean up the invisible cube
Posted by 杨浩 <ya...@gmail.com>.
you can delete cube_0831 like this
bin/metastore.sh remove /cube/cube_0831.json
bin/metastore.sh remove /cube_desc/cube_0831.json
2017-09-20 13:24 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
> You can backup all the metadata to a local folder, and then run
> "metastore.sh reset" to clean up them from hbase; In local metadata, you
> can remove the redundant cube json file, and also remove the reference in
> the project json file. When all done, restore that to hbase.
>
> All these operations need be taken when Kylin is stopped. A backup is
> required before start.
>
> 2017-09-19 19:00 GMT+08:00 apache_dev@163.com <ap...@163.com>:
>
> > Info show Loaded 12 Cube(s),but Only 9 can lists (2017-09-19
> > 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:795 : Loaded 9
> > cubes, fail on 0 cubes)
> >
> >
> >
> > 2017-09-19 18:56:49,105 DEBUG [Thread-15] metadata.MetadataManager:388 :
> > Reloading Table_exd info from folder kylin_metadata(key='/table_
> > exd')@kylin_metadata@hbase
> > 2017-09-19 18:56:49,883 DEBUG [Thread-15] metadata.MetadataManager:397 :
> > Loaded 26 SourceTable EXD(s)
> > 2017-09-19 18:56:49,883 DEBUG [Thread-15] metadata.MetadataManager:572 :
> > Reloading DataModel from folder kylin_metadata(key='/model_
> > desc')@kylin_metadata@hbase
> > 2017-09-19 18:56:50,015 INFO [Thread-15] metadata.MetadataManager:580 :
> > Reloading data model at /model_desc/BUSS_INFO.json
> > 2017-09-19 18:56:50,104 INFO [Thread-15] metadata.MetadataManager:580 :
> > Reloading data model at /model_desc/M_BUSS_INFO.json
> > 2017-09-19 18:56:50,108 INFO [Thread-15] metadata.MetadataManager:580 :
> > Reloading data model at /model_desc/kylin_sales_model.json
> > 2017-09-19 18:56:50,113 INFO [Thread-15] metadata.MetadataManager:580 :
> > Reloading data model at /model_desc/model.json
> > 2017-09-19 18:56:50,117 INFO [Thread-15] metadata.MetadataManager:580 :
> > Reloading data model at /model_desc/model_loan.json
> > 2017-09-19 18:56:50,130 INFO [Thread-15] metadata.MetadataManager:580 :
> > Reloading data model at /model_desc/yewubill.json
> > 2017-09-19 18:56:50,132 DEBUG [Thread-15] metadata.MetadataManager:588 :
> > Loaded 6 DataModel(s)
> > 2017-09-19 18:56:50,133 DEBUG [Thread-15] metadata.MetadataManager:453 :
> > Reloading ExternalFilter from folder kylin_metadata(key='/ext_
> > filter')@kylin_metadata@hbase
> > 2017-09-19 18:56:50,151 DEBUG [Thread-15] metadata.MetadataManager:462 :
> > Loaded 0 ExternalFilter(s)
> >
> >
> >
> > se
> > 2017-09-19 18:58:33,748 WARN [http-bio-7070-exec-2] common.
> BackwardCompatibilityConfig:93
> > : Config 'kylin.hbase.region.cut' is deprecated, use
> > 'kylin.storage.hbase.region-cut-gb' instead
> > 2017-09-19 18:58:33,749 WARN [http-bio-7070-exec-2] common.
> BackwardCompatibilityConfig:93
> > : Config 'kylin.hbase.region.count.min' is deprecated, use
> > 'kylin.storage.hbase.min-region-count' instead
> > 2017-09-19 18:58:33,749 WARN [http-bio-7070-exec-2] common.
> BackwardCompatibilityConfig:93
> > : Config 'kylin.hbase.region.count.max' is deprecated, use
> > 'kylin.storage.hbase.max-region-count' instead
> > 2017-09-19 18:58:33,775 INFO [http-bio-7070-exec-2]
> > cube.CubeDescManager:340 : Loaded 12 Cube(s)
> > 2017-09-19 18:58:33,776 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube C_4187e78b4ce54017aae2f161ea3840dd being CUBE[name=C_
> > 4187e78b4ce54017aae2f161ea3840dd] having 1 segments
> > 2017-09-19 18:58:33,777 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube asdfds being CUBE[name=asdfds] having 0 segments
> > 2017-09-19 18:58:33,779 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube cube_loan being CUBE[name=cube_loan] having 1 segments
> > 2017-09-19 18:58:33,781 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube day1 being CUBE[name=day1] having 2 segments
> > 2017-09-19 18:58:33,782 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube group being CUBE[name=group] having 0 segments
> > 2017-09-19 18:58:33,784 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube kylin_sales_cube being CUBE[name=kylin_sales_cube]
> having 1
> > segments
> > 2017-09-19 18:58:33,785 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube kylin_sales_cube_clone being CUBE[name=kylin_sales_cube_
> clone]
> > having 0 segments
> > 2017-09-19 18:58:33,787 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube sadf being CUBE[name=sadf] having 0 segments
> > 2017-09-19 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> > : Reloaded cube yewucube being CUBE[name=yewucube] having 1 segments
> > 2017-09-19 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:795
> > : Loaded 9 cubes, fail on 0 cubes
> > 2017-09-19 18:58:53,775 INFO [pool-8-thread-1]
> > threadpool.DefaultScheduler:123 : Job Fetcher: 0 should running, 0
> actual
> > running, 0 stopped, 0 ready, 136 already succeed, 21 error, 5 discarded,
> 0
> > others
> > 2017-09-19 18:59:01,756 DEBUG [http-bio-7070-exec-7]
> > project.ProjectL2Cache:191 : Loading L2 project cache for METRIC
> > 2017-09-19 18:59:01,760 INFO [http-bio-7070-exec-7] realization.
> RealizationRegistry:81
> > : Initializing RealizationRegistry with metadata url kylin_metadata@hbase
> > 2017-09-19 18:59:01,769 INFO [http-bio-7070-exec-7]
> > hybrid.HybridManager:94 : Initializing HybridManager with config
> > kylin_metadata@hbase
> > 2017-09-19 18:59:01,778 DEBUG [http-bio-7070-exec-7]
> > hybrid.HybridManager:146 : Loading Hybrid from folder
> > kylin_metadata(key='/hybrid')@kylin_metadata@hbase
> > 2017-09-19 18:59:01,779 DEBUG [http-bio-7070-exec-7]
> > hybrid.HybridManager:152 : Loaded 0 Hybrid(s)
> > 2017-09-19 18:59:01,779 INFO [http-bio-7070-exec-7] realization.
> RealizationRegistry:115
> > : RealizationRegistry is {HYBRID=org.apache.kylin.
> > storage.hybrid.HybridManager@15f14c47, CUBE=org.apache.kylin.cube.
> > CubeManager@ff6a01}
> > 2017-09-19 18:59:01,780 WARN [http-bio-7070-exec-7] realization.
> RealizationRegistry:125
> > : No provider for realization type INVERTED_INDEX
> > 2017-09-19 18:59:01,780 WARN [http-bio-7070-exec-7] realization.
> RealizationRegistry:125
> > : No provider for realization type INVERTED_INDEX
> > 2017-09-19 18:59:06,700 ERROR [http-bio-7070-exec-7]
> > controller.ModelController:163 : Model is referenced by Cube 'cube_0831'
> ,
> > could not dropped
> > org.apache.kylin.rest.exception.BadRequestException: Model is referenced
> > by Cube 'cube_0831' , could not dropped
> > at org.apache.kylin.rest.service.ModelService.dropModel(
> > ModelService.java:151)
> > at org.apache.kylin.rest.service.ModelService$$
> > FastClassBySpringCGLIB$$eb0205be.invoke(<generated>)
> > at org.springframework.cglib.proxy.MethodProxy.invoke(
> > MethodProxy.java:204)
> > at org.springframework.aop.framework.CglibAopProxy$
> > CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
> > at org.springframework.aop.framework.ReflectiveMethodInvocation.
> > proceed(ReflectiveMethodInvocation.java:157)
> > at org.springframework.security.access.intercept.aopalliance.
> > MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)
> > at org.springframework.aop.framework.ReflectiveMethodInvocation.
> > proceed(ReflectiveMethodInvocation.java:179)
> > at org.springframework.aop.framework.CglibAopProxy$
> > DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
> > at org.apache.kylin.rest.service.ModelService$$
> > EnhancerBySpringCGLIB$$63dbdcd1.dropModel(<generated>)
> > at org.apache.kylin.rest.controller.ModelController.
> > deleteModel(ModelController.java:161)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at sun.reflect.NativeMethodAccessorImpl.invoke(
> > NativeMethodAccessorImpl.java:62)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:498)
> > 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:110)
> > at org.springframework.web.servlet.mvc.method.annotation.
> > RequestMappingHandlerAdapter.invokeHandlerMethod(
> > RequestMappingHandlerAdapter.java:832)
> > at org.springframework.web.servlet.mvc.method.annotation.
> > RequestMappingHandlerAdapter.handleInternal(
> RequestMappingHandlerAdapter.
> > java:743)
> > at org.springframework.web.servlet.mvc.method.
> > AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.
> java:85)
> > at org.springframework.web.servlet.DispatcherServlet.
> > doDispatch(DispatcherServlet.java:961)
> > at org.springframework.web.servlet.DispatcherServlet.
> > doService(DispatcherServlet.java:895)
> > at org.springframework.web.servlet.FrameworkServlet.
> > processRequest(FrameworkServlet.java:967)
> > at org.springframework.web.servlet.FrameworkServlet.
> > doDelete(FrameworkServlet.java:891)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
> > at org.springframework.web.servlet.FrameworkServlet.
> > service(FrameworkServlet.java:843)
> > 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:316)
> > at org.springframework.security.web.access.intercept.
> > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
> > at org.springframework.security.web.access.intercept.
> > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.access.
> > ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.session.
> > SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.authentication.
> > AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> > java:111)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.servletapi.
> > SecurityContextHolderAwareRequestFilter.doFilter(
> > SecurityContextHolderAwareRequestFilter.java:169)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.savedrequest.
> > RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.authentication.www.
> > BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.
> > java:213)
> > at org.springframework.web.filter.OncePerRequestFilter.
> > doFilter(OncePerRequestFilter.java:107)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.authentication.
> > AbstractAuthenticationProcessingFilter.doFilter(
> > AbstractAuthenticationProcessingFilter.java:205)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.authentication.logout.
> > LogoutFilter.doFilter(LogoutFilter.java:120)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.header.HeaderWriterFilter.
> > doFilterInternal(HeaderWriterFilter.java:64)
> > at org.springframework.web.filter.OncePerRequestFilter.
> > doFilter(OncePerRequestFilter.java:107)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.context.request.async.
> > WebAsyncManagerIntegrationFilter.doFilterInternal(
> > WebAsyncManagerIntegrationFilter.java:53)
> > at org.springframework.web.filter.OncePerRequestFilter.
> > doFilter(OncePerRequestFilter.java:107)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.context.
> > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> > er.java:91)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.FilterChainProxy.
> > doFilterInternal(FilterChainProxy.java:213)
> > at org.springframework.security.web.FilterChainProxy.doFilter(
> > FilterChainProxy.java:176)
> > at org.springframework.web.filter.DelegatingFilterProxy.
> > invokeDelegate(DelegatingFilterProxy.java:346)
> > at org.springframework.web.filter.DelegatingFilterProxy.
> doFilter(
> > DelegatingFilterProxy.java:262)
> > 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:318)
> > at java.util.concurrent.ThreadPoolExecutor.runWorker(
> > ThreadPoolExecutor.java:1142)
> > at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> > ThreadPoolExecutor.java:617)
> > at org.apache.tomcat.util.threads.TaskThread$
> WrappingRunnable.run(
> > TaskThread.java:61)
> > at java.lang.Thread.run(Thread.java:748)
> > 2017-09-19 18:59:06,719 ERROR [http-bio-7070-exec-7]
> > controller.BasicController:57 :
> > org.apache.kylin.rest.exception.InternalErrorException: Failed to delete
> > model. Caused by: Model is referenced by Cube 'cube_0831' , could not
> > dropped
> > at org.apache.kylin.rest.controller.ModelController.
> > deleteModel(ModelController.java:164)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at sun.reflect.NativeMethodAccessorImpl.invoke(
> > NativeMethodAccessorImpl.java:62)
> > at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:498)
> > 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:110)
> > at org.springframework.web.servlet.mvc.method.annotation.
> > RequestMappingHandlerAdapter.invokeHandlerMethod(
> > RequestMappingHandlerAdapter.java:832)
> > at org.springframework.web.servlet.mvc.method.annotation.
> > RequestMappingHandlerAdapter.handleInternal(
> RequestMappingHandlerAdapter.
> > java:743)
> > at org.springframework.web.servlet.mvc.method.
> > AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.
> java:85)
> > at org.springframework.web.servlet.DispatcherServlet.
> > doDispatch(DispatcherServlet.java:961)
> > at org.springframework.web.servlet.DispatcherServlet.
> > doService(DispatcherServlet.java:895)
> > at org.springframework.web.servlet.FrameworkServlet.
> > processRequest(FrameworkServlet.java:967)
> > at org.springframework.web.servlet.FrameworkServlet.
> > doDelete(FrameworkServlet.java:891)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
> > at org.springframework.web.servlet.FrameworkServlet.
> > service(FrameworkServlet.java:843)
> > 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:316)
> > at org.springframework.security.web.access.intercept.
> > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
> > at org.springframework.security.web.access.intercept.
> > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.access.
> > ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.session.
> > SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.authentication.
> > AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> > java:111)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.servletapi.
> > SecurityContextHolderAwareRequestFilter.doFilter(
> > SecurityContextHolderAwareRequestFilter.java:169)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.savedrequest.
> > RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.authentication.www.
> > BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.
> > java:213)
> > at org.springframework.web.filter.OncePerRequestFilter.
> > doFilter(OncePerRequestFilter.java:107)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.authentication.
> > AbstractAuthenticationProcessingFilter.doFilter(
> > AbstractAuthenticationProcessingFilter.java:205)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.authentication.logout.
> > LogoutFilter.doFilter(LogoutFilter.java:120)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.header.HeaderWriterFilter.
> > doFilterInternal(HeaderWriterFilter.java:64)
> > at org.springframework.web.filter.OncePerRequestFilter.
> > doFilter(OncePerRequestFilter.java:107)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.context.request.async.
> > WebAsyncManagerIntegrationFilter.doFilterInternal(
> > WebAsyncManagerIntegrationFilter.java:53)
> > at org.springframework.web.filter.OncePerRequestFilter.
> > doFilter(OncePerRequestFilter.java:107)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.context.
> > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> > er.java:91)
> > at org.springframework.security.web.FilterChainProxy$
> > VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> > at org.springframework.security.web.FilterChainProxy.
> > doFilterInternal(FilterChainProxy.java:213)
> > at org.springframework.security.web.FilterChainProxy.doFilter(
> > FilterChainProxy.java:176)
> > at org.springframework.web.filter.DelegatingFilterProxy.
> > invokeDelegate(DelegatingFilterProxy.java:346)
> > at org.springframework.web.filter.DelegatingFilterProxy.
> doFilter(
> > DelegatingFilterProxy.java:262)
> > 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:318)
> > at java.util.concurrent.ThreadPoolExecutor.runWorker(
> > ThreadPoolExecutor.java:1142)
> > at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> > ThreadPoolExecutor.java:617)
> > at org.apache.tomcat.util.threads.TaskThread$
> WrappingRunnable.run(
> > TaskThread.java:61)
> > at java.lang.Thread.run(Thread.java:748)
> > Caused by: org.apache.kylin.rest.exception.BadRequestException: Model is
> > referenced by Cube 'cube_0831' , could not dropped
> > at org.apache.kylin.rest.service.ModelService.dropModel(
> > ModelService.java:151)
> > at org.apache.kylin.rest.service.ModelService$$
> > FastClassBySpringCGLIB$$eb0205be.invoke(<generated>)
> > at org.springframework.cglib.proxy.MethodProxy.invoke(
> > MethodProxy.java:204)
> > at org.springframework.aop.framework.CglibAopProxy$
> > CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
> > at org.springframework.aop.framework.ReflectiveMethodInvocation.
> > proceed(ReflectiveMethodInvocation.java:157)
> > at org.springframework.security.access.intercept.aopalliance.
> > MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)
> > at org.springframework.aop.framework.ReflectiveMethodInvocation.
> > proceed(ReflectiveMethodInvocation.java:179)
> > at org.springframework.aop.framework.CglibAopProxy$
> > DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
> > at org.apache.kylin.rest.service.ModelService$$
> > EnhancerBySpringCGLIB$$63dbdcd1.dropModel(<generated>)
> > at org.apache.kylin.rest.controller.ModelController.
> > deleteModel(ModelController.java:161)
> > ... 76 more
> > 2017-09-19 18:59:23,782 INFO [pool-8-thread-1]
> > threadpool.DefaultScheduler:123 : Job Fetcher: 0 should running, 0
> actual
> > running, 0 stopped, 0 ready, 136 already succeed, 21 error, 5 discarded,
> 0
> > others
> >
> >
> >
> >
> > apache_dev@163.com
> >
> > From: Li Yang
> > Date: 2017-09-17 15:17
> > To: dev
> > Subject: Re: How to clean up the invisible cube
> > The cube should be there unless something wrong with your metadata. You
> may
> > check kylin.log to see if any error during system start when cubes are
> > loaded.
> >
> > On Thu, Sep 14, 2017 at 3:39 PM, apache_dev@163.com <ap...@163.com>
> > wrote:
> >
> > > Hi:
> > >
> > > Sometime,When I delete a model, Prompt is referenced by cube, But I
> > > can't see the cube by webUI
> > >
> > > So,how to delete this model?
> > >
> > >
> > >
> > >
> > >
> > > apache_dev@163.com
> > >
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
Re: Re: How to clean up the invisible cube
Posted by ShaoFeng Shi <sh...@apache.org>.
You can backup all the metadata to a local folder, and then run
"metastore.sh reset" to clean up them from hbase; In local metadata, you
can remove the redundant cube json file, and also remove the reference in
the project json file. When all done, restore that to hbase.
All these operations need be taken when Kylin is stopped. A backup is
required before start.
2017-09-19 19:00 GMT+08:00 apache_dev@163.com <ap...@163.com>:
> Info show Loaded 12 Cube(s),but Only 9 can lists (2017-09-19
> 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:795 : Loaded 9
> cubes, fail on 0 cubes)
>
>
>
> 2017-09-19 18:56:49,105 DEBUG [Thread-15] metadata.MetadataManager:388 :
> Reloading Table_exd info from folder kylin_metadata(key='/table_
> exd')@kylin_metadata@hbase
> 2017-09-19 18:56:49,883 DEBUG [Thread-15] metadata.MetadataManager:397 :
> Loaded 26 SourceTable EXD(s)
> 2017-09-19 18:56:49,883 DEBUG [Thread-15] metadata.MetadataManager:572 :
> Reloading DataModel from folder kylin_metadata(key='/model_
> desc')@kylin_metadata@hbase
> 2017-09-19 18:56:50,015 INFO [Thread-15] metadata.MetadataManager:580 :
> Reloading data model at /model_desc/BUSS_INFO.json
> 2017-09-19 18:56:50,104 INFO [Thread-15] metadata.MetadataManager:580 :
> Reloading data model at /model_desc/M_BUSS_INFO.json
> 2017-09-19 18:56:50,108 INFO [Thread-15] metadata.MetadataManager:580 :
> Reloading data model at /model_desc/kylin_sales_model.json
> 2017-09-19 18:56:50,113 INFO [Thread-15] metadata.MetadataManager:580 :
> Reloading data model at /model_desc/model.json
> 2017-09-19 18:56:50,117 INFO [Thread-15] metadata.MetadataManager:580 :
> Reloading data model at /model_desc/model_loan.json
> 2017-09-19 18:56:50,130 INFO [Thread-15] metadata.MetadataManager:580 :
> Reloading data model at /model_desc/yewubill.json
> 2017-09-19 18:56:50,132 DEBUG [Thread-15] metadata.MetadataManager:588 :
> Loaded 6 DataModel(s)
> 2017-09-19 18:56:50,133 DEBUG [Thread-15] metadata.MetadataManager:453 :
> Reloading ExternalFilter from folder kylin_metadata(key='/ext_
> filter')@kylin_metadata@hbase
> 2017-09-19 18:56:50,151 DEBUG [Thread-15] metadata.MetadataManager:462 :
> Loaded 0 ExternalFilter(s)
>
>
>
> se
> 2017-09-19 18:58:33,748 WARN [http-bio-7070-exec-2] common.BackwardCompatibilityConfig:93
> : Config 'kylin.hbase.region.cut' is deprecated, use
> 'kylin.storage.hbase.region-cut-gb' instead
> 2017-09-19 18:58:33,749 WARN [http-bio-7070-exec-2] common.BackwardCompatibilityConfig:93
> : Config 'kylin.hbase.region.count.min' is deprecated, use
> 'kylin.storage.hbase.min-region-count' instead
> 2017-09-19 18:58:33,749 WARN [http-bio-7070-exec-2] common.BackwardCompatibilityConfig:93
> : Config 'kylin.hbase.region.count.max' is deprecated, use
> 'kylin.storage.hbase.max-region-count' instead
> 2017-09-19 18:58:33,775 INFO [http-bio-7070-exec-2]
> cube.CubeDescManager:340 : Loaded 12 Cube(s)
> 2017-09-19 18:58:33,776 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube C_4187e78b4ce54017aae2f161ea3840dd being CUBE[name=C_
> 4187e78b4ce54017aae2f161ea3840dd] having 1 segments
> 2017-09-19 18:58:33,777 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube asdfds being CUBE[name=asdfds] having 0 segments
> 2017-09-19 18:58:33,779 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube cube_loan being CUBE[name=cube_loan] having 1 segments
> 2017-09-19 18:58:33,781 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube day1 being CUBE[name=day1] having 2 segments
> 2017-09-19 18:58:33,782 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube group being CUBE[name=group] having 0 segments
> 2017-09-19 18:58:33,784 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube kylin_sales_cube being CUBE[name=kylin_sales_cube] having 1
> segments
> 2017-09-19 18:58:33,785 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube kylin_sales_cube_clone being CUBE[name=kylin_sales_cube_clone]
> having 0 segments
> 2017-09-19 18:58:33,787 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube sadf being CUBE[name=sadf] having 0 segments
> 2017-09-19 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:834
> : Reloaded cube yewucube being CUBE[name=yewucube] having 1 segments
> 2017-09-19 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:795
> : Loaded 9 cubes, fail on 0 cubes
> 2017-09-19 18:58:53,775 INFO [pool-8-thread-1]
> threadpool.DefaultScheduler:123 : Job Fetcher: 0 should running, 0 actual
> running, 0 stopped, 0 ready, 136 already succeed, 21 error, 5 discarded, 0
> others
> 2017-09-19 18:59:01,756 DEBUG [http-bio-7070-exec-7]
> project.ProjectL2Cache:191 : Loading L2 project cache for METRIC
> 2017-09-19 18:59:01,760 INFO [http-bio-7070-exec-7] realization.RealizationRegistry:81
> : Initializing RealizationRegistry with metadata url kylin_metadata@hbase
> 2017-09-19 18:59:01,769 INFO [http-bio-7070-exec-7]
> hybrid.HybridManager:94 : Initializing HybridManager with config
> kylin_metadata@hbase
> 2017-09-19 18:59:01,778 DEBUG [http-bio-7070-exec-7]
> hybrid.HybridManager:146 : Loading Hybrid from folder
> kylin_metadata(key='/hybrid')@kylin_metadata@hbase
> 2017-09-19 18:59:01,779 DEBUG [http-bio-7070-exec-7]
> hybrid.HybridManager:152 : Loaded 0 Hybrid(s)
> 2017-09-19 18:59:01,779 INFO [http-bio-7070-exec-7] realization.RealizationRegistry:115
> : RealizationRegistry is {HYBRID=org.apache.kylin.
> storage.hybrid.HybridManager@15f14c47, CUBE=org.apache.kylin.cube.
> CubeManager@ff6a01}
> 2017-09-19 18:59:01,780 WARN [http-bio-7070-exec-7] realization.RealizationRegistry:125
> : No provider for realization type INVERTED_INDEX
> 2017-09-19 18:59:01,780 WARN [http-bio-7070-exec-7] realization.RealizationRegistry:125
> : No provider for realization type INVERTED_INDEX
> 2017-09-19 18:59:06,700 ERROR [http-bio-7070-exec-7]
> controller.ModelController:163 : Model is referenced by Cube 'cube_0831' ,
> could not dropped
> org.apache.kylin.rest.exception.BadRequestException: Model is referenced
> by Cube 'cube_0831' , could not dropped
> at org.apache.kylin.rest.service.ModelService.dropModel(
> ModelService.java:151)
> at org.apache.kylin.rest.service.ModelService$$
> FastClassBySpringCGLIB$$eb0205be.invoke(<generated>)
> at org.springframework.cglib.proxy.MethodProxy.invoke(
> MethodProxy.java:204)
> at org.springframework.aop.framework.CglibAopProxy$
> CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:157)
> at org.springframework.security.access.intercept.aopalliance.
> MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:179)
> at org.springframework.aop.framework.CglibAopProxy$
> DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
> at org.apache.kylin.rest.service.ModelService$$
> EnhancerBySpringCGLIB$$63dbdcd1.dropModel(<generated>)
> at org.apache.kylin.rest.controller.ModelController.
> deleteModel(ModelController.java:161)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> 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:110)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandlerMethod(
> RequestMappingHandlerAdapter.java:832)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:743)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:961)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:895)
> at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:967)
> at org.springframework.web.servlet.FrameworkServlet.
> doDelete(FrameworkServlet.java:891)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:843)
> 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:316)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.access.
> ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.session.
> SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:111)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:169)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.savedrequest.
> RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.
> java:213)
> at org.springframework.web.filter.OncePerRequestFilter.
> doFilter(OncePerRequestFilter.java:107)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:205)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:120)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.header.HeaderWriterFilter.
> doFilterInternal(HeaderWriterFilter.java:64)
> at org.springframework.web.filter.OncePerRequestFilter.
> doFilter(OncePerRequestFilter.java:107)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.context.request.async.
> WebAsyncManagerIntegrationFilter.doFilterInternal(
> WebAsyncManagerIntegrationFilter.java:53)
> at org.springframework.web.filter.OncePerRequestFilter.
> doFilter(OncePerRequestFilter.java:107)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.context.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.java:91)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.FilterChainProxy.
> doFilterInternal(FilterChainProxy.java:213)
> at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:176)
> at org.springframework.web.filter.DelegatingFilterProxy.
> invokeDelegate(DelegatingFilterProxy.java:346)
> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:262)
> 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:318)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:748)
> 2017-09-19 18:59:06,719 ERROR [http-bio-7070-exec-7]
> controller.BasicController:57 :
> org.apache.kylin.rest.exception.InternalErrorException: Failed to delete
> model. Caused by: Model is referenced by Cube 'cube_0831' , could not
> dropped
> at org.apache.kylin.rest.controller.ModelController.
> deleteModel(ModelController.java:164)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> 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:110)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandlerMethod(
> RequestMappingHandlerAdapter.java:832)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:743)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:961)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:895)
> at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:967)
> at org.springframework.web.servlet.FrameworkServlet.
> doDelete(FrameworkServlet.java:891)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:843)
> 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:316)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.access.
> ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.session.
> SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:111)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:169)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.savedrequest.
> RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.
> java:213)
> at org.springframework.web.filter.OncePerRequestFilter.
> doFilter(OncePerRequestFilter.java:107)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:205)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:120)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.header.HeaderWriterFilter.
> doFilterInternal(HeaderWriterFilter.java:64)
> at org.springframework.web.filter.OncePerRequestFilter.
> doFilter(OncePerRequestFilter.java:107)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.context.request.async.
> WebAsyncManagerIntegrationFilter.doFilterInternal(
> WebAsyncManagerIntegrationFilter.java:53)
> at org.springframework.web.filter.OncePerRequestFilter.
> doFilter(OncePerRequestFilter.java:107)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.context.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.java:91)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.FilterChainProxy.
> doFilterInternal(FilterChainProxy.java:213)
> at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:176)
> at org.springframework.web.filter.DelegatingFilterProxy.
> invokeDelegate(DelegatingFilterProxy.java:346)
> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:262)
> 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:318)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: org.apache.kylin.rest.exception.BadRequestException: Model is
> referenced by Cube 'cube_0831' , could not dropped
> at org.apache.kylin.rest.service.ModelService.dropModel(
> ModelService.java:151)
> at org.apache.kylin.rest.service.ModelService$$
> FastClassBySpringCGLIB$$eb0205be.invoke(<generated>)
> at org.springframework.cglib.proxy.MethodProxy.invoke(
> MethodProxy.java:204)
> at org.springframework.aop.framework.CglibAopProxy$
> CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:157)
> at org.springframework.security.access.intercept.aopalliance.
> MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)
> at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:179)
> at org.springframework.aop.framework.CglibAopProxy$
> DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
> at org.apache.kylin.rest.service.ModelService$$
> EnhancerBySpringCGLIB$$63dbdcd1.dropModel(<generated>)
> at org.apache.kylin.rest.controller.ModelController.
> deleteModel(ModelController.java:161)
> ... 76 more
> 2017-09-19 18:59:23,782 INFO [pool-8-thread-1]
> threadpool.DefaultScheduler:123 : Job Fetcher: 0 should running, 0 actual
> running, 0 stopped, 0 ready, 136 already succeed, 21 error, 5 discarded, 0
> others
>
>
>
>
> apache_dev@163.com
>
> From: Li Yang
> Date: 2017-09-17 15:17
> To: dev
> Subject: Re: How to clean up the invisible cube
> The cube should be there unless something wrong with your metadata. You may
> check kylin.log to see if any error during system start when cubes are
> loaded.
>
> On Thu, Sep 14, 2017 at 3:39 PM, apache_dev@163.com <ap...@163.com>
> wrote:
>
> > Hi:
> >
> > Sometime,When I delete a model, Prompt is referenced by cube, But I
> > can't see the cube by webUI
> >
> > So,how to delete this model?
> >
> >
> >
> >
> >
> > apache_dev@163.com
> >
>
--
Best regards,
Shaofeng Shi 史少锋
Re: Re: How to clean up the invisible cube
Posted by "apache_dev@163.com" <ap...@163.com>.
Info show Loaded 12 Cube(s),but Only 9 can lists (2017-09-19 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:795 : Loaded 9 cubes, fail on 0 cubes)
2017-09-19 18:56:49,105 DEBUG [Thread-15] metadata.MetadataManager:388 : Reloading Table_exd info from folder kylin_metadata(key='/table_exd')@kylin_metadata@hbase
2017-09-19 18:56:49,883 DEBUG [Thread-15] metadata.MetadataManager:397 : Loaded 26 SourceTable EXD(s)
2017-09-19 18:56:49,883 DEBUG [Thread-15] metadata.MetadataManager:572 : Reloading DataModel from folder kylin_metadata(key='/model_desc')@kylin_metadata@hbase
2017-09-19 18:56:50,015 INFO [Thread-15] metadata.MetadataManager:580 : Reloading data model at /model_desc/BUSS_INFO.json
2017-09-19 18:56:50,104 INFO [Thread-15] metadata.MetadataManager:580 : Reloading data model at /model_desc/M_BUSS_INFO.json
2017-09-19 18:56:50,108 INFO [Thread-15] metadata.MetadataManager:580 : Reloading data model at /model_desc/kylin_sales_model.json
2017-09-19 18:56:50,113 INFO [Thread-15] metadata.MetadataManager:580 : Reloading data model at /model_desc/model.json
2017-09-19 18:56:50,117 INFO [Thread-15] metadata.MetadataManager:580 : Reloading data model at /model_desc/model_loan.json
2017-09-19 18:56:50,130 INFO [Thread-15] metadata.MetadataManager:580 : Reloading data model at /model_desc/yewubill.json
2017-09-19 18:56:50,132 DEBUG [Thread-15] metadata.MetadataManager:588 : Loaded 6 DataModel(s)
2017-09-19 18:56:50,133 DEBUG [Thread-15] metadata.MetadataManager:453 : Reloading ExternalFilter from folder kylin_metadata(key='/ext_filter')@kylin_metadata@hbase
2017-09-19 18:56:50,151 DEBUG [Thread-15] metadata.MetadataManager:462 : Loaded 0 ExternalFilter(s)
se
2017-09-19 18:58:33,748 WARN [http-bio-7070-exec-2] common.BackwardCompatibilityConfig:93 : Config 'kylin.hbase.region.cut' is deprecated, use 'kylin.storage.hbase.region-cut-gb' instead
2017-09-19 18:58:33,749 WARN [http-bio-7070-exec-2] common.BackwardCompatibilityConfig:93 : Config 'kylin.hbase.region.count.min' is deprecated, use 'kylin.storage.hbase.min-region-count' instead
2017-09-19 18:58:33,749 WARN [http-bio-7070-exec-2] common.BackwardCompatibilityConfig:93 : Config 'kylin.hbase.region.count.max' is deprecated, use 'kylin.storage.hbase.max-region-count' instead
2017-09-19 18:58:33,775 INFO [http-bio-7070-exec-2] cube.CubeDescManager:340 : Loaded 12 Cube(s)
2017-09-19 18:58:33,776 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube C_4187e78b4ce54017aae2f161ea3840dd being CUBE[name=C_4187e78b4ce54017aae2f161ea3840dd] having 1 segments
2017-09-19 18:58:33,777 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube asdfds being CUBE[name=asdfds] having 0 segments
2017-09-19 18:58:33,779 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube cube_loan being CUBE[name=cube_loan] having 1 segments
2017-09-19 18:58:33,781 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube day1 being CUBE[name=day1] having 2 segments
2017-09-19 18:58:33,782 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube group being CUBE[name=group] having 0 segments
2017-09-19 18:58:33,784 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube kylin_sales_cube being CUBE[name=kylin_sales_cube] having 1 segments
2017-09-19 18:58:33,785 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube kylin_sales_cube_clone being CUBE[name=kylin_sales_cube_clone] having 0 segments
2017-09-19 18:58:33,787 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube sadf being CUBE[name=sadf] having 0 segments
2017-09-19 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:834 : Reloaded cube yewucube being CUBE[name=yewucube] having 1 segments
2017-09-19 18:58:33,788 INFO [http-bio-7070-exec-2] cube.CubeManager:795 : Loaded 9 cubes, fail on 0 cubes
2017-09-19 18:58:53,775 INFO [pool-8-thread-1] threadpool.DefaultScheduler:123 : Job Fetcher: 0 should running, 0 actual running, 0 stopped, 0 ready, 136 already succeed, 21 error, 5 discarded, 0 others
2017-09-19 18:59:01,756 DEBUG [http-bio-7070-exec-7] project.ProjectL2Cache:191 : Loading L2 project cache for METRIC
2017-09-19 18:59:01,760 INFO [http-bio-7070-exec-7] realization.RealizationRegistry:81 : Initializing RealizationRegistry with metadata url kylin_metadata@hbase
2017-09-19 18:59:01,769 INFO [http-bio-7070-exec-7] hybrid.HybridManager:94 : Initializing HybridManager with config kylin_metadata@hbase
2017-09-19 18:59:01,778 DEBUG [http-bio-7070-exec-7] hybrid.HybridManager:146 : Loading Hybrid from folder kylin_metadata(key='/hybrid')@kylin_metadata@hbase
2017-09-19 18:59:01,779 DEBUG [http-bio-7070-exec-7] hybrid.HybridManager:152 : Loaded 0 Hybrid(s)
2017-09-19 18:59:01,779 INFO [http-bio-7070-exec-7] realization.RealizationRegistry:115 : RealizationRegistry is {HYBRID=org.apache.kylin.storage.hybrid.HybridManager@15f14c47, CUBE=org.apache.kylin.cube.CubeManager@ff6a01}
2017-09-19 18:59:01,780 WARN [http-bio-7070-exec-7] realization.RealizationRegistry:125 : No provider for realization type INVERTED_INDEX
2017-09-19 18:59:01,780 WARN [http-bio-7070-exec-7] realization.RealizationRegistry:125 : No provider for realization type INVERTED_INDEX
2017-09-19 18:59:06,700 ERROR [http-bio-7070-exec-7] controller.ModelController:163 : Model is referenced by Cube 'cube_0831' , could not dropped
org.apache.kylin.rest.exception.BadRequestException: Model is referenced by Cube 'cube_0831' , could not dropped
at org.apache.kylin.rest.service.ModelService.dropModel(ModelService.java:151)
at org.apache.kylin.rest.service.ModelService$$FastClassBySpringCGLIB$$eb0205be.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
at org.apache.kylin.rest.service.ModelService$$EnhancerBySpringCGLIB$$63dbdcd1.dropModel(<generated>)
at org.apache.kylin.rest.controller.ModelController.deleteModel(ModelController.java:161)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
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:110)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
at org.springframework.web.servlet.FrameworkServlet.doDelete(FrameworkServlet.java:891)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
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:316)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:213)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
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:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
2017-09-19 18:59:06,719 ERROR [http-bio-7070-exec-7] controller.BasicController:57 :
org.apache.kylin.rest.exception.InternalErrorException: Failed to delete model. Caused by: Model is referenced by Cube 'cube_0831' , could not dropped
at org.apache.kylin.rest.controller.ModelController.deleteModel(ModelController.java:164)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
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:110)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
at org.springframework.web.servlet.FrameworkServlet.doDelete(FrameworkServlet.java:891)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
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:316)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:213)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
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:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.kylin.rest.exception.BadRequestException: Model is referenced by Cube 'cube_0831' , could not dropped
at org.apache.kylin.rest.service.ModelService.dropModel(ModelService.java:151)
at org.apache.kylin.rest.service.ModelService$$FastClassBySpringCGLIB$$eb0205be.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
at org.apache.kylin.rest.service.ModelService$$EnhancerBySpringCGLIB$$63dbdcd1.dropModel(<generated>)
at org.apache.kylin.rest.controller.ModelController.deleteModel(ModelController.java:161)
... 76 more
2017-09-19 18:59:23,782 INFO [pool-8-thread-1] threadpool.DefaultScheduler:123 : Job Fetcher: 0 should running, 0 actual running, 0 stopped, 0 ready, 136 already succeed, 21 error, 5 discarded, 0 others
apache_dev@163.com
From: Li Yang
Date: 2017-09-17 15:17
To: dev
Subject: Re: How to clean up the invisible cube
The cube should be there unless something wrong with your metadata. You may
check kylin.log to see if any error during system start when cubes are
loaded.
On Thu, Sep 14, 2017 at 3:39 PM, apache_dev@163.com <ap...@163.com>
wrote:
> Hi:
>
> Sometime,When I delete a model, Prompt is referenced by cube, But I
> can't see the cube by webUI
>
> So,how to delete this model?
>
>
>
>
>
> apache_dev@163.com
>
Re: How to clean up the invisible cube
Posted by Li Yang <li...@apache.org>.
The cube should be there unless something wrong with your metadata. You may
check kylin.log to see if any error during system start when cubes are
loaded.
On Thu, Sep 14, 2017 at 3:39 PM, apache_dev@163.com <ap...@163.com>
wrote:
> Hi:
>
> Sometime,When I delete a model, Prompt is referenced by cube, But I
> can't see the cube by webUI
>
> So,how to delete this model?
>
>
>
>
>
> apache_dev@163.com
>