Oh shucks, Never mind about my solution. Still not working. Will get back to the thread after making it working.
Sorry, folks. 2014-03-02 11:47 GMT+09:00 Frederick Haebin Na <[email protected]>: > 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 <[email protected]>: > > 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 >> <[email protected]>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 <[email protected]>: >>> >>> 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 < >>>> [email protected]> 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 <[email protected]>: >>>>> >>>>> 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 >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
