phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Frederick Haebin Na <haebin...@gmail.com>
Subject Re: How to install 3.0?
Date Sun, 02 Mar 2014 02:47:44 GMT
Hey James,

I figured out the source of the problem by remote debugging HBase & Phoenix.
It turned out that I am using HBase version 0.9.15 and the 3.0.0-SNAPSHOT
depends on 0.9.16.

So, I built the Phoenix with HBase 0.9.15 by modifying the root pom.xml and
it worked just fine.
Hope this helped for all the other folks with similar problems.

Best,
Haebin




2014-03-02 10:05 GMT+09:00 James Taylor <jamestaylor@apache.org>:

> Try manually disabling and dropping the SYSTEM.TABLE and/or SYSTEM.CATALOG
> from the HBase shell. Make sure you only have one phoenix jar in the hbase
> lib dir and make sure it's not the one with "client" in the name.
>
> Thanks,
> James
>
>
> On Sat, Mar 1, 2014 at 4:50 PM, Frederick Haebin Na <haebin.na@gmail.com>wrote:
>
>> Hi Stan,
>>
>> Thank you for your suggestion.
>> Yet, I tried all the stuffs recommend here.
>>
>> https://groups.google.com/forum/#!topic/phoenix-hbase-user/gvkHbjZKmtU
>>
>> He had the same problem, but didn't mention how he solved he. Sigh :(
>>
>> Best,
>> Haebin
>>
>>
>>
>> 2014-03-01 2:51 GMT+09:00 Stan Campbell <stan.campbell3@gmail.com>:
>>
>> Sounds like maybe you have multiple versions of the jars in your hbase
>>> lib directory?
>>>
>>>
>>> On Thu, Feb 27, 2014 at 11:41 PM, Frederick Haebin Na <
>>> haebin.na@gmail.com> wrote:
>>>
>>>> Forgot to add my settings' info.
>>>>
>>>> CentOS 6.3
>>>> cdh4.6.0
>>>> HBase 0.94.15
>>>>
>>>>
>>>> Do I need to add the following to hbase-site.xml?
>>>>
>>>>   <property>
>>>>     <name>hbase.coprocessor.user.region.classes</name>
>>>>     <value>???</value>
>>>>   </property>
>>>>
>>>>
>>>>
>>>> Thank you,
>>>> Haebin
>>>>
>>>>
>>>> 2014-02-28 16:19 GMT+09:00 Frederick Haebin Na <haebin.na@gmail.com>:
>>>>
>>>> Hell all,
>>>>>
>>>>> The document says that put phoenix-<version>.jar in hbase/lib
>>>>> directory but there isn't phoenix-<version>.jar like the previous
versions.
>>>>> (2.2.2, 2.2.3)
>>>>>
>>>>> So, I just put the core file, phoenix-core-3.0.0-SNAPSHOT.jar, in
>>>>> hbase/lib directory, yet it does not seem to work.
>>>>> sqlline.py (not .sh) produces an error like the following.
>>>>>
>>>>> Setting property: [isolation, TRANSACTION_READ_COMMITTED]
>>>>> issuing: !connect jdbc:phoenix:localhost none none
>>>>> org.apache.phoenix.jdbc.PhoenixDriver
>>>>> Connecting to jdbc:phoenix:localhost
>>>>> Error: ERROR 2006 (INT08): Incompatible jars detected between client
>>>>> and server. Ensure that phoenix.jar is put on the classpath of HBase
in
>>>>> every region server: null (state=INT08,code=2006)
>>>>> java.sql.SQLException: ERROR 2006 (INT08): Incompatible jars detected
>>>>> between client and server. Ensure that phoenix.jar is put on the classpath
>>>>> of HBase in every region server: null
>>>>>  at
>>>>> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:308)
>>>>> at
>>>>> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
>>>>>  at
>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:761)
>>>>> at
>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:641)
>>>>>  at
>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:884)
>>>>> at
>>>>> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1129)
>>>>>  at
>>>>> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:409)
>>>>> at
>>>>> org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:174)
>>>>>  at
>>>>> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
>>>>> at
>>>>> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:912)
>>>>>  at
>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1171)
>>>>> at
>>>>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:100)
>>>>>  at
>>>>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:108)
>>>>> at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
>>>>>  at
>>>>> sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
>>>>> at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
>>>>>  at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>>  at
>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>>> at
>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>>  at java.lang.reflect.Method.invoke(Method.java:606)
>>>>> at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
>>>>>  at sqlline.SqlLine.dispatch(SqlLine.java:817)
>>>>> at sqlline.SqlLine.initArgs(SqlLine.java:633)
>>>>> at sqlline.SqlLine.begin(SqlLine.java:680)
>>>>>  at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
>>>>> at sqlline.SqlLine.main(SqlLine.java:424)
>>>>> Caused by: java.lang.reflect.UndeclaredThrowableException
>>>>> at com.sun.proxy.$Proxy7.getVersion(Unknown Source)
>>>>> at
>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQueryServicesImpl.java:736)
>>>>>  at
>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQueryServicesImpl.java:733)
>>>>> at
>>>>> org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation$4.call(HConnectionManager.java:1605)
>>>>>  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
>>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:166)
>>>>>  at
>>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>>>> at
>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>>>>  at java.lang.Thread.run(Thread.java:724)
>>>>> Caused by:
>>>>> org.apache.hadoop.hbase.ipc.HBaseRPC$UnknownProtocolException:
>>>>> org.apache.hadoop.hbase.ipc.HBaseRPC$UnknownProtocolException: No matching
>>>>> handler for protocol org.apache.phoenix.coprocessor.MetaDataProtocol
in
>>>>> region SYSTEM.CATALOG,,1393571709854.ff2ff7eaea2d82e6f4bbb892d323307b.
>>>>>  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>>>>> Method)
>>>>> at
>>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>>>>>  at
>>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>>>>>  at
>>>>> org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:95)
>>>>> at
>>>>> org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:79)
>>>>>  at
>>>>> org.apache.hadoop.hbase.client.ServerCallable.translateException(ServerCallable.java:256)
>>>>> at
>>>>> org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:166)
>>>>>  at
>>>>> org.apache.hadoop.hbase.ipc.ExecRPCInvoker.invoke(ExecRPCInvoker.java:79)
>>>>> ... 9 more
>>>>> Caused by: org.apache.hadoop.ipc.RemoteException:
>>>>> org.apache.hadoop.hbase.ipc.HBaseRPC$UnknownProtocolException: No matching
>>>>> handler for protocol org.apache.phoenix.coprocessor.MetaDataProtocol
in
>>>>> region SYSTEM.CATALOG,,1393571709854.ff2ff7eaea2d82e6f4bbb892d323307b.
>>>>>  at
>>>>> org.apache.hadoop.hbase.regionserver.HRegion.exec(HRegion.java:5591)
>>>>> at
>>>>> org.apache.hadoop.hbase.regionserver.HRegionServer.execCoprocessor(HRegionServer.java:3918)
>>>>>  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>> at
>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>>>  at
>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>> at java.lang.reflect.Method.invoke(Method.java:606)
>>>>>  at
>>>>> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:323)
>>>>> at
>>>>> org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428)
>>>>>
>>>>> at org.apache.hadoop.hbase.ipc.HBaseClient.call(HBaseClient.java:1012)
>>>>> at
>>>>> org.apache.hadoop.hbase.ipc.WritableRpcEngine$Invoker.invoke(WritableRpcEngine.java:87)
>>>>>  at com.sun.proxy.$Proxy6.execCoprocessor(Unknown Source)
>>>>> at
>>>>> org.apache.hadoop.hbase.ipc.ExecRPCInvoker$1.call(ExecRPCInvoker.java:75)
>>>>>  at
>>>>> org.apache.hadoop.hbase.ipc.ExecRPCInvoker$1.call(ExecRPCInvoker.java:73)
>>>>> at
>>>>> org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:164)
>>>>>  ... 10 more
>>>>> sqlline version 1.1.2
>>>>> 0: jdbc:phoenix:localhost>
>>>>>
>>>>>
>>>>> Funny thing is that I tried all the other versions, such as, 2.2.2 and
>>>>> 2.2.3, but none of them worked with similar error. (Incompatible version,
>>>>> please deploy phoenix.jar in hbase/lib)
>>>>>
>>>>> Can anyone guide me what to do?
>>>>>
>>>>>
>>>>> Best,
>>>>> Haebin
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>

Mime
View raw message