Re: Getting exception in SQL Query JOINS

Hello, This is a known issue. You can look in the tail to the article [1]. In your case do it like this select c.* from Company c join table(id bigint = ?) i on c.id = i.id [1]: https://apacheignite.readme.io/docs/sql-queries#performance-and-usability-considerations On Thu, Aug 4, 2016 at

Re: Not able to start ignite node in ubuntu server

I had already provided full permissions (777) and owner for these folders/files is root (also starting it as a root user). So I think permissions are right. I am using same permissions that I have used in my local setup. I am running it in bash. It would be great if you can provide insight on

Re: Getting exception in SQL Query JOINS

So What I mean is I need to get data from cache which has keys in the list I pass to query. equavalent SQL will be like, List list = Arrays.asList(2,3,6);//dynamic list coming from client StringBuffer queryStrings = new StringBuffer(" "); for

Re: Ignite Services: How to preserve value of Local variables ?

Val, To reproduce the exception, I've made a simple example. Actually, I'm creating state objects in the Service#init block. I've updated my approach. It doesn't makes sense to make initialization as asynchronous. Regards, Kamal C On Thu, Aug 4, 2016 at 6:21 AM, vkulichenko

Re: Ignite Cluster node stopped

Ok. I attach IGNITE_HOME/work/logs in all server nodes logs when a server node stoped. The stoped server node ip is 172.20.0.183. ignite-logs.bz2 -- View this message in context:

cancel implementation issue in service class.

Hi there, I am trying to implement a service to load data automatically into cache when ignite service started. However, I am not sure how to implement the 'cancel' method. For example, assume that I am loading data via jdbc connections. What should I do to stop loading in 'cancel' method?

Re: Start node in remote server which needs authentication

What are the things I need to include that will make nodes in different remote machines join the same cluster. Also, I am getting below error when I try to start Ignite node in ubuntu server. I have set both JAVA_HOME and IGNITE_HOME in /etc/environment. I am able to start in my local MAC

答复: question about ignite benchmark test

Hi Val, Thank you for your reply. One more question. How about keys in SQL benchmark? Is it the parameter number or the return result of sql query? Best regards, Kevin 发件人: Vladimir Ozerov [mailto:voze...@gridgain.com] 发送时间: 2016年8月4日 17:39 收件人: user@ignite.apache.org 主题: Re: question about

Re: Ignite Cluster node stopped

I attach gc log in ignite server node. gc-logs.bz2 -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-Cluster-node-stopped-tp6608p6758.html Sent from the Apache Ignite Users mailing

Is Ignite worth using in its current state in production? Is it mature enough?

Hi, guys. The more I use Ignite in our system, the more it feels to me like not yet enough mature product. I see lots of performance complains in the discussion, people talking about basic essentials things are not working properly. No one has a clear performance benchmark, just marketing

Re: Not able to start ignite node in ubuntu server

Below is the command I am using - I do - cd $IGNITE_HOME and then, sudo sh bin/ignite.sh -v config/my-ignite.xml -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Not-able-to-start-ignite-node-in-ubuntu-server-tp6707p6751.html Sent from the Apache Ignite Users

Re: Ignite Semaphore Exception

After enabling the Atomic backups to "1". It worked. Thanks Ross! Regards, Kamal On Thu, Aug 4, 2016 at 2:03 PM, ross.anderson wrote: > Hi Kamal, I think I found something similar yesterday. > > In your Ignite configuration, try setting Atomic backups to 1 (it

Re: question about ignite benchmark test

hi Vladimir, What's the size of the key and value in the testing? For the Atomic 10keys, the total entries during the 5 mins' testing is ~35K * 10 * 300 ~= 100M. What's the eviction policy and how many entries are kept in the memory during the whole testing? BTW, is there any benchmark for the

Re: Start node in remote server which needs authentication

Hello, 1) You need to configure DiscoverySPI. Look here [1] 2) Please set IGNITE_HOME where *Ignite* will be unpacked. [1]: http://apacheignite.gridgain.org/docs/cluster-config On Thu, Aug 4, 2016 at 3:28 PM, chevy wrote: > What are the things I need to include

Re: question about ignite benchmark test

