The iteration happens multiple time which means that the key-value API had to 
return an empty result set on second or third iteration. But this never happens.

In any case, do you want to find a root of the issue and fix it? Otherwise, we 
can update the description and wait while someone else fixes it.

—
Denis

> On Apr 14, 2017, at 1:33 AM, ALEKSEY KUZNETSOV <alkuznetsov...@gmail.com> 
> wrote:
> 
> Because expiry time is 10 seconds, while loop iterates every 5 seconds
> 
> пт, 14 апр. 2017 г. в 11:32, ALEKSEY KUZNETSOV <alkuznetsov...@gmail.com>:
> 
>> No, the bug is in SQL query, not key-value storage.
>> 
>> пт, 14 апр. 2017 г. в 11:11, Vladislav Pyatkov <vldpyat...@gmail.com>:
>> 
>>> Denis, Aleksey,
>>> 
>>> It is correct, remember I have already said something like[1].
>>> I have no idea, why this happened in this case with SQL.
>>> 
>>> [1]:
>>> 
>>> http://apache-ignite-developers.2346864.n4.nabble.com/TouchedExpiryPolicy-works-incorrect-in-some-cases-IGNITE-4401-td16349.html#a16356
>>> 
>>> On Fri, Apr 14, 2017 at 4:29 AM, Denis Magda <dma...@apache.org> wrote:
>>> 
>>>> I could reproduce the issue and this should be what Denis K. meant by
>>>> saying “expiration policy works incorrectly”.
>>>> 
>>>> If you remove the expiration policy from the caches' configuration then
>>>> the issue disappears. In general, SQL engine processes an expiration
>>> event
>>>> properly because the SQL queries return an empty result set as expected
>>> but
>>>> something doesn’t work well with key-value operations.
>>>> 
>>>> *Denis K*, *Vlad P.*, as creators of the ticket please confirm that this
>>>> is the case.
>>>> 
>>>> Please keep debugging this and switch to the latest Ignite version.
>>>> 
>>>> —
>>>> Denis
>>>> 
>>>> 
>>>>> On Apr 13, 2017, at 4:22 AM, ALEKSEY KUZNETSOV <
>>> alkuznetsov...@gmail.com>
>>>> wrote:
>>>>> 
>>>>> any feedback?
>>>>> 
>>>>> чт, 13 апр. 2017 г. в 11:51, ALEKSEY KUZNETSOV <
>>> alkuznetsov...@gmail.com
>>>>> :
>>>>> 
>>>>>> You should run ExpiryPolicyTest. The output should contain strings
>>> like
>>>>>> contains? new AffinityKey("1", "1"): and contains?2 new
>>>> AffinityKey("1", "
>>>>>> 1"): and empty cursor? =
>>>>>> If you look at them you will see, that cache contains affinity key
>>> new
>>>>>> AffinityKey("1", "1") whereas cursor is empty(on second iteration).
>>> From
>>>>>> this output you can conclude SQL query returns icorrect data(empty
>>>> value)
>>>>>> 
>>>>>> 
>>>>>> чт, 13 апр. 2017 г. в 3:42, Denis Magda <dma...@apache.org>:
>>>>>> 
>>>>>>> Bluntly speaking I have no idea where to look and what to expect.
>>> This
>>>> is
>>>>>>> output of the test execution of my machine:
>>>>>>> 
>>>>>>> SQL res: [[1], [d]]
>>>>>>> 2
>>>>>>> Op consume: 303
>>>>>>> Value: org.ignite.test.EDU@22db8f4
>>>>>>> SQL res: []
>>>>>>> 0
>>>>>>> Op consume: 9
>>>>>>> Value: org.ignite.test.EDU@29caf222
>>>>>>> SQL res: []
>>>>>>> 0
>>>>>>> Op consume: 15
>>>>>>> Value: org.ignite.test.EDU@7cd1ac19
>>>>>>> SQL res: []
>>>>>>> 0
>>>>>>> Op consume: 5
>>>>>>> 
>>>>>>> Please be more specific, there are too many files in the code.
>>>>>>> 
>>>>>>> —
>>>>>>> Denis
>>>>>>> 
>>>>>>>> On Apr 12, 2017, at 4:50 AM, ALEKSEY KUZNETSOV <
>>>>>>> alkuznetsov...@gmail.com> wrote:
>>>>>>>> 
>>>>>>>> So what do u think about the issue ?
>>>>>>>> 
>>>>>>>> ср, 12 апр. 2017 г. в 10:42, ALEKSEY KUZNETSOV <
>>>>>>> alkuznetsov...@gmail.com>:
>>>>>>>> 
>>>>>>>>> I have already attached simlified version. Shall i simplify it
>>> more ?
>>>>>>>>> 
>>>>>>>>> вт, 11 апр. 2017 г. в 19:28, Denis Magda <dma...@apache.org>:
>>>>>>>>> 
>>>>>>>>> Can you attach the simplified version? Just want to avoid any side
>>>>>>> effects.
>>>>>>>>> 
>>>>>>>>> —
>>>>>>>>> Denis
>>>>>>>>> 
>>>>>>>>>> On Apr 11, 2017, at 9:14 AM, ALEKSEY KUZNETSOV <
>>>>>>> alkuznetsov...@gmail.com>
>>>>>>>>> wrote:
>>>>>>>>>> 
>>>>>>>>>> I took it from https://issues.apache.org/jira/browse/IGNITE-4401
>>> <
>>>>>>>>> https://issues.apache.org/jira/browse/IGNITE-4401> and
>>> simplified .
>>>>>>> See
>>>>>>>>> in attached
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> вт, 11 апр. 2017 г. в 19:03, Denis Magda <dma...@apache.org
>>>> <mailto:
>>>>>>>>> dma...@apache.org>>:
>>>>>>>>>> Hello,
>>>>>>>>>> 
>>>>>>>>>> Do you have sample code?
>>>>>>>>>> 
>>>>>>>>>> —
>>>>>>>>>> Denis
>>>>>>>>>>> On Apr 11, 2017, at 2:45 AM, ALEKSEY KUZNETSOV <
>>>>>>>>> alkuznetsov...@gmail.com <mailto:alkuznetsov...@gmail.com>>
>>> wrote:
>>>>>>>>>>> 
>>>>>>>>>>> Hi, igniters!
>>>>>>>>>>> While doing https://issues.apache.org/jira/browse/IGNITE-4401 <
>>>>>>>>> https://issues.apache.org/jira/browse/IGNITE-4401> ticket i came
>>>>>>>>>>> across the fact that cache querying returns null , while cache
>>>> still
>>>>>>>>> has
>>>>>>>>>>> got entry.
>>>>>>>>>>> Cache query : SELECT nameProp FROM EDUProp WHERE EDUId = 1
>>>>>>>>>>> Cache get operation : ignite().cache("eduPropCache").get(new
>>>>>>>>> AffinityKey("1",
>>>>>>>>>>> "1")) non-null
>>>>>>>>>>> I cannot even imagine what could be wrong with it.
>>>>>>>>>>> 
>>>>>>>>>>> 
>>>>>>>>>>> 
>>>>>>>>>>> --
>>>>>>>>>>> 
>>>>>>>>>>> *Best Regards,*
>>>>>>>>>>> 
>>>>>>>>>>> *Kuznetsov Aleksey*
>>>>>>>>>> 
>>>>>>>>>> --
>>>>>>>>>> Best Regards,
>>>>>>>>>> 
>>>>>>>>>> Kuznetsov Aleksey
>>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>> --
>>>>>>>>> 
>>>>>>>>> *Best Regards,*
>>>>>>>>> 
>>>>>>>>> *Kuznetsov Aleksey*
>>>>>>>>> 
>>>>>>>> --
>>>>>>>> 
>>>>>>>> *Best Regards,*
>>>>>>>> 
>>>>>>>> *Kuznetsov Aleksey*
>>>>>>> 
>>>>>>> --
>>>>>> 
>>>>>> *Best Regards,*
>>>>>> 
>>>>>> *Kuznetsov Aleksey*
>>>>>> 
>>>>> --
>>>>> 
>>>>> *Best Regards,*
>>>>> 
>>>>> *Kuznetsov Aleksey*
>>>> 
>>>> 
>>> 
>>> 
>>> --
>>> Vladislav Pyatkov
>>> 
>> --
>> 
>> *Best Regards,*
>> 
>> *Kuznetsov Aleksey*
>> 
> -- 
> 
> *Best Regards,*
> 
> *Kuznetsov Aleksey*

Reply via email to