[
https://issues.apache.org/jira/browse/PHOENIX-1762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14482587#comment-14482587
]
Thamarai Selvi commented on PHOENIX-1762:
-----------------------------------------
Any updates on this. It is impacting us regularly in production. Please help.
> rg.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
> undefined
> ------------------------------------------------------------------------------------
>
> Key: PHOENIX-1762
> URL: https://issues.apache.org/jira/browse/PHOENIX-1762
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.2.0
> Reporter: Thamarai Selvi
> Priority: Critical
> Labels: Newbie
>
> 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)
