Re: Getting exception in SQL Query JOINS

2016-08-22 Thread begineer
I have one more related question to this, Is there a limit to size of array passed. If we use IN clause, Oracle allows maximum size of 1000 -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Getting-exception-in-SQL-Query-JOINS-tp6674p7203.html Sent from the Apache

Re: Getting exception in SQL Query JOINS

2016-08-22 Thread Vladislav Pyatkov
Hi, I cannot see any limits, except reasonable. Look at the H2 documentation fro the details[1]. [1]: http://www.h2database.com/html/functions.html#table On Mon, Aug 22, 2016 at 11:14 AM, begineer wrote: > I have one more related question to this, > Is there a limit to size of array passed. If

IGNITE DEBUG console in 1.7.0 not functioning

2016-08-22 Thread mzingman
ignite debug web console comes up with exception on the left hand side pane: General error: "java.lang.UnsupportedOperationException"; SQL statement: SELECT UPPER(VALUE) FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME=? [5-191] HY000/5 org.h2.jdbc.JdbcSQLException: General error: "java.lang.Un

Yarn deployment for static TcpDiscoverySpi issues:Urgent In Production

2016-08-22 Thread percent620
Hello, Everything is okay for me to integrate ignite with yarn on *Multicast Based Discovery* in my local spark and yarn cluster , but in our production env, some of ports could't be opened .So, I need to specify a static ip address to discovery each other. but when running my configuration and

Re: Web Session Clustering httpsession

2016-08-22 Thread galo23
hi , below is the log file. thanks. log.log -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Web-Session-Clustering-httpsession-tp7176p7206.html Sent from the Apache Ignite Users mailing

Ignite Grace full node shutdown

2016-08-22 Thread Isaeed Mohanna
Hi I have ignite embedded in my own server, I have a 3 node cluster running different tasks and services all the time. for availability reasons i would like to perform a rolling upgrade of my server (not ignite, ignite will still be in the same version), so i would like to stop one node, put in a n

Re: Yarn deployment for static TcpDiscoverySpi issues:Urgent In Production

2016-08-22 Thread Nikolai Tikhonov
Hi, How I see in your logs that your "file:/usr/apache-ignite- fabric-1.6.0-bin/config/default-config.xml" is incorrect. invalid; nested exception is org.xml.sax.SAXParseException; lineNumber: 6; columnNumber: 71; cvc-elt.1: Cannot find the declaration of element 'beans'. at org.springfra

Re: IGNITE DEBUG console in 1.7.0 not functioning

2016-08-22 Thread Sergi Vladykin
It is a known problem which is already fixed in master. Sergi 2016-08-22 15:33 GMT+03:00 mzingman : > ignite debug web console comes up with exception on the left hand side > pane: > > General error: "java.lang.UnsupportedOperationException"; SQL statement: > SELECT UPPER(VALUE) FROM INFORMATION

Re: Howto setup a single-node, standalone Ignite?

2016-08-22 Thread Vladislav Pyatkov
Sascha, Ignite does not allow disable discovery. You can configure discovery SPI, in order to assign different ip-addresses and ports for different nodes. I see, to implement discovery SPI is one of a way to do as you wanted. On Mon, Aug 22, 2016 at 12:09 AM, SaschaC wrote: > Hi, > > I've been

How to stop ignite node gracefully

2016-08-22 Thread ght230
Usually we use command "kill" to stop an Ignite instance. But sometimes this process will take a very long time. So we try to use command "kill -9" instead. But it may make some off-heap memory not be fully released and cause system memory leaks. I want to know is it normal? And is there any othe

Re: How to stop ignite node gracefully

2016-08-22 Thread Vladislav Pyatkov
Hello, When you invoke kill -9 application closing and all resources associated with the process are released. Therefore kill -9 should not cause a memory leak. On Mon, Aug 22, 2016 at 5:54 PM, ght230 wrote: > Usually we use command "kill" to stop an Ignite instance. But sometimes > this > proc

Does IgniteDataStreamer support traffic control

2016-08-22 Thread ght230
Sometimes the requests to put the data to IgniteDataStreamer are very frequently, this will cause the Ignite cluster instability. I want to know does IgniteDataStreamer support traffic control or anything like backpress(supported by storm)? -- View this message in context: http://apache-ignite

Re: One failing node stalling the whole cluster

2016-08-22 Thread DLopez
Hi Denis, The exception was happening to us in a cluster where all the nodes have the same configuration, they use the same piece of code to setup the cluster, and happened without restarting any node at all. Regarding the first issue, one node being slow due to GC issues would slow down the whole

