[
https://issues.apache.org/jira/browse/PHOENIX-7627?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viraj Jasani updated PHOENIX-7627:
----------------------------------
Description:
Single row atomic delete returning row fails to retrieve the deleted row and
convert it to ResultSet if the table name consists of case-sensitive schema and
table names.
For table name: XYZ.abc123N000001,
{code:java}
java.sql.SQLException: org.apache.hadoop.hbase.TableNotFoundException:
abc123N000001
at
org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.deleteRowAndGetMutationState(DeleteCompiler.java:901)
at
org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.execute(DeleteCompiler.java:856)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:655)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:610)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:609)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:595)
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeAtomicUpdateReturnRow(PhoenixPreparedStatement.java:234)
at
org.apache.phoenix.end2end.OnDuplicateKey2IT.validateReturnedRowAfterDelete(OnDuplicateKey2IT.java:459)
at
org.apache.phoenix.end2end.OnDuplicateKey2IT.testReturnRowResult4(OnDuplicateKey2IT.java:274)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
...
...
Caused by: org.apache.hadoop.hbase.TableNotFoundException: abc123N000001
at
org.apache.hadoop.hbase.client.ConnectionImplementation.locateRegionInMeta(ConnectionImplementation.java:1027)
at
org.apache.hadoop.hbase.client.ConnectionImplementation.locateRegion(ConnectionImplementation.java:897)
at
org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.getRegionLocations(RpcRetryingCallerWithReadReplicas.java:320)
at
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:159)
at
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:53)
at
org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithoutRetries(RpcRetryingCallerImpl.java:191)
at
org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:271)
at
org.apache.hadoop.hbase.client.ClientScanner.loadCache(ClientScanner.java:440)
at
org.apache.hadoop.hbase.client.ClientScanner.nextWithSyncCache(ClientScanner.java:314)
at
org.apache.hadoop.hbase.client.ClientScanner.next(ClientScanner.java:612)
at
org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.deleteRowAndGetMutationState(DeleteCompiler.java:892)
... 49 more{code}
was:
Single row atomic delete returning row fails to retrieve the deleted row and
convert it to ResultSet if the table name consists of case-sensitive schema and
table names.
For table name: XYZ.abc123N000001,
{code:java}
java.sql.SQLException: org.apache.hadoop.hbase.TableNotFoundException:
abc123N000001
at
org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.deleteRowAndGetMutationState(DeleteCompiler.java:901)
at
org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.execute(DeleteCompiler.java:856)
at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:655) at
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:610) at
org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:609)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:595)
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeAtomicUpdateReturnRow(PhoenixPreparedStatement.java:234)
at
org.apache.phoenix.end2end.OnDuplicateKey2IT.validateReturnedRowAfterDelete(OnDuplicateKey2IT.java:459)
at
org.apache.phoenix.end2end.OnDuplicateKey2IT.testReturnRowResult4(OnDuplicateKey2IT.java:274)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498) ...
...Caused by: org.apache.hadoop.hbase.TableNotFoundException: abc123N000001
at
org.apache.hadoop.hbase.client.ConnectionImplementation.locateRegionInMeta(ConnectionImplementation.java:1027)
at
org.apache.hadoop.hbase.client.ConnectionImplementation.locateRegion(ConnectionImplementation.java:897)
at
org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.getRegionLocations(RpcRetryingCallerWithReadReplicas.java:320)
at
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:159)
at
org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:53)
at
org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithoutRetries(RpcRetryingCallerImpl.java:191)
at
org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:271) at
org.apache.hadoop.hbase.client.ClientScanner.loadCache(ClientScanner.java:440)
at
org.apache.hadoop.hbase.client.ClientScanner.nextWithSyncCache(ClientScanner.java:314)
at
org.apache.hadoop.hbase.client.ClientScanner.next(ClientScanner.java:612) at
org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.deleteRowAndGetMutationState(DeleteCompiler.java:892)
... 49 more
{code}
> Atomic Delete return row fails for case-sensitive schema and table names
> ------------------------------------------------------------------------
>
> Key: PHOENIX-7627
> URL: https://issues.apache.org/jira/browse/PHOENIX-7627
> Project: Phoenix
> Issue Type: Bug
> Reporter: Viraj Jasani
> Priority: Major
>
> Single row atomic delete returning row fails to retrieve the deleted row and
> convert it to ResultSet if the table name consists of case-sensitive schema
> and table names.
> For table name: XYZ.abc123N000001,
> {code:java}
> java.sql.SQLException: org.apache.hadoop.hbase.TableNotFoundException:
> abc123N000001
> at
> org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.deleteRowAndGetMutationState(DeleteCompiler.java:901)
> at
> org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.execute(DeleteCompiler.java:856)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:655)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:610)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:609)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:595)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeAtomicUpdateReturnRow(PhoenixPreparedStatement.java:234)
> at
> org.apache.phoenix.end2end.OnDuplicateKey2IT.validateReturnedRowAfterDelete(OnDuplicateKey2IT.java:459)
> at
> org.apache.phoenix.end2end.OnDuplicateKey2IT.testReturnRowResult4(OnDuplicateKey2IT.java:274)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> ...
> ...
> Caused by: org.apache.hadoop.hbase.TableNotFoundException: abc123N000001
> at
> org.apache.hadoop.hbase.client.ConnectionImplementation.locateRegionInMeta(ConnectionImplementation.java:1027)
> at
> org.apache.hadoop.hbase.client.ConnectionImplementation.locateRegion(ConnectionImplementation.java:897)
> at
> org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.getRegionLocations(RpcRetryingCallerWithReadReplicas.java:320)
> at
> org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:159)
> at
> org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:53)
> at
> org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithoutRetries(RpcRetryingCallerImpl.java:191)
> at
> org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:271)
> at
> org.apache.hadoop.hbase.client.ClientScanner.loadCache(ClientScanner.java:440)
> at
> org.apache.hadoop.hbase.client.ClientScanner.nextWithSyncCache(ClientScanner.java:314)
> at
> org.apache.hadoop.hbase.client.ClientScanner.next(ClientScanner.java:612)
> at
> org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.deleteRowAndGetMutationState(DeleteCompiler.java:892)
> ... 49 more{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
