Re: Logging query on server node sent from client node

2017-11-15 Thread opsharma1986
Yes, tried this below configuration ... Rest-of-the-configs It did not work for me. Thanks Om -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Memory utilization of Indexes in ignite

2017-11-15 Thread Tejashwa Kumar Verma
Hi All, I have some open questions about memory utilization of indexes in ignite. So here is the scenario. I have created one cache(CACHE_1) with following props: And i am loading 5GB in CACHE_1. So as per our configs 1 GB data is residing in offHeap and remaining 4GB is going in swap. Now m

Reason for using JVM Instance for Ignite C++ Driver

2017-11-15 Thread kotamrajuyashasvi
Hi >From the Ignite Docs: Ignite С++ starts the JVM in the same process and communicates with it via JNI. I would like to know why a JVM instance is required? Why can't we have Ignite C++ driver communicate via TCP directly to the Ignite Server and from the server side process the request and perf

Ignite ODBC Driver v/s Ignite C++ driver

2017-11-15 Thread kotamrajuyashasvi
Hi I have a C++ Application that needs to perform query operations(DML and Select) and transactions on Ignite Server. Whats the best way to achieve this ? There are two choices: 1. Ignite ODBC driver and 2. Ignite C++ Driver. I would like to what would be right choice to use from the point of sc

Ignite 2.3.0 Console logging handler is not configured error in start-up

