Re: Stand-alone Mode Ignite Installation

2021-04-12 Thread Ilya Kasnacheev
Hello! Can you please highlight any specific issues that you are facing? Regards, -- Ilya Kasnacheev сб, 10 апр. 2021 г. в 20:40, sri hari kali charan Tummala < kali.tumm...@gmail.com>: > Hi Ignite Users, > > Below we link is not working spark ignite standalone mode inst

Re: SQL query performance with JOIN and ORDER BY or WHERE

2021-04-09 Thread Ilya Kasnacheev
Hello! ORDER BY will have to sort the whole table. I think that using index on QUEUED will be optimal here. What is the selectivity of this field? If it s boolean, you might as well use UNION queries. Have you tried joining JOBS via WHERE EXISTS? Regards, -- Ilya Kasnacheev пт, 9 апр. 2021

Re: reading encrypted password from Ignite config file

2021-04-09 Thread Ilya Kasnacheev
Hello! If this is your concern, I recommend switching from login/password to certificate based authentication. It is much stronger and uses encrypted files as is. Regards, -- Ilya Kasnacheev чт, 8 апр. 2021 г. в 16:32, shivakumar : > Hi Igniters, > Does Ignite support reading the enc

Re: Abrupt stop of application on using sql

2021-04-09 Thread Ilya Kasnacheev
Hello! What is the return code of the Java process? I recommend checking dmesg output for OOMKiller messages. Seems to be a popular failure mode these days. Regards, -- Ilya Kasnacheev пт, 9 апр. 2021 г. в 11:58, rakshita04 : > Hi Team, > > Do you have any update on this issue? &g

Re: Abrupt stop of application on using sql

2021-04-08 Thread Ilya Kasnacheev
Hello! Are there hs_err_pid*.log files around after the abrupt stopping? If there are, please share the latest one. Regards, -- Ilya Kasnacheev чт, 8 апр. 2021 г. в 15:06, rakshita04 : > Hi Team, > > We are using sql queries and sql feature of C++ for our existing cache data

Re: Ignite persistence is accepting null value in not null field

2021-04-05 Thread Ilya Kasnacheev
Hello! Okay, this looks like a bug. Can you please put a small reproducer project with this code somewhere on github, or provide as tarball? I will try it and file a ticket, or you can do that yourself. Regards, -- Ilya Kasnacheev пн, 5 апр. 2021 г. в 18:16, sourav dihidar : > Thanks

Re: Ignite persistence is accepting null value in not null field

2021-04-05 Thread Ilya Kasnacheev
Hello! I guess that "not null" is only tracked by SQL code, but not by cache API or data streamer. Regards, -- Ilya Kasnacheev сб, 3 апр. 2021 г. в 18:22, sourav dihidar : > Hi Team, > I am facing one issue > I created one table as below > CREATE TABLE STUDENT >

Re: Correctly stopping/deactivating server node

2021-04-05 Thread Ilya Kasnacheev
Hello! Yes it should be safe, provided that your own hook works correctly. Regards, -- Ilya Kasnacheev вс, 4 апр. 2021 г. в 23:18, DonTequila : > Actually I found that this is indeed true. Ignite supports the JRE option: > > -DIGNITE_NO_SHUTDOWN_HOOK=true > > When I set this

Re: Ignite server not equally distribution load

2021-04-05 Thread Ilya Kasnacheev
Hello! I recommend collecting (java) thread dumps on both server nodes and comparing them, under load. Then you can infer what is the difference in the load that they handle. Regards, -- Ilya Kasnacheev пн, 5 апр. 2021 г. в 07:20, Charlin S : > Hello, > Thanks for your response, >

Re: Ignite-client can not properly connect with ignite-server

2021-04-02 Thread Ilya Kasnacheev
Hello! Unfortunately, I can't see any logs here. Can you attach them as a file? Have you checked out https://www.gridgain.com/docs/latest/developers-guide/clustering/running-client-nodes-behind-nat#running-client-nodes-behind-nat ? Regards, -- Ilya Kasnacheev чт, 25 мар. 2021 г. в

Re: NullPointer Exception while starting new client cache node

2021-04-02 Thread Ilya Kasnacheev
Hello! I believe this question is answered on SO: https://stackoverflow.com/a/66889691/36498 I have also filed a ticket about this issue: https://issues.apache.org/jira/browse/IGNITE-14466 Regards, -- Ilya Kasnacheev ср, 31 мар. 2021 г. в 10:33, Pawan Jangid : > Hi, > &g

Re: [2.10]Binary type has different affinity key fields

2021-04-02 Thread Ilya Kasnacheev
Hello! You can use the experimental --meta commands of control.sh available from 2.9 onwards: https://issues.apache.org/jira/browse/IGNITE-13154 The ticket documents the process to some detail. Regards, -- Ilya Kasnacheev чт, 1 апр. 2021 г. в 18:40, 38797715 <38797...@qq.com>: > H

Re: Getting ERROR IgniteKernal: Failed to start manager: GridManagerAdapter, Caused by: class org.apache.ignite.spi.IgniteSpiException: Failed to deserialize object with given class loader: sun.misc.L

2021-04-01 Thread Ilya Kasnacheev
Hello! Maybe the problem is that InstanceProfileCredentialsProvider not serializable? But then again, none of these seem to be. Unfortunately, from stack trace it is not obvious which object can't be deserialized. Can you try to debug? Regards, -- Ilya Kasnacheev пн, 29 мар. 2021 г. в

Re: [2.10]Binary type has different affinity key fields

2021-04-01 Thread Ilya Kasnacheev
Hello! I guess you have to wipe this directory on all nodes, including clients. If any caches contain old instances of this class, drop the caches before restart. Regards, -- Ilya Kasnacheev чт, 1 апр. 2021 г. в 08:03, 38797715 <38797...@qq.com>: > Hello, > Ignite turns on native

Re: Re[2]: Failed to write class name to file

2021-04-01 Thread Ilya Kasnacheev
Hello! In newer versions Ignite will never use /tmp by default. Regards, -- Ilya Kasnacheev ср, 31 мар. 2021 г. в 13:26, Matej Kováč : > Thank you Zhenya, > it seems that the problem was caused by the fact that centos deleted the > whole ignite work directory as it was unaccessed fo

Re: EVT_CACHE_REBALANCE_STARTED

2021-04-01 Thread Ilya Kasnacheev
Hello! It is triggered when a rebalance future is created - partitions are assigned for rebalance on demanding node. Regards, -- Ilya Kasnacheev ср, 31 мар. 2021 г. в 18:57, narges saleh : > Hello Folks > > When does the event EVT_CACHE_REBALANCE_STARTED get triggered? Upon a >

Re: Ignite server not equally distribution load

