Is tephra 0.7.2 fully supported on HDP-2.4.0.0-169?
44 views
Skip to first unread message
hsh...@dimensions-healthcare.com
Aug 4, 2016, 3:14:11 AM8/4/16
to Tephra User
Is tephra 0.7.2 fully supported on HDP-2.4.0.0-169 with HBase-1.1.2.2.4?
I tried to use tephra as a transaction manager for phoenix query server connected with Hbase, but there is no improvement in performance of phoenix.
I made the recommended configuration mentioned in below links
https://phoenix.apache.org/transactions.html
http://tephra.incubator.apache.org/GettingStarted.html
hbase.coprocessor.region.classes of tephra conflicts with hbase region servers and causes hbase region server to stop and not work properly.
Details are in below:
HDP version:
HDP-2.4.0.0-169
HBase version: 1.1.2.2.4
Phoenix Query Server version : 4.7
Ali Anwar
Aug 4, 2016, 3:40:45 AM8/4/16
to hsh...@dimensions-healthcare.com, Tephra User
Hi Habeeb Shanaa.
1. Just to get more information, can you add more detail in what you mean by "conflicts with hbase region servers and causes hbase region server to stop and not work properly".
Can you attach the relevant logs which contain the errors?
This will help us better understand any issue you are facing.
2. Also, you mention that "there is no improvement in performance of phoenix".
I don't believe that Tephra as a transaction manager for Phoenix is meant as a means for increased performance, in terms of throughput. Instead, it is a way to add transactional support with ACID semantics for Phoenix queries.
Regards,
Ali Anwar
1. Just to get more information, can you add more detail in what you mean by "conflicts with hbase region servers and causes hbase region server to stop and not work properly".
Can you attach the relevant logs which contain the errors?
This will help us better understand any issue you are facing.
2. Also, you mention that "there is no improvement in performance of phoenix".
I don't believe that Tephra as a transaction manager for Phoenix is meant as a means for increased performance, in terms of throughput. Instead, it is a way to add transactional support with ACID semantics for Phoenix queries.
Regards,
Ali Anwar
--
You received this message because you are subscribed to the Google Groups "Tephra User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tephra-user+unsubscribe@googlegroups.com.
To post to this group, send email to tephr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tephra-user/caeab210-b446-4ca5-a40a-945d51b3ddff%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
hsh...@dimensions-healthcare.com
Aug 4, 2016, 4:16:44 AM8/4/16
to Tephra User, hsh...@dimensions-healthcare.com
Thanks for reply and sorry for not being clear, I thought that I had a known issue, I am adding exceptions from
Regarding the first point of problems of hbase.coprocessor.region.classes of tephra (i.e. modify hbase-site conf to have hbase.coprocessor.region.classes=org.apache.hadoop.hbase.security.access.SecureBulkLoadEndpoint,co.cask.tephra.hbase11.coprocessor.TransactionProcessor as recommended by tephra): while I run simple queries statements (such as create, drop, delete, select query statements) against transactional tables unsing sqlline-thin.py of phoenix query server, I got strange exceptions in console and in log files of hbase region servers as in below exceptions although hbase region server is up and running good when I don't use hbase.coprocessor.region classes of tephra (i.e. modify hbase-site conf to have hbase.coprocessor.region.classes=org.apache.hadoop.hbase.security.access.SecureBulkLoadEndpoint), please check below exceptions when using hbase.coprocessor.region classes of tephra:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> ExecutionException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> RetriesExhaustedException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035 -> NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
-> RemoteWithExtrasException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745) (state=00000,code=-1)
org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : Error while executing SQL "create table if not exists claim_phoenix(id bigint primary key, providerid bigint, claimdate bigint, net bigint, ps bigint, gross bigint) TRANSACTIONAL=true, IMMUTABLE_ROWS=false, SALT_BUCKETS = 3": Remote driver error: RuntimeException: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> ExecutionException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> RetriesExhaustedException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035 -> NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
-> RemoteWithExtrasException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
at org.apache.calcite.avatica.Helper.createException(Helper.java:53)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:143)
at org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:177)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:808)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:645)
at org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:709)
at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:186)
at org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:1055)
at org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:1029)
at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102)
at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38)
at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:68)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:538)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:510)
at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50)
at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97)
at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117)
at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64)
at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39)
at org.apache.phoenix.compile.PostDDLCompiler$1.execute(PostDDLCompiler.java:228)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2013)
at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:787)
at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:305)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:297)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:295)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1255)
at org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:689)
... 15 more
Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:534)
... 31 more
Caused by: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
at org.apache.phoenix.iterate.TableResultIterator.getDelegate(TableResultIterator.java:68)
at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:85)
at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:77)
at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:95)
at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:90)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:172)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
... 1 more
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.throwEnrichedException(RpcRetryingCallerWithReadReplicas.java:271)
at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:195)
at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:59)
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
at org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:320)
at org.apache.hadoop.hbase.client.ClientScanner.nextScanner(ClientScanner.java:295)
at org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction(ClientScanner.java:160)
at org.apache.hadoop.hbase.client.ClientScanner.<init>(ClientScanner.java:155)
at org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:821)
at org.apache.phoenix.iterate.TableResultIterator.getDelegate(TableResultIterator.java:65)
... 9 more
Caused by: java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:159)
at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64)
... 3 more
Caused by: org.apache.hadoop.hbase.NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
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.client.ScannerCallable.openScanner(ScannerCallable.java:380)
at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199)
at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62)
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:346)
at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:320)
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
... 4 more
Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.NotServingRegionException): org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1226)
at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:213)
at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:287)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:32651)
at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:372)
... 10 more
Regarding the second point of performance : I expected good improvmenet in performance of phoenix and hbase due to use of tephra, what is the key advantages of using tephra in addition of ACID transactions support? how to know if tephra is working correctly and as expected or not?
Regarding the first point of problems of hbase.coprocessor.region.classes of tephra (i.e. modify hbase-site conf to have hbase.coprocessor.region.classes=org.apache.hadoop.hbase.security.access.SecureBulkLoadEndpoint,co.cask.tephra.hbase11.coprocessor.TransactionProcessor as recommended by tephra): while I run simple queries statements (such as create, drop, delete, select query statements) against transactional tables unsing sqlline-thin.py of phoenix query server, I got strange exceptions in console and in log files of hbase region servers as in below exceptions although hbase region server is up and running good when I don't use hbase.coprocessor.region classes of tephra (i.e. modify hbase-site conf to have hbase.coprocessor.region.classes=org.apache.hadoop.hbase.security.access.SecureBulkLoadEndpoint), please check below exceptions when using hbase.coprocessor.region classes of tephra:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> ExecutionException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> RetriesExhaustedException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035 -> NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
-> RemoteWithExtrasException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745) (state=00000,code=-1)
org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : Error while executing SQL "create table if not exists claim_phoenix(id bigint primary key, providerid bigint, claimdate bigint, net bigint, ps bigint, gross bigint) TRANSACTIONAL=true, IMMUTABLE_ROWS=false, SALT_BUCKETS = 3": Remote driver error: RuntimeException: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> ExecutionException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> RetriesExhaustedException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
-> SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035 -> NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
-> RemoteWithExtrasException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
at org.apache.calcite.avatica.Helper.createException(Helper.java:53)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:143)
at org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:177)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:808)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:645)
at org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:709)
at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:186)
at org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:1055)
at org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:1029)
at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102)
at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38)
at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:68)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:538)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:510)
at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50)
at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97)
at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117)
at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64)
at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39)
at org.apache.phoenix.compile.PostDDLCompiler$1.execute(PostDDLCompiler.java:228)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2013)
at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:787)
at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:305)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:297)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:295)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1255)
at org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:689)
... 15 more
Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:534)
... 31 more
Caused by: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
at org.apache.phoenix.iterate.TableResultIterator.getDelegate(TableResultIterator.java:68)
at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:85)
at org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:77)
at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:95)
at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:90)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:172)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
... 1 more
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:
Thu Aug 04 04:01:23 EDT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.throwEnrichedException(RpcRetryingCallerWithReadReplicas.java:271)
at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:195)
at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:59)
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
at org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:320)
at org.apache.hadoop.hbase.client.ClientScanner.nextScanner(ClientScanner.java:295)
at org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction(ClientScanner.java:160)
at org.apache.hadoop.hbase.client.ClientScanner.<init>(ClientScanner.java:155)
at org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:821)
at org.apache.phoenix.iterate.TableResultIterator.getDelegate(TableResultIterator.java:65)
... 9 more
Caused by: java.net.SocketTimeoutException: callTimeout=60000, callDuration=68157: row '' on table 'CLAIM_PHOENIX' at region=CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390., hostname=ocean1.ocean1,16020,1470297315692, seqNum=12035
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:159)
at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64)
... 3 more
Caused by: org.apache.hadoop.hbase.NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
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.client.ScannerCallable.openScanner(ScannerCallable.java:380)
at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199)
at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62)
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200)
at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:346)
at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:320)
at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126)
... 4 more
Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.NotServingRegionException): org.apache.hadoop.hbase.NotServingRegionException: Region CLAIM_PHOENIX,,1470221721647.058044719027c606de1323ca98da1390. is not online on ocean1.ocean1,16020,1470297315692
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegionByEncodedName(HRegionServer.java:2898)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.getRegion(RSRpcServices.java:947)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2235)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32205)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
at java.lang.Thread.run(Thread.java:745)
at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1226)
at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:213)
at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:287)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:32651)
at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:372)
... 10 more
Regarding the second point of performance : I expected good improvmenet in performance of phoenix and hbase due to use of tephra, what is the key advantages of using tephra in addition of ACID transactions support? how to know if tephra is working correctly and as expected or not?
On Thursday, August 4, 2016 at 10:40:45 AM UTC+3, ali wrote:
Hi Habeeb Shanaa.
1. Just to get more information, can you add more detail in what you mean by "conflicts with hbase region servers and causes hbase region server to stop and not work properly".
Can you attach the relevant logs which contain the errors?
This will help us better understand any issue you are facing.
2. Also, you mention that "there is no improvement in performance of phoenix".
I don't believe that Tephra as a transaction manager for Phoenix is meant as a means for increased performance, in terms of throughput. Instead, it is a way to add transactional support with ACID semantics for Phoenix queries.
Regards,
Ali Anwar
On Thu, Aug 4, 2016 at 12:14 AM, <hsh...@dimensions-healthcare.com> wrote:
Is tephra 0.7.2 fully supported on HDP-2.4.0.0-169 with HBase-1.1.2.2.4?
I tried to use tephra as a transaction manager for phoenix query server connected with Hbase, but there is no improvement in performance of phoenix.
I made the recommended configuration mentioned in below links
https://phoenix.apache.org/transactions.html
http://tephra.incubator.apache.org/GettingStarted.html
hbase.coprocessor.region.classes of tephra conflicts with hbase region servers and causes hbase region server to stop and not work properly.
Details are in below:
HDP version:
HDP-2.4.0.0-169
HBase version: 1.1.2.2.4
Phoenix Query Server version : 4.7
--
You received this message because you are subscribed to the Google Groups "Tephra User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tephra-user...@googlegroups.com.
Ali Anwar
Aug 4, 2016, 4:53:14 AM8/4/16
to hsh...@dimensions-healthcare.com, Tephra User
Hi Habeeb Shanaa.
Did one of the region servers crash any time recently? Can you check for this, and if so, can you attach the error logs for the region server that crashed?
The error logs you pasted don't indicate anything much besides a `NotServingRegionException`, which may have been caused by a Region Server crashing previously.
Regards,
Ali Anwar
Did one of the region servers crash any time recently? Can you check for this, and if so, can you attach the error logs for the region server that crashed?
The error logs you pasted don't indicate anything much besides a `NotServingRegionException`, which may have been caused by a Region Server crashing previously.
Regards,
Ali Anwar
To unsubscribe from this group and stop receiving emails from it, send an email to tephra-user+unsubscribe@googlegroups.com.
To post to this group, send email to tephr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tephra-user/44a85f36-d0eb-4fc1-9b27-d6eb84e5102f%40googlegroups.com.
hsh...@dimensions-healthcare.com
Aug 4, 2016, 4:58:48 AM8/4/16
to Tephra User, hsh...@dimensions-healthcare.com
None of them crashed in past, these exceptions happened only when using hbase.coprocessor.region.
classes of tephra in hbase-site conf file, I am pretty sure that it is incompatibility issue between tephra-0.7.2 and hbase-1.1.2.2.4, can you please check if they are compatibles or not?
Ali Anwar
Aug 4, 2016, 5:12:36 AM8/4/16
to Habeeb Shanaa, Tephra User
Hey Habeeb.
We regularly test CDAP (which utilizes Tephra quite a bit) on HDP 2.4.0, which uses Apache HBase 1.1.2 and Tephra 0.7.1, so I don't think there's any incompatibility issue there.
Regards,
Ali Anwar
We regularly test CDAP (which utilizes Tephra quite a bit) on HDP 2.4.0, which uses Apache HBase 1.1.2 and Tephra 0.7.1, so I don't think there's any incompatibility issue there.
Regards,
Ali Anwar
To unsubscribe from this group and stop receiving emails from it, send an email to tephra-user+unsubscribe@googlegroups.com.
To post to this group, send email to tephr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tephra-user/e7ae48b0-b614-4e27-8bbd-303242d757c6%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages