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 >>>> >>>> >>>> >>>> >>> >> >
