Re: [EXTERNAL] Re: Replace or Put after PutAsync causes Ignite to hang

2020-01-13 Thread Maxim Muzafarov
Igniters, Bump this thread up. It seems the issue [1] is important but still unassigned. [1] https://issues.apache.org/jira/browse/IGNITE-12033 On Thu, 15 Aug 2019 at 15:01, Pavel Tupitsyn wrote: > Hi Eduard, > > Yes, that is the same issue. > The workaround above is not enough, because

Getting all data from cache via scan query is taking lot of time

2020-01-13 Thread Tunas
Configuration of Ignite server backups = 1 persistenceEnabled = true atomicityMode = true I have two nodes on one server and only one ignite server instance is running. I am using C# thin client to fetch data from collection. I am storing custom user defined object collection in my cache. 1.

Re: Failed to execute DML statement Ignite JDBC

2020-01-13 Thread siva
Hi, sorry,there was a typo mistake or post message issue.as i edited after post post message. this is log as exception getting on server: -- -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Failed to execute DML statement Ignite JDBC

2020-01-13 Thread Ilya Kasnacheev
Hello! Pretty descriptive: *Caused by: org.apache.ignite.IgniteChecke**dException: Key is missing from query* How is your cache key declared? Which fields are supposed to go in it? Regards, -- Ilya Kasnacheev пн, 13 янв. 2020 г. в 13:05, siva : > Hi, > Thank you for suggestion. > Please

Re: Failed to reinitialize local partitions (rebalancing will be stopped)

