[IGNITE-10291] Unable to find row by index created on partial baseline topology

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.4, 2.5, 2.6
• Fix Version/s: 2.8
• Component/s: cache, persistence, sql
• Assignee: Vladimir Ozerov
• Reporter: Pavel Vinokurov
• Created: 16/Nov/18 08:00
• Updated: 03/Dec/18 15:09
• Resolved: 03/Dec/18 15:09

Description

Steps to reproduce:
1. Start two nodes cluster with persistence.
2. Create table
CREATE TABLE PERSON (
FIRST_NAME VARCHAR,
LAST_NAME VARCHAR,
ADDRESS VARCHAR,
LANG VARCHAR,
BIRTH_DATE TIMESTAMP,
CONSTRAINT PK_PESON PRIMARY KEY (FIRST_NAME,LAST_NAME,ADDRESS,LANG)
) WITH "key_type=PersonKeyType, CACHE_NAME=PersonCache, value_type=PersonValueType, AFFINITY_KEY=FIRST_NAME,template=PARTITIONED,backups=1"

Insert 1000 rows.
3. Stop the second node.
4. Create index
create index PERSON_FIRST_NAME_IDX on PERSON(FIRST_NAME)
5. Start the second node
6. Perform select query for each row:
select * from PERSON use index(PERSON_FIRST_NAME_IDX)
where
FIRST_NAME=?
and LAST_NAME=?
and ADDRESS=?
and LANG = ?

Result: The select doesn't return row in half of cases.

The reproducer is attached.

Issue Links

• links to: GitHub Pull Request #5525