Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-199

Can not connect Hbase

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Resolution: Fixed
    • None
    • None
    • None
    • 68

    Description

      Dear ,

      I use the following command to connect to zk using phoenix. But I can not connect to the hbase and make test.

      java -jar phoenix-1.0-client.jar 192.168.1.198:2181 examples/stock_symbol.sql

      The following error returned from phoenix.

      And when I use SquirreLSQL, It comes the same exception. Please help me find why. Thanks a lot.

      Hbase version: 0.94.1
      Zk Version: 3.4.3

      The exception is as following:

      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:zookeeper.version=3.4.3-1240972, built on 02/06/2012 10:48 GMT
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:host.name=wbtest02
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:java.version=1.7.0_09
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:java.vendor=Oracle Corporation
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:java.home=/usr/lib/java/jdk1.7/jre
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:java.class.path=phoenix-1.0-client.jar
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:java.io.tmpdir=/tmp
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:java.compiler=<NA>
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:os.name=Linux
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:os.arch=amd64
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:os.version=3.5.0-17-generic
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:user.name=hadoop
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:user.home=/home/hadoop
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Client environment:user.dir=/home/hadoop/hbase
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=192.168.1.198:2181 sessionTimeout=180000 watcher=hconnection
      13/02/22 16:53:13 INFO zookeeper.ClientCnxn: Opening socket connection to server /192.168.1.198:2181
      13/02/22 16:53:13 INFO zookeeper.RecoverableZooKeeper: The identifier of this process is 32682@wbtest02
      13/02/22 16:53:13 INFO client.ZooKeeperSaslClient: Client will not SASL-authenticate because the default JAAS configuration section 'Client' could not be found. If you are not using SASL, you may ignore this. On the other hand, if you expected SASL to work, please fix your JAAS configuration.
      13/02/22 16:53:13 INFO zookeeper.ClientCnxn: Socket connection established to wbtest02/192.168.1.198:2181, initiating session
      13/02/22 16:53:13 INFO zookeeper.ClientCnxn: Session establishment complete on server wbtest02/192.168.1.198:2181, sessionid = 0x13ce72e6de4023f, negotiated timeout = 40000
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=192.168.1.198:2181 sessionTimeout=180000 watcher=hconnection
      13/02/22 16:53:13 INFO zookeeper.ClientCnxn: Opening socket connection to server /192.168.1.198:2181
      13/02/22 16:53:13 INFO client.ZooKeeperSaslClient: Client will not SASL-authenticate because the default JAAS configuration section 'Client' could not be found. If you are not using SASL, you may ignore this. On the other hand, if you expected SASL to work, please fix your JAAS configuration.
      13/02/22 16:53:13 INFO zookeeper.ClientCnxn: Socket connection established to wbtest02/192.168.1.198:2181, initiating session
      13/02/22 16:53:13 INFO zookeeper.RecoverableZooKeeper: The identifier of this process is 32682@wbtest02
      13/02/22 16:53:13 INFO zookeeper.ClientCnxn: Session establishment complete on server wbtest02/192.168.1.198:2181, sessionid = 0x13ce72e6de40240, negotiated timeout = 40000
      13/02/22 16:53:13 INFO client.HConnectionManager$HConnectionImplementation: Closed zookeeper sessionid=0x13ce72e6de4023f
      13/02/22 16:53:13 INFO zookeeper.ZooKeeper: Session: 0x13ce72e6de4023f closed
      13/02/22 16:53:13 INFO zookeeper.ClientCnxn: EventThread shut down
      13/02/22 16:53:13 WARN client.HConnectionManager$HConnectionImplementation: Error executing for row
      java.util.concurrent.ExecutionException: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.TABLE: tried to access method org.apache.hadoop.hbase.regionserver.HRegion.getLock(Ljava/lang/Integer;[BZ)Ljava/lang/Integer; from class com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl
      at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)
      at java.util.concurrent.FutureTask.get(FutureTask.java:111)
      at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.processExecs(HConnectionManager.java:1453)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:605)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:639)
      at com.salesforce.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:315)
      at com.salesforce.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:78)
      at com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.executeUpdate(PhoenixStatement.java:271)
      at com.salesforce.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:657)
      at com.salesforce.phoenix.util.SchemaUtil.initMetaData(SchemaUtil.java:314)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:720)
      at com.salesforce.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:95)
      at com.salesforce.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:100)
      at java.sql.DriverManager.getConnection(DriverManager.java:579)
      at java.sql.DriverManager.getConnection(DriverManager.java:243)
      at com.salesforce.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:154)
      Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.TABLE: tried to access method org.apache.hadoop.hbase.regionserver.HRegion.getLock(Ljava/lang/Integer;[BZ)Ljava/lang/Integer; from class com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl
      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:525)
      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:228)
      at org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:166)
      at org.apache.hadoop.hbase.ipc.ExecRPCInvoker.invoke(ExecRPCInvoker.java:79)
      at $Proxy7.createTable(Unknown Source)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl$8.call(ConnectionQueryServicesImpl.java:643)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl$8.call(ConnectionQueryServicesImpl.java:640)
      at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation$4.call(HConnectionManager.java:1441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
      at java.util.concurrent.FutureTask.run(FutureTask.java:166)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
      at java.lang.Thread.run(Thread.java:722)
      Caused by: org.apache.hadoop.ipc.RemoteException: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.TABLE: tried to access method org.apache.hadoop.hbase.regionserver.HRegion.getLock(Ljava/lang/Integer;[BZ)Ljava/lang/Integer; from class com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl
      at com.salesforce.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:49)
      at com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:344)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.apache.hadoop.hbase.regionserver.HRegion.exec(HRegion.java:4887)
      at org.apache.hadoop.hbase.regionserver.HRegionServer.execCoprocessor(HRegionServer.java:3478)
      at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
      at org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1389)
      Caused by: java.lang.IllegalAccessError: tried to access method org.apache.hadoop.hbase.regionserver.HRegion.getLock(Ljava/lang/Integer;[BZ)Ljava/lang/Integer; from class com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl
      at com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:308)
      ... 11 more

      at org.apache.hadoop.hbase.ipc.HBaseClient.call(HBaseClient.java:1021)
      at org.apache.hadoop.hbase.ipc.WritableRpcEngine$Invoker.invoke(WritableRpcEngine.java:150)
      at $Proxy6.execCoprocessor(Unknown Source)
      at org.apache.hadoop.hbase.ipc.ExecRPCInvoker$1.call(ExecRPCInvoker.java:75)
      at org.apache.hadoop.hbase.ipc.ExecRPCInvoker$1.call(ExecRPCInvoker.java:73)
      at org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:163)
      ... 10 more
      java.sql.SQLException: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.TABLE: tried to access method org.apache.hadoop.hbase.regionserver.HRegion.getLock(Ljava/lang/Integer;[BZ)Ljava/lang/Integer; from class com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:623)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:639)
      at com.salesforce.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:315)
      at com.salesforce.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:78)
      at com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.executeUpdate(PhoenixStatement.java:271)
      at com.salesforce.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:657)
      at com.salesforce.phoenix.util.SchemaUtil.initMetaData(SchemaUtil.java:314)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:720)
      at com.salesforce.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:95)
      at com.salesforce.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:100)
      at java.sql.DriverManager.getConnection(DriverManager.java:579)
      at java.sql.DriverManager.getConnection(DriverManager.java:243)
      at com.salesforce.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:154)
      Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.TABLE: tried to access method org.apache.hadoop.hbase.regionserver.HRegion.getLock(Ljava/lang/Integer;[BZ)Ljava/lang/Integer; from class com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl
      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:525)
      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:228)
      at org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:166)
      at org.apache.hadoop.hbase.ipc.ExecRPCInvoker.invoke(ExecRPCInvoker.java:79)
      at $Proxy7.createTable(Unknown Source)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl$8.call(ConnectionQueryServicesImpl.java:643)
      at com.salesforce.phoenix.query.ConnectionQueryServicesImpl$8.call(ConnectionQueryServicesImpl.java:640)
      at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation$4.call(HConnectionManager.java:1441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
      at java.util.concurrent.FutureTask.run(FutureTask.java:166)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
      at java.lang.Thread.run(Thread.java:722)
      Caused by: org.apache.hadoop.ipc.RemoteException: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.TABLE: tried to access method org.apache.hadoop.hbase.regionserver.HRegion.getLock(Ljava/lang/Integer;[BZ)Ljava/lang/Integer; from class com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl
      at com.salesforce.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:49)
      at com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:344)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.apache.hadoop.hbase.regionserver.HRegion.exec(HRegion.java:4887)
      at org.apache.hadoop.hbase.regionserver.HRegionServer.execCoprocessor(HRegionServer.java:3478)
      at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:364)
      at org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1389)
      Caused by: java.lang.IllegalAccessError: tried to access method org.apache.hadoop.hbase.regionserver.HRegion.getLock(Ljava/lang/Integer;[BZ)Ljava/lang/Integer; from class com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl
      at com.salesforce.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:308)
      ... 11 more

      at org.apache.hadoop.hbase.ipc.HBaseClient.call(HBaseClient.java:1021)
      at org.apache.hadoop.hbase.ipc.WritableRpcEngine$Invoker.invoke(WritableRpcEngine.java:150)
      at $Proxy6.execCoprocessor(Unknown Source)
      at org.apache.hadoop.hbase.ipc.ExecRPCInvoker$1.call(ExecRPCInvoker.java:75)
      at org.apache.hadoop.hbase.ipc.ExecRPCInvoker$1.call(ExecRPCInvoker.java:73)
      at org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:163)
      ... 10 more

      Attachments

        Activity

          People

            Unassigned Unassigned
            guowseu guowei
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: