use to have the same issue with you,solved by update HBase coprocessor,here is the official guide: http://kylin.apache.org/docs15/howto/howto_update_coprocessor.html
----------------------------------------------------- 赵天烁 Kevin Zhao [email protected] 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology & Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com -----邮件原件----- 发件人: Li Yang [mailto:[email protected]] 发送时间: 2016年6月13日 16:41 收件人: [email protected] 抄送: 吴钰彬 <[email protected]> 主题: Re: Re: Timeout visiting cube! I suspect something went wrong when creating the HTable and registering the coprocessor. However without logs, I'm not sure. On Fri, Jun 10, 2016 at 12:27 PM, [email protected] <[email protected]> wrote: > version infos ： > > Kylin 1.5.1 > HBase 1.1.4 for apache package。 > > What may be the problem? > > > > [email protected] > > 发件人： Li Yang > 发送时间： 2016-06-08 17:24 > 收件人： dev > 抄送： 吴钰彬 > 主题： Re: 答复: Timeout visiting cube! > There must be something wrong during cube build. If you are using > 1.5.2, there is a diagnosis tool that extract useful info that helps diagnose. > > On Wed, Jun 8, 2016 at 10:07 AM, ShaoFeng Shi <[email protected]> > wrote: > > > Hi Gao, what's your Kylin version and HBase version? > > > > 2016-06-08 9:20 GMT+08:00 [email protected] <[email protected]>: > > > > > 你好： > > > 我并不是真的超时，而是kylin抛异常了，异常如下： > > > 每次构建之后都会有这个问题，必须去$KYLIN_HOME/bin/kylin.sh > > > org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI > > > $KYLIN_HOME/lib/kylin-coprocessor-*.jar all才行 > > > > > > Caused by: org.apache.hadoop.hbase.exceptions.UnknownProtocolException: > > > org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No > > registered > > > coprocessor service found for name CubeVisitService in region > > > KYLIN_NDT1PYHI7P,,1465298389410.ebf41fc2bd7ac44fb2f0b14a2146ecae. > > > at > > > > > > org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java: > 7457) > > > at > > > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion > (RSRpcServices.java:1891) > > > at > > > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcSe > rvices.java:1873) > > > at > > > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$ > 2.callBlockingMethod(ClientProtos.java:32389) > > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117) > > > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104) > > > at > > > > > > org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java: > 133) > > > at > > > org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108 > > > ) at java.lang.Thread.run(Thread.java:745) > > > > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > > > at > > > > > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructo > rAccessorImpl.java:57) > > > at > > > > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCo > nstructorAccessorImpl.java:45) > > > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > > > at > > > > > > org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteExcep > tion.java:106) > > > at > > > > > > org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteExce > ption.java:95) > > > at > > > > > > org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(Proto > bufUtil.java:325) > > > at > > > > > > org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil > .java:1620) > > > at > > > > > > org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionC > oprocessorRpcChannel.java:92) > > > at > > > > > > org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionC > oprocessorRpcChannel.java:89) > > > at > > > > > > org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRe > tryingCaller.java:126) > > > at > > > > > > org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecServic > e(RegionCoprocessorRpcChannel.java:95) > > > at > > > > > > org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(Coprocess > orRpcChannel.java:56) > > > at > > > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated. > CubeVisitProtos$CubeVisitService$Stub.visitCube(CubeVisitProtos.java:3 > 861) > > > at > > > > > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(Cub > eHBaseEndpointRPC.java:362) > > > at > > > > > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(Cub > eHBaseEndpointRPC.java:358) > > > at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1751) > > > ... 4 more > > > Caused by: > > > > > > org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.exceptions.UnknownProtocolException): > > > org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No > > registered > > > coprocessor service found for name CubeVisitService in region > > > KYLIN_NDT1PYHI7P,,1465298389410.ebf41fc2bd7ac44fb2f0b14a2146ecae. > > > at > > > > > > org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java: > 7457) > > > at > > > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion > (RSRpcServices.java:1891) > > > at > > > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcSe > rvices.java:1873) > > > at > > > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$ > 2.callBlockingMethod(ClientProtos.java:32389) > > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2117) > > > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:104) > > > at > > > > > > org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java: > 133) > > > at > > > org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108 > > > ) at java.lang.Thread.run(Thread.java:745) > > > > > > at > > org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:12 > > 35) > > > at > > > > > > org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(Abstr > actRpcClient.java:222) > > > at > > > > > > org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplem > entation.callBlockingMethod(AbstractRpcClient.java:323) > > > at > > > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$ > BlockingStub.execService(ClientProtos.java:32855) > > > at > > > > > > org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil > .java:1616) > > > ... 13 more > > > > > > > > > > > > [email protected] > > > > > > 发件人： 吴钰彬 > > > 发送时间： 2016-06-08 09:10 > > > 收件人： [email protected] > > > 主题： 答复: Timeout visiting cube! > > > > > > 我不是KYLIN的开发，一样是用户，我之前也碰到过这个问题 > > > > > > 你可以尝试在kylin.profile的配置文件里面添加下面的参数，默认值是1，我这边是改成3倍 > > > > > > kylin.query.cube.visit.timeout.times=3 > > > #default is 1 > > > > > > -----邮件原件----- > > > 发件人: [email protected] [mailto:[email protected]] > > > 发送时间: 2016年6月7日 20:39 > > > 收件人: dev <[email protected]> > > > 主题: Timeout visiting cube! > > > > > > > > > 你好： > > > 每次当我build完 cube之后，都必须去更新 Update HBase Coprocessor > > > 否则查询的时候便会报错，如下：Error while executing SQL "SELECT * FROM > > > YOOSHU_BID_REQUEST_VIEWS LIMIT 10": Timeout visiting cube! > > > > > > 当执行完$KYLIN_HOME/bin/kylin.sh > > > org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI > > > $KYLIN_HOME/lib/kylin-coprocessor-*.jar all > > > 之后，便可以正常查询。 > > > 但是下次build之后，又会出现这个问题。 > > > > > > 应该如何解决的啊？ > > > > > > > > > > > > > > > [email protected] > > > > > > > > > > > -- > > Best regards, > > > > Shaofeng Shi > > >