2021-04-01 Thread Ilya Kasnacheev
Hello! What is your baseline topology? Are both of your server nodes on it? Regards, -- Ilya Kasnacheev чт, 1 апр. 2021 г. в 07:02, Charlin S : > Hello, > Thanks for the reply. > Two servers are formed as cluster and the details as below > Topology snapshot [ver=262, locN

Re: Correctly stopping/deactivating server node

2021-04-01 Thread Ilya Kasnacheev
Hello! I guess that it's already too late to deactivate if the node is shutting down. What are scenarios for which you are trying to prepare here? Regards, -- Ilya Kasnacheev ср, 31 мар. 2021 г. в 22:13, DonTequila : > Has anyone been able to look at this and give me some advise

Re: Ignite hanging with log "TcpCommunicationSpi - TCP client created"

2021-04-01 Thread Ilya Kasnacheev
Hello! Can you please provide a runnable reproducer for this behavior? Regards, -- Ilya Kasnacheev чт, 1 апр. 2021 г. в 12:54, swara : > > Thank you for your response. > > we are querying the same cache object concurrently and executing the > cache.query() eagerly. The se

Re: JDK15 support

2021-03-30 Thread Ilya Kasnacheev
Hello! You are free to file tickets against Apache Ignite JIRA if you see any issues while working on JDK15, maybe provide fixes as well. Regards, -- Ilya Kasnacheev вт, 23 мар. 2021 г. в 19:54, wiesenfe : > Good afternoon, > > I am trying to start Apache Ignite with persistence ena

Re: Understanding Swap Space feature-- how it works?

2021-03-24 Thread Ilya Kasnacheev
Hello! As far as my understanding goes, you do not need to do anything special to get data off swap. You can just access any data in the cache, whether swapped out or not. I'm not sure how it would interact with eviction. Regards, -- Ilya Kasnacheev ср, 24 мар. 2021 г. в

Re: GMSA

2021-03-24 Thread Ilya Kasnacheev
, since there is no support in stock Apache Ignite. Regards, -- Ilya Kasnacheev ср, 24 мар. 2021 г. в 06:15, Josh Katz : > Does Ignite support Group Managed Service Accounts (GMSA)? > > > > Thanks, > > > > *Josh Katz* > > *Dodge & Cox* > > 555 Califor

Re: Working with Objects Fields Defined is Multiple Tables.

2021-03-23 Thread Ilya Kasnacheev
Hello! There's an answer on stack overflow: https://stackoverflow.com/questions/66716680/how-to-define-ignite-caches-for-objects-joined-from-multiple-tables/66764133#66764133 If you have further questions, you can ask here as well. Regards, -- Ilya Kasnacheev сб, 20 мар. 2021 г. в

Re: Ignite hanging with log "TcpCommunicationSpi - TCP client created"

2021-03-19 Thread Ilya Kasnacheev
Hello! It's too hard to answer since I do not have context for some of these questions. I recommend closing cursors when they are no longer needed, then checking if you still have issues. Regards, -- Ilya Kasnacheev пт, 19 мар. 2021 г. в 13:43, swara : > Thank you for your response

Re: Logging client instance name in server logs

2021-03-18 Thread Ilya Kasnacheev
Hello! I recommend putting client instance name as a node attribute. Then it may be read on server nodes and printed. Regards, -- Ilya Kasnacheev чт, 18 мар. 2021 г. в 14:25, Gangaiah Gundeboina : > HI, > > Anyone please help us, how to log the client instance name in se

Re: Ignite hanging with log "TcpCommunicationSpi - TCP client created"

2021-03-18 Thread Ilya Kasnacheev
Hello! SqlFieldsQuery does not have connection pool limit, since it is handled by GridGain nodes and it is multiplexed asynchronously. The actual SQL request handling takes place in query thread pool, which indeed has default size of max(8, total number of cores) Regards, -- Ilya Kasnacheev

Re: Unable to evict cache entry in all nodes synchronously

2021-03-18 Thread Ilya Kasnacheev
Hello! Glad to hear that! These settings indeed seem reasonable. Regards, -- Ilya Kasnacheev чт, 18 мар. 2021 г. в 10:04, ashishg : > Hi Ilya, > > Thanks for response. I am able to achieve FULL_SYNC now which cache > update/clear. I am suspecting one of the timeouts value as

Re: Configuring persistence for large dataset on small cluster

2021-03-16 Thread Ilya Kasnacheev
will grind to a halt or you can even catch IgniteOOM. I guess that you will have to live with the limit that you have determined. Regards, -- Ilya Kasnacheev вс, 14 мар. 2021 г. в 23:15, Sebastien Blind : > Hello Apache Ignite friends, > I am trying to load 1bn records in an i

Re: Re[2]: Run sql query on key-value cache

2021-03-12 Thread Ilya Kasnacheev
ndexes#creating-indexes-with-sql should also refer to CREATE TABLE btw. Regards, -- Ilya Kasnacheev пт, 12 мар. 2021 г. в 13:40, Zhenya Stanilovsky : > Ilya, seems you mistaken, check [1] > Seems there is no additional documentation, but API is simple , check > example [2]. > > [1]

Re: Loading data to cache using a data streamer

2021-03-12 Thread Ilya Kasnacheev
Hello! Unfortunately, the exception snippet that you have pasted is not sufficient to understand what's going on. Regards, -- Ilya Kasnacheev ср, 10 мар. 2021 г. в 19:35, Pelado : > Take a look at the data node. If the data node has restarted you might see > a client disconnecte

Re: Cache group setting not taking effect

2021-03-12 Thread Ilya Kasnacheev
ards, -- Ilya Kasnacheev пт, 12 мар. 2021 г. в 00:19, joaogoncalves1 : > Hi Ilya, > > Sorry for the delay, we have been heavy testing our cluster since we were > able to set the cache groups. > A difference between development and production configs was making me > believe that cache

Re: Run sql query on key-value cache

2021-03-12 Thread Ilya Kasnacheev
Hello! Once a cache is created, you can't add indexes. You will need to recreate cache / restart cluster with updated configuration. You can define caches with Query Entities in spring XML configuration, pass it to IgniteConfguration instance. Regards, -- Ilya Kasnacheev пт, 12 мар. 2

Re: Initialise properties at implemented CacheEntryUpdatedListener

2021-03-10 Thread Ilya Kasnacheev
Hello! Just declare the field as transient, and then apply if (f == null) f = initialValue() pattern. Regards, -- Ilya Kasnacheev чт, 4 мар. 2021 г. в 17:34, mvolkomorov <2201...@gmail.com>: > Hi, guys! > > Is it possible to initialize my property with an injected resource at

Re: Failed to process selector key (Connection reset by peer)

2021-03-10 Thread Ilya Kasnacheev
ote client to exhaust its heap and virtually hang? Then it will build up on server and exhaust memory, too. What is the query in question? Regards, -- Ilya Kasnacheev сб, 6 мар. 2021 г. в 08:19, erathina : > Hi, We have an ignite cluster setup with two ignite servers. At certain > times

Re: Cache group setting not taking effect

2021-03-10 Thread Ilya Kasnacheev
, only then may new operations start. This would explain why you see multi-second delays. Regards, -- Ilya Kasnacheev ср, 10 мар. 2021 г. в 00:13, joaogoncalves1 : > I am trying to take an Ignite cluster to production but so far we have hit > a > lot of performance issues and are in th

Re: ContinuousQuery and injected bean

2021-03-10 Thread Ilya Kasnacheev
Hello! It is recommended to use inner static classes as remote filters or runnables/callables, precisely because they don't bring parent class instance with them, which will otherwise consume bandwidth and may cause serialization issues. Regards, -- Ilya Kasnacheev пт, 5 мар. 2021 г. в

Re: [2.9.1]Failed to find DHT update future for deferred update response

2021-03-10 Thread Ilya Kasnacheev
the operation. I'm not sure that "Failed to find DHT update future for deferred update response" may cause subsequent node failure. Can you provide complete logs from all server nodes in the cluster? Regards, -- Ilya Kasnacheev пт, 5 мар. 2021 г. в 16:16, 38797715 <38797...@q

Re: Apache-ignite cluster taking too long to start , its taking around one hour to start

2021-03-10 Thread Ilya Kasnacheev
Hello! Please provide the complete verbose log from all nodes! Regards, -- Ilya Kasnacheev ср, 10 мар. 2021 г. в 09:22, mohammed.afzal : > i configured ignite cluster using 3 nodes , to form cluster its taking 1 > hour > for all nodes to form. > i have this setup : > node -1

Re: Loading data to cache using a data streamer

2021-03-09 Thread Ilya Kasnacheev
Hello! Does it work with a smaller batch? My guess is that you end up consuming too much resources and then the cluster falls apart. Regards, -- Ilya Kasnacheev сб, 6 мар. 2021 г. в 00:59, Josh Katz : > Client node gets disconnected while trying to load data to cache using a > data st

Re: [2.9.1]Failed to find DHT update future for deferred update response

2021-03-05 Thread Ilya Kasnacheev
Hello! Do you happen to have a reproducer for this issue? I've not seen anything similar. Regards, -- Ilya Kasnacheev ср, 3 мар. 2021 г. в 12:31, 38797715 <38797...@qq.com>: > Hi team, > > When using DataStreamer to write a large amount of data at high speed, if > one

Re: Unable to evict cache entry in all nodes synchronously

2021-03-05 Thread Ilya Kasnacheev
Hello! Do you have a reproducer which shows that entries are still contained in cache after remove/clear? Regards, -- Ilya Kasnacheev пт, 5 мар. 2021 г. в 08:22, ashishg : > Can we get an acknowledgement from all cluster nodes that the cache has > been > updated or cleared? > >

Re: Exception while running Select Query in ignite 2.8.1 - Fetched result set was too large

2021-03-05 Thread Ilya Kasnacheev
Hello! Please check out https://lists.apache.org/thread.html/rf9a3f10fb719f9c1e31516992cc624f9898b08857c34b6e5a3a0fc13%40%3Cuser.ignite.apache.org%3E Regards, -- Ilya Kasnacheev чт, 4 мар. 2021 г. в 08:52, Veena : > Hi, > > We are getting below exception execution join query us

Re: Ignite hanging with log "TcpCommunicationSpi - TCP client created"

2021-03-05 Thread Ilya Kasnacheev
Hello! This looks like the case of half-open connections with very long retransmits. One host acknowledges that connection has failed when the other does not. Please provide complete logs from both directions. Regards, -- Ilya Kasnacheev чт, 4 мар. 2021 г. в 08:42, swara : > Hi, >

Re: Ignite 2.8.1 ContinuousQueryWithTransformer: ClassCastException on PME

2021-03-05 Thread Ilya Kasnacheev
Hello! Can you please provide a runnable reproducer project? Save me the trouble of pasting all these snippets and writing the boilerplate. Regards, -- Ilya Kasnacheev чт, 4 мар. 2021 г. в 18:21, : > Ilya, unfortunately, I am unable to reproduce this issue in a pet project. > > I

Re: Unable to evict cache entry in all nodes synchronously

2021-03-02 Thread Ilya Kasnacheev
Hello! What do you mean by eviction here? How do you determine that it isn't happening? Regards, -- Ilya Kasnacheev вт, 2 мар. 2021 г. в 18:14, ashishg : > Hi, > > I am using Ignite v2.9.1 and trying to evict cache entry via Http API call. > The other cluster nodes should al

Re: BinaryObjectException: Conflicting Enum Values

2021-03-01 Thread Ilya Kasnacheev
Hello! I guess this information was stored somewhere and is causing conflicts now. You can try dropping binary_meta/ directory from ignite work dir on all nodes, hope that it would be repopulated all right. Make sure to back it up first! Regards, -- Ilya Kasnacheev чт, 25 февр. 2021 г. в 21

Re: Set Think Client ClassLoader

2021-03-01 Thread Ilya Kasnacheev
Hello! Have you tried the solution posted there? Regards, -- Ilya Kasnacheev сб, 27 февр. 2021 г. в 01:10, PunxsutawneyPhil3 : > Stack over flow link > < > https://stackoverflow.com/questions/66393352/is-there-a-way-to-set-an-ignite-thin-client-classloader> > > to

Re: Client node disconnected

2021-03-01 Thread Ilya Kasnacheev
Hello! You can set clientReconnectDisabled to 'true' on the client nodes, in this case the client will not try to reconnect and instead will produce an error. When you see this error you may create a new client which will hopefully not have these problems. Regards, -- Ilya Kasnachee

Re: Database has been closed

2021-03-01 Thread Ilya Kasnacheev
Hello! You don't seem to have INFO log level enabled, so there's not much to see there unfortunately. Please enable INFO level, it should also add thread dumps automatically, I think. Regards, -- Ilya Kasnacheev пн, 1 мар. 2021 г. в 13:48, DonTequila : > Hi Ilya, > > The c

Re: Database has been closed

2021-03-01 Thread Ilya Kasnacheev
Hello! Unfortunately, we can't go from here without thread dump or, at least, a complete log from the beginning. Regards, -- Ilya Kasnacheev чт, 25 февр. 2021 г. в 11:07, DonTequila : > Hi again, > > is there anything that could help me identify the potential reason for t

Re: Near Cache versus Continuous Query

2021-02-24 Thread Ilya Kasnacheev
is to have a server node working on replicated cache, with FULL_SYNC. 3. You may open it in a singleton service's init(), for example. Still there is no guarantee that it is always up, only that it's never down for a long time. If you really need to catch every write always, consider a ca

Re: Client node disconnected

2021-02-24 Thread Ilya Kasnacheev
Hello! Looks like network problems, long GC on server node or some kind of deadlock on server node which prevents it from responding. Regards, -- Ilya Kasnacheev ср, 24 февр. 2021 г. в 13:09, oguzhan : > Hello, > > We have 1 client node and 1 server node and we are using ignit

Re: Eager TTL and query

2021-02-24 Thread Ilya Kasnacheev
Hello! As far as my understanding goes, each cache operation has a chance of expiring some number of cache entries, so the answer is "e1 and e2 may be removed when putting e3 into mycache". Maybe there's somebody to correct me. Regards, -- Ilya Kasnacheev ср, 24 февр.

Re: Database has been closed

2021-02-24 Thread Ilya Kasnacheev
. You can also see java.lang.OutOfMemoryError: Java heap space But that's probably due to build-up of requests, etc, caused by the locking. Regards, -- Ilya Kasnacheev вт, 23 февр. 2021 г. в 22:06, DonTequila : > I've a production cluster of 1 server with Ignite native persiste

Re: Near Cache versus Continuous Query

2021-02-20 Thread Ilya Kasnacheev
Hello! "I always want a fully up to date copy of that cache" sounds like you need a cache store actually. Regards, -- Ilya Kasnacheev сб, 20 февр. 2021 г. в 04:05, tschauenberg : > Hi, > > I have a use case where I want a fully copy of a replicated cache on a > subs

Re: Proper way to configure RDMS as persistent store

2021-02-20 Thread Ilya Kasnacheev
Hello! I can see that the questions are answered on SO: https://stackoverflow.com/a/66288272/36498 Regards, -- Ilya Kasnacheev пт, 19 февр. 2021 г. в 19:02, PunxsutawneyPhil3 : > I followed the example > < > https://ignite.apache.org/docs/latest/persistence/external-s

Re: very fast loading of very big table

2021-02-19 Thread Ilya Kasnacheev
Hello! Is there a chance that you have tried enabling streaming (data streamer) on the clients? Regards, -- Ilya Kasnacheev пт, 19 февр. 2021 г. в 10:10, : > Hi Denis, > > Data space is 3.7Gb according to MSSQL table properries > > Vladimir > > 9:47, 19 февраля

Re: Ignite 2.81. - NULL pointer exception

2021-02-19 Thread Ilya Kasnacheev
Hello! I have filed a ticket https://issues.apache.org/jira/browse/IGNITE-13475 Regards, -- Ilya Kasnacheev пт, 19 февр. 2021 г. в 02:24, narges saleh : > Was there a resolution for this issue? > > On Mon, Sep 7, 2020 at 9:40 AM Ilya Kasnacheev > wrote: > >> Hell

Re: Unsubscribe

2021-02-19 Thread Ilya Kasnacheev
Hello! Please send email to this address: user-unsubscr...@ignite.apache.org It has to be from the e-mail box that you have subscribed to. Regards, -- Ilya Kasnacheev пт, 19 февр. 2021 г. в 01:02, Ryan Trollip : > I sent an unsubscribe request but am still getting emails. Please rem

Re: Graceful shutdown and request draining of Ignite servers

2021-02-18 Thread Ilya Kasnacheev
Hello! This sounds like a too detailed and peculiar scenario that should be taken care of on the application level, as you already do. Regards, -- Ilya Kasnacheev ср, 17 февр. 2021 г. в 23:50, Raymond Wilson : > I Ilya, > > Sorry, that was a response to another problem! > > I

Re: Reliably duplicate SQL cache

2021-02-18 Thread Ilya Kasnacheev
Hello! It will be available in cache's Query Entities so you can try: ((CacheConfiguration)ignite.cache("SQL_PUBLIC_") .getConfiguration(CacheConfiguration.class)).getQueryEntities().iterator().next().getValueType() Regards, -- Ilya Kasnacheev чт, 18 февр. 2021 г. в

Re: [2.10 branch]cpp thin client transaction :Transaction with id 1 not found.

2021-02-17 Thread Ilya Kasnacheev
Hello! I confirm that I see this issue. Can you please file a ticket against IGNITE JIRA? Thanks, -- Ilya Kasnacheev вт, 16 февр. 2021 г. в 11:58, jjimeno : > Hello! > > In fact, it's very simple: > > int main() >{ >IgniteClientConfiguration cfg; > >

Re: Graceful shutdown and request draining of Ignite servers

2021-02-17 Thread Ilya Kasnacheev
Hello! Why can't you just use Ignite.stop(instanceName, false)? Just make sure your projections are not singleton and the tasks will be rolled over. Regards, -- Ilya Kasnacheev вт, 9 февр. 2021 г. в 06:41, Raymond Wilson : > All, > > We have a very similar requirement as des

Re: Ignite 2.9.1 - An existing connection was forcibly closed by the remote host

2021-02-16 Thread Ilya Kasnacheev
Hello! Have you gotten around collecting thread dump from the client? Regards, -- Ilya Kasnacheev вт, 16 февр. 2021 г. в 16:59, Charlin S : > Hello, > Thanks for your help, > I am not sure where to check the network misconfiguration either in System > or in Application configura

Re: Ignite 2.9.1 - An existing connection was forcibly closed by the remote host

2021-02-16 Thread Ilya Kasnacheev
Hello! It should be JVM thread dump. Packet drops is one thing, network misconfiguration is another. Regards, -- Ilya Kasnacheev пн, 15 февр. 2021 г. в 15:12, Charlin S : > Hello, > Thanks for your help, > As per our network team, there were no packet drops between client and >

Re: [2.10 branch]cpp thin client transaction :Transaction with id 1 not found.

2021-02-15 Thread Ilya Kasnacheev
Hello! Can you prepare a simple reproducer? I can start two server nodes and launch it specifying their addresses as parameters. If there needs to be any specific node configuration, please share also. Regards, -- Ilya Kasnacheev пн, 15 февр. 2021 г. в 15:08, jjimeno : > Hello > >

Re: [2.10 branch]cpp thin client transaction :Transaction with id 1 not found.

2021-02-15 Thread Ilya Kasnacheev
to the second one which never knew that it was started. Maybe this is also the case with different nodes, btw. Maybe it's just not safe to roll over with uncommitted tx even to a different node in the cluster. This needs checking. Regards, -- Ilya Kasnacheev пн, 15 февр. 2021 г. в

Re: Reliably duplicate SQL cache

2021-02-15 Thread Ilya Kasnacheev
har, b varchar, c varchar, PRIMARY KEY (a, b)) WITH \"cache_name=page2, key_type=PageKey, value_type=Page\"") Regards, -- Ilya Kasnacheev сб, 13 февр. 2021 г. в 19:32, Courtney Robinson : > Due to an issue I posted about in a previous thread > http://apache-ignite-users.7051

