Re: 答复: Any query returns error 'null'

[Li Yang]

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 
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 
> 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.
> 

答复: Any query returns error 'null'

[jianhui.yi]

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  > 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