You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by ShaoFeng Shi <sh...@apache.org> on 2016/06/08 02:07:19 UTC
Re: 答复: Timeout visiting cube!
Hi Gao, what's your Kylin version and HBase version?
2016-06-08 9:20 GMT+08:00 gaolv123tyu@163.com <ga...@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(RSRpcServices.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(NativeConstructorAccessorImpl.java:57)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at
> org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)
> at
> org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)
> at
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:325)
> at
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1620)
> at
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:92)
> at
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:89)
> at
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
> at
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:95)
> at
> org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:56)
> at
> org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated.CubeVisitProtos$CubeVisitService$Stub.visitCube(CubeVisitProtos.java:3861)
> at
> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.java:362)
> at
> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.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(RSRpcServices.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:1235)
> at
> org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:222)
> at
> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.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
>
>
>
> gaolv123tyu@163.com
>
> 发件人： 吴钰彬
> 发送时间： 2016-06-08 09:10
> 收件人： gaolv123tyu@163.com
> 主题： 答复: Timeout visiting cube!
>
> 我不是KYLIN的开发，一样是用户，我之前也碰到过这个问题
>
> 你可以尝试在kylin.profile的配置文件里面添加下面的参数，默认值是1，我这边是改成3倍
>
> kylin.query.cube.visit.timeout.times=3
> #default is 1
>
> -----邮件原件-----
> 发件人: gaolv123tyu@163.com [mailto:gaolv123tyu@163.com]
> 发送时间: 2016年6月7日 20:39
> 收件人: dev <de...@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之后，又会出现这个问题。
>
> 应该如何解决的啊？
>
>
>
>
> gaolv123tyu@163.com
>
--
Best regards,
Shaofeng Shi
Re: 答复: Re: Timeout visiting cube!
Posted by ShaoFeng Shi <sh...@apache.org>.
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 赵天烁 <zh...@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
> zhaotianshuo@meizu.com
>
> 珠海市魅族科技有限公司
> MEIZU Technology Co., Ltd.
> 广东省珠海市科技创新海岸魅族科技楼
> MEIZU Tech Bldg., Technology & Innovation Coast
> Zhuhai, 519085, Guangdong, China
>
>
> meizu.com
>
>
>
>
> -----邮件原件-----
> 发件人: Li Yang [mailto:liyang@apache.org]
> 发送时间: 2016年6月13日 16:41
> 收件人: dev@kylin.apache.org
> 抄送: 吴钰彬 <wu...@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, gaolv123tyu@163.com <gaolv123tyu@163.com
> >
> wrote:
>
> > version infos ：
> >
> > Kylin 1.5.1
> > HBase 1.1.4 for apache package。
> >
> > What may be the problem?
> >
> >
> >
> > gaolv123tyu@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 <sh...@apache.org>
> > wrote:
> >
> > > Hi Gao, what's your Kylin version and HBase version?
> > >
> > > 2016-06-08 9:20 GMT+08:00 gaolv123tyu@163.com <ga...@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
> > > >
> > > >
> > > >
> > > > gaolv123tyu@163.com
> > > >
> > > > 发件人： 吴钰彬
> > > > 发送时间： 2016-06-08 09:10
> > > > 收件人： gaolv123tyu@163.com
> > > > 主题： 答复: Timeout visiting cube!
> > > >
> > > > 我不是KYLIN的开发，一样是用户，我之前也碰到过这个问题
> > > >
> > > > 你可以尝试在kylin.profile的配置文件里面添加下面的参数，默认值是1，我这边是改成3倍
> > > >
> > > > kylin.query.cube.visit.timeout.times=3
> > > > #default is 1
> > > >
> > > > -----邮件原件-----
> > > > 发件人: gaolv123tyu@163.com [mailto:gaolv123tyu@163.com]
> > > > 发送时间: 2016年6月7日 20:39
> > > > 收件人: dev <de...@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之后，又会出现这个问题。
> > > >
> > > > 应该如何解决的啊？
> > > >
> > > >
> > > >
> > > >
> > > > gaolv123tyu@163.com
> > > >
> > >
> > >
> > >
> > > --
> > > Best regards,
> > >
> > > Shaofeng Shi
> > >
> >
>
--
Best regards,
Shaofeng Shi
答复: Re: Timeout visiting cube!
Posted by 赵天烁 <zh...@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
zhaotianshuo@meizu.com
珠海市魅族科技有限公司
MEIZU Technology Co., Ltd.
广东省珠海市科技创新海岸魅族科技楼
MEIZU Tech Bldg., Technology & Innovation Coast
Zhuhai, 519085, Guangdong, China
meizu.com
-----邮件原件-----
发件人: Li Yang [mailto:liyang@apache.org]
发送时间: 2016年6月13日 16:41
收件人: dev@kylin.apache.org
抄送: 吴钰彬 <wu...@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, gaolv123tyu@163.com <ga...@163.com>
wrote:
> version infos ：
>
> Kylin 1.5.1
> HBase 1.1.4 for apache package。
>
> What may be the problem?
>
>
>
> gaolv123tyu@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 <sh...@apache.org>
> wrote:
>
> > Hi Gao, what's your Kylin version and HBase version?
> >
> > 2016-06-08 9:20 GMT+08:00 gaolv123tyu@163.com <ga...@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
> > >
> > >
> > >
> > > gaolv123tyu@163.com
> > >
> > > 发件人： 吴钰彬
> > > 发送时间： 2016-06-08 09:10
> > > 收件人： gaolv123tyu@163.com
> > > 主题： 答复: Timeout visiting cube!
> > >
> > > 我不是KYLIN的开发，一样是用户，我之前也碰到过这个问题
> > >
> > > 你可以尝试在kylin.profile的配置文件里面添加下面的参数，默认值是1，我这边是改成3倍
> > >
> > > kylin.query.cube.visit.timeout.times=3
> > > #default is 1
> > >
> > > -----邮件原件-----
> > > 发件人: gaolv123tyu@163.com [mailto:gaolv123tyu@163.com]
> > > 发送时间: 2016年6月7日 20:39
> > > 收件人: dev <de...@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之后，又会出现这个问题。
> > >
> > > 应该如何解决的啊？
> > >
> > >
> > >
> > >
> > > gaolv123tyu@163.com
> > >
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi
> >
>
Re: Re: Timeout visiting cube!
Posted by Li Yang <li...@apache.org>.
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, gaolv123tyu@163.com <ga...@163.com>
wrote:
> version infos ：
>
> Kylin 1.5.1
> HBase 1.1.4 for apache package。
>
> What may be the problem?
>
>
>
> gaolv123tyu@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 <sh...@apache.org>
> wrote:
>
> > Hi Gao, what's your Kylin version and HBase version?
> >
> > 2016-06-08 9:20 GMT+08:00 gaolv123tyu@163.com <ga...@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(RSRpcServices.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(NativeConstructorAccessorImpl.java:57)
> > > at
> > >
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > > at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> > > at
> > >
> >
> org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)
> > > at
> > >
> >
> org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)
> > > at
> > >
> >
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:325)
> > > at
> > >
> >
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1620)
> > > at
> > >
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:92)
> > > at
> > >
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:89)
> > > at
> > >
> >
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
> > > at
> > >
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:95)
> > > at
> > >
> >
> org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:56)
> > > at
> > >
> >
> org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated.CubeVisitProtos$CubeVisitService$Stub.visitCube(CubeVisitProtos.java:3861)
> > > at
> > >
> >
> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.java:362)
> > > at
> > >
> >
> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.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(RSRpcServices.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:1235)
> > > at
> > >
> >
> org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:222)
> > > at
> > >
> >
> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.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
> > >
> > >
> > >
> > > gaolv123tyu@163.com
> > >
> > > 发件人： 吴钰彬
> > > 发送时间： 2016-06-08 09:10
> > > 收件人： gaolv123tyu@163.com
> > > 主题： 答复: Timeout visiting cube!
> > >
> > > 我不是KYLIN的开发，一样是用户，我之前也碰到过这个问题
> > >
> > > 你可以尝试在kylin.profile的配置文件里面添加下面的参数，默认值是1，我这边是改成3倍
> > >
> > > kylin.query.cube.visit.timeout.times=3
> > > #default is 1
> > >
> > > -----邮件原件-----
> > > 发件人: gaolv123tyu@163.com [mailto:gaolv123tyu@163.com]
> > > 发送时间: 2016年6月7日 20:39
> > > 收件人: dev <de...@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之后，又会出现这个问题。
> > >
> > > 应该如何解决的啊？
> > >
> > >
> > >
> > >
> > > gaolv123tyu@163.com
> > >
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi
> >
>
Re: Re: Timeout visiting cube!
Posted by "gaolv123tyu@163.com" <ga...@163.com>.
version infos ：
Kylin 1.5.1
HBase 1.1.4 for apache package。
What may be the problem?
gaolv123tyu@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 <sh...@apache.org>
wrote:
> Hi Gao, what's your Kylin version and HBase version?
>
> 2016-06-08 9:20 GMT+08:00 gaolv123tyu@163.com <ga...@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(RSRpcServices.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(NativeConstructorAccessorImpl.java:57)
> > at
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> > at
> >
> org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)
> > at
> >
> org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)
> > at
> >
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:325)
> > at
> >
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1620)
> > at
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:92)
> > at
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:89)
> > at
> >
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
> > at
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:95)
> > at
> >
> org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:56)
> > at
> >
> org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated.CubeVisitProtos$CubeVisitService$Stub.visitCube(CubeVisitProtos.java:3861)
> > at
> >
> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.java:362)
> > at
> >
> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.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(RSRpcServices.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:1235)
> > at
> >
> org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:222)
> > at
> >
> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.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
> >
> >
> >
> > gaolv123tyu@163.com
> >
> > 发件人： 吴钰彬
> > 发送时间： 2016-06-08 09:10
> > 收件人： gaolv123tyu@163.com
> > 主题： 答复: Timeout visiting cube!
> >
> > 我不是KYLIN的开发，一样是用户，我之前也碰到过这个问题
> >
> > 你可以尝试在kylin.profile的配置文件里面添加下面的参数，默认值是1，我这边是改成3倍
> >
> > kylin.query.cube.visit.timeout.times=3
> > #default is 1
> >
> > -----邮件原件-----
> > 发件人: gaolv123tyu@163.com [mailto:gaolv123tyu@163.com]
> > 发送时间: 2016年6月7日 20:39
> > 收件人: dev <de...@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之后，又会出现这个问题。
> >
> > 应该如何解决的啊？
> >
> >
> >
> >
> > gaolv123tyu@163.com
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
Re: 答复: Timeout visiting cube!
Posted by Li Yang <li...@apache.org>.
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 <sh...@apache.org>
wrote:
> Hi Gao, what's your Kylin version and HBase version?
>
> 2016-06-08 9:20 GMT+08:00 gaolv123tyu@163.com <ga...@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(RSRpcServices.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(NativeConstructorAccessorImpl.java:57)
> > at
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> > at
> >
> org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106)
> > at
> >
> org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95)
> > at
> >
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:325)
> > at
> >
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1620)
> > at
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:92)
> > at
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:89)
> > at
> >
> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
> > at
> >
> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:95)
> > at
> >
> org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:56)
> > at
> >
> org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated.CubeVisitProtos$CubeVisitService$Stub.visitCube(CubeVisitProtos.java:3861)
> > at
> >
> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.java:362)
> > at
> >
> org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call(CubeHBaseEndpointRPC.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(RSRpcServices.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:1235)
> > at
> >
> org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:222)
> > at
> >
> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.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
> >
> >
> >
> > gaolv123tyu@163.com
> >
> > 发件人： 吴钰彬
> > 发送时间： 2016-06-08 09:10
> > 收件人： gaolv123tyu@163.com
> > 主题： 答复: Timeout visiting cube!
> >
> > 我不是KYLIN的开发，一样是用户，我之前也碰到过这个问题
> >
> > 你可以尝试在kylin.profile的配置文件里面添加下面的参数，默认值是1，我这边是改成3倍
> >
> > kylin.query.cube.visit.timeout.times=3
> > #default is 1
> >
> > -----邮件原件-----
> > 发件人: gaolv123tyu@163.com [mailto:gaolv123tyu@163.com]
> > 发送时间: 2016年6月7日 20:39
> > 收件人: dev <de...@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之后，又会出现这个问题。
> >
> > 应该如何解决的啊？
> >
> >
> >
> >
> > gaolv123tyu@163.com
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>