Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1762

rg.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.2.0
    • Fix Version/s: None
    • Labels:

      Description

      Hi James Taylor,

      I am facing this issue repetately. Its not the case always getting this issue. Sometimes only it is occuring. Not able to identify the root cause of this issue. We are using hbase 0.98 and phoenix-4.2.0. Following are the two scenarios where i have faced this issue,

      Scenario1:
      1. Ran a simple aggregation query without any join in phoenix client directly.
      2. Client throws table not found exception.
      3. Ran command !tables in client.
      4. None of the tables were shown in the client apart from SYSTEM tables.
      5. Quit the client and reconnected again.
      6. Ran the same command !tables in client.
      7. Now i can able to see all the tables along with SYSTEM tables.
      8. Ran the same query. The query executed successfully and gave the result.

      Scenario2:
      1. Ran a simple aggregation query without any join from our application server through phoenix jdbc server.
      2. Application throws Phoenix table not found exception.
      3. Re triggered the same process
      4. The same query executed sucessfully by the same process and returned the result.

      Exception Trace:
      org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined.
      at org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:303)
      at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:215)
      at org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:159)
      at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:374)
      at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:139)
      at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:311)
      at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:294)
      at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:215)
      at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:211)
      at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
      at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:210)
      at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:1013)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              thamarai_selvi Thamarai Selvi
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: