[
https://issues.apache.org/jira/browse/IGNITE-8900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16528164#comment-16528164
]
Vladimir Ozerov commented on IGNITE-8900:
-----------------------------------------
The problem is caused by link content - it is impossible to resolve correct
partition form a link. Thus, duplicate or missing entries appear.
Please see {{ignite-8900-repro}} [1] branch with simplified and stable
reproducer. Two nodes, several cache create-destroy cycles. On fifth attempt
test fails. Offending key is {{610026643276160002}}. On {{node1}} it resolves
to partition {{831}}, on {{node2}} to {{108}}. See debug output in
{{H2Tree#getRow}}.
[1] https://github.com/apache/ignite/tree/ignite-8900-repro
> SqlFieldsQuery provides incorrect result when item size exceeds page size
> -------------------------------------------------------------------------
>
> Key: IGNITE-8900
> URL: https://issues.apache.org/jira/browse/IGNITE-8900
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.4
> Reporter: Anton Kurbanov
> Priority: Blocker
> Attachments: Main.java, Node.java
>
>
> Start several server nodes, then start client, execute queries with value
> range in where clause. Duplicate entries may be found, some entries may be
> missing.
> Results as an example:
> expected 5 results but got back 3 results (query range 610026643276160000 to
> 610026643276160004), cache.getAll returned 5 entries.
> expected 8 results but got back 7 results (query range 610026643276160000 to
> 610026643276160007), cache.getAll returned 8 entries.
> Query results: [610026643276160000, 610026643276160003, 610026643276160004,
> 610026643276160005, 610026643276160005, 610026643276160006,
> 610026643276160007]
> Please find reproducer attached.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
