[PHOENIX-6090] Local indexes get out of sync after changes for global consistent indexes

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 4.15.0, 5.1.0, 4.16.0
• Fix Version/s: 5.1.0, 4.16.0
• Assignee: Lars Hofhansl
• Reporter: Lars Hofhansl
• Created: 20/Aug/20 07:05
• Updated: 15/Jan/21 12:22
• Resolved: 22/Aug/20 18:56

Description

 > select /*+ NO_INDEX */ count(*) from test;
+----------+
| COUNT(1) |
+----------+
| 522244   |
+----------+
1 row selected (1.213 seconds)

> select count(*) from test;
+---------+
| COUNT(1) |
+----------+
| 522245   |
+----------+
1 row selected (1.23 seconds)

 

This was after I did some insert and a bunch of splits (but not in parallel).

It's not, yet, clear under what circumstances that exactly happens. Just that after a while it happens.

This is Phoenix built from master and HBase built from branch-2.3. (Client and server versions of HBase are matching).

I've since tried with Phoenix 4.x and see the same issue - also see attached tests.

Sub-Tasks

• Improve LOCAL index consistency tests: Resolved
• Avoid duplicate work between local and global indexes: Resolved