Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Phoenix query server in Hbase is getting stopped after restarting.

Highlighted

Phoenix query server in Hbase is getting stopped after restarting.

New Contributor

After Restarting also phoenix server is getting stopped .After restart it will work for some seconds and again getting stopped.Please help.

logs:-

INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing zookeeper sessionid=0x15ca2ca52ba3d42 2018-02-25 11:15:54,847 FATAL org.apache.phoenix.queryserver.server.Main: Unrecoverable service error. Shutting down. java.lang.RuntimeException: 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: SYSTEM.CATALOG is disabled. at org.apache.phoenix.queryserver.server.PhoenixMetaFactoryImpl.create(PhoenixMetaFactoryImpl.java:73) at org.apache.phoenix.queryserver.server.Main.run(Main.java:203) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.phoenix.queryserver.server.Main.main(Main.java:226) Caused by: 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: SYSTEM.CATALOG is disabled. at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:386) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) at org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:990) at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:869)

4 REPLIES 4

Re: Phoenix query server in Hbase is getting stopped after restarting.

@Manoj Menon

Looks like you are using multiple versions of phoenix jars. Make sure you have the same version of phoenix jar in hbase lib directory (/usr/hdp/current/hbase-client/lib/) in master and all the region servers

Re: Phoenix query server in Hbase is getting stopped after restarting.

New Contributor

I have checked and all jars are same version.

Re: Phoenix query server in Hbase is getting stopped after restarting.

New Contributor

I solved this error by enabling system-catalog table .But now it is getting stopped after some time due to one error and that table is already present in that slave.

org.apache.hadoop.hbase.NotServingRegionException: Region SYSTEM.CATALOG,,1472064039558.0e215adee75cb12a96b422b7a820da20. is not online

Re: Phoenix query server in Hbase is getting stopped after restarting.

New Contributor

I solved this issue by enable some tables from the hbase like system catalog,sequence,function & stats