[jira] [Resolved] (PHOENIX-1762) rg.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-1762.
-----------------------------------
    Resolution: Cannot Reproduce

Please reopen if the problem occurs again.

> 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)