[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lars Hofhansl updated PHOENIX-3163:
---
Comment: was deleted
(was: Also, can someone remind me why regionsplits are bad? So bad that check
on the server whether the Scan's start/stop key match the region's beginning
and end key...?)
> Split during global index creation may cause ERROR 201 error
>
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
>Priority: Major
> Fix For: 4.14.0, 5.0.0
>
> Attachments: PHOENIX-3163_addendum1.patch, PHOENIX-3163_v1.patch,
> PHOENIX-3163_v3.patch, PHOENIX-3163_v4.patch, PHOENIX-3163_v5.patch,
> PHOENIX-3163_v6.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.pho
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lars Hofhansl updated PHOENIX-3163:
---
Comment: was deleted
(was: I suggest we roll this one back.
[~sergey.soldatov], [~rajeshbabu], [~jamestaylor], this breaks the general
UPSERT SELECT case now. Also this has no test, so it's hard to make sure any
changes we do in PHOENIX-4849 will not break this case again.
Edit: Since the change never resets the stopKey from the scan (see newScan in
the code), this would even theoretically not fix the problem, we'd pass a new
scan with the old stopKey and the server would again flag it as a stale region
cache.
I'm going to revert.)
> Split during global index creation may cause ERROR 201 error
>
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
>Priority: Major
> Fix For: 4.14.0, 5.0.0
>
> Attachments: PHOENIX-3163_addendum1.patch, PHOENIX-3163_v1.patch,
> PHOENIX-3163_v3.patch, PHOENIX-3163_v4.patch, PHOENIX-3163_v5.patch,
> PHOENIX-3163_v6.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpressi
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-3163:
--
Attachment: PHOENIX-3163_addendum1.patch
> Split during global index creation may cause ERROR 201 error
>
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
>Priority: Major
> Fix For: 4.14.0, 5.0.0
>
> Attachments: PHOENIX-3163_addendum1.patch, PHOENIX-3163_v1.patch,
> PHOENIX-3163_v3.patch, PHOENIX-3163_v4.patch, PHOENIX-3163_v5.patch,
> PHOENIX-3163_v6.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutat
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-3163:
--
Fix Version/s: 5.0.0
> Split during global index creation may cause ERROR 201 error
>
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
>Priority: Major
> Fix For: 4.14.0, 5.0.0
>
> Attachments: PHOENIX-3163_v1.patch, PHOENIX-3163_v3.patch,
> PHOENIX-3163_v4.patch, PHOENIX-3163_v5.patch, PHOENIX-3163_v6.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:259)
> at
> org.apache.p
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-3163:
--
Fix Version/s: (was: 4.15.0)
4.14.0
> Split during global index creation may cause ERROR 201 error
>
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
>Priority: Major
> Fix For: 4.14.0, 5.0.0
>
> Attachments: PHOENIX-3163_v1.patch, PHOENIX-3163_v3.patch,
> PHOENIX-3163_v4.patch, PHOENIX-3163_v5.patch, PHOENIX-3163_v6.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompile
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-3163:
--
Summary: Split during global index creation may cause ERROR 201 error
(was: Split during global index creation may cause ERROR 201 error.)
> Split during global index creation may cause ERROR 201 error
>
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
>Priority: Major
> Fix For: 4.15.0
>
> Attachments: PHOENIX-3163_v1.patch, PHOENIX-3163_v3.patch,
> PHOENIX-3163_v4.patch, PHOENIX-3163_v5.patch, PHOENIX-3163_v6.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.c
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-3163:
--
Attachment: PHOENIX-3163_v6.patch
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
>Priority: Major
> Fix For: 4.15.0
>
> Attachments: PHOENIX-3163_v1.patch, PHOENIX-3163_v3.patch,
> PHOENIX-3163_v4.patch, PHOENIX-3163_v5.patch, PHOENIX-3163_v6.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:259)
> at
> org.
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-3163:
--
Attachment: PHOENIX-3163_v5.patch
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
>Priority: Major
> Fix For: 4.15.0
>
> Attachments: PHOENIX-3163_v1.patch, PHOENIX-3163_v3.patch,
> PHOENIX-3163_v4.patch, PHOENIX-3163_v5.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:259)
> at
> org.apache.phoenix.compile.
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-3163:
--
Fix Version/s: (was: 4.8.1)
4.9.0
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3163_v1.patch, PHOENIX-3163_v3.patch,
> PHOENIX-3163_v4.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:259)
> at
> org.apache.phoenix.compile.MutatingParallelIteratorFactor
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rajeshbabu Chintaguntla updated PHOENIX-3163:
-
Attachment: PHOENIX-3163_v4.patch
There is a chance that the query might have client side aggregations but not
server side then also we should not handle the Stale region boundary exception.
Added check in the patch and also for upsert select queries failing the queries
if the table is local index. otherwise creating ScanningResultIterator with new
scan object. [~sergey.soldatov] [~samarthjain] please review.
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
> Fix For: 4.8.1
>
> Attachments: PHOENIX-3163_v1.patch, PHOENIX-3163_v3.patch,
> PHOENIX-3163_v4.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rajeshbabu Chintaguntla updated PHOENIX-3163:
-
Attachment: PHOENIX-3163_v3.patch
Here is the patch what I was telling.
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
> Fix For: 4.8.1
>
> Attachments: PHOENIX-3163_v1.patch, PHOENIX-3163_v3.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:259)
> at
> org.apache.phoenix.compile.MutatingParallelI
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Samarth Jain updated PHOENIX-3163:
--
Attachment: PHOENIX-3163_v1.patch
[~sergey.soldatov] - sorry about the last patch. It had some changes which
shouldn't be there. Irrespective of whether or not the patch fixes the issue, I
think the call to recreate scanner isn't correct.
{code}
this.scanIterator =
plan.iterator(scanGrouper, newScan);
{code}
It should instead be what I have in this patch.
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
> Fix For: 4.8.1
>
> Attachments: PHOENIX-3163_v1.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(Ups
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Samarth Jain updated PHOENIX-3163:
--
Attachment: (was: PHOENIX-3163_v1.patch)
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
> Fix For: 4.8.1
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:259)
> at
> org.apache.phoenix.compile.MutatingParallelIteratorFactory.newIterator(MutatingParallelIteratorFactory.java:59)
> at
> org.apache.phoenix.iterate.ParallelIter
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Samarth Jain updated PHOENIX-3163:
--
Attachment: PHOENIX-3163_v1.patch
[~sergey.soldatov] - can you try out this possible fix and see if it resolves
the issue you are seeing.
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
> Fix For: 4.8.1
>
> Attachments: PHOENIX-3163_v1.patch
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:259)
> at
> org.apache.phoenix.com
[jira] [Updated] (PHOENIX-3163) Split during global index creation may cause ERROR 201 error.
[
https://issues.apache.org/jira/browse/PHOENIX-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-3163:
--
Fix Version/s: 4.8.1
> Split during global index creation may cause ERROR 201 error.
> -
>
> Key: PHOENIX-3163
> URL: https://issues.apache.org/jira/browse/PHOENIX-3163
> Project: Phoenix
> Issue Type: Bug
>Affects Versions: 4.8.0
>Reporter: Sergey Soldatov
>Assignee: Sergey Soldatov
> Fix For: 4.8.1
>
>
> When we create global index and split happen meanwhile there is a chance to
> fail with ERROR 201:
> {noformat}
> 2016-08-08 15:55:17,248 INFO [Thread-6]
> org.apache.phoenix.iterate.BaseResultIterators(878): Failed to execute task
> during cancel
> java.util.concurrent.ExecutionException: java.sql.SQLException: ERROR 201
> (22000): Illegal data.
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:192)
> at
> org.apache.phoenix.iterate.BaseResultIterators.close(BaseResultIterators.java:872)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:809)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:713)
> 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:815)
> 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:2823)
> at
> org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1079)
> at
> org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1382)
> at
> org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:85)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:343)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:331)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:330)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1440)
> at
> org.apache.phoenix.hbase.index.write.TestIndexWriter$1.run(TestIndexWriter.java:93)
> Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data.
> at
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:441)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
> at
> org.apache.phoenix.schema.types.PDataType.newIllegalDataException(PDataType.java:287)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint$UnsignedShortCodec.decodeShort(PUnsignedSmallint.java:146)
> at
> org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:104)
> at org.apache.phoenix.schema.types.PSmallint.toObject(PSmallint.java:28)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PUnsignedSmallint.toObject(PUnsignedSmallint.java:102)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:980)
> at
> org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:992)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:830)
> at
> org.apache.phoenix.schema.types.PDecimal.coerceBytes(PDecimal.java:342)
> at
> org.apache.phoenix.schema.types.PDataType.coerceBytes(PDataType.java:810)
> at
> org.apache.phoenix.expression.CoerceExpression.evaluate(CoerceExpression.java:149)
> at
> org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.getBytes(PhoenixResultSet.java:308)
> at
> org.apache.phoenix.compile.UpsertCompiler.upsertSelect(UpsertCompiler.java:197)
> at
> org.apache.phoenix.compile.UpsertCompiler.access$000(UpsertCompiler.java:115)
> at
> org.apache.phoenix.compile.UpsertCompiler$UpsertingParallelIteratorFactory.mutate(UpsertCompiler.java:259)
> at
> org.apache.phoenix.compile.MutatingParallelIteratorFactory.newIterator(MutatingParallelIteratorFactory.java:59)
> at
> org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIte
