Re: Cache Expiry policy not working..

2020-08-26 Thread kay
Hi, I can get data at remain cache data. so that issue you are share is not my problem. It not happend every time. sometimes, data is not expired. Here is my node log when after start, data not expired. Cache1-2-2.zip

Ignite client node raises "Sequence was removed from cache" after Ignite Server node restarts

2020-08-26 Thread xmw45688
*USE CASE *- use IgniteAtomicLong for table sequence generation (may not be correct approach in a distributed environment). *Ignite Server *(start Ignite as server mode) - apache-ignite-2.8.0.20190215 daily build *Ignite Service* (start Ignite as client mode) - use Ignite Spring to initialize the

How to confirm that disk compression is in effect?

2020-08-26 Thread 38797715
Hi, We turn on disk compression to see the trend of execution time and disk space. Our expectation is that after disk compression is turned on, although more CPU is used, the disk space is less occupied. Because more data is written per unit time, the overall execution time will be

Re: Hibernate 2nd Level query cache with Ignite

2020-08-26 Thread Evgenii Zhuravlev
Hi, Can you please share full logs from client and server nodes? Thanks, Evgenii ср, 26 авг. 2020 г. в 14:26, Tathagata Roy : > Hi, > > > > I am trying to do a POC on hibernate 2nd level cache with Apache Ignite. > With this configuration I was able to make it work > > > >

Hibernate 2nd Level query cache with Ignite

2020-08-26 Thread Tathagata Roy
Hi, I am trying to do a POC on hibernate 2nd level cache with Apache Ignite. With this configuration I was able to make it work spring.jpa.properties.hibernate.cache.use_second_level_cache=true spring.jpa.properties.hibernate.cache.use_query_cache=true

Re: Cache Expiry policy not working..

2020-08-26 Thread Evgenii Zhuravlev
Hi, It looks like a little bit different problem then. As far as I see, the only issue here is related to the cache size, no to the get operations. It is a known issue: https://issues.apache.org/jira/browse/IGNITE-9474 Best Regards, Evgenii вт, 25 авг. 2020 г. в 21:22, kay : > Hello, There is

Re: Shared counter

2020-08-26 Thread Srikanta Patanjali
Hi Bastien, Ignore provides the ability to have distributed data structure. And in your case an atomic long would work as a distributed counter. For more info https://apacheignite.readme.io/docs/atomic-types Regards, Srikanta On Wed, 26 Aug 2020, 12:24 pm Bastien Durel, wrote: > Hello, > >

Ignite's memory consumption

2020-08-26 Thread Dana Milan
Hi all Igniters, I am trying to minimize Ignite's memory consumption on my server. Some background: My server has 16GB RAM, and is supposed to run applications other than Ignite. I use Ignite to store a cache. I use the TRANSACTIONAL_SNAPSHOT mode and I don't use persistence (configuration file

Increase the indexing speed while loading the cache from an RDBMS

2020-08-26 Thread Srikanta Patanjali
Currently I'm using Apache Ignite v2.8.1 to preload a cache from the RDBMS. There are two tables with each 27M rows. The index is defined on a single column of type String in 1st table and Integer in the 2nd table. Together the total size of the two tables is around 120GB. The preloading process

Re: Lag before records are visible after transaction commit

2020-08-26 Thread ssansoy
As an update, if I update the printBs method to also try a cache.getAll(keys), it still exhibits the same problem (missing records): private int printBs(long id) { IgniteCache cacheB = ignite.cache("B").withKeepBinary(); ScanQuery scanQuery = new ScanQuery<>(

Re: 2.8.1 : Server cluster node startup issue

2020-08-26 Thread akorensh
Veena, Ignite shouldn't be waiting for the storage spi. It first starts all its components and when an Event is ready to be recorded, the storage SPI is invoked. This scenario tests out ok. Send a reproducer and I'll take a look. Thanks, Alex -- Sent from:

Re: Lag before records are visible after transaction commit

2020-08-26 Thread ssansoy
Here is a reproducer for this btw. Run the mainclass with program argument READER and again with argument WRITER. In the console for WRITER press a key (this will generate an A and 100 associated Bs) READER subscribes to A and gets the associated B's with a scan query. However, it takes some

Re: How to solve the problem of single quotes in SQL statements?

2020-08-26 Thread 38797715
ok,solved. INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (1,'Ka''bul','AFG','Kabol',178); 在 2020/8/26 下午7:10, 38797715 写道: Hi, for example: CREATE TABLE City (   ID INT(11),   Name CHAR(35),   CountryCode CHAR(3),   District CHAR(20),   Population INT(11),  

Re: ignite partition mode

2020-08-26 Thread itsmeravikiran.c
By using ignite web console -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

How to solve the problem of single quotes in SQL statements?

2020-08-26 Thread 38797715
Hi, for example: CREATE TABLE City (   ID INT(11),   Name CHAR(35),   CountryCode CHAR(3),   District CHAR(20),   Population INT(11),   PRIMARY KEY (ID, CountryCode) ) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey,

Shared counter

2020-08-26 Thread Bastien Durel
Hello, I whish to know if there is a supported way to implement some kind of shared counter in ignite, where any node could increment or decrement a value, which would be decremented automatically if a node is leaving the cluster ? I know I can use an AtomicInteger but there will be no decrement

Re: 2.8.1 : Server cluster node startup issue

2020-08-26 Thread VeenaMithare
Thanks Alex, Will try and see if I can create a reproducer. >>If Ignite hasn't fully started, it will wait( U.awaitQuiet(startLatch); ) until it has, before returning the instance. Does the Ignition.start wait for the storage spi to return from record, to start ? since the storage spi is waiting