sunny, providing the startup log in $KYLIN_HOME/logs can help other guys to analysis;
2017-02-08 14:10 GMT+08:00 sunny <[email protected]>: > Hello，Manoj Jain，are you online? ou have succeeded in installing kylin > 1.6.0 > on CDH5.9, all right? Could you please share your deploy documents or > methods , please? Our previous platform version is also CDH5.7 ,after > upgrading , we met the same situation as yours, and after some tries, I am > able to see the login page now , but I still cann't login it. I'm very > interested in your deploy experences and would be deeply grateful. Maybe > My > email [email protected] would be helpful. Look forward to you reply. > Thanks. Best regards for you. sunny---------------------- > Manoj Jain wrote > > Thanks for your input. We are able to install Kylin 1.6 successfully on > > CDH 5.9 and able to execute the queries.We have created a separate folder > > and hbase metadata for the kylin 1.6. Is it ok to copy the Kylin 1.5 > > meta-data and hbase tables on Kylin 1.6 folders? By doing so I don’t have > > to rebuild the cubes in kylin 1.6. Please confirm if this approach will > > work.Thanks,Manoj Jain> On Jan 27, 2017, at 8:37 AM, > > > liuyiming.vip@ > > > wrote:> > > > For item a), correct. In your case, I think this is the > > root cause.> > For item b), if the latest kylin could not work for the > > newer CDH, the older one could not work either definetly. The dev team > has > > no resource to verify CDH5.9 yet. There is no special APIs used for > > CDH5.7+. So the CDH release should work for you.> > > > > > Yiming Liu> > > > > > > > > 发件人: Manoj Jain> > 发送时间: 1月27日 星期五 20:48> > 主题: Re: URGENT !!! > > Help needed - Issue executing query in Kylin> > 收件人: > > > [email protected] > > >> > 抄送: > > > [email protected] > > > , Sudeep Dey, Raja Tallapaneni, Sanjeev Singh> > > > Thanks for your > quick > > response. Need few clarification:> > > > a) "When you upgrade, please > > follow the upgrade instructuon, such as redeploy the coprocessor jar.” - > I > > believe you are saying when we upgrade the kylin version, we need to > > redeploy the coprocessor jar. Confirm my understanding.> > > > b) We plan > > to deploy the newer version of the Kylin. However, the new Kylin version > > does not mention compatibility with CDH 5.9.> > > I need your advice > > whether we upgrade to newer version of Kylin or apply some patch that > will > > resolve the current issue.> > > > http://kylin.apache.org/download/> > > > > 1.6.0> > > In this version Kylin has better support for Kafka as data > > source, read blog New NRT Streaming in Apache Kylin.Release NotesSource > > download: apache-kylin-1.6.0-src.tar.gz [asc] [md5]Binary download:for > > HBase 0.98 (includes HDP 2.2, CDH 5.2/5.3) - > apache-kylin-1.6.0-bin.tar.gz > > [asc] [md5]for HBase 1.x (includes HDP 2.3/2.4, EMR 5.0) - > > apache-kylin-1.6.0-hbase1.x-bin.tar.gz [asc] [md5]for CDH 5.5/5.7/5.8 - > > apache-kylin-1.6.0-cdh5.7-bin.tar.gz [asc] [md5]> > > Thanks,> > > Manoj > > Jain> > > > On Jan 26, 2017, at 11:59 PM, > > > liuyiming.vip@ > > > wrote:> > > > When you upgrade, please follow the upgrade instructuon, > > such as redeploy the coprocessor jar.> > > > Yiming Liu> > > > > > > > On > > Fri, Jan 27, 2017 at 12:33 PM +0800, "Manoj Jain" < > > > mjain@ > > > > wrote:> > > > > > > > > We were running klyin 1.5 on CDH 5.7 and was > > working fine.> > > > Post upgrade to CDH 5.9, we are seeing an exception > > while running the queries in Kylin.> > > > I have restarted the Kylin 1.5 > > instance and also build the test cube from scratch. The cube built was > > successful but seeing an exception in the Kylin.log when running the > > queries (in the Kyiin ‘Insight’ tab).> > > > Please help us to resolve > > this issue at the earliest. Let us know if you need any other > > information.> > > > Kylin Version: 1.5.2> > > > Excerpts from the Server > > Environment> > > HBASE_LOG_DIR = /var/log/hbase> > > HBASE_HOME = > > /opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.21/lib/hbase/bin/..> > > > > HBASE_OPTS = -Xmx268435456 -XX:+HeapDumpOnOutOfMemoryError > > -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode > > -Djava.net.preferIPv4Stack=true > > -Djava.security.auth.login.config=/etc/hbase/conf/jaas.conf > > -Dhbase.log.dir=/var/log/hbase -Dhbase.log.file=hbase.log > > -Dhbase.home.dir=/opt/cloudera/parcels/CDH-5.9.0-1. > cdh5.9.0.p0.21/lib/hbase/bin/.. > > -Dhbase.id.str=hbase -Dhbase.root.logger=INFO,console > > -Djava.library.path=/opt/cloudera/parcels/CDH-5.9.0-1. > cdh5.9.0.p0.21/lib/hadoop/lib/native:/opt/cloudera/parcels/ > CDH-5.9.0-1.cdh5.9.0.p0.21/lib/hbase/bin/../lib/native/Linux-amd64-64 > > -Dhbase.security.logger=INFO,NullAppender> > > HBASE_ENV_INIT = true> > > > > > hbase_dependency = > > /opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.21/lib/hbase/ > bin/../lib/hbase-common-1.2.0-cdh5.9.0.jar> > > > > > > > Kylin log exceprts> > > > 2017-01-26 18:33:50,419 INFO > > [http-bio-10101-exec-7] v2.CubeHBaseRPC:271 : Visiting hbase table > > KYLIN_XXXXXXXXX: cuboid exact match, from 2 to 2 Start: > > \x00\x00\x00\x00\x00\x0> > > 0\x00\x00\x00\x02\x00 > > (\x00\x00\x00\x00\x00\x00\x00\x00\x00\x02\x00) Stop: > > \x00\x00\x00\x00\x00\x00\x00\x00\x00\x02\xFF\x00 > > (\x00\x00\x00\x00\x00\x00\x00\x00\x00\x02\xFF\x00), > > > No Fuzzy Key> > > > > > 2017-01-26 18:33:50,419 DEBUG [http-bio-10101-exec-7] > > v2.CubeHBaseEndpointRPC:319 : Submitting rpc to 1 shards starting from > > shard 0, scan range count 1> > > 2017-01-26 18:33:50,419 INFO > > [http-bio-10101-exec-7] v2.CubeHBaseEndpointRPC:102 : Timeout for > > ExpectedSizeIterator is: 198000> > > 2017-01-26 18:33:50,420 DEBUG > > [http-bio-10101-exec-7] enumerator.OLAPEnumerator:127 : return > > TupleIterator...> > > 2017-01-26 18:33:50,430 ERROR [pool-7-thread-5] > > util.LoggableCachedThreadPool:44 : Execution exception when running task > > in pool-7-thread-5> > > 2017-01-26 18:33:50,431 ERROR [pool-7-thread-5] > > util.LoggableCachedThreadPool:54 : Caught exception in thread > > pool-7-thread-5: > > > java.lang.RuntimeException: > > > Error when visiting cubes by endpoint> > > at > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$1.run( > CubeHBaseEndpointRPC.java:344)> > > > > at > > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)> > > > > > at java.util.concurrent.FutureTask.run(FutureTask.java:262)> > > > > > at > > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1145)> > > > > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:615)> > > > > at java.lang.Thread.run(Thread.java:745)> > > Caused by: > > org.apache.hadoop.hbase.DoNotRetryIOException: > > org.apache.hadoop.hbase.DoNotRetryIOException: > > java.lang.NoSuchMethodError: > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/HRegion;> > > > > at > > org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2212)> > > > > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:109)> > > > > at > > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run( > RpcExecutor.java:185)> > > > > at > > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run( > RpcExecutor.java:165)> > > > > Caused by: java.lang.NoSuchMethodError: > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/HRegion;> > > > > at > > org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:177)> > > > > at > > org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated. > CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:4164)> > > > > at > > org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:7797)> > > > > at > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion( > RSRpcServices.java:1982)> > > > > at > > org.apache.hadoop.hbase.regionserver.RSRpcServices. > execService(RSRpcServices.java:1964)> > > > > at > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2. > callBlockingMethod(ClientProtos.java:33652)> > > > > at > > org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2170)> > > > > ... 3 more> > > > 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:327)> > > > > at > > org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1631)> > > > > 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:4225)> > > > > at > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call( > CubeHBaseEndpointRPC.java:392)> > > > > at > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$2.call( > CubeHBaseEndpointRPC.java:388)> > > > > at > > org.apache.hadoop.hbase.client.HTable$15.call(HTable.java:1797)> > > > > ... 4 more> > > Caused by: > > org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org. > apache.hadoop.hbase.DoNotRetryIOException): > > org.apache.hadoop.hbase.DoNotRetryIOException: > > java.lang.NoSuchMethodError: > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/HRegion;> > > > > at > > org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2212)> > > > > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:109)> > > > > at > > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run( > RpcExecutor.java:185)> > > > > at > > org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run( > RpcExecutor.java:165)> > > > > Caused by: java.lang.NoSuchMethodError: > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/HRegion;> > > > > at > > org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:177)> > > > > at > > org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated. > CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:4164)> > > > > at > > org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:7797)> > > > > at > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion( > RSRpcServices.java:1982)> > > > > at > > org.apache.hadoop.hbase.regionserver.RSRpcServices. > execService(RSRpcServices.java:1964)> > > > > at > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2. > callBlockingMethod(ClientProtos.java:33652)> > > > > at > > org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2170)> > > > > ... 3 more> > > > at > > org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1269)> > > > > > at > > org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod( > AbstractRpcClient.java:226)> > > > > at > > org.apache.hadoop.hbase.ipc.AbstractRpcClient$ > BlockingRpcChannelImplementation.callBlockingMethod( > AbstractRpcClient.java:331)> > > > > at > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$ > BlockingStub.execService(ClientProtos.java:34118)> > > > > at > > org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1627)> > > > > ... 13 more> > > > > > Thanks,> > > Manoj Jain> > > > > > > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/URGENT-Help-needed-Issue-executing-query-in- > Kylin-tp7046p7131.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi 史少锋
