phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vasanth Bhat <vasb...@gmail.com>
Subject Re: Errors while launching sqlline
Date Sun, 03 Jul 2016 05:36:07 GMT
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 <vasbhat@gmail.com> 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.
>
>
> 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