Re: Ignite 2.9.1 - An existing connection was forcibly closed by the remote host

2021-02-15 Thread Ilya Kasnacheev
Thread.run(IgniteSpiThread.java:58) Maybe there's something in your network configuration which prevents relaying of "connection closed" packets from client to server? Can you collect thread dump from such failing client when it has already started to exhibit that behavior? Regards, -- Ilya

Re: [2.9.1] Out of memory in data region

2021-02-15 Thread Ilya Kasnacheev
Hello! I think it's quite possible to run out of off-heap if your transactions are comparable with your data region in time. Ignite needs to do page eviction to be able to reuse off-heap pages, but I guess that pages relevant to currently running transactions can't be evicted. Regards

Re: SQL queries on the Ignite cache fail, cannot find table

2021-02-15 Thread Ilya Kasnacheev
Hello! Have you tried SELECT * FROM "PersonCache".PERSON? Regards, -- Ilya Kasnacheev вс, 14 февр. 2021 г. в 01:33, PunxsutawneyPhil3 : > I am trying to configure Ignite to act as a cache with a Postgres database. > > I have started with the example on the Ignite we

Re: ContinuousQueryWithTransformer fails to deliver an update when a custom java class is being used as a transformed value

2021-02-10 Thread Ilya Kasnacheev
Hello! This does indeed look like a bug. I have filed https://issues.apache.org/jira/browse/IGNITE-14161 Regards, -- Ilya Kasnacheev ср, 10 февр. 2021 г. в 15:48, : > Hi Ilya, > > Sure, the complete code could be found here: > https://github.com/ifedorenkov-tda/ignite-expe

