You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ignite.apache.org by "ratadepally (via GitHub)" <gi...@apache.org> on 2024/07/11 19:54:43 UTC
[I] Question: Querying Ignite Cache with Eviction and external storage enabled [ignite]
ratadepally opened a new issue, #11433:
URL: https://github.com/apache/ignite/issues/11433
Hi,
We are currently working on a scenario where we have cache with some of the below configuration.
1. Dedicated data region with min and max provided and eviction enabled with with Random-2-LRU.
2. External storage persistence for data recovery.
3. two backups
With the above setup we have come across a behavior where if the data from the cache reaches its limit the data is automatically getting evicted which is expected. But the issue we are currently facing is that we are not able to query the data which is evicted using SQL API as the data is not longer present in **OFF HEAP** memory.
Also when eviction happens can we still retrieve the data from the configured backups or they will be evicted as well?
In this case the only way to get the data is to explicitly call either of below methods.
1. cache.get(ID) - This will load specific Key data onto off heap memory which will then be available for querying
2. cache.loadCache() - In this case do we need to call the method every time we need to retrieve a specific key from cache data or
for every transaction as the data we are looking for might not be in cache due to eviction in place?
Can you please suggest any approach where we can perform SQL queries to retrieve data with Cache eviction in place and don't have to load the data for every transaction.
Attaching sample configuration for dataregion and cache config
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@ignite.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Question: Querying Ignite Cache with Eviction and external storage enabled [ignite]
Posted by "ptupitsyn (via GitHub)" <gi...@apache.org>.
ptupitsyn closed issue #11433: Question: Querying Ignite Cache with Eviction and external storage enabled
URL: https://github.com/apache/ignite/issues/11433
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@ignite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Question: Querying Ignite Cache with Eviction and external storage enabled [ignite]
Posted by "ptupitsyn (via GitHub)" <gi...@apache.org>.
ptupitsyn commented on issue #11433:
URL: https://github.com/apache/ignite/issues/11433#issuecomment-2225127187
Ignite SQL [does not load data from external storage](https://ignite.apache.org/docs/latest/persistence/external-storage).
I suggest using [native Ignite persistence](https://ignite.apache.org/docs/latest/persistence/native-persistence) instead of external storage for data recovery. In this case SQL is fully supported.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@ignite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Question: Querying Ignite Cache with Eviction and external storage enabled [ignite]
Posted by "ratadepally (via GitHub)" <gi...@apache.org>.
ratadepally commented on issue #11433:
URL: https://github.com/apache/ignite/issues/11433#issuecomment-2226228200
@ptupitsyn - thank you for the quick response.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@ignite.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org