[jira] [Resolved] (PHOENIX-1793) Exception encountered when executing the Phoenix query "If Table Not exists" when table does not exist

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

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

James Taylor resolved PHOENIX-1793.
-----------------------------------
    Resolution: Duplicate

This was fixed by not creating a local index table up front for multi tenant tables.

> Exception encountered when executing the Phoenix query "If Table Not exists" when table does not exist
> ------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1793
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1793
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Muhammad Tayyab Javed
>            Priority: Minor
>
> Every call to create a hbase table goes through a phoenix query to check if that table exists or not , such a query is gacking always. Here is the stack trace
>  
> org.apache.hadoop.hbase.TableNotFoundException: _LOCAL_IDX_RRS_00DX00000030LXQEAU_0LGX00000004CE3GAM
> at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getHTableDescriptor(HConnectionManager.java:2668)
> at hbase.client.CounterProtectedHConnection$14.inner(CounterProtectedHConnection.java:200)
> at hbase.client.CounterProtectedHConnection$14.inner(CounterProtectedHConnection.java:197)
> at hbase.client.ProtectedResourceOperation.outer(ProtectedResourceOperation.java:38)
> at hbase.client.CounterProtectedHConnection.getHTableDescriptor(CounterProtectedHConnection.java:197)
> at org.apache.hadoop.hbase.client.HTable.getTableDescriptor(HTable.java:565)
> at hbase.client.CounterProtectedHTable$22.inner(CounterProtectedHTable.java:295)
> at hbase.client.CounterProtectedHTable$22.inner(CounterProtectedHTable.java:292)
> at hbase.client.ProtectedResourceOperation.outer(ProtectedResourceOperation.java:38)
> at hbase.client.CounterProtectedHTable.getTableDescriptor(CounterProtectedHTable.java:292)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.getTableDescriptor(ConnectionQueryServicesImpl.java:307)
> at org.apache.phoenix.util.MetaDataUtil.hasLocalIndexTable(MetaDataUtil.java:349)
> at org.apache.phoenix.util.MetaDataUtil.hasLocalIndexTable(MetaDataUtil.java:343)
> at org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:1819)
> at org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:1788)
> at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDropTableStatement$1.execute(PhoenixStatement.java:605)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:280)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:272)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:270)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1052)
> at phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:73)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)