[PHOENIX-7295] Fix getTableRegions failing due to overlap/inconsistencies on region

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.2.0, 5.1.4
• Assignee: Tanuj Khurana
• Reporter: Tanuj Khurana
• Created: 29/Mar/24 21:39
• Updated: 02/Apr/24 23:43
• Resolved: 02/Apr/24 23:43

Description

Call is failing with below exception but prev region start/end key is more that current region start/end key.

HBase region overlap/inconsistencies on region=TEST.T1,00DG0000000BmaA0D51L00007I7hn000516000006bhpG,1630096440965.f7984a617b32835f54e080f236e6517e., hostname=localhost,61020,1711471610848, seqNum=130428 , current key: 00DG0000000BmaA0D51L00007Iagpf00516000006wBmb , region startKey: 00DG0000000BmaA0D51L00007I7hn000516000006bhpG , region endKey: 00DG0000000BmaA0D51L00007JBsQU005G0000004AXE2 , prev region startKey: 00DG0000000BmaA0D51L00009I6xCm00516000006bhpG , prev region endKey: 00DG0000000BmaA0D58X00009JLrTm 

Exception encountered in getAllTableRegions for table: TEST.T1, retryCount: 3 , currentKey: 00DG0000000BmaA0D51L00007Iagpf , startRowKey: 00DG0000000BmaA0D51L00007Iagpf , endRowKey: 00DG0000000BmaA0D58X0000E2Nmki
Cause: java.io.IOException: HBase region information overlap/inconsistencies on region TEST.T1,00DG0000000BmaA0D51L00007I7hn000516000006bhpG,1630096440965.f7984a617b32835f54e080f236e6517e.
StackTrace: 
org.apache.phoenix.query.ConnectionQueryServicesImpl.getNextRegionStartKey(ConnectionQueryServicesImpl.java:775)
org.apache.phoenix.query.ConnectionQueryServicesImpl.getTableRegions(ConnectionQueryServicesImpl.java:815)
org.apache.phoenix.query.DelegateConnectionQueryServices.getTableRegions(DelegateConnectionQueryServices.java:96)
org.apache.phoenix.iterate.DefaultParallelScanGrouper.getRegionBoundaries(DefaultParallelScanGrouper.java:85)
org.apache.phoenix.iterate.BaseResultIterators.getRegionBoundaries(BaseResultIterators.java:588) 

Issue Links

• is caused by: PHOENIX-7253 Metadata lookup performance improvement for range scan queries
• links to: GitHub Pull Request #1870