ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-10291) Unable to find row by index created on partial baseline topology
Date Thu, 29 Nov 2018 08:23:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-10291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16702845#comment-16702845
] 

Vladimir Ozerov commented on IGNITE-10291:
------------------------------------------

Test run: https://ci.ignite.apache.org/viewQueued.html?itemId=2422359

> Unable to find row by index created on partial baseline topology
> ----------------------------------------------------------------
>
>                 Key: IGNITE-10291
>                 URL: https://issues.apache.org/jira/browse/IGNITE-10291
>             Project: Ignite
>          Issue Type: Bug
>          Components: cache, persistence, sql
>    Affects Versions: 2.4, 2.5, 2.6
>            Reporter: Pavel Vinokurov
>            Assignee: Vladimir Ozerov
>            Priority: Critical
>             Fix For: 2.8
>
>         Attachments: Reproducer.java
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message