phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vasanth Bhat <vasb...@gmail.com>
Subject Errors while launching sqlline
Date Thu, 30 Jun 2016 05:02:35 GMT
Hi,
        We are trying to do a small POC with  Hbase 1.2.1 , Hadoop 2.6.4,
zookeeper 3.4.8 and phoenix 4.7.0.

We have setup a three node zookeeper quorum, and hbase 1.2.1 setup with 3
region servers.
The Hbase and zk setup seems to be OK, as we are able to do basic   CRUD
operations with hbase.

Now we are trying to setup phoenix and  connect.

When I try to  launch sqlline.py, I get the following exception.


hadoop@client-121.hbasepoc.com:~/phoenix-4.7.0-HBase-1.1-bin/bin$
*./sqlline.py
zk1.hbasepoc.com <http://zk1.hbasepoc.com>,zk2.hbasepoc.com
<http://zk2.hbasepoc.com>,zk3.hbasepoc.com:2181/hbase
<http://zk3.hbasepoc.com:2181/hbase>*
phoenix_utils.hbase_conf_dir => /etc/hbase/conf
phoenix_utils.phoenix_client_jar =>
/u01/hadoop/phoenix-4.7.0-HBase-1.1-bin/bin/../phoenix-4.7.0-HBase-1.1-client.jar
java_cmd => /usr/jdk/instances/jdk1.8.0/bin/java $PHOENIX_OPTS  -cp
"/etc/hbase/conf:/u01/hadoop/phoenix-4.7.0-HBase-1.1-bin/bin/../phoenix-4.7.0-HBase-1.1-client.jar:::/etc/hadoop/conf:"
-Dlog4j.configuration=file:/u01/hadoop/phoenix-4.7.0-HBase-1.1-bin/bin/log4j.properties
sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver -u jdbc:phoenix:
zk1.hbasepoc.com,zk2.hbasepoc.com,zk3.hbasepoc.com:2181/hbase -n none -p
none --color=true --fastConnect=false --verbose=true --incremental=false
--isolation=TRANSACTION_READ_COMMITTED
Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:zk1.hbasepoc.com,zk2.hbasepoc.com,
zk3.hbasepoc.com:2181/hbase none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:zk1.hbasepoc.com,zk2.hbasepoc.com,
zk3.hbasepoc.com:2181/hbase
*java.lang.NoClassDefFoundError: Could not initialize class
org.apache.hadoop.hbase.util.Bytes$LexicographicalComparerHolder$UnsafeComparer*
        at org.apache.hadoop.hbase.util.Bytes.putInt(Bytes.java:899)
        at
org.apache.hadoop.hbase.KeyValue.createByteArray(KeyValue.java:1082)
        at org.apache.hadoop.hbase.KeyValue.<init>(KeyValue.java:652)
        at org.apache.hadoop.hbase.KeyValue.<init>(KeyValue.java:580)
        at org.apache.hadoop.hbase.KeyValue.<init>(KeyValue.java:483)
        at org.apache.hadoop.hbase.KeyValue.<init>(KeyValue.java:370)
        at org.apache.hadoop.hbase.KeyValue.<clinit>(KeyValue.java:267)
        at
org.apache.phoenix.util.KeyValueUtil.newKeyValue(KeyValueUtil.java:48)
        at
org.apache.phoenix.util.KeyValueUtil.newKeyValue(KeyValueUtil.java:82)
        at
org.apache.phoenix.jdbc.PhoenixDatabaseMetaData.<clinit>(PhoenixDatabaseMetaData.java:1004)
        at
org.apache.phoenix.exception.SQLExceptionCode.<clinit>(SQLExceptionCode.java:238)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:392)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:211)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2269)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248)
        at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248)
        at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233)
        at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135)
        at
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
        at
sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
        at sqlline.Commands.connect(Commands.java:1064)
        at sqlline.Commands.connect(Commands.java:996)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
        at sqlline.SqlLine.dispatch(SqlLine.java:804)
        at sqlline.SqlLine.initArgs(SqlLine.java:588)
        at sqlline.SqlLine.begin(SqlLine.java:656)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)
sqlline version 1.1.8
0: jdbc:phoenix:zk1.hbasepoc.com,zk2.hbasepoc>


Now  when I try to quit the program, I again get new set of exceptions as
below.



0: jdbc:phoenix:zk1.hbasepoc.com,zk2.hbasepoc> !quit
*java.lang.NoClassDefFoundError: Could not initialize class
org.apache.phoenix.exception.SQLExceptionCode*
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:392)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:211)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2269)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248)
        at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248)
        at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233)
        at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135)
        at
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
        at
sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
        at sqlline.Commands.close(Commands.java:906)
        at sqlline.Commands.quit(Commands.java:870)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
        at sqlline.SqlLine.dispatch(SqlLine.java:804)
        at sqlline.SqlLine.begin(SqlLine.java:681)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)
*Exception in thread "main" java.lang.NoClassDefFoundError: Could not
initialize class org.apache.phoenix.exception.SQLExceptionCode*
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:392)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:211)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2269)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248)
        at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248)
        at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233)
        at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135)
        at
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
        at
sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
        at sqlline.Commands.close(Commands.java:906)
        at sqlline.Commands.closeall(Commands.java:880)
        at sqlline.SqlLine.begin(SqlLine.java:709)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)
hadoop@client-121.hbasepoc.com:~/phoenix-4.7.0-HBase-1.1-bin/bin$


I looked into the jar  "phoenix-4.7.0-HBase-1.1-client.jar"  and see that
both of these classes are present


hadoop@client-121.hbasepoc.com:~/phoenix-4.7.0-HBase-1.1-bin$ *jar -tvf
phoenix-4.7.0-HBase-1.1-client.jar | grep
org.apache.hadoop.hbase.util.Bytes$LexicographicalComparerHolder$UnsafeComparer*
  1651 Sat Jan 16 18:17:00 IST 2016
org/apache/hadoop/hbase/util/Bytes$1.class
   770 Sat Jan 16 18:17:00 IST 2016
org/apache/hadoop/hbase/util/Bytes$2.class
  1795 Sat Jan 16 18:17:00 IST 2016
org/apache/hadoop/hbase/util/Bytes$ByteArrayComparator.class
   364 Sat Jan 16 18:17:00 IST 2016
org/apache/hadoop/hbase/util/Bytes$Comparer.class
  2208 Sat Jan 16 18:17:00 IST 2016
org/apache/hadoop/hbase/util/Bytes$LexicographicalComparerHolder$PureJavaComparer.class
  4489 Sat Jan 16 18:17:00 IST 2016
org/apache/hadoop/hbase/util/Bytes$LexicographicalComparerHolder$UnsafeComparer.class
  1984 Sat Jan 16 18:17:00 IST 2016
org/apache/hadoop/hbase/util/Bytes$LexicographicalComparerHolder.class
  1509 Sat Jan 16 18:17:00 IST 2016
org/apache/hadoop/hbase/util/Bytes$RowEndKeyComparator.class
 31594 Sat Jan 16 18:17:00 IST 2016 org/apache/hadoop/hbase/util/Bytes.class



hadoop@client-121.hbasepoc.com:~/phoenix-4.7.0-HBase-1.1-bin$ *jar -tvf
phoenix-4.7.0-HBase-1.1-client.jar | grep
org.apache.phoenix.exception.SQLExceptionCode*
   997 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$16.class
  1084 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$5.class
  1080 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$6.class
  1041 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$7.class
   987 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$9.class
   947 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$8.class
  1032 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$Factory$2.class
   947 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$15.class
   729 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$Factory.class
   997 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$2.class
   992 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$12.class
   994 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$10.class
   936 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$1.class
  1038 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$14.class
  1018 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$4.class
  1016 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$3.class
  1000 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$13.class
  1160 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$Factory$1.class
   997 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode$11.class
 30164 Thu Mar 03 12:48:14 IST 2016
org/apache/phoenix/exception/SQLExceptionCode.class

I tried with both JDK 7  as well as JDK 8, the  results are the same.

Thanks
Vasanth

Mime
View raw message