How to increase Heap Space for Ignite Server in .Net Core?

Hi, I am using Apache Ignite 2.7.5 And .net core v2.2.103. While loading data through .net core client heap space getting increase.so for that i am trying to set more heap space. I have tried to set Heap space from command line with running exe by using below command. C:\igniteapp\IgniteApp\bin\

Re: Thick client/thin client difference and how to get thin client port

Thank a lot, Alex. You saved my day :) . On Wed, Jul 3, 2019 at 12:14 AM Alex Plehanov wrote: > Hello, > > There was a bug [1] with one node thin client configuration, which is > fixed now but was not released yet. > You can try to add one more server address (the same address) as a > workaround

Re: Ignite Durable Memory Runs out of Heap Space

Hi, Ignite stores data off-heap (and that's what you've configured) while the out-of-memory exception reports that Java Heap usage goes beyond some bar. Please double check you have optimal heap settings and there are no memory leaks: https://apacheignite.readme.io/docs/jvm-and-system-tuning - D

Ignite Durable Memory Runs out of Heap Space

Hi, I am trying to store many kv pairs into ignite than the available ram. At this moment, the primary purpose of using ignite is a distributed kv database. *My current configuration is: *

Re: ignite how to get cluster queue name and count

Looping in Ignite dev community, Nikolay, in my understanding the new metrics & tracing framework will be flexible enough so that we can add required metrics for data structures like queues. Is this counted in our design? - Denis On Mon, Jul 1, 2019 at 8:42 AM Ilya Kasnacheev wrote: > Hello!

