phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: How to install 3.0?
Date Sun, 02 Mar 2014 01:05:48 GMT
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