You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Sergey Kozlov (JIRA)" <ji...@apache.org> on 2019/02/05 21:03:00 UTC

[jira] [Created] (IGNITE-11218) COUNT(*) may return wrong value with PDS

Sergey Kozlov created IGNITE-11218:
--------------------------------------

             Summary: 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: sql
    Affects Versions: 2.7
            Reporter: Sergey Kozlov
         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}}
{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)