Thamarai Selvi created PHOENIX-1761:
---------------------------------------
Summary: rg.apache.phoenix.schema.TableNotFoundException: ERROR
1012 (42M03): Table undefined
Key: PHOENIX-1761
URL: https://issues.apache.org/jira/browse/PHOENIX-1761
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.2
Reporter: Thamarai Selvi
Priority: Critical
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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
