You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Mujtaba Chohan (JIRA)" <ji...@apache.org> on 2016/01/15 20:21:39 UTC
[jira] [Updated] (PHOENIX-2600) NPE on immutable index creation
over transactional table
[ https://issues.apache.org/jira/browse/PHOENIX-2600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mujtaba Chohan updated PHOENIX-2600:
------------------------------------
Description:
{code}
org.apache.phoenix.exception.PhoenixIOException: java.lang.NullPointerException
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:111)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:627)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:569)
at org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
at org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
at org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCompiler.java:768)
at org.apache.phoenix.compile.DelegateMutationPlan.execute(DelegateMutationPlan.java:31)
at org.apache.phoenix.compile.PostIndexDDLCompiler$1.execute(PostIndexDDLCompiler.java:124)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2620)
at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1106)
at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1399)
at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:242)
at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172)
at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177)
at org.apache.phoenix.jdbc.PhoenixConnection.executeStatements(PhoenixConnection.java:351)
at org.apache.phoenix.util.PhoenixRuntime.executeStatements(PhoenixRuntime.java:293)
at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:238)
Caused by: java.util.concurrent.ExecutionException: java.lang.NullPointerException
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:622)
... 20 more
Caused by: java.lang.NullPointerException
at org.apache.phoenix.execute.MutationState.addReadFence(MutationState.java:247)
at org.apache.phoenix.execute.MutationState.send(MutationState.java:851)
at org.apache.phoenix.execute.MutationState.send(MutationState.java:1248)
at org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:185)
at org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:106)
at org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:221)
at org.apache.phoenix.compile.MutatingParallelIteratorFactory.newIterator(MutatingParallelIteratorFactory.java:59)
at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:112)
at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:103)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
{code}
*DDL*
{code}
CREATE TABLE IF NOT EXISTS PHERF.FHA (
ORGANIZATION_ID CHAR(15) NOT NULL,
PARENT_ID CHAR(15) NOT NULL,
CREATED_DATE DATE NOT NULL,
ENTITY_HISTORY_ID CHAR(15) NOT NULL,
FIELD_HISTORY_ARCHIVE_ID CHAR(15),
CREATED_BY_ID VARCHAR,
FIELD VARCHAR,
DATA_TYPE VARCHAR,
OLDVAL_STRING VARCHAR,
NEWVAL_STRING VARCHAR,
OLDVAL_FIRST_NAME VARCHAR,
NEWVAL_FIRST_NAME VARCHAR,
OLDVAL_LAST_NAME VARCHAR,
NEWVAL_LAST_NAME VARCHAR,
OLDVAL_NUMBER DECIMAL,
NEWVAL_NUMBER DECIMAL,
OLDVAL_DATE DATE,
NEWVAL_DATE DATE,
ARCHIVE_PARENT_TYPE VARCHAR,
ARCHIVE_FIELD_NAME VARCHAR,
ARCHIVE_TIMESTAMP DATE,
ARCHIVE_PARENT_NAME VARCHAR,
DIVISION INTEGER,
CONNECTION_ID VARCHAR
CONSTRAINT PK PRIMARY KEY
(
ORGANIZATION_ID,
PARENT_ID,
CREATED_DATE DESC,
ENTITY_HISTORY_ID
)
) MULTI_TENANT=true,IMMUTABLE_ROWS=true,TRANSACTIONAL=true
{code}
*Index*
{code}
CREATE INDEX IDX_FHA ON PHERF.FHA (FIELD_HISTORY_ARCHIVE_ID, NEWVAL_DATE);
{code}
was:
{code}
org.apache.phoenix.exception.PhoenixIOException: java.lang.NullPointerException
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:111)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:627)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:569)
at org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
at org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
at org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCompiler.java:768)
at org.apache.phoenix.compile.DelegateMutationPlan.execute(DelegateMutationPlan.java:31)
at org.apache.phoenix.compile.PostIndexDDLCompiler$1.execute(PostIndexDDLCompiler.java:124)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2620)
at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1106)
at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1399)
at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:242)
at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172)
at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177)
at org.apache.phoenix.jdbc.PhoenixConnection.executeStatements(PhoenixConnection.java:351)
at org.apache.phoenix.util.PhoenixRuntime.executeStatements(PhoenixRuntime.java:293)
at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:238)
Caused by: java.util.concurrent.ExecutionException: java.lang.NullPointerException
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:622)
... 20 more
Caused by: java.lang.NullPointerException
at org.apache.phoenix.execute.MutationState.addReadFence(MutationState.java:247)
at org.apache.phoenix.execute.MutationState.send(MutationState.java:851)
at org.apache.phoenix.execute.MutationState.send(MutationState.java:1248)
at org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:185)
at org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:106)
at org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:221)
at org.apache.phoenix.compile.MutatingParallelIteratorFactory.newIterator(MutatingParallelIteratorFactory.java:59)
at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:112)
at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:103)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
{code}
*DDL*
CREATE TABLE IF NOT EXISTS PHERF.FHA (
ORGANIZATION_ID CHAR(15) NOT NULL,
PARENT_ID CHAR(15) NOT NULL,
CREATED_DATE DATE NOT NULL,
ENTITY_HISTORY_ID CHAR(15) NOT NULL,
FIELD_HISTORY_ARCHIVE_ID CHAR(15),
CREATED_BY_ID VARCHAR,
FIELD VARCHAR,
DATA_TYPE VARCHAR,
OLDVAL_STRING VARCHAR,
NEWVAL_STRING VARCHAR,
OLDVAL_FIRST_NAME VARCHAR,
NEWVAL_FIRST_NAME VARCHAR,
OLDVAL_LAST_NAME VARCHAR,
NEWVAL_LAST_NAME VARCHAR,
OLDVAL_NUMBER DECIMAL,
NEWVAL_NUMBER DECIMAL,
OLDVAL_DATE DATE,
NEWVAL_DATE DATE,
ARCHIVE_PARENT_TYPE VARCHAR,
ARCHIVE_FIELD_NAME VARCHAR,
ARCHIVE_TIMESTAMP DATE,
ARCHIVE_PARENT_NAME VARCHAR,
DIVISION INTEGER,
CONNECTION_ID VARCHAR
CONSTRAINT PK PRIMARY KEY
(
ORGANIZATION_ID,
PARENT_ID,
CREATED_DATE DESC,
ENTITY_HISTORY_ID
)
) MULTI_TENANT=true,IMMUTABLE_ROWS=true,TRANSACTIONAL=true
*Index*
CREATE INDEX IDX_FHA ON PHERF.FHA (FIELD_HISTORY_ARCHIVE_ID, NEWVAL_DATE);
> NPE on immutable index creation over transactional table
> --------------------------------------------------------
>
> Key: PHOENIX-2600
> URL: https://issues.apache.org/jira/browse/PHOENIX-2600
> Project: Phoenix
> Issue Type: Bug
> Reporter: Mujtaba Chohan
> Assignee: James Taylor
>
> {code}
> org.apache.phoenix.exception.PhoenixIOException: java.lang.NullPointerException
> at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:111)
> at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:627)
> at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:569)
> at org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
> at org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
> at org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCompiler.java:768)
> at org.apache.phoenix.compile.DelegateMutationPlan.execute(DelegateMutationPlan.java:31)
> at org.apache.phoenix.compile.PostIndexDDLCompiler$1.execute(PostIndexDDLCompiler.java:124)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2620)
> at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1106)
> at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1399)
> at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
> at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:242)
> at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:172)
> at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:177)
> at org.apache.phoenix.jdbc.PhoenixConnection.executeStatements(PhoenixConnection.java:351)
> at org.apache.phoenix.util.PhoenixRuntime.executeStatements(PhoenixRuntime.java:293)
> at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:238)
> Caused by: java.util.concurrent.ExecutionException: java.lang.NullPointerException
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:206)
> at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:622)
> ... 20 more
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.execute.MutationState.addReadFence(MutationState.java:247)
> at org.apache.phoenix.execute.MutationState.send(MutationState.java:851)
> at org.apache.phoenix.execute.MutationState.send(MutationState.java:1248)
> at org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:185)
> at org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:106)
> at org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:221)
> at org.apache.phoenix.compile.MutatingParallelIteratorFactory.newIterator(MutatingParallelIteratorFactory.java:59)
> at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:112)
> at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:103)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {code}
> *DDL*
> {code}
> CREATE TABLE IF NOT EXISTS PHERF.FHA (
> ORGANIZATION_ID CHAR(15) NOT NULL,
> PARENT_ID CHAR(15) NOT NULL,
> CREATED_DATE DATE NOT NULL,
> ENTITY_HISTORY_ID CHAR(15) NOT NULL,
> FIELD_HISTORY_ARCHIVE_ID CHAR(15),
> CREATED_BY_ID VARCHAR,
> FIELD VARCHAR,
> DATA_TYPE VARCHAR,
> OLDVAL_STRING VARCHAR,
> NEWVAL_STRING VARCHAR,
> OLDVAL_FIRST_NAME VARCHAR,
> NEWVAL_FIRST_NAME VARCHAR,
> OLDVAL_LAST_NAME VARCHAR,
> NEWVAL_LAST_NAME VARCHAR,
> OLDVAL_NUMBER DECIMAL,
> NEWVAL_NUMBER DECIMAL,
> OLDVAL_DATE DATE,
> NEWVAL_DATE DATE,
> ARCHIVE_PARENT_TYPE VARCHAR,
> ARCHIVE_FIELD_NAME VARCHAR,
> ARCHIVE_TIMESTAMP DATE,
> ARCHIVE_PARENT_NAME VARCHAR,
> DIVISION INTEGER,
> CONNECTION_ID VARCHAR
> CONSTRAINT PK PRIMARY KEY
> (
> ORGANIZATION_ID,
> PARENT_ID,
> CREATED_DATE DESC,
> ENTITY_HISTORY_ID
> )
> ) MULTI_TENANT=true,IMMUTABLE_ROWS=true,TRANSACTIONAL=true
> {code}
> *Index*
> {code}
> CREATE INDEX IDX_FHA ON PHERF.FHA (FIELD_HISTORY_ARCHIVE_ID, NEWVAL_DATE);
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)