Re: Errors while launching sqlline

Mon, 18 Jul 2016 08:38:01 -0700

You can check the dev list for the VOTE thread which contains a link to the release candidate but it is not an official Apache Phoenix release yet. 

Vasanth Bhat wrote:

Thanks a lot Ankit.

where do I download this from?   I am looking at
http://mirror.fibergrid.in/apache/phoenix/    don't seem to find the 4.8
version here.
Do I need to look at somewhere else?

Thanks
Vasanth




On Thu, Jul 14, 2016 at 10:33 AM, Ankit Singhal<[email protected]>
wrote:


Hi Vasanth,

RC for 4.8(with support of hbase-1.2) is just out today, you can try with
the latest build.

Regards,
Ankit Singhal

On Thu, Jul 14, 2016 at 10:06 AM, Vasanth Bhat<[email protected]>  wrote:


Thanks James.

          When are the early builds going to be available for  Phoenix
4.8.0?
also are the two errors below related to  hbase version compatibility?
There  are also seems to be some java class loader related issue?

How do I enable debug to get more information?

Thanks
Vasanth


On Sun, Jul 3, 2016 at 12:05 PM, James Taylor<[email protected]>
wrote:


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<[email protected]>  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<[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

Reply via email to