Re: Re[2]: Long transaction suspended

2021-02-10 Thread Ilya Kasnacheev
Hello! Unfortunately, this C++ thin client / platforms issue is not so easily fixable. Our platforms interaction does not expect buffers larger than 2G apparently. Regards, -- Ilya Kasnacheev ср, 10 февр. 2021 г. в 16:43, Zhenya Stanilovsky : > Hi ! > > > > > Hi, > >

Re: Long transaction suspended

2021-02-10 Thread Ilya Kasnacheev
Hello! RocksDB is an embedded database whereas Apache Ignite is a *distributed* database. Regards, -- Ilya Kasnacheev ср, 10 февр. 2021 г. в 16:11, jjimeno : > Hi, > > Because of the kind of product we have to develop, we currently have a set > of scenarios with this kind of tran

Re: Long transaction suspended

2021-02-10 Thread Ilya Kasnacheev
Hello! I think you need to register first. Btw, why do you need such large transactions? Have you considered data streamer instead? Regards, -- Ilya Kasnacheev ср, 10 февр. 2021 г. в 15:28, jjimeno : > I wouldn't mind, but I'm afraid I'm not allowed to... at least, I c

Re: Long transaction suspended

2021-02-10 Thread Ilya Kasnacheev
Hello! Would you care to create a JIRA ticket for that issue? https://issues.apache.org/jira/projects/IGNITE/issues Regards, -- Ilya Kasnacheev ср, 10 февр. 2021 г. в 14:18, jjimeno : > Hi, > > First off, thanks for your help. > > In the test, I'm using a single server n

