[jira] [Created] (PHOENIX-1212) Create table if not exists throws TableNotEnaledException while promoting Hbase Table to Phoenix

["Ravi Kishore Valeti (JIRA)" <ji...@apache.org>]

Ravi Kishore Valeti created PHOENIX-1212:
--------------------------------------------

             Summary: Create table if not exists throws TableNotEnaledException while promoting Hbase Table to Phoenix
                 Key: PHOENIX-1212
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1212
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.1
            Reporter: Ravi Kishore Valeti
            Priority: Minor


When multiple threads run "create table if not exists" concurrently on a pre-existing HBase Table, only one succeedes and others fail with 
org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.TableNotEnabledException: TEST_11
	at org.apache.hadoop.hbase.master.handler.DisableTableHandler.prepare(DisableTableHandler.java:100)
      .
      .
      .
      .
	at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:101)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:846)
	at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1057)
	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1156)
	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422)
	at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:908)
	at com.salesforce.hbasemm.phoenix.PhoenixClient.executeUpdate(PhoenixClient.java:170)
	at PhoenixCreateTableTest$TableCreateThread.run(PhoenixCreateTableTest.java:50)
	at java.lang.Thread.run(Thread.java:745)

i) Create a Table from Hbase Shell

> create "TEST_PHOENIX","cf"

ii) Run a Test with multiple Threads trying to execute "create table if not exists" query

create table if not exists "TEST_PHOENIX" ("role" VARCHAR primary key, "cf"."hosts" VARCHAR)

Only one thread will succeed with rest all ending up with the above exception




--
This message was sent by Atlassian JIRA
(v6.2#6252)