Viraj Jasani created PHOENIX-7627:
-------------------------------------

             Summary: 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


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)

Reply via email to