Re: ContinuousQueryWithTransformer fails to deliver an update when a custom java class is being used as a transformed value

2021-02-10 Thread Ilya Kasnacheev
Hello! Can you please share the complete runnable project? In your gist, POJO classes are missing. Regards, -- Ilya Kasnacheev вт, 9 февр. 2021 г. в 13:57, : > Dear Igniters, > > I have come across a bug in ContinuousQueryWithTransformer. The thing is > that the query is failin

Re: cpu usage is %10 while running query on ignite

2021-02-10 Thread Ilya Kasnacheev
Hello! This looks like a huge query which should be optimized in parts. Please try to simplify it until it is no longer slow, then you will find the step which is not optimal. Regards, -- Ilya Kasnacheev пт, 29 янв. 2021 г. в 08:10, cihad : > thank you for quick reply > > here is

Re: Long transaction suspended

2021-02-10 Thread Ilya Kasnacheev
Hello! I can see that the only occurrence of transaction suspending in our own code is in thin client implementation. Do you happen to use thin client for this operation? Regards, -- Ilya Kasnacheev пн, 8 февр. 2021 г. в 20:32, akorensh : > I would also recommend taking a thread dump to

Re: Ignite 2.8.1 - Remote node does not observe current node in topology

2021-02-10 Thread Ilya Kasnacheev
0521-sha1:86422096, isClient=true], done=true, newCrdFut=null], topVer=AffinityTopologyVersion [topVer=500, minorTopVer=0]] I'm not sure why these nodes were not able to detect that they are no longer in the cluster. Perhaps some network issues could cause it. Normally this should not happen, client nodes

