You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Ravi Kishore Valeti (JIRA)" <ji...@apache.org> on 2014/08/26 21:37:57 UTC
[jira] [Updated] (PHOENIX-1212) Create table if not exists throws
TableNotEnaledException while promoting Hbase Table to Phoenix
[ 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 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
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 "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 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
--
This message was sent by Atlassian JIRA
(v6.2#6252)