Hi Kang-sen, In this TopN cube, as "IMSIID" has already been defined in the TopN, it doesn't need to appear on the dimension. Did you try to not using it as a dimension?
Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: [email protected] Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] Lu, Kang-Sen <[email protected]> 于2019年6月20日周四 下午9:36写道： > I am running kylin 2.6.2. > > > > The following query failed with > “org.apache.kylin.rest.exception.InternalErrorException: coprocessor > timeout after scanning 59600 rows” error. > > > > We have a data model vl_aggs_model. > > We have two cube created: vl_aggs_cube and vl_aggs_topn_cube. > > > > In the vl_aggs_topn_cube, we configured measures: > > SUM(SUCC_CALL_FLG), and > > TOP_N(SUM(SUCC_CALL_FLG), GROUP-BY: IMSIID) > > > > We have only one agg-group: {IMSIID, THEDATE, THEHOUR, REGION_3}. > > > > The query is as follows: > > > > select IMSIID, sum(succ_call_flg) > > from a_vl_hourly_v > > JOIN D_CELL_V ON a_vl_hourly_v.cell_key = D_CELL_V.cell_key where > THEDATE='20190509' and THEHOUR='00' and REGION_3 = 'MP' GROUP BY IMSIID > ORDER BY sum(succ_call_flg) DESC LIMIT 100 ; > > > > The kylin selected vl_aggs_tpn_cube for this query. > > > > Here is the kylin.log showing what happened to the query time out. I hope > someone can figure out what went wrong. > > > > ===================== kylin.log =============== > > > > 2019-06-20 09:14:55,131 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] routing.QueryRouter:51 : Applying > rule: class org.apache.kylin.query.routing.rules.RealizationSortRule, > realizations before: > [CUBE[name=vl_aggs_cube],CUBE[name=vl_aggs_topn_cube_ksl]], realizations > after: [CUBE[name=vl_aggs_topn_cube_ksl],CUBE[name=vl_aggs_cube]] > > 2019-06-20 09:14:55,132 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] routing.QueryRouter:75 : The > realizations remaining: > [CUBE[name=vl_aggs_topn_cube_ksl],CUBE[name=vl_aggs_cube]],and the final > chosen one for current olap context 0 is CUBE[name=vl_aggs_topn_cube_ksl] > > 2019-06-20 09:14:55,211 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] enumerator.OLAPEnumerator:105 : > query storage... > > 2019-06-20 09:14:55,212 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] topn.TopNMeasureType:453 : > Rewrite function FunctionDesc [expression=SUM, > parameter=ZETTICSDW.A_VL_HOURLY_V.SUCC_CALL_FLG, returnType=bigint] to > FunctionDesc [expression=TOP_N, > parameter=ZETTICSDW.A_VL_HOURLY_V.SUCC_CALL_FLG,ZETTICSDW.A_VL_HOURLY_V.IMSIID, > returnType=topn(500,4)] > > 2019-06-20 09:14:55,213 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] > gtrecord.GTCubeStorageQueryBase:331 : Need storage aggregation > > 2019-06-20 09:14:55,213 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] > gtrecord.GTCubeStorageQueryBase:562 : exactAggregation is false because > need storage aggregation > > 2019-06-20 09:14:55,213 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] > gtrecord.GTCubeStorageQueryBase:309 : Filter column set for query: %s > > 2019-06-20 09:14:55,214 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] > gtrecord.GTCubeStorageQueryBase:318 : Filter mask is: {0} > > 2019-06-20 09:14:55,214 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] > gtrecord.GTCubeStorageQueryBase:461 : storageLimitLevel set to NO_LIMIT > because the query has order by > > 2019-06-20 09:14:55,215 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] > gtrecord.GTCubeStorageQueryBase:189 : Cuboid identified: > cube=vl_aggs_topn_cube_ksl, cuboidId=30, groupsD=[], > filterD=[ZETTICSDW.A_VL_HOURLY_V.THEHOUR, ZETTICSDW.A_VL_HOURLY_V.THEDATE, > ZETTICSDW.D_CELL_V.REGION_3], limitPushdown=2147483647, > limitLevel=NO_LIMIT, storageAggr=true > > 2019-06-20 09:14:55,215 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] common.SegmentPruner:98 : Pruner > passed on segment vl_aggs_topn_cube_ksl[20190509000000_20190509010000] > > 2019-06-20 09:14:55,216 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] gtrecord.CubeSegmentScanner:60 : > Init CubeSegmentScanner for segment 20190509000000_20190509010000 > > 2019-06-20 09:14:55,437 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] hbase.HBaseConnection:180 : Using > the working dir FS for HBase: hdfs://hadoop1.zettics.com:8020 > > 2019-06-20 09:14:55,438 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] v2.CubeHBaseRPC:315 : > hbase.rpc.timeout = 90000 ms, use 81000 ms as timeout for coprocessor > > 2019-06-20 09:14:55,440 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] v2.CubeHBaseEndpointRPC:164 : > Serialized scanRequestBytes 1056 bytes, rawScanBytesString 84 bytes > > 2019-06-20 09:14:55,440 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] v2.CubeHBaseEndpointRPC:167 : The > scan 4a26ddd7 for segment > vl_aggs_topn_cube_ksl[20190509000000_20190509010000] is as below with 1 > separate raw scans, shard part of start/end key is set to 0 > > 2019-06-20 09:14:55,442 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] v2.CubeHBaseRPC:288 : Visiting > hbase table ANOVA_KYLIN_26x_E6IAAG1TCV: cuboid require post aggregation, > from 28 to 30 Start: > \x00\x00\x00\x00\x00\x00\x00\x00\x00\x1E\x00\x00\x00\x00\x00\x00 > (\x00\x00\x00\x00\x00\x00\x00\x00\x00\x1E\x00\x00\x00\x00\x00\x00) Stop: > \x00\x00\x00\x00\x00\x00\x00\x00\x00\x1E\x00\x00\x00\xFF\xFF\xFF\x00 > (\x00\x00\x00\x00\x00\x00\x00\x00\x00\x1E\x00\x00\x00\xFF\xFF\xFF\x00) > Fuzzy key counts: 1. Fuzzy keys : > \x00\x00\x00\x00\x00\x00\x00\x00\x00\x1E\x00\x00\x00\x00\x00\x00 > \x01\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x01\x01\x01; > > 2019-06-20 09:14:55,442 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] v2.CubeHBaseEndpointRPC:174 : > Submitting rpc to 1 shards starting from shard 0, scan range count 1 > > 2019-06-20 09:14:55,442 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] v2.CubeHBaseEndpointRPC:220 : > Submitting rpc to 1 shards starting from shard 0, scan range count 1 > > 2019-06-20 09:14:55,443 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] common.KylinConfig:328 : > KYLIN_CONF property was not set, will seek KYLIN_HOME env variable > > 2019-06-20 09:14:55,444 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] common.KylinConfig:334 : Use > KYLIN_HOME=/home/zettics/kylin/apache-kylin > > 2019-06-20 09:14:55,446 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] > gtrecord.SegmentCubeTupleIterator:95 : Using GTStreamAggregateScanner to > pre-aggregate storage partition. > > 2019-06-20 09:14:55,447 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] > gtrecord.SequentialCubeTupleIterator:78 : Using Iterators.concat to merge > segment results > > 2019-06-20 09:14:55,448 DEBUG [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] enumerator.OLAPEnumerator:117 : > return TupleIterator... > > 2019-06-20 09:14:55,450 INFO [kylin-coproc--pool3-t13] > v2.CubeHBaseEndpointRPC:277 : Query-8f5a0b10-331f-8f3a-81b8-b248ab83a401: > send request to the init region server hadoop10.zettics.com on table > ANOVA_KYLIN_26x_E6IAAG1TCV > > 2019-06-20 09:15:18,382 INFO [BadQueryDetector] > service.BadQueryDetector:147 : Detect bad query. > > 2019-06-20 09:15:19,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > 2019-06-20 09:15:49,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > 2019-06-20 09:16:16,326 INFO [kylin-coproc--pool3-t13] > v2.CubeHBaseEndpointRPC:344 : <sub-thread for Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401 GTScanRequest 4a26ddd7>Endpoint RPC > returned from HTable ANOVA_KYLIN_26x_E6IAAG1TCV Shard > \x41\x4E\x4F\x56\x41\x5F\x4B\x59\x4C\x49\x4E\x5F\x32\x36\x78\x5F\x45\x36\x49\x41\x41\x47\x31\x54\x43\x56\x2C\x2C\x31\x35\x36\x31\x30\x33\x35\x36\x37\x31\x32\x34\x31\x2E\x35\x65\x35\x38\x61\x38\x66\x64\x31\x63\x33\x37\x39\x36\x66\x30\x36\x34\x61\x64\x31\x37\x32\x61\x61\x36\x33\x61\x35\x33\x32\x61\x2E > on host: hadoop10.zettics.com.Total scanned row: 59600. Total scanned > bytes: 17641682. Total filtered row: 0. Total aggred row: 59600. Time > elapsed in EP: 80782(ms). Server CPU usage: 0.0958898668604005, server > physical mem left: 6.0349026304E10, server swap mem left:5.82498304E9.Etc > message: start latency: 317@103,agg done@80776,compress done@80778,server > stats done@80780, > debugGitTag:3612b4b131e112eaa271b84e9dc4a688f2c609ab;.Normal Complete: > false.Compressed row size: 8 > > 2019-06-20 09:16:16,326 ERROR [pool-11-thread-8] > v2.CubeHBaseEndpointRPC:426 : <sub-thread for Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401 GTScanRequest 4a26ddd7>Error when > visiting cubes by endpoint > > org.apache.kylin.common.exceptions.KylinTimeoutException: coprocessor > timeout after scanning 59600 rows > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC.getCoprocessorException(CubeHBaseEndpointRPC.java:505) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC.access$300(CubeHBaseEndpointRPC.java:77) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$3.update(CubeHBaseEndpointRPC.java:355) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$3.update(CubeHBaseEndpointRPC.java:323) > > at > org.apache.hadoop.hbase.client.HTable$15.call(HTable.java:1739) > > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > > at java.lang.Thread.run(Thread.java:748) > > 2019-06-20 09:16:16,462 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] util.PushDownUtil:86 : Query > failed to utilize pre-calculation, routing to other engines > > java.sql.SQLException: Error while executing SQL "select IMSIID, > sum(succ_call_flg) > > from a_vl_hourly_v > > JOIN D_CELL_V ON a_vl_hourly_v.cell_key = D_CELL_V.cell_key where > THEDATE='20190509' and THEHOUR='00' and REGION_3 = 'MP' GROUP BY IMSIID > ORDER BY sum(succ_call_flg) DESC LIMIT 100 ": coprocessor timeout after > scanning 59600 rows > > 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:156) > > at > org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218) > > at > org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:938) > > at > org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:641) > > at > org.apache.kylin.rest.service.QueryService.query(QueryService.java:208) > > at > org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:468) > > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:429) > > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367) > > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93) > > at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown > Source) > > 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:205) > > at > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) > > at > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > > 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:317) > > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) > > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) > > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > 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:331) > > at > org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) > > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) > > at > org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) > > 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:219) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) > > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) > > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) > > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) > > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) > > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > > 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.common.exceptions.KylinTimeoutException: > coprocessor timeout after scanning 59600 rows > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC.getCoprocessorException(CubeHBaseEndpointRPC.java:505) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC.access$300(CubeHBaseEndpointRPC.java:77) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$3.update(CubeHBaseEndpointRPC.java:355) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$3.update(CubeHBaseEndpointRPC.java:323) > > at > org.apache.hadoop.hbase.client.HTable$15.call(HTable.java:1739) > > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > > ... 1 more > > 2019-06-20 09:16:16,466 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] util.PushDownUtil:88 : quit > doPushDownQuery because prior exception thrown is unexpected > > 2019-06-20 09:16:16,467 ERROR [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] service.QueryService:510 : > Exception while executing query > > java.sql.SQLException: Error while executing SQL "select IMSIID, > sum(succ_call_flg) > > from a_vl_hourly_v > > JOIN D_CELL_V ON a_vl_hourly_v.cell_key = D_CELL_V.cell_key where > THEDATE='20190509' and THEHOUR='00' and REGION_3 = 'MP' GROUP BY IMSIID > ORDER BY sum(succ_call_flg) DESC LIMIT 100 ": coprocessor timeout after > scanning 59600 rows > > 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:156) > > at > org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218) > > at > org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:938) > > at > org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:641) > > at > org.apache.kylin.rest.service.QueryService.query(QueryService.java:208) > > at > org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:468) > > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:429) > > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367) > > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93) > > at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown > Source) > > 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:205) > > at > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) > > at > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > > 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:317) > > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) > > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) > > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > 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:331) > > at > org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) > > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) > > at > org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) > > 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:219) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) > > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) > > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) > > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) > > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) > > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > > 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.common.exceptions.KylinTimeoutException: > coprocessor timeout after scanning 59600 rows > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC.getCoprocessorException(CubeHBaseEndpointRPC.java:505) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC.access$300(CubeHBaseEndpointRPC.java:77) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$3.update(CubeHBaseEndpointRPC.java:355) > > at > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$3.update(CubeHBaseEndpointRPC.java:323) > > at > org.apache.hadoop.hbase.client.HTable$15.call(HTable.java:1739) > > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > > ... 1 more > > 2019-06-20 09:16:16,469 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] service.QueryService:1121 : > Processed rows for each storageContext: 0 > > 2019-06-20 09:16:16,488 INFO [Query > 8f5a0b10-331f-8f3a-81b8-b248ab83a401-805] service.QueryService:353 : > > ==========================[QUERY]=============================== > > Query Id: 8f5a0b10-331f-8f3a-81b8-b248ab83a401 > > SQL: select IMSIID, sum(succ_call_flg) > > from a_vl_hourly_v > > JOIN D_CELL_V ON a_vl_hourly_v.cell_key = D_CELL_V.cell_key where > THEDATE='20190509' and THEHOUR='00' and REGION_3 = 'MP' GROUP BY IMSIID > ORDER BY sum(succ_call_flg) DESC LIMIT 100 ; > > User: ADMIN > > Success: false > > Duration: 81.528 > > Project: Anovadata > > Realization Names: [CUBE[name=vl_aggs_topn_cube_ksl]] > > Cuboid Ids: [30] > > Total scan count: 59600 > > Total scan bytes: 17641682 > > Result row count: 0 > > Accept Partial: true > > Is Partial Result: false > > Hit Exception Cache: false > > Storage cache used: false > > Is Query Push-Down: false > > Is Prepare: false > > Trace URL: null > > Message: coprocessor timeout after scanning 59600 rows > > while executing SQL: "select IMSIID, sum(succ_call_flg) from > a_vl_hourly_v JOIN D_CELL_V ON a_vl_hourly_v.cell_key = > D_CELL_V.cell_key where THEDATE='20190509' and THEHOUR='00' and REGION_3 = > 'MP' GROUP BY IMSIID ORDER BY sum(succ_call_flg) DESC LIMIT 100" > > ==========================[QUERY]=============================== > > > > 2019-06-20 09:16:16,491 ERROR [http-bio-7070-exec-17] > controller.BasicController:63 : > > org.apache.kylin.rest.exception.InternalErrorException: coprocessor > timeout after scanning 59600 rows > > while executing SQL: "select IMSIID, sum(succ_call_flg) from > a_vl_hourly_v JOIN D_CELL_V ON a_vl_hourly_v.cell_key = > D_CELL_V.cell_key where THEDATE='20190509' and THEHOUR='00' and REGION_3 = > 'MP' GROUP BY IMSIID ORDER BY sum(succ_call_flg) DESC LIMIT 100" > > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:441) > > at > org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:367) > > at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93) > > at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown > Source) > > 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:205) > > at > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) > > at > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > > 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:317) > > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) > > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) > > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > 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:331) > > at > org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) > > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) > > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > > at > org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) > > at > org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) > > 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:219) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) > > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) > > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) > > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) > > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) > > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > > at > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > > at java.lang.Thread.run(Thread.java:748) > > 2019-06-20 09:16:18,382 INFO [BadQueryDetector] > service.BadQueryDetector:147 : Detect bad query. > > 2019-06-20 09:16:19,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > 2019-06-20 09:16:49,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > 2019-06-20 09:17:13,969 INFO [timeline] > timeline.HadoopTimelineMetricsSink:278 : No live collector to send metrics > to. Metrics to be sent will be discarded. This message will be skipped for > the next 20 times. > > 2019-06-20 09:17:18,383 INFO [BadQueryDetector] > service.BadQueryDetector:147 : Detect bad query. > > 2019-06-20 09:17:19,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > 2019-06-20 09:17:49,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > 2019-06-20 09:18:18,384 INFO [BadQueryDetector] > service.BadQueryDetector:147 : Detect bad query. > > 2019-06-20 09:18:19,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > 2019-06-20 09:18:49,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > 2019-06-20 09:19:18,385 INFO [BadQueryDetector] > service.BadQueryDetector:147 : Detect bad query. > > 2019-06-20 09:19:19,593 INFO [FetcherRunner 382430485-57] > threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 > actual running, 0 stopped, 0 ready, 73 already succeed, 20 error, 0 > discarded, 0 others > > > > > > Thanks. > > > > Kang-sen > > > ------------------------------ > Notice: This e-mail together with any attachments may contain information > of Ribbon Communications Inc. that is confidential and/or proprietary for > the sole use of the intended recipient. Any review, disclosure, reliance or > distribution by others or forwarding without express permission is strictly > prohibited. If you are not the intended recipient, please notify the sender > immediately and then delete all copies, including any attachments. > ------------------------------ >
