[
https://issues.apache.org/jira/browse/PHOENIX-1212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ravi Kishore Valeti updated PHOENIX-1212:
-----------------------------------------
Description:
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 Phoenix Query "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
was:
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 Phoenix Queyr "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
> 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
> Labels: Phoenix
>
> 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 Phoenix Query "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)
