[
https://issues.apache.org/jira/browse/IGNITE-11218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16763610#comment-16763610
]
Vladimir Ozerov commented on IGNITE-11218:
------------------------------------------
[~skozlov], as discussed, this is expected behavior for PRIMARY_SYNC.
> COUNT(*) may return wrong value with PDS
> ----------------------------------------
>
> Key: IGNITE-11218
> URL: https://issues.apache.org/jira/browse/IGNITE-11218
> Project: Ignite
> Issue Type: Bug
> Components: persistence, sql
> Affects Versions: 2.7
> Reporter: Sergey Kozlov
> Priority: Major
> Attachments: count.zip
>
>
> 1. Unzip attached file into {{examples}} directory
> 2. Open {{ignite-examples}} project in IDEA.
> 3. Start at least 3 nodes {{bin/ignite.sh examples/config/count.xml -v}}
> 4. Run {{SqlJdbcCountExample}} which creates tables by template _Replicated,
> TX, PRIMARY_SYNC, readFromBackup=false_, inserts 500 rows and executes
> _SELECT COUNT(*)_
> {noformat}
> [23:54:44] Ignite node started OK (id=97f4654e)
> [23:54:44] >>> Ignite cluster is not active (limited functionality
> available). Use control.(sh|bat) script or IgniteCluster interface to
> activate.
> [23:54:44] Topology snapshot [ver=4, locNode=97f4654e, servers=3, clients=1,
> state=INACTIVE, CPUs=4, offheap=0.66GB, heap=8.3GB]
> [23:54:45] Ignite node stopped OK [uptime=00:00:01.238]
> >>> Connected to server.
> >>> Attempt 1
> >>> ERROR! Expected 500 entries for table t1 but got 498 entries
> >>> Attempt 2
> >>> ERROR! Expected 500 entries for table t2 but got 476 entries
> >>> Attempt 3
> >>> ERROR! Expected 500 entries for table t3 but got 477 entries
> >>> Attempt 4
> >>> ERROR! Expected 500 entries for table t4 but got 430 entries
> >>> Attempt 5
> >>> Attempt 6
> >>> ERROR! Expected 500 entries for table t6 but got 486 entries
> >>> Attempt 7
> >>> Attempt 8
> >>> ERROR! Expected 500 entries for table t8 but got 463 entries
> >>> Attempt 9
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
