Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-10291

Unable to find row by index created on partial baseline topology

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      None

      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.

        Attachments

        1. Reproducer.java
          6 kB
          Pavel Vinokurov

          Issue Links

            Activity

              People

              • Assignee:
                vozerov Vladimir Ozerov
                Reporter:
                pvinokurov Pavel Vinokurov
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: