[
https://issues.apache.org/jira/browse/PHOENIX-7185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anchal Kejriwal updated PHOENIX-7185:
-------------------------------------
Description:
In SequenceNotFoundException message it is giving is tableName instead of
sequenceName. So better to change SqlBuilderInfo to support sequenceName also.
{code:java}
testSameSchemaSameClient(org.apache.phoenix.end2end.AppendOnlySchemaIT)
org.apache.phoenix.schema.SequenceNotFoundException: ERROR 1201 (42Z01):
Sequence undefined. tableName=N000002
at
org.apache.phoenix.exception.SQLExceptionCode$14.newException(SQLExceptionCode.java:376)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:217)
at
org.apache.phoenix.schema.MetaDataClient.handleCreateTableMutationCode(MetaDataClient.java:3298)
at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:3096)
at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1117)
at
org.apache.phoenix.compile.CreateTableCompiler$CreateTableMutationPlan.execute(CreateTableCompiler.java:420)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:443)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:425)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:424)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:412)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:2009)
at
org.apache.phoenix.end2end.AppendOnlySchemaIT.testTableWithSameSchema(AppendOnlySchemaIT.java:98)
at
org.apache.phoenix.end2end.AppendOnlySchemaIT.testSameSchemaSameClient(AppendOnlySchemaIT.java:186){code}
{code:java}
{code}
was:
In SequenceNotFoundException message it is giving is tableName instead of
sequenceName. So better to change SqlBuilderInfo to support sequenceName also.
testSameSchemaSameClient(org.apache.phoenix.end2end.AppendOnlySchemaIT)
org.apache.phoenix.schema.SequenceNotFoundException: ERROR 1201 (42Z01):
Sequence undefined. tableName=N000002
at
org.apache.phoenix.exception.SQLExceptionCode$14.newException(SQLExceptionCode.java:376)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:217)
at
org.apache.phoenix.schema.MetaDataClient.handleCreateTableMutationCode(MetaDataClient.java:3298)
at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:3096)
at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1117)
at
org.apache.phoenix.compile.CreateTableCompiler$CreateTableMutationPlan.execute(CreateTableCompiler.java:420)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:443)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:425)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:424)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:412)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:2009)
at
org.apache.phoenix.end2end.AppendOnlySchemaIT.testTableWithSameSchema(AppendOnlySchemaIT.java:98)
at
org.apache.phoenix.end2end.AppendOnlySchemaIT.testSameSchemaSameClient(AppendOnlySchemaIT.java:186)
{code}
{code}
> Error message in SequenceNotFoundException is misleading
> --------------------------------------------------------
>
> Key: PHOENIX-7185
> URL: https://issues.apache.org/jira/browse/PHOENIX-7185
> Project: Phoenix
> Issue Type: Bug
> Reporter: Anchal Kejriwal
> Assignee: Anchal Kejriwal
> Priority: Major
>
> In SequenceNotFoundException message it is giving is tableName instead of
> sequenceName. So better to change SqlBuilderInfo to support sequenceName also.
> {code:java}
> testSameSchemaSameClient(org.apache.phoenix.end2end.AppendOnlySchemaIT)
> org.apache.phoenix.schema.SequenceNotFoundException: ERROR 1201 (42Z01):
> Sequence undefined. tableName=N000002
> at
> org.apache.phoenix.exception.SQLExceptionCode$14.newException(SQLExceptionCode.java:376)
> at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:217)
> at
> org.apache.phoenix.schema.MetaDataClient.handleCreateTableMutationCode(MetaDataClient.java:3298)
> at
> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:3096)
> at
> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1117)
> at
> org.apache.phoenix.compile.CreateTableCompiler$CreateTableMutationPlan.execute(CreateTableCompiler.java:420)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:443)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:425)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:424)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:412)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:2009)
> at
> org.apache.phoenix.end2end.AppendOnlySchemaIT.testTableWithSameSchema(AppendOnlySchemaIT.java:98)
> at
> org.apache.phoenix.end2end.AppendOnlySchemaIT.testSameSchemaSameClient(AppendOnlySchemaIT.java:186){code}
> {code:java}
>
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