Re: [WARNING][query-#491%ServerNode%][IgniteH2Indexing] Query execution is too long

Please get to know best practices for performance optimizations: https://apacheignite-sql.readme.io/docs/performance-and-debugging As Ilya suggested, your queries just need extra optimization steps. - Denis On Tue, Jul 2, 2019 at 6:49 AM siva wrote: > Hi, > I am using Apache Ignite v2.7.5 as

Re: Set Expiry Policies When Creating Cache Using Java Thin Client

Shane, That's unavailable on the thing clients end yet. My suggestion is to configure caches with required expiration policies on the servers' configuration end. - Denis On Tue, Jul 2, 2019 at 10:54 AM Shane Duan wrote: > I mean ClientCacheConfiguration > > On Tue, Jul 2, 2019 at 10:48 AM Sha

Re: Ignite Visor Cache command hangs indefinitely.

John, This is usually required for the server nodes. - Denis On Wed, Jul 3, 2019 at 10:28 AM John Smith wrote: > Should I do this on the server nodes or the client nodes? > > On Tue, 25 Jun 2019 at 10:18, Maxim.Pudov wrote: > >> You could increase failureDetectionTimeout [1] from default val

Re: Ignite Visor Cache command hangs indefinitely.

Should I do this on the server nodes or the client nodes? On Tue, 25 Jun 2019 at 10:18, Maxim.Pudov wrote: > You could increase failureDetectionTimeout [1] from default value of 1 > to > 6 or so. > > https://apacheignite.readme.io/docs/tcpip-discovery#section-failure-detection-timeout >

Re: INSERT and MERGE statements

Hello! I think you've parsed this one incorrectly: {VALUES (...) | select} Regards, -- Ilya Kasnacheev ср, 3 июл. 2019 г. в 20:15, vitalys : > Yes, it worked. Thank you. > > But I was trying to use the tutorial : > > https://apacheignite-sql.readme.io/docs/merge > > MERGE INTO tableName [(

Re: 2.7.5 IGNITE_HOME/bin/ignitevisorcmd.sh is absent

I can confirm this for 2.7.0 DEB package also. I don't think the DEB and RPM packages come with ignitevisorcmd. If you look under /usr/share/apache-ignite/bin it's not there... On Mon, 1 Jul 2019 at 05:44, Michaelikus wrote: > Hi! > > It was installed from official RPM repository. > > > > > > -

Re: INSERT and MERGE statements

Yes, it worked. Thank you. But I was trying to use the tutorial : https://apacheignite-sql.readme.io/docs/merge MERGE INTO tableName [(columnName [,...])] [KEY (columnName [,...])] {VALUES {({ DEFAULT | expression } [,...])} [,...] | select} I guess the tutorial should be updated :) -- S

Re: INSERT and MERGE statements

Hello! Have you tried instead: MERGE INTO RBCFPVP.RBCFPVPDATAIN (valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,_key) SELECT valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGI

On ServerNode Thread TIMED_WAITING Lock

Hi, I have Apache Ignite V2.7.5 and Windows VM CPU=32,RAM=128. Whenever any operation doing like sql Query,Put or Get cache getting thread time waiting exception on server log. *Server configuration:* --- server-config.xml

Re: INSERT and MERGE statements

KEY clause is commented out and not being used : MERGE INTO RBCFPVP.RBCFPVPDATAIN (valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,_key) VALUES (SELECT valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE9

Re: install_amd

Hi, There is probably some error in the call, if you'd give me an example of how you call the script I could try to help you. But why don't you use an msi installer? It is easier and more reliable way to install ODBC driver on windows. Best Regards, Igor On Wed, Jul 3, 2019 at 5:28 PM ilyn wro

Re: INSERT and MERGE statements

Hello! I think it is self-describing: VALUATIONDATE is not a key column (but value field) so it can't be used in MERGE. You can only use key columns in KEYS() I guess. Regards, -- Ilya Kasnacheev ср, 3 июл. 2019 г. в 18:26, vitalys : > I had some issue with the MERGE .. SELECT .. > > *MERGE I

Re: INSERT and MERGE statements

I had some issue with the MERGE .. SELECT .. *MERGE INTO RBCFPVP.RBCFPVPDATAIN (valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,_key) VALUES (SELECT valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90T

install_amd

Hi, I previously had created my Apache Ignite ODBC driver by running this from apache-ignite-2.7-bin\platforms\cpp\odbc\install and it worked without issue. I just downloaded apache-ignite-2.7.5-bin so wanted to recreate the odbc driver. I uninstalled the previously installed Apache Ignite driver

Re: INSERT and MERGE statements

I made INSERT working : INSERT INTO RBCCTEVAPVP.RBCCTEVAMARGINCALCED (valuationdate, BUSINESSRUN,REPORTINGCOMPANY,RBCCTE90MARGIN,RBCCTE90TAXADJRATIO,RBCCTE97MARGIN,RBCCTE97TAXADJRATIO,RBCCASOMARGIN,_key) VALUES ('12-03-2019','5',9,3.3,4.4,5.5,6.6,7.7,'12-03-2019_5_9'); Merge still failin

Re: TcpCommunicationSpi failed to establish connection to node, node will be dropped from cluster

Hello! [11:09:05,401][WARNING][sys-stripe-5-#6%null%][TcpCommunicationSpi] Connect timed out (consider increasing 'failureDetectionTimeout' configuration property) [*addr=/172.20.0.1:48588 *, failureDetectionTimeout=3] [11:13:08,565][WARNING][grid-timeout-worker-#55%nu

Re: about single service redistribution after node restart

Hi! Currently services don't get redistributed if new nodes join a topology. So, if you have all services deployed on one node, then they won't be moved to newly joined ones. This is a known issue. The following ticket mentions it: https://issues.apache.org/jira/browse/IGNITE-7667 Currently even d

Re: INSERT and MERGE statements

Hello! Can you please quote full stack traces? They are probably in the logs of server nodes. Regards, -- Ilya Kasnacheev вт, 2 июл. 2019 г. в 23:25, vitalys : > I am running Ignite v.25 and I am trying to populate cache using SQL > statements via DBeaver. > > I create a cache called TAXRATE

Re: Thick client/thin client difference and how to get thin client port

Hello, There was a bug [1] with one node thin client configuration, which is fixed now but was not released yet. You can try to add one more server address (the same address) as a workaround. For example: ClientConfiguration cfg = new ClientConfiguration().setAddresses(hostName + ":" + portNumber