Re: Rebalancing Errors

2021-02-08 Thread Ilya Kasnacheev
Hello! Please attach the complete thread dump from the affected node, along with the node log. Regards, -- Ilya Kasnacheev пт, 5 февр. 2021 г. в 01:05, nasim mombini : > Hello Folks > > The attempts to partition rebalancing in my ignite clusters fail with the > following erro

Re: CacheJdbcBlobStoreFactory Failed to load bean in application context

2021-02-08 Thread Ilya Kasnacheev
d non-affinity nodes. Are you sure that this node fits the description? Can you share a reproducer project? Regards, -- Ilya Kasnacheev пт, 5 февр. 2021 г. в 17:16, mvolkomorov <2201...@gmail.com>: > Hello! > > Is it correct to start 2 nodes at single jvm using IgniteSpring#star

Re: Cannot create SQL index with INLINE_SIZE if ` is used

2021-02-08 Thread Ilya Kasnacheev
Hello! Please file a ticket about that, against Apache Ignite JIRA: https://issues.apache.org/jira/projects/IGNITE Parsing of INLINE_SIZE, etc, is our own addendum to H2 grammar so we could have broken something there. Regards, -- Ilya Kasnacheev сб, 6 февр. 2021 г. в 17:50, Courtney

Re: Ignite 2.8.1 - Remote node does not observe current node in topology

2021-02-05 Thread Ilya Kasnacheev
Hello! Please share a complete log from both nodes. I expect that one of the nodes were previously segmented. Regards, -- Ilya Kasnacheev пт, 5 февр. 2021 г. в 12:41, Charlin S : > Hi, > > i'm running an ASP.Net application with ignite 2.8.1 and seeing below > error details

Re: ignite common code gitflow

2021-02-05 Thread Ilya Kasnacheev
Hello! Related stackoverflow discussion: https://stackoverflow.com/q/66025789/36498 Regards, -- Ilya Kasnacheev вт, 2 февр. 2021 г. в 13:14, mvolkomorov <2201...@gmail.com>: > Hi, guys! > > I am implementing an Ignite cluster with data node, service node and spring > b

Re: Ignite thick client triggering PME in 2.8.0 ?

2021-02-05 Thread Ilya Kasnacheev
Hello! I think it will. You can probably check it - try removing these configurations, see if extra PMEs disappear. Regards, -- Ilya Kasnacheev пт, 5 февр. 2021 г. в 13:36, Shiva Kumar : > Hi Ilya, > In my case i have cache group configuration as attached in the config file > and c

Re: Ignite thick client triggering PME in 2.8.0 ?

2021-02-05 Thread Ilya Kasnacheev
Hello! Do you have any caches defined in client configuration? If you have any caches there then PME will be triggered. Regards, -- Ilya Kasnacheev чт, 4 февр. 2021 г. в 14:37, Shiva Kumar : > Even i observed the same, during thick client or visor joining cluster > looks like som

Re: Persistent atomics

2021-02-05 Thread Ilya Kasnacheev
Hello! I don't think so. Atomic types will go into the default data region. If it is persistent, then they are all persistent also. Regards, -- Ilya Kasnacheev чт, 4 февр. 2021 г. в 21:44, Kathryn Hogg : > I'm using Ignite.Net 2.9.1. > > > > Is there any way

Re: Partition Rebalancing Error

2021-02-03 Thread Ilya Kasnacheev
Hello! This will usually mean that some other operation is blocking the checkpoint. Until it finishes, and the checkpoint starts, no new operations may proceed. You need a full thread dumps to find any operations not waiting on GridCacheDatabaseSharedManager.checkpoint*Lock Regards, -- Ilya

Re: Ignite Startup Warnings

2021-02-03 Thread Ilya Kasnacheev
Hello! Yes, it would be great! Regards, -- Ilya Kasnacheev ср, 3 февр. 2021 г. в 10:22, Paolo Bazzi : > Thanks for your replies and creating the issue. > > > ilya.kasnacheev wrote > > The second one is clearly also a bug. You can sidestep it by setting log > > le

Re: Re[4]: Performance of Ignite as key-value datastore. C++ Thin Client.

2021-02-03 Thread Ilya Kasnacheev
Hello! For the curious, the ticket is https://issues.apache.org/jira/browse/IGNITE-14076 Regards, -- Ilya Kasnacheev пт, 29 янв. 2021 г. в 18:55, jjimeno : > Ok... thanks! > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >

Re: Ignite Startup Warnings

2021-02-01 Thread Ilya Kasnacheev
Hello! The second one is clearly also a bug. You can sidestep it by setting log level to INFO. Regards, -- Ilya Kasnacheev пн, 1 февр. 2021 г. в 22:44, Paolo Bazzi : > Hi all, > > I've getting a series of logger warnings when I startup an Ignite instance. > I could get rid o

Re: Query System Views Ignite 2.9.1

2021-02-01 Thread Ilya Kasnacheev
also, in the form of services, Spring beans or distributed compute. You can run compute operations on server node from the client node, for example. Regards, -- Ilya Kasnacheev сб, 30 янв. 2021 г. в 01:06, Nathan Neely : > How can I query system views from a server node? I have looked at exam

Re: Performance issues with java thin client

2021-02-01 Thread Ilya Kasnacheev
Hello! I recommend collecting thread dumps from server nodes when you see this issue, especially by simulating many new client connections at once. Then you can triage why this would happen. Regards, -- Ilya Kasnacheev пн, 1 февр. 2021 г. в 10:18, Naveen : > Not really used with any earl

Re: [2.9.1]in SYS.METRICS View some data is always 0

2021-02-01 Thread Ilya Kasnacheev
Hello! You are running SqlFieldsQuery on client node here, but you are checking metric on server. Metrics are per-node local. Regards, -- Ilya Kasnacheev пн, 1 февр. 2021 г. в 14:16, 38797715 <38797...@qq.com>: > It's amazing, let's simplify the problem. > >

Re: W3P Processor memory utilization does includes JVM heap

2021-02-01 Thread Ilya Kasnacheev
Hello! I would expect that it includes current utilization of heap and off-heap as well as all other memory occupied by the JVM and IIS internals. Regards, -- Ilya Kasnacheev пн, 1 февр. 2021 г. в 16:31, Charlin S : > Hi, > > i'm having doubts on the total memory utilisation of

Re: RAM required for apache-ignite (if persistence is enabled)

2021-02-01 Thread Ilya Kasnacheev
the specific libraries placement. Regards, -- Ilya Kasnacheev пн, 1 февр. 2021 г. в 13:35, rakshita04 : > can we enable this option via xml? > is there a C++ API to enable/disable it? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >

Re: Initial data loading from database

2021-02-01 Thread Ilya Kasnacheev
Hello! loadCache usually will only affect local partitions. There are no guarantees that entries loaded from cache store are in sync. Entries touched via Ignite APIs should be in sync. loadCache will not overwrite existing data. Regards, -- Ilya Kasnacheev пн, 1 февр. 2021 г. в 07:29, eerick

Re: RAM required for apache-ignite (if persistence is enabled)

2021-02-01 Thread Ilya Kasnacheev
Hello! It will not affect RAM usage by Ignite (but may decrease the amount of disk buffers held by the OS). It may affect performance, and is written in expectation to improve it. Regards, -- Ilya Kasnacheev пн, 1 февр. 2021 г. в 13:02, rakshita04 : > Thanks for the response. > On

Re: RAM required for apache-ignite (if persistence is enabled)

2021-02-01 Thread Ilya Kasnacheev
Hello! Please check out the following docs page: https://ignite.apache.org/docs/latest/memory-architecture https://ignite.apache.org/docs/latest/memory-configuration/data-regions Regards, -- Ilya Kasnacheev пн, 1 февр. 2021 г. в 11:34, rakshita04 : > Hi, > > We are using apache-

<    1   2   3   4   5   6   7   8   9   10   >