Hi All,
I am trying to setup and use Phoenix 3.0.0 along with Hbase 0.94.3, and
getting issues as follows ::
I have a 1 node test cluster where my setup is running and I did setup
Phoenix binaries as per instructions (coped phoenix-core and phoenix-client
jars at respective locatoins, and restarted HBase ).
Next, I am trying to run sqlline.py <myzookeeper>:2181 , and getting
following exception. Am I missing anything? Only Select * on already
existing HBsae table is working. Create table gives same error as below,
but creates the table in the backend (Hbase). Upsurt hangs infinitely.
Please let me know your suggestions if I am missing anything , here is the
complete stack trace --
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:192.168.10.128:2181 none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:192.168.10.128:2181
Connected to: Phoenix (version 3.0)
Driver: org.apache.phoenix.jdbc.PhoenixDriver (version 3.0)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to
true to skip)...
Error: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException:
SYSTEM.CATALOG,,1398435444815.10f169f0ad0d3b6c97f2c3fec643e8d5.:
org/apache/hadoop/hbase/regionserver/RegionScanner.getMvccReadPoint()J
(state=08000,code=101)
org.apache.phoenix.exception.PhoenixIOException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException:
SYSTEM.CATALOG,,1398435444815.10f169f0ad0d3b6c97f2c3fec643e8d5.:
org/apache/hadoop/hbase/regionserver/RegionScanner.getMvccReadPoint()J
at
org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:97)
at
org.apache.phoenix.iterate.ParallelIterators.getIterators(ParallelIterators.java:289)
at
org.apache.phoenix.iterate.MergeSortResultIterator.getIterators(MergeSortResultIterator.java:48)
at
org.apache.phoenix.iterate.MergeSortResultIterator.minIterator(MergeSortResultIterator.java:63)
at
org.apache.phoenix.iterate.MergeSortResultIterator.next(MergeSortResultIterator.java:90)
at
org.apache.phoenix.iterate.MergeSortTopNResultIterator.next(MergeSortTopNResultIterator.java:87)
at
org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:732)
at sqlline.SqlLine.getColumnNames(SqlLine.java:1175)
at sqlline.SqlLine$SQLLineSQLCompletor.<init>(SqlLine.java:4427)
at
sqlline.SqlLine$DatabaseConnection.setCompletions(SqlLine.java:4574)
at sqlline.SqlLine$DatabaseConnection.access$700(SqlLine.java:4508)
at sqlline.SqlLine.setCompletions(SqlLine.java:1814)
at sqlline.SqlLine.access$2500(SqlLine.java:56)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3944)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at
sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
at sqlline.SqlLine.dispatch(SqlLine.java:817)
at sqlline.SqlLine.initArgs(SqlLine.java:633)
at sqlline.SqlLine.begin(SqlLine.java:680)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
Caused by: java.util.concurrent.ExecutionException:
org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException:
SYSTEM.CATALOG,,1398435444815.10f169f0ad0d3b6c97f2c3fec643e8d5.:
org/apache/hadoop/hbase/regionserver/RegionScanner.getMvccReadPoint()J
at
java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:243)
at java.util.concurrent.FutureTask.get(FutureTask.java:102)
at
org.apache.phoenix.iterate.ParallelIterators.getIterators(ParallelIterators.java:283)
... 23 more
Caused by: org.apache.phoenix.exception.PhoenixIOException:
org.apache.hadoop.hbase.DoNotRetryIOException:
SYSTEM.CATALOG,,1398435444815.10f169f0ad0d3b6c97f2c3fec643e8d5.:
org/apache/hadoop/hbase/regionserver/RegionScanner.getMvccReadPoint()J
at
org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:97)
at
org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:57)
at
org.apache.phoenix.iterate.ParallelIterators$2.call(ParallelIterators.java:251)
at
org.apache.phoenix.iterate.ParallelIterators$2.call(ParallelIterators.java:245)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:314)
at java.util.concurrent.FutureTask.run(FutureTask.java:149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:897)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)
at java.lang.Thread.run(Thread.java:738)
Caused by: org.apache.hadoop.hbase.DoNotRetryIOException:
org.apache.hadoop.hbase.DoNotRetryIOException:
SYSTEM.CATALOG,,1398435444815.10f169f0ad0d3b6c97f2c3fec643e8d5.:
org/apache/hadoop/hbase/regionserver/RegionScanner.getMvccReadPoint()J
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at
org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:95)
at
org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:79)
at
org.apache.hadoop.hbase.client.ServerCallable.translateException(ServerCallable.java:256)
at
org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:166)
at
org.apache.hadoop.hbase.client.ClientScanner.nextScanner(ClientScanner.java:210)
at
org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction(ClientScanner.java:125)
at
org.apache.hadoop.hbase.client.ClientScanner.<init>(ClientScanner.java:120)
at org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:702)
at
org.apache.phoenix.iterate.TableResultIterator.<init>(TableResultIterator.java:54)
... 7 more
Caused by: org.apache.hadoop.ipc.RemoteException:
org.apache.hadoop.hbase.DoNotRetryIOException:
SYSTEM.CATALOG,,1398435444815.10f169f0ad0d3b6c97f2c3fec643e8d5.:
org/apache/hadoop/hbase/regionserver/RegionScanner.getMvccReadPoint()J
at
org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:73)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:68)
at
org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1260)
at
org.apache.hadoop.hbase.regionserver.HRegionServer.openScanner(HRegionServer.java:2438)
at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at
org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
at
org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1426)
Caused by: java.lang.NoSuchMethodError:
org/apache/hadoop/hbase/regionserver/RegionScanner.getMvccReadPoint()J
at
org.apache.phoenix.iterate.RegionScannerResultIterator.<init>(RegionScannerResultIterator.java:39)
at
org.apache.phoenix.coprocessor.ScanRegionObserver.deserializeFromScan(ScanRegionObserver.java:120)
at
org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:188)
at
org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:66)
... 7 more
at
org.apache.hadoop.hbase.ipc.HBaseClient.call(HBaseClient.java:1012)
at
org.apache.hadoop.hbase.ipc.WritableRpcEngine$Invoker.invoke(WritableRpcEngine.java:87)
at $Proxy3.openScanner(Unknown Source)
at
org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:224)
at
org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:126)
at
org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:42)
at
org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:164)
... 12 more
sqlline version 1.1.2
--
Regards,
Rahul Joshi.
