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*