Hi Kevin, This is the number of keys involved into PUT or GET operation. If there is 1 key, then *IgniteCache.get() *or *IgniteCache.put() *operation was used. If there are more keys, then we benchmarked *IgniteCache.getAll() *or *IgniteCache.putAll() *operations. On Thu, Aug 4, 2016 at 11:08

Ignite Sql query problem using IN clause

Hi there, When we using ignite sql query, we find that IN clause cannot use indexing when adding extra 'and xxx' clause. Here are the descriptions : If using 'IN' clause like this, and set col1 to be indexed. It works fine. select * from table1 where col1 in (?,?,?); However, if you add more

Re: Ignite Semaphore Exception

Hi Kamal, I think I found something similar yesterday. In your Ignite configuration, try setting Atomic backups to 1 (it defaults to 0, so when the node where it resides goes down it is lost) See the bottom of this page: http://apacheignite.gridgain.org/docs/atomic-types Best, Ross -- View

What is the recommended EC2 instance to setup and run Apache Ignite?

What is the recommended EC2 instance to setup and run Apache Ignite? Should it be Memory Optimized, or Compute Optimized? What are the requirements for Network Performance? How many vCPUs and Memory should the instance have at very minimum? Does Instance Storage type matter? -- View this

Re: Not able to start ignite node in ubuntu server

Hi, You appear to be running this in a non-bash shell (dash?). See this as an example: % cat test.sh source test.env % dash test.sh test.sh: 1: test.sh: source: not found Note the similarity with the first error you have. I did see your message where you mention you are running under bash,

Is there any test case for disaster tolerance ?

Hi, all I want to test the disaster tolerance of ignite, so I must write the test case, is there any test case for it ? if there is, can you provide it to me ? and I also need to start and stop remote nodes, is there any tool that we can use it to start or stop remote nodes ?

Re: Is there any test case for disaster tolerance ?

Hello, Ignite has some test on yardstick framework (in module ignite-yardstick) and documentation of how to use it here https://github.com/gridgain/yardstick and here https://github.com/apacheignite/yardstick-ignite. For checking disaster tolerance you can use any test from the module

Re: Getting exception in SQL Query JOINS

Does it work for single parameter only. If I pass list to query.setArgs(), I get below exception If I pass single value to setArgs, it works fine. BUt it does not accept list/array of values. Failed to execute query... Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting

Ignite Semaphore Exception

Hi all, I'm facing the below exception while using the Ignite Semaphore. Exception in thread "main" class org.apache.ignite.IgniteException: Failed to find semaphore with given name: Hello at org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:906) at

Re: Not able to start ignite node in ubuntu server

Yes, it points to "/opt/ignite/apache-ignite-fabric-1.6.0-bin" where where my ignite.sh is residing. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Not-able-to-start-ignite-node-in-ubuntu-server-tp6707p6740.html Sent from the Apache Ignite Users mailing list

What is the recommended/typical deployment/managing procedure for Ignite in production?

How do you start/stop and manage Ignite instance on the server? So, far as I can see there is IGNITE_HOME/bin/ignite.sh, which can be used only (?) to start the ignite instance. But how do you stop/restart? (now I have to find the process by using `ps aux | grep ignite` and `kill`it manually).

Re: Not able to start ignite node in ubuntu server

How are you starting ignite? (Exact command line you are running, please) Are you running /bin/sh $IGNITE_HOME/bin/ignite.sh? Or are you running just $IGNITE_HOME/bin/ignite.sh? You should be using the second way. ignite.sh has a #!/bin/bash line that will ensure it is run by bash. But

Re: Not able to start ignite node in ubuntu server

How can I confirm that I am using bash or not? -- Regards, Chetan. From: "Kushal Kumaran [via Apache Ignite Users]" > Date: Thursday, August 4, 2016 at 2:28 PM To: "Chetan.V.Yadav"

Re: How Asynchronous support works underneath? 60 * N put calls every second

But, how the future gets notified? What does mean async IO, and how it could be implemented without using threads? Do you use some kind of event/infinite loop? -- View this message in context:

question about ignite benchmark test

Hi there, I am reading ignite benchmark test result from this address：http://www.gridgain.com/resources/benchmarks/ignite-vs-hazelcast-benchmarks And I see there are some graph result labeled with descriptions like this: Graphs: 1