Re: Does IgniteDataStreamer support traffic control

2016-08-22 Thread Vladislav Pyatkov
Hi, DataStreamer buffers and redirects data by nodes, in addition it allow tuning buffer size and parallel operation amount (perNodeBufferSize(), perNodeParallelOperations()). DataStreamer can lose data in instability topology if allowOverwrite was setted as false, but if allowOverwrite is true i

Re: Way to save Multiple queries results for further manipulation

2016-08-22 Thread vkulichenko
chevy wrote > I am adding data into a map and loading it to cache. But when I do that > using cache.put() method, all my column names gets added as metadata and > values in items. How can I get my results as shown above i.e., key : value > format. Can you show the code snippets of what you're doin

Re: Embedded mode ignite on spark

2016-08-22 Thread vkulichenko
You can use this one as a reference: https://apacheignite-fs.readme.io/docs/ignitecontext-igniterdd Here the empty configuration object is created, but you can change any properties if needed. The whole point is to do this inside the function, not the outside. -Val -- View this message in cont

Re: Howto setup a single-node, standalone Ignite?

2016-08-22 Thread vkulichenko
Another possible solution is to use VM IP finder in shared mode: TcpDiscoverySpi disco = new TcpDiscoverySpi().setIpFinder(new TcpDiscoveryVmIpFinder(true)); This will limit the discovery to the single process (i.e., nodes will discover each other only if they are started within one JVM with the

Re: One failing node stalling the whole cluster

2016-08-22 Thread Denis Magda
Hi Binti, See below > On Aug 21, 2016, at 4:24 PM, bintisepaha wrote: > > Hi Denis, > we see this exception too from a client when the cluster is > restarted."IllegalStateException: Cache has been closed or destroyed: cache" > we reconnect the client to the cluster by calling Ignition.stop and

Re: One failing node stalling the whole cluster

2016-08-22 Thread Denis Magda
Hi See below > On Aug 22, 2016, at 8:52 AM, DLopez wrote: > > Hi Denis, > The exception was happening to us in a cluster where all the nodes have the > same configuration, they use the same piece of code to setup the cluster, and > happened without restarting any node at all. Please refer to

Re: Yarn deployment for static TcpDiscoverySpi issues:Urgent In Production

2016-08-22 Thread vkulichenko
Hi, Can you please attach the configuration file instead of copy-pasting pieces of it? percent620 wrote* > the sparks-run will be running successfully, but the programs always > running NOT STOP, and didn't print message numbers * Can you please clarify what you meant by this? Is there still an

Re: Near Cache

2016-08-22 Thread vkulichenko
I don't there is something available out of the box. However, you can create a small app that will get the contents of near cache using IgniteCache API: cache.localEntries(CachePeekMode.NEAR); -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Near-Cache-tp70

why allocated containers much more than INGNITE_NODE_COUNT?

2016-08-22 Thread shirely
well, I tried to integrate ignite with yarn and set IGNITE_NODE_COUNT equals 2, but when running the ignite yarn application, I found the total allocated containers is 156 and kept increasing. I'm really confused, what is the relationship between ignite node and allocated containers? -- View t

Re: mybatis-ignite

2016-08-22 Thread Roman Shtykh
Hi all, The issue with starting an Ignite instance is fixed with mybatis-ignite 1.0.2 release. -Roman On Tuesday, July 19, 2016 6:26 AM, vkulichenko wrote: Hi, First of all, please properly subscribe to the mailing list so that the community can receive email notifications for you me

Re: Getting exception in SQL Query JOINS

2016-08-22 Thread begineer
OK thanks -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Getting-exception-in-SQL-Query-JOINS-tp6674p7228.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Web Console on Local Machine not working

2016-08-22 Thread pawantlor
Hello, i am new to ignite. I am trying to start web-console but could not got through. I have used below link for making web-console work: https://cwiki.apache.org/confluence/display/IGNITE/Web+Console >From above link, when i am executing "node server" command, i am getting below exception: fir

Re: Web Console on Local Machine not working

2016-08-22 Thread Andrey Novikov
Hi,Please try to use web console from latest released version: 1.7 pawantlor wrote > I have used below link for making web-console > work:https://cwiki.apache.org/confluence/display/IGNITE/Web+Console This documentation is outdated (will be upgraded soon). At this moment you may use DEVNOTES.txt