Re: Cache pre-loading question

2017-10-09 Thread franck102
Hi Alex, what do you mean by custom? I am indeed using a CacheJdbcPojoStore, it has the method I need (loadCache(final IgniteBiInClosure clo, @Nullable Object... args)) however I can't obtain a reference to the store from my ignite instance. I can try to build an instance of the store outsid

Re: Cache pre-loading question

2017-10-09 Thread franck102
Hi Alex, what do you mean by custom? I am indeed using a CacheJdbcPojoStore, it has the method I need (loadCache(final IgniteBiInClosure clo, @Nullable Object... args)) however I can't obtain a reference to the store from my ignite instance. I can try to build an instance of the store outside I

Re: SQL query with string where clause value evaluated as hex string

2017-10-09 Thread chuck.wi...@gm.com
I believe I found my own answer here . After adding the referenced hibernate jar to my project, ignite SQL queries against VIN were not interpreted as hexadecimal strings.

Lock on cache keys during node failures

2017-10-09 Thread naresh.goty
Hi All, We would like to understand the lock behavior on cache items, based on the code snippet below: 1. What happens if the key "fake" in cache1 is lost (due to node failure, part data lost etc) after the lock is acquired and before it is released ? 2. What happens, if another thread

BackupFilter for the RendezvousAffinityFunction Questions

2017-10-09 Thread Chris Berry
Hi, I have 2 availability zones (AZs), and an Ignite Grid that spans them. I have implemented a BackupFilter for the RendezvousAffinityFunction, which attempts to keep the Primary and Backups balanced. In other words, if I have 1 Primary and 3 Backups (for a PARTITIONED cache) across 16 Nodes (8

SQL query with string where clause value evaluated as hex string

2017-10-09 Thread chuck.wi...@gm.com
I am trying to use vehicle identification number (VIN) as a field in an apache ignite cache. I am using version 2.2. The form of this string is 17 characters in length and contains alphanumeric character outside of the hexadecimal digit range. I am getting errors similar to this thread

Re: Data (that is inserted via JDBC) is not persisted after cluster restart

2017-10-09 Thread blackfield
The config file: IgniteConfig.xml No source code is provided as the issue is reproduce-able from SQL tool such as DBeaver. As far as logs, I have not configured ignite.-log4j.xml (as in it is still default). Do you wa

Re: Performance of persistent store too low when bulb-loading

2017-10-09 Thread Ray
I also had the same problem here. I'm using ignite-spark's saveParis method(which is also a IgniteDataStreamer) to ingest 550 million entries of data into Ignite, and the ingesting speed got slow down after first few minutes and seems stuck for now with persistent store enabled. My setup is 4 node

Re: (Cross Platform)c# wrapper for java CacheStoreAdapter for database persistence

2017-10-09 Thread JP
Could you read this topic, http://apache-ignite-users.70518.x6.nabble.com/Persistence-store-MSSQL-using-cross-platform-c-Ignite-Client-windows-and-java-Ignite-Server-linux-ve-td17238.html Actually, I am looking for using JavaCachStore in C# not .NETCacheStore. -- Sent from: http://apache-ignit

Re: Cache pre-loading question

2017-10-09 Thread afedotov
Hi Franck, Yes. You would need to implement the same mapping logic in your client populating a cache via data streamer. A custom CacheStore or CacheJdbcPojoStore should be an easier approach in case of an underlying DB, especially if you need read-through/write-through semantics as well. Kind reg

Re: (Cross Platform)c# wrapper for java CacheStoreAdapter for database persistence

2017-10-09 Thread afedotov
Hi, Please take a look at the end of the following documentation section Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

(Cross Platform)c# wrapper for java CacheStoreAdapter for database persistence

2017-10-09 Thread JP
Hi, Working on persisting data in the database from the .NET ignite client(windows) to Ignite server(ubuntu). I have created CacheJdbcPersonStore in Java and deployed in Ignite Server(Ubuntu). https://apacheignite.readme.io/docs/3rd-party-store#section-cachestore-example >From .NET Ignite client

Re: Possible dead lock when number of jobs exceeds thread pool

2017-10-09 Thread afedotov
Hi Raymond, Yes. Bringing C# client in sync with Java version is on plans. Of course, C# client will always be a bit outdated in terms of features of Java client. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

checkpoint marker is present on disk, but checkpoint record is missed in WAL

2017-10-09 Thread KR Kumar
Hi Guys - I am using ignite persistence with a 8 node cluster. Currently in dev/poc stages. I get following exception when i try to restart the node after I killed the process with "kill . I have a shutdown hook to the code in which I am shutting down Ignite with G.stop(false). I read in a blog th

Re: Why SQL_PUBLIC is appending to Cache name while using JDBC thin driver

2017-10-09 Thread Vladimir Ozerov
Hi Austin, All caches in Ignite must have unique names. This is why we add unique prefix with schema name attached. On Sat, Oct 7, 2017 at 1:17 PM, austin solomon wrote: > Hi, > > I am using Ignite version 2.2.0, and I have created a table using > IgniteJdbcThinDriver. > > When I checked the ca

Cache pre-loading question

2017-10-09 Thread franck102
Hi all, I am trying to figure out the best approach for pre-loading cache entries from a SQL DB on startup. I have read the recommendations to use a client node and a data streamer to pre-load cache data on startup. One issue I see with the approach however, compared with cache.loadCache(), is th

Re: Race in Service Grid deployment?

2017-10-09 Thread Artёm Basov
Hi Denis! Thank you for explanation. If this is the case, then i don't think that user should actually know that this was happening (this exception handled and retry happens?), since user can't change anyhing to avoid such messages. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/