phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Errors while launching sqlline
Date Sun, 03 Jul 2016 06:35:20 GMT
Phoenix 4.7.0 does not support HBase 1.2.1, but Phoenix 4.8.0 will. We're
very close to getting an RC up for this, so stay tuned.

Thanks,
James

On Sun, Jul 3, 2016 at 7:36 AM, Vasanth Bhat <vasbhat@gmail.com> wrote:

> 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