2020-01-13 Thread ashishb888
Yes, I cleared the directories. Case 1: Exception occurs worker node and the node get killed Steps: -start data node -worker node -start data node -activate the cluster by client node (or by control script) Case 2: All nodes comes under baseline topology instead of 2 nodes (data

Re: write behind is not triggering for created table through query

2020-01-13 Thread siva
Hi, Thanks for reply...write behind triggering now.but getting exception in writeAll() method. I have one query on insert what will be the key and value for writeAll() method,if i defined or not in create query commond key_type and value_type?.is this key_type and value_type needed.? but in case

Re: write behind is not triggering for created table through query

2020-01-13 Thread Ilya Kasnacheev
Hello! You need to employ cache configuration templates to add Write Behind to cache configured via SQL: https://apacheignite.readme.io/docs/cache-template In your case, you created two caches: one is empty but with write behind, other is with SQL-inserted data but without Write Behind.

Re: Failed to reinitialize local partitions (rebalancing will be stopped)

2020-01-13 Thread ashishb888
Client node Data node Worker node -- Sent

Re: Failed to execute DML statement Ignite JDBC

2020-01-13 Thread Ilya Kasnacheev
Hello! This is a mailing list, so messages are not editable. Unfortunately I can't see any exception in your last message. Please paste it as text. Regards, -- Ilya Kasnacheev пн, 13 янв. 2020 г. в 12:57, siva : > Hi, > sorry,there was a typo mistake or post message issue.as i edited after

Re: Failed to execute DML statement Ignite JDBC

2020-01-13 Thread Ilya Kasnacheev
Hello! You should search your server nodes' logs for an exact error message corresponding to this client error. Can you find it, paste to your message? Regards, -- Ilya Kasnacheev сб, 11 янв. 2020 г. в 08:41, siva : > Cache,table and index created through QueryEntities. > like below > >

Re: Failed to execute DML statement Ignite JDBC

2020-01-13 Thread siva
Hi, Thank you for suggestion. Please find the Server log exception: org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to execute DML statement [stmt=INSERT INTO

Re: Failed to reinitialize local partitions (rebalancing will be stopped)

2020-01-13 Thread Ilya Kasnacheev
Hello! What are steps to reproduce? I tried to start 2 data nodes, 1 worker node and 1 client, then activated cluster with control.sh. I didn't see any errors. Have you tried clearing persistence dirs before a run? Regards, -- Ilya Kasnacheev пн, 13 янв. 2020 г. в 13:08, ashishb888 : >

How does a cache behave in LOCAL mode ?

2020-01-13 Thread userx
Hi team, I went through the documentation available at https://apacheignite.readme.io/docs/cache-modes#section-local-mode to understand what does the LOCAL mode mean. I have a following scenario. 1) There are 5 Ignite data grid servers. I1, I2, I3, I4, I5. The machines are M1, M2, M3, M4, M5.

Re: Getting all data from cache via scan query is taking lot of time

2020-01-13 Thread Pavel Tupitsyn
20 seconds for a collection of 7k objects is way too slow. Can you please attach full reproducer so I can run it and dig deeper? On Mon, Jan 13, 2020 at 2:47 PM Tunas wrote: > Configuration of Ignite server > > backups = 1 > persistenceEnabled = true > atomicityMode = true > > I have two nodes

Getting all data from cache via scan query is taking lot of time

2020-01-13 Thread Tunas
Configuration of Ignite server backups = 1 persistenceEnabled = true atomicityMode = true I have two nodes on one server and only one ignite server instance is running. I am using C# thin client to fetch data from collection. I am storing custom user defined object collection in my cache. 1.

Re: Failed to execute DML statement Ignite JDBC

2020-01-13 Thread siva
*Step-1:Model class* - namespace Models.Ignite { public class ENTITIESTABLEINFO : ICustomCacheStore { [QuerySqlField] [Key] public String EntityId { get; set; } [QuerySqlField] public String EntityType { get; set; }

Re: Failed to execute DML statement Ignite JDBC

2020-01-13 Thread Pavel Tupitsyn
[Key] attribute is not recognized by Ignite, you should set QueryEntity.KeyFieldName = "EntityId". This is a good catch, by the way - I've filed a ticket: https://issues.apache.org/jira/browse/IGNITE-12532 On Mon, Jan 13, 2020 at 5:32 PM siva wrote: > *Step-1:Model class* >

Re: WriteAll() method on insert statement execute from sqlline

2020-01-13 Thread Pavel Tupitsyn
When you insert data from C# code, Ignite registers Person class automatically and knows how to deserialize it later. But when you insert data from Sqline, Ignite.NET does not know about Person class yet, so deserialization fails. You can fix this by setting

Re: How does a cache behave in LOCAL mode ?

2020-01-13 Thread userx
hi team, Any comments on the same ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Getting all data from cache via scan query is taking lot of time

2020-01-13 Thread Tunas
Configuration of Ignite server backups = 1 persistenceEnabled = true atomicityMode = true I have two nodes on one server and only one ignite server instance is running. I am using C# thin client to fetch data from collection. I am storing custom user defined object collection in my cache. 1.

WriteAll() method on insert statement execute from sqlline

2020-01-13 Thread siva
Hi, I am using .net core Application for Ignite client and server,Ignite V2.7.6. Table and indexes created through QueryEntity from Model class. So same table i am using with 3rd party thin client to put data into cache. e.g: public interface ICustomCacheStore { } public class

Re: Load Data with Streamer

2020-01-13 Thread narges saleh
Thanks Saikat for the feedback. I have a simple design. I have external data sources which send data to the ignite cluster via http post requests. I wanted to see if I can utilize ignite's rest API for this purpose and at the same time take advantage of the streamer high performant data load (

Best approach for jdbc sink into ignite cache with write behind .net client and server 3rd party application

2020-01-13 Thread siva
Hi, I have .net core client and Server application Ignite v2.7.6. All tables and indexes created through IgniteConfiguration and QueryEntity in .net application at the time of cache creation. currently i am using from source to client.putAsync(key,tableModelClassObject) to put data in cache as

Re: Failed to execute DML statement Ignite JDBC

2020-01-13 Thread siva
Hi, Thanks for reply.I will look into this. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Best approach for jdbc sink into ignite cache with write behind .net client and server 3rd party application

2020-01-13 Thread Pavel Tupitsyn
Hi, The question is not very clear - do you have any difficulties with JDBC? On Tue, Jan 14, 2020 at 7:28 AM siva wrote: > Hi, > I have .net core client and Server application Ignite v2.7.6. > > All tables and indexes created through IgniteConfiguration and QueryEntity > in .net application

unsubscribe

2020-01-13 Thread Shahid Muhamed
unsubscribe Thanks, Muhamed Shahid