java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions

GitHub | naheedmk | 2 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Demo UI generating exception

    GitHub | 2 months ago | naheedmk
    java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions
  2. 0

    When region server serving SYSTEM.CATALOG is down or when all region servers are down, phoenix throws 'Incompatible jar detected' exception which is misleading and wraps 'Cannot get all table region exception'. Stack: 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: at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:333) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:902) at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:799) at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1107) at org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:114) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1315) .... java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:333) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:409) at org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:857) ... 191 shared with parent

    Apache's JIRA Issue Tracker | 2 years ago | Mujtaba Chohan
    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:
  3. 0

    Getting SQLException in Phoenix JDBC client

    Stack Overflow | 1 year ago | Learner
    java.sql.SQLException: ERROR 2007 (INT09): Outdated jars. The following servers require an updated phoenix.jar to be put in the classpath of HBase: region=SYSTEM.CATALOG
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Guava conflict with wildfly 9.0.2

    Stack Overflow | 8 months ago | DarKAngeL
    org.apache.hadoop.hbase.zookeeper.MetaTableLocator
  6. 0

    Re: CsvBulkUpload not working after upgrade to 4.6

    phoenix-user | 1 year ago | Gabriel Reid
    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: > org.apache.hadoop.hbase.protobuf.generated.ZooKeeperProtos$MetaRegionServer.hasState()Z at > org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:396) at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) at > org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1000) at > org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:879) at > org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1225) at > org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:113) at > org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2013) at > org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:785) at > org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186) at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:319) at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:311) at > org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:309) at > org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1368) at > org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1929) at > org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1898) at > org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78) at > org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1898) at > org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:180) at > org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:132) at > org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:151) at > java.sql.DriverManager.getConnection(DriverManager.java:571) at > java.sql.DriverManager.getConnection(DriverManager.java:187) at > org.apache.phoenix.util.QueryUtil.getConnection(QueryUtil.java:301) at > org.apache.phoenix.util.QueryUtil.getConnection(QueryUtil.java:292) at > org.apache.phoenix.mapreduce.CsvBulkLoadTool.loadData(CsvBulkLoadTool.java:211) at > org.apache.phoenix.mapreduce.CsvBulkLoadTool.run(CsvBulkLoadTool.java:184)

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ERROR 1102 (XCL02): Cannot get all table regions

      at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException()
    2. Phoenix Core
      PhoenixDriver.connect
      1. org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:386)
      2. org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
      3. org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:443)
      4. org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:941)
      5. org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:867)
      6. org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1213)
      7. org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:112)
      8. org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1902)
      9. org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:744)
      10. org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186)
      11. org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:303)
      12. org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:295)
      13. org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
      14. org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:293)
      15. org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1236)
      16. org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1891)
      17. org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1860)
      18. org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
      19. org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1860)
      20. org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
      21. org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:131)
      22. org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
      22 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:664)
      2. java.sql.DriverManager.getConnection(DriverManager.java:270)
      2 frames