Same object different hashes

2018-03-22 Thread Ariel Tubaltsev
When fetching a key from different data structures on the client side, I can end up with not finding the object in the cache after putting it there. Server logs will show different hash values for the same object: PUT: *** Received event [cache=demo, evt=CACHE_OBJECT_PUT, key=com.google.protobuf.

RE: Get all data of one cache in Ignite without creating a new ignite node

2018-03-22 Thread linrick
Hi Amir By the way, if we would like to insert/update data to cache, do you have any idea to achieve this? PreparedStatement stmt = conn.prepareStatement("INSERT INTO \"igniteCache\".STRING"); stmt.setString(1, "keyInsert"); stmt.setString(2, "valueInsert"); stmt.execute(); Error: Invocation

RE: Get all data of one cache in Ignite without creating a new ignite node

2018-03-22 Thread linrick
Hi Amir I use the method recommended by you, and that works well. My testing code is as: ResultSet rs = conn.createStatement().executeQuery("select * from \"igniteCache\".STRING"); while (rs.next()) { String key = rs.getNString(1); String value = rs.getString(2); System.out.println("cacheData fo

Re: Spark 'close' API call hangs within ignite service grid

2018-03-22 Thread akshaym
I have pushed the sample application to github . Please check it once. Also, I am able to get rid of the hang issue with spark.close API call by adding "igniteInstanceName" property. Not sure if its a right approach though. I came up with

Re: Ignite @QuerySqlField on interfaces instead of classes

2018-03-22 Thread vkulichenko
Wilhelm, First of all, your code doesn't make much sense, it won't compile. But in any case, Ignite stores data in binary format [1] that allows to not deserialize values when running SQL queries. Internally, it works only with fields and would never call a getter. Therefore, you can put annotati

Re: Ignite @QuerySqlField on interfaces instead of classes

2018-03-22 Thread Amir Akhmedov
Hi, I think the answer to your question is no rather than yes. @QuerySqlField has a field target type and a field in interface is public, static and final. Thanks, Amir

Re: Is class inheritance supported in ignite 2.4.0?

2018-03-22 Thread vkulichenko
Wilhelm, When you're working with SQL in Ignite, you should think about data types in the same way as about tables in relational databases. SQL works with a particular schema, and therefore if there is a 'Vehicle' table, it can only store attributes that are generic for all vehicles. There is no w

Ignite @QuerySqlField on interfaces instead of classes

2018-03-22 Thread Wilhelm
Hello, Just to make sure, right now I'm putting my annotation @QuerySqlField on some classes. Is there a way to put it at the interface layer and use the getter/setter instead of the direct field? Like class Person implement IPerson{ private string _name = null; ... } interface IPerson {

Re: RE: Is the partition cache re-balance at once a new Node join/left?

2018-03-22 Thread aa...@tophold.com
Thanks Stan and Ivan, We did not use the Native persistence, and the Ignite is 2.4.0 We will try both those argument to check whether can find something. in more logger we can find in fact the nodes find each others. if I use the RendezvousAffinityFunction manually check it should can work.

Is class inheritance supported in ignite 2.4.0?

2018-03-22 Thread Wilhelm
Hello Is class inheritance supported by ignite and SQL search? I tried creating a Person class who own a Vehicule and Vehicule can be a car, boat, truck, motocycle. If I add a Vehicule to the Vehicule cache then it is ok but if I add a Car (Car inherit from Vehicule) then it is not showing up? I

Re: Ignite Expiry Inconsistency with Native Persistence

2018-03-22 Thread vkulichenko
Subash, Yes, I reproduced it now. Looks like a bug to me, I created a ticket: https://issues.apache.org/jira/browse/IGNITE-8027 -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Error: Failed to parse query: SELECT * FROM ...

2018-03-22 Thread Wilhelm
Working! Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Disk Persistence Performance

2018-03-22 Thread Denis Magda
Milliseconds for sure, we can't beat the physics ;) -- Denis On Tue, Mar 20, 2018 at 11:02 AM, piyush wrote: > Thanks for relevant links. > > Just to be clear, When you say disk latency is (20 - 500 ms) did you mean > microsecond or millisecond ? > > > > -- > Sent from: http://apache-ignite-use

Re: New feature with 2.4 - Using 3rd Party Persistence With Native Persistence

2018-03-22 Thread Denis Magda
Hi Naveen, Thanks for confirming it works in RAM to DB case for you. As for DB to RAM, that's not supported by Ignite and you need to use tools like Oracle Golden Gate to move the changes from Oracle to Ignite: https://dzone.com/articles/syncing-a-gridgain-in-memory-computing-cluster-and -- Dens

Re:Issue about ignite-sql limit of table quantity

2018-03-22 Thread fvyaba
any help? At 2018-03-22 16:19:15, "fvyaba" wrote: Hi,I have a question about ignite-sql limit of table quantity: 1.We are design a system might have huge quantity of table,as we understand about ignite-sql table mechanism,all the tables could only be created within so-called 'PUBLIC' schema,wh

Re: Using Rest module cache not getting created

2018-03-22 Thread ilya.kasnacheev
Hello! curl http://10.194.11.99:8080/ignite?cmd=getorcreate&cacheName=myCache [1] 11814 Ah-ah! Notice this [1]? This means that second part of your query was just eaten by UNIX shell. Use quotes to protect URLs in commands: curl 'http://10.194.11.99:8080/ignite?cmd=getorcreate&cacheName=myCach

Re: Setting userVersion on client node causes ignite.active(true) to fail

2018-03-22 Thread ilya.kasnacheev
Hello Dave! I think you can still fill a usability issue against JIRA. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Get all data of one cache in Ignite without creating a new ignite node

2018-03-22 Thread Amir Akhmedov
Hi Rick, In Ignite cache name is used as a database schema and a cache value type as a table name. So, in your case you should execute select * from "igniteCache".STRING to get your cache data. I would recomend you to run your Ignite instance with -DIGNITE_H2_DEBUG_CONSOLE=true parameter so you c

Re: Service Grid launching Compute Tasks

2018-03-22 Thread aealexsandrov
Hi Neeraj, Generally you can launch compute tasks from execute method because they will use separated thread pools executors. Also according documentation you can be in execute method until cancel method will not called: https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/services

Re: Issues trying to force redeployment in shared mode

2018-03-22 Thread ilya.kasnacheev
Hello Dave! I suggest filling an issue agains Apache Ignite JIRA with this scenario and suggestions about how it should work after fix. Test case would be awesome. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Usage of DataStreamer for bulk loading

2018-03-22 Thread Gaurav Bajaj
Hi Naveen, In our case biggest performance gain happened when we started adding data to IgniteStreamer in parallel. Earlier we are doing : entryMapToBeStreamed.entrySet().*stream*().forEach(dataStreamer::addData); Perf improved tremendously when we did something like this : entryMapToBeStreamed

Re: ContinuousQuery - SqlFieldsQuery as InitialQuery

2018-03-22 Thread au.fp2018
Thanks Pavel I was able to get a Java version of the query client implemented using your suggestions. But I am having a hard time convincing the scala compiler to type check. Even if I get it to work the amount of type coercing I would need to get it to work is extremely hairy. Before your reply

Re: [2.4.0] Cluster unrecoverable after node failure

2018-03-22 Thread joseheitor
Hi Pavel, 1. Disconnect database connection 2. Stop all component processes on all nodes (Ctl+C) 3. I delete the 'work' folder on the node on which I want to simulate an unrecoverable hardware failure. When the node is started up anew - it is like deploying a new instance on the same IP address.

Re: [2.4.0] Cluster unrecoverable after node failure

2018-03-22 Thread Pavel Vinokurov
Hi, >> 4 - simulate power-failure ... all components down; Node-B with unrecoverable damage (hardware) >> How do you emulate failure with unrecoverable damage ? 2018-03-22 14:34 GMT+03:00 joseheitor : > I do apologise for the long-winded post earlier (with error stack-traces, > etc.). > > And

Re: Performance of Ignite integrating with PostgreSQL

2018-03-22 Thread Pavel Vinokurov
In your example you add the same key/values into cache, so it's just overwrites entries and persists only 100 entries. Please look at the project https://bitbucket.org/vinokurov-pavel/ignite-postgres . I have ~70-100 Mb/s on my SSD. 2018-03-22 11:55 GMT+03:00 : > Hi Vinokurov, > > > > I changed m

Re: Delete Message Topic and Listener

2018-03-22 Thread Evgenii Zhuravlev
Hi Venkat, It's not clear what happened. Could you please create a small reproducer and also describe the changes you applied to your project? Thank you, Evgenii 2018-03-22 12:18 GMT+03:00 kvenkatramtreddy : > I have setup ignite cluster with native persistence. I enabled messaging > and > crea

Re: Kubernetes - Access Ignite Cluster Externally

2018-03-22 Thread Ryan Samo
Ok thank you all for the tips, I will give it a try! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Native persistence and IGFS

2018-03-22 Thread Evgenii Zhuravlev
Hi, Well, you can do this by setting your own pre-configured caches as data and metadata caches using IgniteConfiguration.FileSystemConfiguration.setMetaCacheName and IgniteConfiguration.FileSystemConfiguration.setDataCacheName. Also, it would be great if you could share feedback regarding this u

RE: Is the partition cache re-balance at once a new Node join/left?

2018-03-22 Thread Stanislav Lukyanov
Hi Aaron, To add to what Ivan’ve said about baseline topology, there is a general setting for the time between a topology change and rebalancing start - CacheConfiguration.rebalanceDelay. See Javadoc for details: https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/configuration

Re: [2.4.0] Cluster unrecoverable after node failure

2018-03-22 Thread joseheitor
I do apologise for the long-winded post earlier (with error stack-traces, etc.). And hope that someone can assist me with this issue - it is a basic, real-world scenario that tests the fundamental integrity of the clustering system! Am I perhaps missing something? Or mismanaging the cluster in su

Re: Is the partition cache re-balance at once a new Node join/left?

2018-03-22 Thread Ivan Rakov
Hi Aaron, Which version of Ignite do you use? Is Ignite Native Persistence enabled on your node? Since 2.4, in persistent mode partitions are mapped to nodes according to Baseline Topology. You may need to set new Baseline Topology of your new set of nodes in order to trigger rebalancing. Rea

Is the partition cache re-balance at once a new Node join/left?

2018-03-22 Thread aa...@tophold.com
Hi all, We had a partition cache with backup as zero, but we found sometime even a new nodes join, the cache's partition not re-balance. one of the node may contain all the primary partition, while other may have none partition. so will the re-balance happen under a specific condition? cach

Native persistence and IGFS

2018-03-22 Thread andrey.davydov
Hello, If ignite native persistence feature is applicable to igfs? If it possible to setup igfs to use small memory but large hdd space? Thanks. Andrey.

Re: Apache Ignite nightly release builds

2018-03-22 Thread Petr Ivanov
It works, thanks! Here is updated links for Artifacts and Changes respectively with silent guest login (can be added to bookmarks): * https://ci.ignite.apache.org/viewLog.html?buildId=lastSuccessful&buildTypeId=Releases_NightlyRelease_RunApacheIgniteNightlyRelease&tab=artifacts&guest=1 * https

Delete Message Topic and Listener

2018-03-22 Thread kvenkatramtreddy
I have setup ignite cluster with native persistence. I enabled messaging and created a message topic and added listener to it and deployed. There were some business logic errors in the listener code and I fixed it. But the changes are not yet all reflecting. I have tried restarting the ignite serv

Re: Apache Ignite nightly release builds

2018-03-22 Thread Petr Ivanov
I’ve added corresponding role to guest access user. Vitaly, can you open Ignite Apache TC for guest login if no security issues exists that prevent from opening it? > On 22 Mar 2018, at 11:49, Alexey Kuznetsov wrote: > > +1 to get nightly builds WITHOUT login. > > On Thu, Mar 22, 2018 at 3:3

Re: could not load all records into partitioned cache when server node count increased

2018-03-22 Thread serdar severcan
Hello, I've tried in sample project and worked as expected. In my original case I had updated records in database using arbitrary partition ids. I had misunderstood. I should have updated records according to affinity function. Thank you Regards, Serdar On 20 March 2018 at 16:57, slava.koptilin w

RE: Is backup copy always stored on different host - is ithost-awarereplication

2018-03-22 Thread Stanislav Lukyanov
You need to create a cache template (a cache configuration with a name ending with a *), and specify that in the CREATE TABLE. To define a cache template:

RE: Performance of Ignite integrating with PostgreSQL

2018-03-22 Thread itriA40453
Hi Vinokurov, I changed my code >> IgniteCache igniteCache = ignite.getOrCreateCache("testCache >> "); To IgniteCache igniteCache = ignite.cache("testCache"); And update to 2.4.0 version. But the writing speed is still about 100 KB per second. Below is jdbc connection initialization: @Autowire

Re: Apache Ignite nightly release builds

2018-03-22 Thread Alexey Kuznetsov
+1 to get nightly builds WITHOUT login. On Thu, Mar 22, 2018 at 3:38 PM, Dmitriy Setrakyan wrote: > Why do we need to ask people to login to get a nightly build? Anyway to > open it to public without a login? > > -- Alexey Kuznetsov

Re: Apache Ignite nightly release builds

2018-03-22 Thread Dmitriy Setrakyan
Why do we need to ask people to login to get a nightly build? Anyway to open it to public without a login? On Wed, Mar 21, 2018 at 10:45 PM, Dmitry Pavlov wrote: > Hi Raymond, > > You could sign up using valid email address. Please write to @dev list if > link still is not available. > > Sincere

Issue about ignite-sql limit of table quantity

2018-03-22 Thread fvyaba
Hi,I have a question about ignite-sql limit of table quantity: 1.We are design a system might have huge quantity of table,as we understand about ignite-sql table mechanism,all the tables could only be created within so-called 'PUBLIC' schema,which means all the meta-data of table are stored in a

RE: Is backup copy always stored on different host - is it host-awarereplication

2018-03-22 Thread Gaurav Bajaj
Hi Naveen, Also there is a way you control on which exact host backup be will be created using Backupfilter : https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/cache/affinity/rendezvous/RendezvousAffinityFunction.html#setAffinityBackupFilter-org.apache.ignite.lang.IgniteBiPredi

RE: Get all data of one cache in Ignite without creating a new ignite node

2018-03-22 Thread linrick
Hi Andrey, I tried to use JDBC client at https://apacheignite-sql.readme.io/docs/jdbc-driver The java code is as: Class.forName("org.apache.ignite.IgniteJdbcThinDriver"); Connection conn = DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1"); ResultSet rs = conn.createStatement().executeQu

Re: Get all data of one cache in Ignite without creating a new ignite node

2018-03-22 Thread Alexey Kuznetsov
Rick, Java think client may be released in some nearest release. You can track its progress here: https://issues.apache.org/jira/browse/IGNITE-7421 Meanwhile you can use client node or JDBC or REST. -- Alexey Kuznetsov

Re: Error: Failed to parse query: SELECT * FROM ...

2018-03-22 Thread Alex Plehanov
In case of Cache_A and Cache_B you need to use quote symbols, since table schema is case-sensitive, but parser convert schemas in your query to upper case. Try these statements: SELECT * FROM "Cache_B".B0; SELECT * FROM "Cache_A".A; 2018-03-21 20:27 GMT+03:00 Wilhelm : > Super - Thanks a lot Ale

Re: ContinuousQuery - SqlFieldsQuery as InitialQuery

2018-03-22 Thread Pavel Vinokurov
Hi, Yes, continuous queries are only predicate based and could named as "continuous listener", but for an initial query that run once we could use SQLFieldsQuery. Let try with following code: ContinuousQuery q= new ContinuousQuery(); ((ContinuousQuery)q).setInitialQuery(new SqlFieldsQuery("select

Re: Get all data of one cache in Ignite without creating a new ignite node

2018-03-22 Thread Andrey Mashenkov
Rick, Yes, you have to start a node to get access to the grid from another JVM, Or use REST, or JDBC client. чт, 22 марта 2018, 9:49 Pavel Vinokurov : > Hi Rick, > > You could use rest api that documented in > https://apacheignite.readme.io/docs/rest-api . > > Thanks, > Pavel > > 2018-03-22 9:44