Hi Gaolv, Did you compare the difference of the HTable before and after running " org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI"?
You can build a new segment, and then describe the table in hbase shell; and then run the DeployCoprocessorCLI, then describe it again to see whether there is change in the table's metadata. I'm wondering whether Kylin still uses the old coprocessor for a newly created table. 2016-06-13 18:00 GMT+08:00 赵天烁 <zhaotians...@meizu.com>: > 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 > zhaotians...@meizu.com > > 珠海市魅族科技有限公司 > MEIZU Technology Co., Ltd. > 广东省珠海市科技创新海岸魅族科技楼 > MEIZU Tech Bldg., Technology & Innovation Coast > Zhuhai, 519085, Guangdong, China > > > meizu.com > > > > > -----邮件原件----- > 发件人: Li Yang [mailto:liy...@apache.org] > 发送时间: 2016年6月13日 16:41 > 收件人: dev@kylin.apache.org > 抄送: 吴钰彬 <wuyu...@baixing.com> > 主题: 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, gaolv123...@163.com <gaolv123...@163.com > > > wrote: > > > version infos : > > > > Kylin 1.5.1 > > HBase 1.1.4 for apache package。 > > > > What may be the problem? > > > > > > > > gaolv123...@163.com > > > > 发件人: 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 <shaofeng...@apache.org> > > wrote: > > > > > Hi Gao, what's your Kylin version and HBase version? > > > > > > 2016-06-08 9:20 GMT+08:00 gaolv123...@163.com <gaolv123...@163.com>: > > > > > > > 你好: > > > > 我并不是真的超时,而是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 > > > > > > > > > > > > > > > > gaolv123...@163.com > > > > > > > > 发件人: 吴钰彬 > > > > 发送时间: 2016-06-08 09:10 > > > > 收件人: gaolv123...@163.com > > > > 主题: 答复: Timeout visiting cube! > > > > > > > > 我不是KYLIN的开发,一样是用户,我之前也碰到过这个问题 > > > > > > > > 你可以尝试在kylin.profile的配置文件里面添加下面的参数,默认值是1,我这边是改成3倍 > > > > > > > > kylin.query.cube.visit.timeout.times=3 > > > > #default is 1 > > > > > > > > -----邮件原件----- > > > > 发件人: gaolv123...@163.com [mailto:gaolv123...@163.com] > > > > 发送时间: 2016年6月7日 20:39 > > > > 收件人: dev <dev@kylin.apache.org> > > > > 主题: 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之后,又会出现这个问题。 > > > > > > > > 应该如何解决的啊? > > > > > > > > > > > > > > > > > > > > gaolv123...@163.com > > > > > > > > > > > > > > > > -- > > > Best regards, > > > > > > Shaofeng Shi > > > > > > -- Best regards, Shaofeng Shi