Re: Start node in remote server which needs authentication

1. I have done both of those steps. 2. Also, please look into below config. Is this the right way to add remote machines which forms cluster? 127.0.0.1:47500..47509 10.63.78.112:47500..47509

Client Reconnect Lifecycle with Continuous Queries

I'm trying to understand the lifecycle of reconnecting I have created a gist with testcase and some logging output https://gist.github.com/bearrito/a2aed9e3e8e06799d3f5b27fc997aaa6 My question is why does the client still receive the cache put event even after it has been disconnected and then

Re: Ignite Sql query problem using IN clause

It looks like an issue in H2 database engine, but it was fixed in newest versions. In Ignite-1.7.0 (which is on the vote right now) we upgraded H2, so it must be ok. Sergi 2016-08-04 11:19 GMT+03:00 Zhengqingzheng : > Hi there, > > When we using ignite sql query, we

Re: Start node in remote server which needs authentication

The row is not necessary 127.0.0.1:47500..47509 but in general it is right. Also, I stronly recoment using TcpDiscoveryVmIpFinder instead of TcpDiscoveryMulticastIpFinder, because multicast is often be disabled on practice. On Thu, Aug 4, 2016 at 4:07 PM, chevy wrote:

RE: Ignite performance

Hi Yakov, Thanks again for your help, I guess my goal here was to measure how a cluster behaves if requests come at a certain rate (hence including the queuing/slowdown was intentional), the Executor has 128 threads just to make sure Ignite’s pipes are kept full, which should be equivalent of

Re: What is the recommended/typical deployment/managing procedure for Ignite in production?

Hello, II think use kill is right way. You can write special sh/but file for it. Cluster node it is more than the simple state. For monitor full state (topology, cache, memory consume e.t.c) you can use ignitevisorcmd and yes you can use ps (for check alive or not). Your PR merged into

Re?? Is there any test case for disaster tolerance ?

Thanks for your answer, and I want to know that how the developers of ignite test disaster tolerance ? -- -- ??: "Vladislav Pyatkov";; : 2016??8??4??(??) 6:13 ??: "user"; :

Re: What is the recommended/typical deployment/managing procedure for Ignite in production?

Hi, I saw case where Ignite runs in OpenJDK. Before, I had not compatibility problems with to using OpenJDK. If an issues (bonded with OpenJDK) exist, its will need to be solve. On Thu, Aug 4, 2016 at 7:56 PM, zshamrock wrote: > Thank you, vdpyatkov. > > Also, do

Re: Not able to start ignite node in ubuntu server

On 2016-08-04 15:44, chevy wrote: Below is the command I am using - I do - cd $IGNITE_HOME and then, sudo sh bin/ignite.sh -v config/my-ignite.xml ^^ ^^ That is the problem. You can do either: $ sudo $IGNITE_HOME/bin/ignite.sh -v $IGNITE_HOME/config/my-ignite.xml or $ sudo bash

Ignite logging and troubleshooting

How do you troubleshoot ignite issues in production? Regards logs file, I see there is IGNITE_HOME/work/log directory, with the following files in it: ls -1 ignite-1c980573.0.log ignite-1c980573.0.log.lck ignite-2d181411.0.log ignite-7261bcd3.0.log ignite-7261bcd3.0.log.lck ignite-75b64de5.0.log

Re: Start node in remote server which needs authentication

So, what do you think that is going wrong. Should I change from Ubuntu to something else or config? Also, can I use just .pem file and implement SSLContextFactory to connect to remote server? -- View this message in context:

Re: Does Apache Ignite support clustering multiple Java clients?

Hello Dean, Apache ignite allow to package it to one bundle jar (like you want jar-with-dependencies). It posible, because Ignite was fully wrote on java and delivered as batch of jars. You can use several server Ignite node for cast datagrams and one client node (inter-client as you say), which

Re: What is the recommended/typical deployment/managing procedure for Ignite in production?

Thank you, vdpyatkov. Also, do you recommend to run Ignite from Docker in production? As I saw on the Ignite home page, it says it was fully tested only against Oracle JDK. But in Docker you are using Open JDK. -- View this message in context: