Hi ,
I am stuck not able to progress. Any suggestions to debug the
issue? Please advice.
Thanks
Vasanth
On Thu, Jun 30, 2016 at 10:32 AM, Vasanth Bhat <[email protected]> wrote:
> 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.
>
>
> [email protected]:~/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)
> [email protected]:~/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
>
>
> [email protected]:~/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
>
>
>
> [email protected]:~/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
>
>
>
>
>
>
>
>
>
>
>
