ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Kozlov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-11218) COUNT(*) may return wrong value with PDS
Date Wed, 06 Feb 2019 13:33:00 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-11218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sergey Kozlov updated IGNITE-11218:
-----------------------------------
    Attachment:     (was: count.zip)

> 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,
copyOnRead=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)

Mime
View raw message