Mujtaba Chohan created PHOENIX-2600:
---------------------------------------
Summary: 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*
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);
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