2017-11-15 Thread Sumanta Ghosh
Hi, I am using ignite with spring boot 1.5.8, which has Slf4j configured (with logback implementation as default). Starting from 2.3 (most probably any version after 2.0, as with 2.0 I am not getting this error) I am getting following in the log 2017-11-16 09:45:11.591 ERROR 8636 --- [ m

Re: Best way to configure a single node embedded ignite 2.3

2017-11-15 Thread Sumanta Ghosh
Thanks. Will look for the page you mentioned. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite 2.3.0 hangs in startup

2017-11-15 Thread Sumanta Ghosh
Hi, Got the reason now. Ignite 2.3.0 hangs because of a regression bug wherein the cachestores use @SpringResource annotation and ignite starts up with SpringCacheManager class. Thanks for the help extended. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Initial query resent the data when client got reconnect

2017-11-15 Thread gunman524
I tried to use contentious query to monitor a cache and set initial query, LocalListener and RemoteFilter as example did. The issue I met is when client reconnect to Ignite cluster, the initial query will query the data from cache which the client might already got before. I tried to use unchange

Apache Ignite binary type invalidation

2017-11-15 Thread gunman524
I've createted the binary type with the name 'someField' and the field type is "String". Now I want to change it from string to int. But I don't want to change the name of the type, but I got an exception while cache populating: javax.cache.CacheException:class org.apache.ignite.binary.Binary0bje

Re: ComputeTask is including Nodes for ComputeJobs prematurely

2017-11-15 Thread vkulichenko
Chris, Sorry, I still don't understand. What are the things that need to happen exactly? Is there anything on Ignite level that is not initialized when job arrives for execution? -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

"Duplicate field ID" Error when register a contentious query

2017-11-15 Thread gunman524
Hi guys, I met a issue that "Duplicate field ID" Error occurs when register a contentious query. Here is my case: 1. Start a jdbc client and use SQL to create table and insert record 2. Start a another client and using contentious query to monitor table and insert the income data to another My

Re: Can JAVA API SqlQuery query a cache create by SQL DDL?

2017-11-15 Thread gunman524
vkulichenko, thanks for your advice。 It works, by setting value_type=person during DDL, then running SqlQuery sql = new SqlQuery("person","id >? and id http://apache-ignite-users.70518.x6.nabble.com/

Re: ComputeTask is including Nodes for ComputeJobs prematurely

2017-11-15 Thread Chris Berry
Hi Val, "Prematurely" in this case is a Node not fully initialized. In a nutshell, Ignite is started, enters the "discovery set", but further things must happen for it to be ready to do computation (take real load). When the Grid is initially started, this is pretty easy to control -- we can gate

Re: Can JAVA API SqlQuery query a cache create by SQL DDL?

2017-11-15 Thread vkulichenko
Hi, You should specify type name instead of cache name when creating the query: SqlQuery sql = new SqlQuery("person","id >? and id http://apache-ignite-users.70518.x6.nabble.com/

Re: ComputeTask is including Nodes for ComputeJobs prematurely

2017-11-15 Thread vkulichenko
Hi Chris, Can you define "prematurely"? What exactly is required for a node to be ready to execute jobs? From Ignite perspective, it is ready as long as it's in topology on discovery level, and that's when it starts receiving requests. BTW, with AdaptiveLoadBalancingSpi you can implement custom A

Re: Deserializing to an object from a request based on SqlQueryField.

2017-11-15 Thread jerpic
Hi again Mike, I'm confuse, in fact I did a basic mistake with the cast of the object. So, there is no problem ;-) Thanks for your help. Regards, Jérôme. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ComputeTask is including Nodes for ComputeJobs prematurely

2017-11-15 Thread Chris Berry
Hmmm, the raw code does not appear to be visible. Reposting public Map map(List subgrid, @Nullable TRequest request) throws IgniteException { Map jobMap = new HashMap<>(); List cacheKeys = getIgniteAffinityCacheKeys(request); Map> nodeToKeysMap = ignite.

Re: ComputeTask is including Nodes for ComputeJobs prematurely

2017-11-15 Thread Chris Berry
I figure I should probably add my map() method. I think this is all further complicated because we rely heavily on Affinity. I was thinking that could maybe use the AdaptiveLoadBalancingSpi But I see no way to add my own metrics to ClusterMetrics Plus, I do not see how this would work with af

Re: Deserializing to an object from a request based on SqlQueryField.

2017-11-15 Thread jerpic
Hi Mike, Thanks for you answer. Yes, I marked the B field with [QuerySqlField], and you are right I use C#. I did a mistake in the presentation of my problel, in fact the B field is an ArrayList of the CustomizedObject, maybe it can help... Regards, Jerome. -- Sent from: http://apache-ignit

ComputeTask is including Nodes for ComputeJobs prematurely

2017-11-15 Thread Chris Berry
Hi, We are using Ignite’s Compute Grid. And mostly, it is working beautifully. But there is one glitch I need to work around. AWS, Nodes come and go. And when a new Node joins the existing Grid, it is given ComputeJobs before it is actually ready to handle them. In our infrastructure, a Node an

Re: Deserializing to an object from a request based on SqlQueryField.

2017-11-15 Thread Mikhail
Hi, did you mark B field with @QuerySqlField? I'm just checked you case and it works fine for me, but I used java while you I guess you c#, don't you? Thanks, Mike. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Logging query on server node sent from client node

2017-11-15 Thread Mikhail
Hi, did you enabled events in configurations: https://apacheignite.readme.io/docs/events#section-configuration ? Thanks, Mike. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Grid freezing

2017-11-15 Thread smurphy
I figured this out at long last... The root cause of the problem was the Scan object's toString method: @Override public String toString() { return ReflectionToStringBuilder.reflectionToString(this); } It used the apache common-lang's RefelectionToStringBuilder and this jar

Re: QueryEntity Based Configuration

2017-11-15 Thread daniels
Thank you for response. I cant do the first offer(flatten map). And that about the second one I didnt understand ,can you please explain it in details? p.s. My cache value is List of Models. And I want get Models with sorting (by some fields ) quikly. And therefore I decided to use indexes and c

Re: How can I get Ignite security plugin to work with JDBC thin client?

2017-11-15 Thread calebs
Hi Valdimir, There are at least two problems that I've found here. The first is the query execution engine as you have just pointed out. The second one is the JDBC thin driver itself. In JdbcThinTcpIo.handshake, it doesn't pass in user credentials (i.e., user & password) as shown below, so how c

Re: Failed to find query with ID: 0

2017-11-15 Thread Igor Sapego
You are totally right, that's why there is a ticket for the issue which is fixed. Best Regards, Igor On Wed, Nov 15, 2017 at 6:40 PM, kenn_thomp...@qat.com < kenn_thomp...@qat.com> wrote: > Igor Sapego-2 wrote > > You get "Table exists" error, because table is successfully > > created by the pre

Re: Failed to find query with ID: 0

2017-11-15 Thread kenn_thomp...@qat.com
Igor Sapego-2 wrote > You get "Table exists" error, because table is successfully > created by the previous query. Error "Failed to find query > with ID:[xx]" generated when ODBC statement is closed > after execution of query that produced empty result set. That makes sense, but I wouldn't expect

Re: Failed to find query with ID: 0

2017-11-15 Thread Igor Sapego
You should use a driver from 2.2 too if you use nodes of version 2.2. You get "Table exists" error, because table is successfully created by the previous query. Error "Failed to find query with ID:[xx]" generated when ODBC statement is closed after execution of query that produced empty result set

Re: Failed to find query with ID: 0

2017-11-15 Thread kenn_thomp...@qat.com
For what it's worth, a little more poking - the create table sql included the option from the example in the docs... CREATE TABLE IF NOT EXISTS TestTable [blah blah blah] This was used over and over again to test with, always with the same response (Failed to find query). To see if maybe the opt

Re: Failed to find query with ID: 0

2017-11-15 Thread kenn_thomp...@qat.com
Igor Sapego-2 wrote > You used ODBC through C# to create table with CREATE TABLE > command, right? If this is the case, then this is a known issue [1] for > Ignite 2.3, which, I assume you are using. The issue already fixed > and the patch was merged to master. As a workaround, you may try > using

Logging query on server node sent from client node

2017-11-15 Thread opsharma1986
Is there a way to log query sent by client node on the server node. I tried this way IgnitePredicate locLsnr = new IgnitePredicate() { @Override public boolean apply(EventAdapter evt) { switch (e

Re: QueryEntity Based Configuration

2017-11-15 Thread afedotov
Hi, Indexes for nested collections and in particular for maps are not supported. If you need indexes for data please consider analyzing and refactoring the problem domain. You could either flatten map so that its keys become fields of the Model or move data into separate cache/caches related to

Deserializing to an object from a request based on SqlQueryField.

2017-11-15 Thread jerpic
Hi All, I’m facing a problem to get the object from a query based on SqlQueryField. Let me give you an example. The type of the field A is : string The type of the field B is : CustomizedObject with its own structure. In the table STRUCTURE we can see that B has been correctly serialized. The p

Re: Best way to configure a single node embedded ignite 2.3

2017-11-15 Thread slava.koptilin
Hello, I think that there is no special setup for embedded mode. If I am not mistaken there is only one important difference between embedded and standalone modes. In case of embedded mode, Ignite node will be started in the same process. Perhaps, the following page will be helpful as well https:

Re: No Error/Exception on Data Loss ?

2017-11-15 Thread afedotov
Hi, If a client is up before a node leaves the cluster then it could listen to org.apache.ignite.events.EventType#EVT_NODE_LEFT and org.apache.ignite.events.EventType#EVT_NODE_FAILED events. If a client may start after a possible server node failure, then there is no solution out of the box but y

Re: Failed to find query with ID: 0

2017-11-15 Thread Igor Sapego
Hi, You used ODBC through C# to create table with CREATE TABLE command, right? If this is the case, then this is a known issue [1] for Ignite 2.3, which, I assume you are using. The issue already fixed and the patch was merged to master. As a workaround, you may try using other Ignite release, lik

Re: AW: NullPointer in GridAffinityAssignment.initPrimaryBackupMaps

2017-11-15 Thread Alexey Popov
Lukas, You are right, IGNITE_HOME could not be a problem in embedded mode. Do you have any specific Affinity Function parameters in Cache configuration? Thanks, Alexey -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/