??????????????????????????????????????
2017-04-28 15:22:09,556 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
plan.RelOptPlanner:856 : Cheapest plan:
OLAPToEnumerableConverter: rowcount = 10.0, cumulative cost = {1.0E100 rows,
12.55 cpu, 0.0 io}, id = 77
OLAPLimitRel(fetch=[50000]): rowcount = 10.0, cumulative cost = {12.0625
rows, 12.55 cpu, 0.0 io}, id = 76
OLAPProjectRel(EXPR$0=[$1], FDZ=[$0]): rowcount = 10.0, cumulative cost =
{11.5625 rows, 12.05 cpu, 0.0 io}, id = 75
OLAPAggregateRel(group=[{0}], EXPR$0=[COUNT()]): rowcount = 10.0,
cumulative cost = {10.5625 rows, 10.05 cpu, 0.0 io}, id = 74
OLAPProjectRel(FDZ=[$3]): rowcount = 100.0, cumulative cost = {10.0
rows, 10.05 cpu, 0.0 io}, id = 73
OLAPTableScan(table=[[DEFAULT, OPTIONACTION]], fields=[[0, 1, 2, 3,
4, 5, 6, 7]]): rowcount = 100.0, cumulative cost = {5.0 rows, 5.050000000000001
cpu, 0.0 io}, id = 0
2017-04-28 15:22:09,557 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
plan.RelOptPlanner:859 : Provenance:
OLAPToEnumerableConverter#77
direct
rel#34:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#32:Subset#4.OLAP.[])
call#171 rule [OLAPToEnumerableConverterRule]
rel#32:Subset#4.OLAP.[]
subset rel#32:Subset#4.OLAP.[]
rel#31:OLAPLimitRel.OLAP.[](input=rel#30:Subset#3.OLAP.[],fetch=50000)
call#129 rule [OLAPLimitRule]
rel#12:LogicalSort.NONE.[](input=rel#11:Subset#3.NONE.[],fetch=50000)
no parent
OLAPLimitRel#76
direct
rel#31 (see above)
OLAPProjectRel#75
direct
rel#48:OLAPProjectRel.OLAP.[](input=rel#47:Subset#2.OLAP.[],EXPR$0=$1,FDZ=$0)
call#103 rule [OLAPProjectRule]
rel#10:LogicalProject.NONE.[](input=rel#9:Subset#2.NONE.[],EXPR$0=$1,FDZ=$0)
no parent
OLAPAggregateRel#74
direct
rel#51:OLAPAggregateRel.OLAP.[](input=rel#50:Subset#1.OLAP.[],group={0},EXPR$0=COUNT())
call#71 rule [OLAPAggregateRule]
rel#8:LogicalAggregate.NONE.[](input=rel#7:Subset#1.NONE.[],group={0},EXPR$0=COUNT())
no parent
OLAPProjectRel#73
direct
rel#52:OLAPProjectRel.OLAP.[](input=rel#5:Subset#0.OLAP.[],FDZ=$3)
call#44 rule [OLAPProjectRule]
rel#6:LogicalProject.NONE.[](input=rel#5:Subset#0.OLAP.[],FDZ=$3)
no parent
rel#0:OLAPTableScan.OLAP.[](table=[DEFAULT, OPTIONACTION],fields=[0, 1, 2, 3,
4, 5, 6, 7])
no parent
2017-04-28 15:22:09,558 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
plan.RelOptPlanner:361 : For final plan, using
rel#87:OLAPToEnumerableConverter.ENUMERABLE.[](input=HepRelVertex#86)
2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
plan.RelOptPlanner:361 : For final plan, using
rel#85:OLAPLimitRel.OLAP.[](input=HepRelVertex#84,fetch=50000)
2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
plan.RelOptPlanner:361 : For final plan, using
rel#83:OLAPProjectRel.OLAP.[](input=HepRelVertex#82,EXPR$0=$1,FDZ=$0)
2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
plan.RelOptPlanner:361 : For final plan, using
rel#81:OLAPAggregateRel.OLAP.[](input=HepRelVertex#80,group={0},EXPR$0=COUNT())
2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
plan.RelOptPlanner:361 : For final plan, using
rel#79:OLAPProjectRel.OLAP.[](input=HepRelVertex#78,FDZ=$3)
2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
plan.RelOptPlanner:361 : For final plan, using
rel#0:OLAPTableScan.OLAP.[](table=[DEFAULT, OPTIONACTION],fields=[0, 1, 2, 3,
4, 5, 6, 7])
2017-04-28 15:22:09,561 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
prepare.Prepare:154 : Plan after physical tweaks: OLAPToEnumerableConverter:
rowcount = 10.0, cumulative cost = {1.0E100 rows, 12.55 cpu, 0.0 io}, id = 87
OLAPLimitRel(fetch=[50000]): rowcount = 10.0, cumulative cost = {12.0625
rows, 12.55 cpu, 0.0 io}, id = 85
OLAPProjectRel(EXPR$0=[$1], FDZ=[$0]): rowcount = 10.0, cumulative cost =
{11.5625 rows, 12.05 cpu, 0.0 io}, id = 83
OLAPAggregateRel(group=[{0}], EXPR$0=[COUNT()]): rowcount = 10.0,
cumulative cost = {10.5625 rows, 10.05 cpu, 0.0 io}, id = 81
OLAPProjectRel(FDZ=[$3]): rowcount = 100.0, cumulative cost = {10.0
rows, 10.05 cpu, 0.0 io}, id = 79
OLAPTableScan(table=[[DEFAULT, OPTIONACTION]], fields=[[0, 1, 2, 3,
4, 5, 6, 7]]): rowcount = 100.0, cumulative cost = {5.0 rows, 5.050000000000001
cpu, 0.0 io}, id = 0
2017-04-28 15:22:09,575 INFO [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
routing.QueryRouter:48 : The project manager's reference is
org.apache.kylin.metadata.project.ProjectManager@192989fd
2017-04-28 15:22:09,585 INFO [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
routing.QueryRouter:60 : Find candidates by table DEFAULT.OPTIONACTION and
project=OPTIONACTION : CUBE[name=aaabbb]
2017-04-28 15:22:09,589 INFO [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
realizations before: [aaabbb(CUBE)], realizations after: [aaabbb(CUBE)]
2017-04-28 15:22:09,594 INFO [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
realizations before: [aaabbb(CUBE)], realizations after: [aaabbb(CUBE)]
2017-04-28 15:22:09,594 INFO [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
rules.RealizationSortRule:40 : CUBE[name=aaabbb] priority 1 cost 93.
2017-04-28 15:22:09,595 INFO [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
routing.QueryRouter:51 : Applying rule: class
org.apache.kylin.query.routing.rules.RealizationSortRule, realizations before:
[aaabbb(CUBE)], realizations after: [aaabbb(CUBE)]
2017-04-28 15:22:09,595 INFO [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
routing.QueryRouter:72 : The realizations remaining: [aaabbb(CUBE)] And the
final chosen one is the first one
2017-04-28 15:22:09,767 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
enumerator.OLAPEnumerator:100 : query storage...
2017-04-28 15:22:09,778 ERROR [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
service.QueryService:372 : Exception when execute sql
java.sql.SQLException: Error while executing SQL "select count(*),fdz from
optionaction group by fdz
LIMIT 50000": null
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:147)
at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:208)
at
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:538)
at
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:452)
at
org.apache.kylin.rest.service.QueryService.query(QueryService.java:151)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:354)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
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:483)
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:150)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.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(SecurityContextPersistenceFilter.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: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:745)
Caused by: java.util.NoSuchElementException
at java.util.ArrayList$Itr.next(ArrayList.java:854)
at java.util.Collections.min(Collections.java:635)
at
org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(Cuboid.java:217)
at
org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(Cuboid.java:141)
at org.apache.kylin.cube.cuboid.Cuboid.findById(Cuboid.java:83)
at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.java:68)
at
org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:104)
at
org.apache.kylin.query.enumerator.OLAPEnumerator.queryStorage(OLAPEnumerator.java:114)
at
org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:65)
at Baz$1$1.moveNext(Unknown Source)
at
org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:823)
at
org.apache.calcite.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:758)
at
org.apache.calcite.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:302)
at Baz.bind(Unknown Source)
at
org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:327)
at
org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:282)
at
org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(CalciteMetaImpl.java:553)
at
org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:544)
at
org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:187)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:65)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:44)
at
org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:605)
at
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:599)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:613)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:139)
... 77 more
------------------ ???????? ------------------
??????: "35925138";<[email protected]>;
????????: 2017??4??28??(??????) ????1:16
??????: "dev"<[email protected]>;
????: ??????????: ??????????: Error while executing SQL "select count(*) as
nums,courseid from optionaction group by courseid LIMIT 50000": null
??????????????????????????????????????????
2017-04-28 13:11:23,614 ERROR [http-bio-7070-exec-10]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Failed to create
download for diagnosis. java.net.SocketException: Broken pipe
at
org.apache.kylin.rest.controller.DiagnosisController.setDownloadResponse(DiagnosisController.java:117)
at
org.apache.kylin.rest.controller.DiagnosisController.dumpProjectDiagnosisInfo(DiagnosisController.java:88)
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:483)
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.doGet(FrameworkServlet.java:842)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
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:150)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.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(SecurityContextPersistenceFilter.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: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:745)
Caused by: org.apache.catalina.connector.ClientAbortException:
java.net.SocketException: Broken pipe
at
org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:407)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:480)
at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:310)
at
org.apache.catalina.connector.OutputBuffer.writeByte(OutputBuffer.java:451)
at
org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:77)
at
org.springframework.security.web.context.SaveContextOnUpdateOrErrorResponseWrapper$SaveContextServletOutputStream.write(SaveContextOnUpdateOrErrorResponseWrapper.java:203)
at java.io.OutputStream.write(OutputStream.java:116)
at org.apache.commons.io.IOUtils.copyLarge(IOUtils.java:2147)
at org.apache.commons.io.IOUtils.copy(IOUtils.java:2102)
at org.apache.commons.io.IOUtils.copyLarge(IOUtils.java:2123)
at
org.apache.kylin.rest.controller.DiagnosisController.setDownloadResponse(DiagnosisController.java:114)
... 72 more
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at
org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:215)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:480)
at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:366)
at
org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:240)
at
org.apache.coyote.http11.filters.IdentityOutputFilter.doWrite(IdentityOutputFilter.java:84)
at
org.apache.coyote.http11.AbstractOutputBuffer.doWrite(AbstractOutputBuffer.java:192)
at org.apache.coyote.Response.doWrite(Response.java:499)
at
org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:402)
... 82 more
2017-04-28 13:11:23,616 ERROR [http-bio-7070-exec-10]
annotation.ExceptionHandlerExceptionResolver:324 : Failed to invoke
@ExceptionHandler method: org.apache.kylin.rest.response.ErrorResponse
org.apache.kylin.rest.controller.BasicController.handleError(javax.servlet.http.HttpServletRequest,java.lang.Exception)
org.apache.catalina.connector.ClientAbortException: java.net.SocketException:
Broken pipe
at
org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:407)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:480)
at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:310)
at
org.apache.catalina.connector.OutputBuffer.writeByte(OutputBuffer.java:451)
at
org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:77)
at
org.springframework.security.web.context.SaveContextOnUpdateOrErrorResponseWrapper$SaveContextServletOutputStream.write(SaveContextOnUpdateOrErrorResponseWrapper.java:203)
at java.io.OutputStream.write(OutputStream.java:116)
at
com.fasterxml.jackson.core.json.UTF8JsonGenerator._flushBuffer(UTF8JsonGenerator.java:2003)
at
com.fasterxml.jackson.core.json.UTF8JsonGenerator.flush(UTF8JsonGenerator.java:1019)
at
com.fasterxml.jackson.databind.ObjectMapper.writeValue(ObjectMapper.java:2385)
at
org.springframework.http.converter.json.MappingJackson2HttpMessageConverter.writeInternal(MappingJackson2HttpMessageConverter.java:204)
at
org.springframework.http.converter.AbstractHttpMessageConverter.write(AbstractHttpMessageConverter.java:180)
at
org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:168)
at
org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:113)
at
org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.handleReturnValue(RequestResponseBodyMethodProcessor.java:188)
at
org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:69)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:122)
at
org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(ExceptionHandlerExceptionResolver.java:320)
at
org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException(AbstractHandlerMethodExceptionResolver.java:60)
at
org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException(AbstractHandlerExceptionResolver.java:136)
at
org.springframework.web.servlet.DispatcherServlet.processHandlerException(DispatcherServlet.java:1156)
at
org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:994)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)
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.doGet(FrameworkServlet.java:842)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
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:150)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.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(SecurityContextPersistenceFilter.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: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:745)
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at
org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:215)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:480)
at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:366)
at
org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:240)
at
org.apache.coyote.http11.filters.IdentityOutputFilter.doWrite(IdentityOutputFilter.java:84)
at
org.apache.coyote.http11.AbstractOutputBuffer.doWrite(AbstractOutputBuffer.java:192)
at org.apache.coyote.Response.doWrite(Response.java:499)
at
org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:402)
... 82 more
------------------ ???????? ------------------
??????: "roger shi";<[email protected]>;
????????: 2017??4??28??(??????) ????11:25
??????: "dev"<[email protected]>;
????: ????: ??????????: Error while executing SQL "select count(*) as
nums,courseid from optionaction group by courseid LIMIT 50000": null
Cannot figure out the root cause according to the info provided. Would you
please follow the following guide to generate diagnosis package?
http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/
Apache Kylin | Diagnosis Tool
Introduction<http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/>
kylin.apache.org
Diagnosis Tool Introduction. Jun 10, 2016 ?6?1 Dong Li. Introduction. Since
Apache Kylin 1.5.2, there??s a diagnosis tool on Web UI, which aims to help
Kylin admins ...
________________________________
??????: 35925138 <[email protected]>
????????: 2017??4??28?? 10:12:17
??????: dev
????: ??????????: Error while executing SQL "select count(*) as nums,courseid
from optionaction group by courseid LIMIT 50000": null
??????
????????????????
2017-04-28 10:08:47,001 ERROR [http-bio-7070-exec-6]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Error while executing
SQL "select count(*) as nums,fdz from optionaction group by fdz LIMIT 50000":
null
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:389)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
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:483)
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(DefaultLoginPageGeneratingFilter.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(SecurityContextPersistenceFilter.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: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:745)
cube ??json??????
{ "uuid": "9bc80d90-4bf2-4ae5-b3ee-dd8a563fcefd", "last_modified":
1493263501742, "version": "1.6.0", "name": "aaabbb", "model_name":
"optionaction", "description": "", "null_string": null, "dimensions": [
{ "name": "ACTION_TIME", "table": "DEFAULT.OPTIONACTION",
"column": "ACTION_TIME", "derived": null }, { "name":
"AGENTID", "table": "DEFAULT.OPTIONACTION", "column": "AGENTID",
"derived": null }, { "name": "COURSEID", "table":
"DEFAULT.OPTIONACTION", "column": "COURSEID", "derived": null
}, { "name": "COURSEVERSION", "table": "DEFAULT.OPTIONACTION",
"column": "COURSEVERSION", "derived": null }, {
"name": "IP", "table": "DEFAULT.OPTIONACTION", "column": "IP",
"derived": null }, { "name": "DAY_TIME", "table":
"DEFAULT.OPTIONACTION", "column": "DAY_TIME", "derived": null
}, { "name": "HOUR_TIME", "table": "DEFAULT.OPTIONACTION",
"column": "HOUR_TIME", "derived": null }, { "name":
"MONTH_TIME", "table": "DEFAULT.OPTIONACTION", "column":
"MONTH_TIME", "derived": null }, { "name": "YEAR_TIME",
"table": "DEFAULT.OPTIONACTION", "column": "YEAR_TIME",
"derived": null }, { "name": "RESTYPE", "table":
"DEFAULT.OPTIONACTION", "column": "RESTYPE", "derived": null },
{ "name": "RESID", "table": "DEFAULT.OPTIONACTION",
"column": "RESID", "derived": null }, { "name": "USERID",
"table": "DEFAULT.OPTIONACTION", "column": "USERID", "derived":
null }, { "name": "SEX", "table": "DEFAULT.OPTIONACTION",
"column": "SEX", "derived": null }, { "name": "AGE",
"table": "DEFAULT.OPTIONACTION", "column": "AGE", "derived":
null }, { "name": "RX_PICI", "table":
"DEFAULT.OPTIONACTION", "column": "RX_PICI", "derived": null },
{ "name": "STUDYKIND", "table": "DEFAULT.OPTIONACTION",
"column": "STUDYKIND", "derived": null }, { "name":
"SUBJECT", "table": "DEFAULT.OPTIONACTION", "column": "SUBJECT",
"derived": null }, { "name": "FDZ", "table":
"DEFAULT.OPTIONACTION", "column": "FDZ", "derived": null },
{ "name": "PROVINCENAME", "table": "DEFAULT.OPTIONACTION",
"column": "PROVINCENAME", "derived": null }, { "name":
"CITYNAME", "table": "DEFAULT.OPTIONACTION", "column": "CITYNAME",
"derived": null } ], "measures": [ { "name": "_COUNT_",
"function": { "expression": "COUNT", "parameter": {
"type": "constant", "value": "1", "next_parameter": null
}, "returntype": "bigint" },
"dependent_measure_ref": null } ], "dictionaries": [], "rowkey": {
"rowkey_columns": [ { "column": "ACTION_TIME",
"encoding": "time", "isShardBy": false }, {
"column": "AGENTID", "encoding": "dict", "isShardBy": false
}, { "column": "COURSEID", "encoding": "dict",
"isShardBy": false }, { "column": "COURSEVERSION",
"encoding": "dict", "isShardBy": false }, {
"column": "IP", "encoding": "dict", "isShardBy": false },
{ "column": "DAY_TIME", "encoding": "dict",
"isShardBy": false }, { "column": "HOUR_TIME",
"encoding": "dict", "isShardBy": false }, {
"column": "MONTH_TIME", "encoding": "dict", "isShardBy": false
}, { "column": "YEAR_TIME", "encoding": "dict",
"isShardBy": false }, { "column": "RESTYPE",
"encoding": "dict", "isShardBy": false }, {
"column": "RESID", "encoding": "dict", "isShardBy": false
}, { "column": "USERID", "encoding": "dict",
"isShardBy": false }, { "column": "SEX",
"encoding": "dict", "isShardBy": false }, {
"column": "AGE", "encoding": "dict", "isShardBy": false
}, { "column": "RX_PICI", "encoding": "dict",
"isShardBy": false }, { "column": "STUDYKIND",
"encoding": "dict", "isShardBy": false }, {
"column": "SUBJECT", "encoding": "dict", "isShardBy": false
}, { "column": "FDZ", "encoding": "dict",
"isShardBy": false }, { "column": "PROVINCENAME",
"encoding": "dict", "isShardBy": false }, {
"column": "CITYNAME", "encoding": "dict", "isShardBy": false
} ] }, "hbase_mapping": { "column_family": [ {
"name": "F1", "columns": [ { "qualifier": "M",
"measure_refs": [ "_COUNT_" ] }
] } ] }, "aggregation_groups": [ { "includes": [
"ACTION_TIME", "AGENTID", "COURSEID",
"COURSEVERSION", "YEAR_TIME", "RESTYPE", "RESID",
"USERID", "FDZ" ], "select_rule": {
"hierarchy_dims": [], "mandatory_dims": [ "ACTION_TIME",
"AGENTID", "COURSEID", "COURSEVERSION",
"YEAR_TIME", "RESID", "USERID", "FDZ",
"RESTYPE" ], "joint_dims": [] } } ], "signature":
"OAQ2Qt6vo4CWuAstfTJ4qg==", "notify_list": [], "status_need_notify": [
"ERROR", "SUCCEED" ], "partition_date_start": 1491436800000,
"partition_date_end": 3153600000000, "auto_merge_time_ranges": [
604800000, 2419200000 ], "retention_range": 0, "engine_type": 2,
"storage_type": 2, "override_kylin_properties": {} }
------------------ ???????? ------------------
??????: "roger shi";<[email protected]>;
????????: 2017??4??27??(??????) ????1:46
??????: "dev"<[email protected]>;
????: ????: Error while executing SQL "select count(*) as nums,courseid from
optionaction group by courseid LIMIT 50000": null
More information is required to answer your question. Would you mind to attach
kylin log and related metadata json?
________________________________
??????: 35925138 <[email protected]>
????????: 2017??4??27?? 11:32:44
??????: dev
????: Error while executing SQL "select count(*) as nums,courseid from
optionaction group by courseid LIMIT 50000": null
?????? ??????????cube????????????????????????????????sql??????????null
????????????????????????????????????cube??
????kylin??????1.6.0
