ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anil <anilk...@gmail.com>
Subject Re: IGNITE-4106
Date Tue, 21 Mar 2017 04:02:38 GMT
Hi Andrew,

#1 - it is very simple select query - select * from person hwere personid =
'something';
i just ran the query in for loop and noticed the results are not same.

#2 - it is stable topology. swap is configured. but this test was done when
full load is completed and some compute job going on for other cache.

Please let me know if you have any questions. thanks.

Thanks.

On 20 March 2017 at 21:07, Andrey Mashenkov <andrey.mashenkov@gmail.com>
wrote:

> Hi Anil,
>
> 1. Would you please share sql query text?
>
> 2. Is it happening on unstable topology or during rebalancing? Or may be
> eviction\expire policy or swap is configured?
>
> On Mon, Mar 20, 2017 at 5:41 PM, Anil <anilklce@gmail.com> wrote:
>
>> Yes. i am using partition cache only with no joins :)
>>
>> how about #2 ?
>>
>> On 20 March 2017 at 19:20, Andrey Mashenkov <andrey.mashenkov@gmail.com>
>> wrote:
>>
>>> Hi Anil,
>>>
>>> I should although mention that Replicated caches can participate in same
>>> query with partitioned caches regardless a degree of parallelizm.
>>> This limitation relates to partitioned caches only.
>>>
>>> On Mon, Mar 20, 2017 at 3:54 PM, Andrey Mashenkov <
>>> andrey.mashenkov@gmail.com> wrote:
>>>
>>>> Hi Anil,
>>>>
>>>> It is ok. Doc says *"If a query contains JOINs, then all the
>>>> participating caches must have the same degree of parallelism.".*
>>>> Possibly, it is easy to fix but there can be unobvious limitations, so
>>>> we need a time to make a POC.
>>>> I believe, it will be fixed in future releases.
>>>>
>>>> On Mon, Mar 20, 2017 at 1:11 PM, Anil <anilklce@gmail.com> wrote:
>>>>
>>>>> Hi Andrey,
>>>>>
>>>>> I see few more issues with IGNITE-4826
>>>>>
>>>>> 1. queryParallelism should be used for all caches for which queries
>>>>> are used other it throws following exception.
>>>>>
>>>>> Caused by: java.sql.SQLException: Failed to query Ignite.
>>>>>         at org.apache.ignite.internal.jdb
>>>>> c2.JdbcStatement.executeQuery(JdbcStatement.java:131)
>>>>>         at org.apache.ignite.internal.jdb
>>>>> c2.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:76)
>>>>>         at org.apache.commons.dbcp2.Deleg
>>>>> atingPreparedStatement.executeQuery(DelegatingPreparedStatem
>>>>> ent.java:83)
>>>>>         at org.apache.commons.dbcp2.Deleg
>>>>> atingPreparedStatement.executeQuery(DelegatingPreparedStatem
>>>>> ent.java:83)
>>>>>
>>>>> Caused by: javax.cache.CacheException: class
>>>>> org.apache.ignite.IgniteException: Using indexes with different
>>>>> parallelism levels in same query is forbidden.
>>>>>         at org.apache.ignite.internal.pro
>>>>> cessors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:760)
>>>>>         at org.apache.ignite.internal.jdb
>>>>> c2.JdbcQueryTask.call(JdbcQueryTask.java:161)
>>>>>         at org.apache.ignite.internal.jdb
>>>>> c2.JdbcStatement.executeQuery(JdbcStatement.java:116)
>>>>>         ... 13 more
>>>>> 2. query is not returning same result if it is hit number of times.
>>>>>
>>>>> please let me know if these are known issues.
>>>>>
>>>>> Thanks
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Best regards,
>>>> Andrey V. Mashenkov
>>>>
>>>
>>>
>>>
>>> --
>>> Best regards,
>>> Andrey V. Mashenkov
>>>
>>
>>
>
>
> --
> Best regards,
> Andrey V. Mashenkov
>

Mime
View raw message