You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Tupitsyn (JIRA)" <ji...@apache.org> on 2016/08/09 12:33:28 UTC
[jira] [Updated] (IGNITE-2078) Need to clean cache after query in
CacheQueryExample
[ https://issues.apache.org/jira/browse/IGNITE-2078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Tupitsyn updated IGNITE-2078:
-----------------------------------
Fix Version/s: (was: 1.7)
1.8
> Need to clean cache after query in CacheQueryExample
> ----------------------------------------------------
>
> Key: IGNITE-2078
> URL: https://issues.apache.org/jira/browse/IGNITE-2078
> Project: Ignite
> Issue Type: Bug
> Components: cache
> Affects Versions: 1.5.0.final
> Environment: OS X 10.10.2
> jdk 1.7
> Reporter: Ilya Suntsov
> Assignee: Alexey Goncharuk
> Fix For: 1.8
>
>
> Steps to reproduce:
> 1. Build examples
> 2. Start several nodes: org/apache/ignite/examples/ExampleNodeStartup.java
> 3. Run org/apache/ignite/examples/datagrid/CacheQueryExample.java
> Example output:
> {noformat}
> >>> Cache query example started.
> >>> People with salaries between 0 and 1000 (queried with SCAN query):
> >>> Entry [key=AffinityKey [key=1717604734904449, affKey=-6908357575301716955], val=Person [firstName=Jane, lastName=Doe, id=1717604734904449, orgId=-6908357575301716955, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=-591199628496362239, affKey=-7983468300595888028], val=Person [firstName=John, lastName=Smith, id=-591199628496362239, orgId=-7983468300595888028, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> People with salaries between 0 and 1000 (queried with SQL query):
> >>> Entry [key=AffinityKey [key=1717604734904449, affKey=-6908357575301716955], val=Person [firstName=Jane, lastName=Doe, id=1717604734904449, orgId=-6908357575301716955, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=-591199628496362239, affKey=-7983468300595888028], val=Person [firstName=John, lastName=Smith, id=-591199628496362239, orgId=-7983468300595888028, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> People with salaries between 1000 and 2000 (queried with SQL query):
> >>> Entry [key=AffinityKey [key=6165286975353599015, affKey=-7983468300595888028], val=Person [firstName=Jane, lastName=Smith, id=6165286975353599015, orgId=-7983468300595888028, resume=Jane Smith has Master Degree., salary=2000.0]]
> >>> Entry [key=AffinityKey [key=-3732623193094597924, affKey=-6908357575301716955], val=Person [firstName=John, lastName=Doe, id=-3732623193094597924, orgId=-6908357575301716955, resume=John Doe has Master Degree., salary=2000.0]]
> >>> Following people are 'ApacheIgnite' employees:
> >>> Following people are 'Other' employees:
> >>> Entry [key=AffinityKey [key=-591199628496362239, affKey=-7983468300595888028], val=Person [firstName=John, lastName=Smith, id=-591199628496362239, orgId=-7983468300595888028, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Following people have 'Master Degree' in their resumes:
> >>> Entry [key=AffinityKey [key=6165286975353599015, affKey=-7983468300595888028], val=Person [firstName=Jane, lastName=Smith, id=6165286975353599015, orgId=-7983468300595888028, resume=Jane Smith has Master Degree., salary=2000.0]]
> >>> Entry [key=AffinityKey [key=-3732623193094597924, affKey=-6908357575301716955], val=Person [firstName=John, lastName=Doe, id=-3732623193094597924, orgId=-6908357575301716955, resume=John Doe has Master Degree., salary=2000.0]]
> >>> Following people have 'Bachelor Degree' in their resumes:
> >>> Entry [key=AffinityKey [key=1717604734904449, affKey=-6908357575301716955], val=Person [firstName=Jane, lastName=Doe, id=1717604734904449, orgId=-6908357575301716955, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=-591199628496362239, affKey=-7983468300595888028], val=Person [firstName=John, lastName=Smith, id=-591199628496362239, orgId=-7983468300595888028, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Average salary for 'ApacheIgnite' employees:
> >>> [null]
> >>> Names of all employees:
> >>> [Jane Smith]
> >>> [Jane Doe]
> >>> [John Doe]
> >>> [John Smith]
> >>> Names of all employees and organizations they belong to:
> >>> [John Smith, Other]
> >>> Cache query example finished.
> [13:01:23] Ignite node stopped OK [uptime=00:00:01:297]
> {noformat}
> 4. Start example second time (don't stop nodes).
> Example output:
> {noformat}
> >>> Cache query example started.
> >>> People with salaries between 0 and 1000 (queried with SCAN query):
> >>> Entry [key=AffinityKey [key=1717604734904449, affKey=-6908357575301716955], val=Person [firstName=Jane, lastName=Doe, id=1717604734904449, orgId=-6908357575301716955, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=-591199628496362239, affKey=-7983468300595888028], val=Person [firstName=John, lastName=Smith, id=-591199628496362239, orgId=-7983468300595888028, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=5197178966669880766, affKey=1592024302498385925], val=Person [firstName=John, lastName=Smith, id=5197178966669880766, orgId=1592024302498385925, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=8974786509558363413, affKey=5589626694668844], val=Person [firstName=Jane, lastName=Doe, id=8974786509558363413, orgId=5589626694668844, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> People with salaries between 0 and 1000 (queried with SQL query):
> >>> Entry [key=AffinityKey [key=1717604734904449, affKey=-6908357575301716955], val=Person [firstName=Jane, lastName=Doe, id=1717604734904449, orgId=-6908357575301716955, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=-591199628496362239, affKey=-7983468300595888028], val=Person [firstName=John, lastName=Smith, id=-591199628496362239, orgId=-7983468300595888028, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=5197178966669880766, affKey=1592024302498385925], val=Person [firstName=John, lastName=Smith, id=5197178966669880766, orgId=1592024302498385925, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=8974786509558363413, affKey=5589626694668844], val=Person [firstName=Jane, lastName=Doe, id=8974786509558363413, orgId=5589626694668844, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> People with salaries between 1000 and 2000 (queried with SQL query):
> >>> Entry [key=AffinityKey [key=-3732623193094597924, affKey=-6908357575301716955], val=Person [firstName=John, lastName=Doe, id=-3732623193094597924, orgId=-6908357575301716955, resume=John Doe has Master Degree., salary=2000.0]]
> >>> Entry [key=AffinityKey [key=5870108035079820267, affKey=5589626694668844], val=Person [firstName=John, lastName=Doe, id=5870108035079820267, orgId=5589626694668844, resume=John Doe has Master Degree., salary=2000.0]]
> >>> Entry [key=AffinityKey [key=4778749539838745402, affKey=1592024302498385925], val=Person [firstName=Jane, lastName=Smith, id=4778749539838745402, orgId=1592024302498385925, resume=Jane Smith has Master Degree., salary=2000.0]]
> >>> Following people are 'ApacheIgnite' employees:
> >>> Entry [key=AffinityKey [key=8974786509558363413, affKey=5589626694668844], val=Person [firstName=Jane, lastName=Doe, id=8974786509558363413, orgId=5589626694668844, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=5870108035079820267, affKey=5589626694668844], val=Person [firstName=John, lastName=Doe, id=5870108035079820267, orgId=5589626694668844, resume=John Doe has Master Degree., salary=2000.0]]
> >>> Following people are 'Other' employees:
> >>> Entry [key=AffinityKey [key=4778749539838745402, affKey=1592024302498385925], val=Person [firstName=Jane, lastName=Smith, id=4778749539838745402, orgId=1592024302498385925, resume=Jane Smith has Master Degree., salary=2000.0]]
> >>> Following people have 'Master Degree' in their resumes:
> >>> Entry [key=AffinityKey [key=-3732623193094597924, affKey=-6908357575301716955], val=Person [firstName=John, lastName=Doe, id=-3732623193094597924, orgId=-6908357575301716955, resume=John Doe has Master Degree., salary=2000.0]]
> >>> Entry [key=AffinityKey [key=5870108035079820267, affKey=5589626694668844], val=Person [firstName=John, lastName=Doe, id=5870108035079820267, orgId=5589626694668844, resume=John Doe has Master Degree., salary=2000.0]]
> >>> Entry [key=AffinityKey [key=4778749539838745402, affKey=1592024302498385925], val=Person [firstName=Jane, lastName=Smith, id=4778749539838745402, orgId=1592024302498385925, resume=Jane Smith has Master Degree., salary=2000.0]]
> >>> Following people have 'Bachelor Degree' in their resumes:
> >>> Entry [key=AffinityKey [key=1717604734904449, affKey=-6908357575301716955], val=Person [firstName=Jane, lastName=Doe, id=1717604734904449, orgId=-6908357575301716955, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=-591199628496362239, affKey=-7983468300595888028], val=Person [firstName=John, lastName=Smith, id=-591199628496362239, orgId=-7983468300595888028, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=5197178966669880766, affKey=1592024302498385925], val=Person [firstName=John, lastName=Smith, id=5197178966669880766, orgId=1592024302498385925, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=8974786509558363413, affKey=5589626694668844], val=Person [firstName=Jane, lastName=Doe, id=8974786509558363413, orgId=5589626694668844, resume=Jane Doe has Bachelor Degree., salary=1000.0]]
> >>> Entry [key=AffinityKey [key=5197178966669880766, affKey=1592024302498385925], val=Person [firstName=John, lastName=Smith, id=5197178966669880766, orgId=1592024302498385925, resume=John Smith has Bachelor Degree., salary=1000.0]]
> >>> Average salary for 'ApacheIgnite' employees:
> >>> [1500.0]
> >>> Names of all employees:
> >>> [John Smith]
> >>> [Jane Doe]
> >>> [John Doe]
> >>> [John Smith]
> >>> [Jane Doe]
> >>> [John Doe]
> >>> [Jane Smith]
> >>> Names of all employees and organizations they belong to:
> >>> [Jane Doe, ApacheIgnite]
> >>> [John Doe, ApacheIgnite]
> >>> [Jane Smith, Other]
> >>> Cache query example finished.
> [13:01:50] Ignite node stopped OK [uptime=00:00:00:438]
> {noformat}
> Results are different. We have duplicate rows in second time.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)