Re: How to change backup number after cache is created?

2020-08-07 Thread Ilya Kasnacheev
Hello! You cannot change the number of backups once the cache is created. You need to create it with correct value (maybe one that depends on the current env). Regards, -- Ilya Kasnacheev пт, 7 авг. 2020 г. в 13:04, Steven Zheng : > Hi community, > I want to know how to modify num

Re: What does all partition owners have left the grid, partition data has been lost mean?

2020-08-06 Thread Ilya Kasnacheev
Hello! You are confusing baseline with backups here. You should have 1 backup to afford losing a node. You should have all data nodes in the baseline. Regards, -- Ilya Kasnacheev ср, 5 авг. 2020 г. в 17:56, John Smith : > I mean I have 3 nodes and the baseline is set to 3. Does it mean

Re: Ignite 2.81. - NULL pointer exception

2020-08-06 Thread Ilya Kasnacheev
Hello! This seems to be an assertion failure that we did not see before. Please tell us if you see recurrence and especially if you can link it to some activity/ Regards, -- Ilya Kasnacheev ср, 5 авг. 2020 г. в 10:18, Mahesh Renduchintala < mahesh.renduchint...@aline-consulting.com>:

Re: Enabling swapPath causes invoking shutdown hook

2020-08-06 Thread Ilya Kasnacheev
Hello! I think the performance of swap space should be on par with persistence with disabled WAL. You can submit suggested updates to the documentation if you like. Regards, -- Ilya Kasnacheev ср, 5 авг. 2020 г. в 06:00, 38797715 <38797...@qq.com>: > Hi Ilya, > > If so, the

Re: IgniteTxOptimisticCheckedException

2020-08-04 Thread Ilya Kasnacheev
Hello! Optimistic transactions are supposed to be retry-able. Why won't you retry such transactions upon getting the exception? Regards, -- Ilya Kasnacheev пт, 31 июл. 2020 г. в 10:56, marble.zh...@coinflex.com < marble.zh...@coinflex.com>: > Hi Guru, > > We met below two

Re: question about collation with an ignite set

2020-08-04 Thread Ilya Kasnacheev
Hello! Why don't you set cacheMode to REPLICATED? Partitions in replicated caches should not be lost. Regards, -- Ilya Kasnacheev пн, 3 авг. 2020 г. в 08:35, scottmf : > hi, If I setup my *Ignite Set* as specified below what will happen when a > node leaves the cluster topol

Re: What does all partition owners have left the grid, partition data has been lost mean?

2020-08-04 Thread Ilya Kasnacheev
Hello! What is your baseline topology at this moment? It means just that: you have lost enough nodes of your distributed grid that data is nowhere to be found now. Regards, -- Ilya Kasnacheev пн, 3 авг. 2020 г. в 19:12, John Smith : > I get the below exception on my client... >

Re: Ignite client node hangs while IgniteAtomicLong is created

2020-08-04 Thread Ilya Kasnacheev
Hello! Can you collect thread dumps from all nodes once you get them hanging? Can you throw together a reproducer project? Regards, -- Ilya Kasnacheev вт, 4 авг. 2020 г. в 12:51, Ilya Roublev : > We are developing Jira cloud app using Apache Ignite both as data storage > and

Re: 2.8.1 - Loading Plugin Provider - Conflicting documentation

2020-08-04 Thread Ilya Kasnacheev
Hello! You do this with IgniteConfiguration.setPluginConfiguration(). Regards, -- Ilya Kasnacheev вт, 28 июл. 2020 г. в 13:04, VeenaMithare : > Okay. > > >> The recommended way is to use the service provider as detailed here: > > How do we pass configuration for

Re: [External]Re: Node left from running cluster due to org.apache.ignite.internal.processors.cache.persistence.tree.CorruptedTreeException: Runtime failure on search row

2020-08-04 Thread Ilya Kasnacheev
Hello! You can't do that in runtime, but you can certainly remove index.bin as bulk operation. Regards, -- Ilya Kasnacheev вт, 28 июл. 2020 г. в 08:48, Kamlesh Joshi : > Thanks for the update Andrei. We upgraded from 2.6.0 to 2.7.6. > > We followed the same approach and it w

Re: Enabling swapPath causes invoking shutdown hook

2020-08-04 Thread Ilya Kasnacheev
ink these are either-or. You should either do the first (and configure OS swapping) or the second part. Having said that, I recommend setting proper Native Persistence instead. Regards, -- Ilya Kasnacheev сб, 25 июл. 2020 г. в 04:49, 38797715 <38797...@qq.com>: > H

Re: Block until partition map exchange is complete

2020-08-04 Thread Ilya Kasnacheev
Hello! It is supposed to be fixed in 2.8. Did you check that? Thanks. -- Ilya Kasnacheev ср, 22 июл. 2020 г. в 12:24, ssansoy : > Hi, could the behaviour I have observed be captured by this bug: > > https://issues.apache.org/jira/browse/IGNITE-9841 > > "Note, ScanQue

Re: apache-ignite compatibility with armhf(32-bit arm linux)

2020-08-03 Thread Ilya Kasnacheev
Hello! Our DEB packages are published with "all" architecture, which means they are not bound to any specific arch. Regards, -- Ilya Kasnacheev пт, 24 июл. 2020 г. в 17:31, Stanislav Lukyanov : > It should work fine. I ran Ignite on various platforms non-Intel platforms, &g

Re: apache ignite compatibility with armhf(arm 32-bit)

2020-07-31 Thread Ilya Kasnacheev
Hello! Try it and see :) I don't see why it won't work. Maybe there will be some endianness issues, but you never know in advance. Regards, -- Ilya Kasnacheev чт, 23 июл. 2020 г. в 20:54, rakshita04 : > I need to use apache ignite for my Debian linux 32-bit version. > Is it

Re: Remote Filter Execution

2020-07-17 Thread Ilya Kasnacheev
Hello! There's nothing we can do about 2.7.x right now, I suggest upgrading to 2.8.1. Regards, -- Ilya Kasnacheev пт, 17 июл. 2020 г. в 10:06, VeenaMithare : > I can also confirm that both these issues happen consistently on 2.7.6. All > the nodes are in baseline when both t

Re: Block until partition map exchange is complete

2020-07-15 Thread Ilya Kasnacheev
is is org.apache.ignite.testframework.junits.common.GridCommonAbstractTest#awaitPartitionMapExchange(boolean, boolean, java.util.Collection, boolean, java.util.Set) Regards, -- Ilya Kasnacheev ср, 15 июл. 2020 г. в 12:03, ssansoy : > By the way, just referring back to the original question -

Re: How to get local node near cache metrics?

2020-07-15 Thread Ilya Kasnacheev
Hello! The only thing I can think of is cache.metrics().getHeapEntriesCount() Have you tried that? Regards, -- Ilya Kasnacheev вт, 14 июл. 2020 г. в 05:12, John Smith : > Hi I want to get how many entries are on the thick client's near cache. Is > there a way? >

Re: question about node segment and split brain

2020-07-15 Thread Ilya Kasnacheev
ee above. Regards, -- Ilya Kasnacheev чт, 2 июл. 2020 г. в 13:45, bbweb : > Hi, > > we are considering ignite for mission critical system and concerning > about node segmentation and split brain problem. I searched for current > documents and suggestions but still have some que

Re: Remote Filter Execution

2020-07-15 Thread Ilya Kasnacheev
on 2.7.6. Can you confirm or deny that it works on 2.8.1 for you? Are you sure that all nodes are in the baseline? Regards, -- Ilya Kasnacheev ср, 15 июл. 2020 г. в 13:55, VeenaMithare : > Hi Ilya, > > Please find the reproducer project with a readme.txt. > > I have put in comm

Re: First 10 long running cache futures [total=1]

2020-07-15 Thread Ilya Kasnacheev
Hello! The printed cache future contains some of this information, but it's hard to decipher. In this case, you are waiting for a node 1e36906c-fae5-49a3-b67a-9eed6ada7e4e. It will make sense to check its thread dump. Regards, -- Ilya Kasnacheev вт, 14 июл. 2020 г. в 05:59, marb

Re: DataRegion sysMemPlc, TxLog

2020-07-15 Thread Ilya Kasnacheev
Hello! sysMemPlc is used to hold ignite-sys-cache and TxLog to hold SQL MVCC information. You may skip monitoring these. Regards, -- Ilya Kasnacheev ср, 15 июл. 2020 г. в 09:02, kay : > Hello > > We found sysMempPlc and Txlog DataRegion. What is each role? > Do I have to moni

Re: First 10 long running cache futures [total=1]

2020-07-13 Thread Ilya Kasnacheev
Hello! This means a cache operation takes longer to complete than usual, mostly due to locking, node network unavailability, checkpoint, etc... Regards, -- Ilya Kasnacheev пн, 13 июл. 2020 г. в 09:20, marble.zh...@coinflex.com < marble.zh...@coinflex.com>: > Hi Guru, > > we m

Re: [External]Re: Ignite cluster became unresponsive

2020-07-13 Thread Ilya Kasnacheev
Hello! I recommend setting it somewhat lower, but longer than any of your expected GC pauses. 30s is OK. Regards, -- Ilya Kasnacheev вс, 12 июл. 2020 г. в 14:03, Kamlesh Joshi : > Thanks for the findings Ilya. > > > > So shall we set the same timeout value for *socketWriteT

Re: Remote Filter Execution

2020-07-13 Thread Ilya Kasnacheev
Hello! Maybe there's something with your filter implementation which prevents it from functioning. Can you throw together a small reproducer project to show this behavior? Regards, -- Ilya Kasnacheev пт, 10 июл. 2020 г. в 19:35, VeenaMithare : > Hi Ilya, > > Yes, So filter ge

Re: DataStreamer. allowOverwrite(false) - Will it slow the writes?

2020-07-13 Thread Ilya Kasnacheev
Hello! With persistence, you will probably burn through the burst time (in-memory no-checkpoint) faster and hit the "slow" persistent epoch earlier. Then you will need to tune your persistence. Please see https://apacheignite.readme.io/docs/durable-memory-tuning Regards, -- Ilya

Re: Using SORT BY and ORDER BY

2020-07-13 Thread Ilya Kasnacheev
Hello! By putting your affinity column in the public key of all tables and issuing WITH "affinity_key=" clause when creating table. Please also see https://apacheignite.readme.io/docs/affinity-collocation Regards, -- Ilya Kasnacheev пт, 10 июл. 2020 г. в 18:32, Surkov.Aleksandr :

Re: Using SORT BY and ORDER BY

2020-07-10 Thread Ilya Kasnacheev
Hello! 1. I guess it is a honest mistake. 2. The idea here is that you can't expect that GROUP BY COL will return anything relevant, if the table is not collocated by COL. Regards, -- Ilya Kasnacheev пт, 10 июл. 2020 г. в 17:34, Surkov.Aleksandr :

Re: Remote Filter Execution

2020-07-10 Thread Ilya Kasnacheev
com.COMPANYNAME.prophet.configstore.common.remote.ConfigStoreTableRemoteFilterFactory [] - projectname LISTENS: Filter created with andPredicateMap{NAME=(EQUAL,CENTRE)},orPredicateMapnull, Remotefilterfactory:com.COMPANYNAME.prophet.configstore.common.remote.ConfigStoreTableRemoteFilterFactory@14bf552f, Is it relevant? Regards, -- Ilya Kasnacheev пт, 10 июл

Re: [External]Re: Ignite cluster became unresponsive

2020-07-10 Thread Ilya Kasnacheev
ndMessage0(TcpCommunicationSpi.java:2713) at o.a.i.spi.communication.tcp.TcpCommunicationSpi.sendMessage(TcpCommunicationSpi.java:2672) Regards, -- Ilya Kasnacheev пт, 10 июл. 2020 г. в 16:32, Kamlesh Joshi : > Hi Ilya, > > > > PFA the entire node logs, which contains thread dump as w

Re: Ignite Backup and Restore

2020-07-10 Thread Ilya Kasnacheev
Hello! I guess that Apache Ignite 2.9 will have snapshotting capabilities. Traditionally we rely more on backup nodes/partitions than on off-line backups. Regards, -- Ilya Kasnacheev ср, 8 июл. 2020 г. в 12:23, marble.zh...@coinflex.com < marble.zh...@coinflex.com>: > Hi, any su

Re: ignite 2.8.1: Failed to resolve node topology

2020-07-10 Thread Ilya Kasnacheev
Hello! It seems that the node fell behind in switching to new topology. Can you provide full log of this node? I guess that something was blocking PME. Regards, -- Ilya Kasnacheev чт, 9 июл. 2020 г. в 09:44, Mahesh Renduchintala < mahesh.renduchint...@aline-consulting.com>: > H

Re: [External]Re: Ignite cluster became unresponsive

2020-07-10 Thread Ilya Kasnacheev
Hello! Can you provide full thread dump (jstack) after you see these messages? Regards, -- Ilya Kasnacheev ср, 8 июл. 2020 г. в 15:57, Kamlesh Joshi : > Hi Stephen/Team, > > > > Did you got any chance to look into this? > > > > *Thanks and Regards,* > &

Re: Block until partition map exchange is complete

2020-07-10 Thread Ilya Kasnacheev
Hello! Can you throw together a reproducer project which shows this behavior? I would check. Regards, -- Ilya Kasnacheev пт, 3 июл. 2020 г. в 13:14, ssansoy : > Thanks - the issue I have now is how can I confirm that the local listen > has > returned before executing my code? >

Re: Ignite server of perNodeParallelOperatoins ?

2020-07-10 Thread Ilya Kasnacheev
Hello! Yes, there is Data Streamer Thread Pool Size on server, which corresponds to perNodeParallelOperations. Server will not run more parallel operations than thread pool size. Regards, -- Ilya Kasnacheev вт, 7 июл. 2020 г. в 23:18, Edward Chen : > Hello, > > In IgniteDataStream

Re: enum behavior in REST

2020-07-10 Thread Ilya Kasnacheev
Hello! Can you provide an example of REST response? I don't understand how this issue manifests. Regards, -- Ilya Kasnacheev ср, 8 июл. 2020 г. в 01:25, Maxim Volkomorov <2201...@gmail.com>: > I have "type":{"platformType":false}" in REST response fo

Re: DataStreamer. allowOverwrite(false) - Will it slow the writes?

2020-07-10 Thread Ilya Kasnacheev
Hello! I don't think so. It is supposed to speed it up. Do you have persistence? With persistence, you would expect a slow-down after an initial spike. Regards, -- Ilya Kasnacheev пт, 10 июл. 2020 г. в 15:09, krkumar24061...@gmail.com < krkumar24061...@gmail.com>: > Hi Guys

Re: Ignite node top ram limit

2020-07-10 Thread Ilya Kasnacheev
Hello! I don't think there is any, if we are talking of off-heap size. Any problems in case of node failure are shared by persistent clusters which have more data than RAM. Regards, -- Ilya Kasnacheev ср, 8 июл. 2020 г. в 18:01, Maxim Volkomorov <2201...@gmail.com>: > Is the

Re: Request among nodes taking minimum of idleConnectionTimeout configuration in tcpcommunicationSpi

2020-07-10 Thread Ilya Kasnacheev
Hello! Maybe you have some firewall issue here, such as only one way connections are possible but not the other way around. We do not recommend geo-distributed clustering with Apache Ignite. Regards, -- Ilya Kasnacheev вт, 7 июл. 2020 г. в 06:59, trans : > Hi, can someone please suggest

Re: Destroying a ignite cache when one of the worker nodes is down

2020-07-10 Thread Ilya Kasnacheev
Hello! As far as I know, there is no such way yet. Regards, -- Ilya Kasnacheev чт, 9 июл. 2020 г. в 17:22, krkumar24061...@gmail.com < krkumar24061...@gmail.com>: > Hi Guys - I have a five node cluster and all the nodes are part of the > baseline. Ignite native persistence is ena

Re: Remote Filter Execution

2020-07-10 Thread Ilya Kasnacheev
Hello! This is weird, I recommend checking logs for exceptions, maybe the filter cannot run on two other server nodes. Regards, -- Ilya Kasnacheev пт, 10 июл. 2020 г. в 10:25, VeenaMithare : > Hello, > > We have a 3 server cluster . The Caches on this cluster are configured as >

Re: Equivalent Open Source Ignite Version to Gridgain Version

2020-07-06 Thread Ilya Kasnacheev
Hello! We can only recommend to use the latest release of Apache Ignite, which is currently 2.8.1. Regards, -- Ilya Kasnacheev пн, 6 июл. 2020 г. в 07:48, Ishan Gandhi : > Considering migrating from Gridgain Ignite version 8.5.8 or 8.7.13, So what > are the equivalent Apache Ignite ve

Re: ScanQuery Transform: fail to deserialze! ignite 2.8.0, java 11

2020-07-03 Thread Ilya Kasnacheev
Hello! There is now a ticket about this issue, which I indeed can see: https://issues.apache.org/jira/browse/IGNITE-13212 While it is not fixed, you will have to make sure that filter code is deployed to all nodes. Regards, -- Ilya Kasnacheev пт, 3 июл. 2020 г. в 15:50, Rafael Troilo

Re: Block until partition map exchange is complete

2020-07-03 Thread Ilya Kasnacheev
Hello! Yes, you need to return from event listener as soon as you can. Regards, -- Ilya Kasnacheev пт, 3 июл. 2020 г. в 12:03, ssansoy : > Hi Ilya, thanks for the quick help! > Within the local listen, I am adding a task to an executor - so the cache > operations happen in a differe

Re: Block until partition map exchange is complete

2020-07-03 Thread Ilya Kasnacheev
run when rebalance already takes place. Regards, -- Ilya Kasnacheev пт, 3 июл. 2020 г. в 11:17, ssansoy : > Hi Ignite users, > > I have 3 nodes running, with a cache with the following configuration: > > cacheConfiguration.setCacheMode(CacheMode.PARTITIONED); > cacheConfigur

Re: KafkaStream marshaller error

2020-07-02 Thread Ilya Kasnacheev
Hello! init() will be called before execute() and stop(). To be extra sure, you can check for null. Regards, -- Ilya Kasnacheev чт, 2 июл. 2020 г. в 19:06, Maxim Volkomorov <2201...@gmail.com>: > Ok, if i put an assignment to init(), how will i start it in execute() > method,

Re: KafkaStream marshaller error

2020-07-02 Thread Ilya Kasnacheev
Hello! You should do the assignment in init() method. Don't create KafkaStreamer before service is sent over and is ready for initialization. Regards, -- Ilya Kasnacheev чт, 2 июл. 2020 г. в 18:54, Maxim Volkomorov <2201...@gmail.com>: > public class KafkaStreamerService impl

Re: KafkaStream marshaller error

2020-07-02 Thread Ilya Kasnacheev
Hello! Where do you assign kafkaStreamer field? Regards, -- Ilya Kasnacheev чт, 2 июл. 2020 г. в 18:46, Maxim Volkomorov <2201...@gmail.com>: > Now i disabled node Filtering. You mean i started KafkaStreamer in > init()? > I started KafkaStreamer like: > > @Overr

Re: ScanQuery Transform: fail to deserialze! ignite 2.8.0, java 11

2020-07-02 Thread Ilya Kasnacheev
Hello! I would like to start with a reproducer. Rafael, can you please throw together a runnable stand-alone reproducer of this issue? Thanks, -- Ilya Kasnacheev чт, 2 июл. 2020 г. в 17:28, Denis Magda : > Ilya, > > Yes, Rafael confirmed that the peer-class-loading is set. > >

Re: KafkaStream marshaller error

2020-07-02 Thread Ilya Kasnacheev
Hello! You should probably start KafkaStreamer on remote node when the service is initialized (init()), instead of starting it in e.g. constructor and trying to send it to remote node. Avoid putting fat instances in the fields of service/compute/predicate classes. Regards, -- Ilya Kasnacheev

Re: CusterGroup topology unexpectedly empty

2020-07-02 Thread Ilya Kasnacheev
refresh it. Please check https://issues.apache.org/jira/browse/IGNITE-13050 Regards, -- Ilya Kasnacheev ср, 1 июл. 2020 г. в 11:26, Raymond Wilson : > I've been researching a problem where we see a ClusterGroup topology > becoming unexpectedly empty. I have not found anything that is

Re: Re:

2020-07-02 Thread Ilya Kasnacheev
Hello! I've never seen this issue so I don't know. I would really appreciate a reproducer. Regards, -- Ilya Kasnacheev ср, 1 июл. 2020 г. в 08:16, BEELA GAYATRI : > > > Hi Kasnacheev, > > > >The below behavior is occurring randomly after stopping the no

Re: Ignite node log file setup

2020-07-02 Thread Ilya Kasnacheev
Hello! """ In Spring syntax it will be #{systemProperties['gridName']}: """ Regards, -- Ilya Kasnacheev ср, 1 июл. 2020 г. в 12:01, kay : > Hello, I'm waiting for reply :) > > How can I set system property to use in ignite config file??

Re: ScanQuery Transform: fail to deserialze! ignite 2.8.0, java 11

2020-07-02 Thread Ilya Kasnacheev
Hello! Did you enable peer class loading? You need to either enable peer class loading, or put your filter class(es) to all server nodes. Regards, -- Ilya Kasnacheev чт, 2 июл. 2020 г. в 15:09, Rafael Troilo : > Hi Denis, > > thank you for your quick response. Unfortunately even

Re: Hot service upgrade without downtime

2020-07-02 Thread Ilya Kasnacheev
Hello! I don't see why you can't start the new service under new name, and then stop the old service when new service is already available. Regards, -- Ilya Kasnacheev чт, 2 июл. 2020 г. в 16:35, Sergey Antonov : > Hi, Aravind. > > > > Thank you for reply! I don’t

Re: Question on Key choice for an Ignite cache

2020-06-30 Thread Ilya Kasnacheev
Hello! You can also use Binary Object (POJO) as a key, i.e., you can use an Object with String email and String phone fields. I don't recommend mangling strings further than concatenation. String key is no worse than numeric key. Regards, -- Ilya Kasnacheev вт, 30 июн. 2020 г. в

Re: How to do address resolution?

2020-06-30 Thread Ilya Kasnacheev
d it fails because the network connection is filtered out. Regards, -- Ilya Kasnacheev пн, 29 июн. 2020 г. в 23:47, John Smith : > Ok. > > I am able to reproduce the "issue" unless we have a misunderstanding and > we are talking about the same thing... > > My thick

Re: Ignite Configuration file modify

2020-06-30 Thread Ilya Kasnacheev
Hello! You can implement this yourself if you really need it. Such as, you can watch an XML file, when it changes, do Ignition.loadSpringBin(file, bean name), and then call ignite.getOrCreateCache() on all cache configurations found in that bean. Regards. -- Ilya Kasnacheev вт, 30 июн. 2020

Re: How to do address resolution?

2020-06-29 Thread Ilya Kasnacheev
Hello! The easiest way is jstack Regards, -- Ilya Kasnacheev пн, 29 июн. 2020 г. в 20:20, John Smith : > How? > > On Mon, 29 Jun 2020 at 12:03, Ilya Kasnacheev > wrote: > >> Hello! >> >> Try collecting thread dump from Visor as it freezes. >&g

Re: How to do address resolution?

2020-06-29 Thread Ilya Kasnacheev
Hello! Try collecting thread dump from Visor as it freezes. Regards, -- Ilya Kasnacheev пн, 29 июн. 2020 г. в 18:11, John Smith : > How though? > > 1- Entered node command > 2- Got list of nodes, including thick clients > 3- Selected thick client > 4- Entered Y for detai

Re: How to do address resolution?

2020-06-29 Thread Ilya Kasnacheev
Hello! This usually means there's no connectivity between node and Visor. Regards, -- Ilya Kasnacheev пн, 29 июн. 2020 г. в 17:01, John Smith : > Also I think for Visor as well? > > When I do top or node commands, I can see the thick client. But when I > look at detailed st

Re: WriteBehind enabled problem FK constraint

2020-06-29 Thread Ilya Kasnacheev
Hello! I recommend disabling FKs for tables which are written by Cache Store. Regards, -- Ilya Kasnacheev пн, 29 июн. 2020 г. в 16:01, manueltg89 : > Hello! > > With writeBehind enabled I get many more errors that with writeBehind > disabled. What write state do you recommended

Re: WriteBehind enabled problem FK constraint

2020-06-29 Thread Ilya Kasnacheev
it may maintain its own ordering between different caches. Regards, -- Ilya Kasnacheev сб, 27 июн. 2020 г. в 18:59, manueltg89 : > Hello. > > In my app I have writeBehind to true, when I start to write in my Apache > Ignite instance sometimes throw an error with FK, is there anyw

Re: How to do address resolution?

2020-06-29 Thread Ilya Kasnacheev
Hello! For thick clients, you need both 47100 and 47500, both directions (perhaps for 47500 only client -> server is sufficient, but for 47100, both are needed). For thin clients, 10800 is enough. For control.sh, 11211. Regards, -- Ilya Kasnacheev пт, 26 июн. 2020 г. в 22:06, John Sm

Re: Non Distributed Join between tables

2020-06-26 Thread Ilya Kasnacheev
Hello! If both tbl_a and tbl_c use tbl_b.id == tbl_a.fk_id == tbl_c.fk_id as affinity key, then I assume it would. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 19:17, manueltg89 : > With the following structure, and partitioned cache in the three tables: > > tbl_a tbl_b

Re: Ignite authenticationEnabled queries

2020-06-26 Thread Ilya Kasnacheev
Hello! Make sure user's login is "in quotes", otherwise it will be case-insensitive, i.e. ALLCAPS login. Regards, -- Ilya Kasnacheev пт, 26 июн. 2020 г. в 05:02, marble.zh...@coinflex.com < marble.zh...@coinflex.com>: > thanks a lot, with statement works. > >

Re: Unsubscribe

2020-06-26 Thread Ilya Kasnacheev
Hello! Please write to user-unsubscr...@ignite.apache.org, etc, to unsubscribe from lists. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 22:16, Sriveena Mattaparthi < sriveena.mattapar...@ekaplus.com>: > > “Confidentiality Notice: The contents of this email message and any &

Re: Ignite-cassandra with protobuf

2020-06-26 Thread Ilya Kasnacheev
Hello! You can put protobuf values as byte[] into our cache. SQL will not be able to index these. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 22:17, abhi2703 : > Hi All, > > I want to use protobuf end to end.. Java -> Ignite -> Cassandra. > > Is it poss

Re: CacheVersionIO.read and AbstractDataPageIO.readPayload are hot methods

2020-06-26 Thread Ilya Kasnacheev
Hello! In Apache Ignite, data is held in Durable Memory regardless whether you have persistence enabled or not. https://apacheignite.readme.io/docs/durable-memory-tuning I guess these classes are in the 'persistence' package for historical reasons. Regards, -- Ilya Kasnacheev

Re:

2020-06-25 Thread Ilya Kasnacheev
Hello! This looks like a known issue: https://issues.apache.org/jira/browse/IGNITE-12850 Do you have a reproducer for this behavior? Regards, -- Ilya Kasnacheev пн, 15 июн. 2020 г. в 10:49, BEELA GAYATRI : > > > Hi Team, > > > > I am running 3 server nodes by setting

Re: Non Distributed Join between tables

2020-06-25 Thread Ilya Kasnacheev
Hello! This seems to be a MySQL script. Can you please provide an Ignite SQL script to demonstrate the issue? Thanks, -- Ilya Kasnacheev пт, 19 июн. 2020 г. в 16:35, manueltg89 : > I attach required file SQL. dbaffinity.sql > <http://apache-ignite-users.70518.x6.nabble.com/f

Re: Ignite authenticationEnabled queries

2020-06-25 Thread Ilya Kasnacheev
Hello! I have filed a ticket about this mismatch: https://issues.apache.org/jira/browse/IGNITE-13184 Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 13:48, Ilya Kasnacheev : > Hello! > > I'm sorry for earlier advice, the correct syntax is: > ALTER USER "ignite&q

Re: Ignite authenticationEnabled queries

2020-06-25 Thread Ilya Kasnacheev
Hello! I'm sorry for earlier advice, the correct syntax is: ALTER USER "ignite" WITH PASSWORD 'abcdefg' ; Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 13:10, marble.zh...@coinflex.com < marble.zh...@coinflex.com>: > not works, still show error, &g

Re: Unsubscribe

2020-06-25 Thread Ilya Kasnacheev
Hello! Please write to user-unsubscr...@ignite.apache.org, etc, to unsubscribe from lists. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 13:20, preeti nidgunde : > Unsubscribe . >

Re: Ignite Load Performance when memory exhausted

2020-06-25 Thread Ilya Kasnacheev
https://apacheignite.readme.io/docs/durable-memory-tuning Regards, -- Ilya Kasnacheev вт, 23 июн. 2020 г. в 18:25, njcstreet : > Hi, > > I am evaluating Apache Ignite for a use case where I know we may not have > enough RAM to store the entire database. For example we might store 30 days &g

Re: Ignite authenticationEnabled queries

2020-06-25 Thread Ilya Kasnacheev
Hello! Try ALTER USER "ignite" SET PASSWORD 'NewPassword'. WRT grants, we do not have granular object in JDBC authentication currently, except by using a 3rd party security plugin. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 06:11, marble.zh...@coinflex.com < ma

Re: Can not finish proxy initialization in logs

2020-06-25 Thread Ilya Kasnacheev
Hello! This is INFO level, meaning, there's nothing for you to worry about (probably). If you dropped a cache and client node rejoins cluster, you will see this message. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 10:36, itsmeravikiran.c : > Hi Team, > > Recently i

Re: Ignite Cache exists but table lost

2020-06-25 Thread Ilya Kasnacheev
Hello! Can you perhaps provide some logs or error messages? It's hard to say what happens here, it's unexpected. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 11:26, marble.zh...@coinflex.com < marble.zh...@coinflex.com>: > Hi Guru, > > We found a problem that,

Re: Setting Cache Size using Max Records

2020-06-25 Thread Ilya Kasnacheev
Hello! You can have a data region configured for this specific cache, with max size (in bytes) and page eviction on. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 07:16, Victor : > Hi Denis, > > For our product we are using an in-house solution where we expose the size > in

Re: Respective XML Configuration for @QueryTextField in ignite-default.xml

2020-06-23 Thread Ilya Kasnacheev
Hello! I think in your QueryEntity you need to declare an index of type QueryIndexType.FULLTEXT. Regards, -- Ilya Kasnacheev вт, 23 июн. 2020 г. в 19:35, ram.gaurav.chhabra < ram.gaurav.chha...@gmail.com>: > Hello All, > > Currently working on one module which is using Apache

Re: Problem with writeBehind Apache Ignite 2.8.1

2020-06-19 Thread Ilya Kasnacheev
Hello! I think there is indeed a problem with Cache Store here: https://issues.apache.org/jira/browse/IGNITE-13167 I hope it will get fixed, until it isn't I recommend switching that cache to ATOMIC mode, this will help sidestep the issue. Regards, -- Ilya Kasnacheev пт, 19 июн. 2020 г.

Re: Non Distributed Join between tables

2020-06-19 Thread Ilya Kasnacheev
Hello! Do you have a SQL script to reproduce this issue? Regards, -- Ilya Kasnacheev пт, 12 июн. 2020 г. в 09:48, manueltg89 : > I'm going to explain a bit more. I use Apache Ignite as front cache to my > RDBMS, I've done automatic RDBMS integration. Table A, Table B, Table

Re: NPE during printing failure information

2020-06-19 Thread Ilya Kasnacheev
Hello! I suggest filing an issue against Apache Ignite JIRA. Ticket which added this line is IGNITE-11750 Regards, -- Ilya Kasnacheev сб, 13 июн. 2020 г. в 01:37, Andrey Davydov : > Yes, I think that initial problem was with communication and it need to be > tested more on my sid

Re: Problem with writeBehind Apache Ignite 2.8.1

2020-06-19 Thread Ilya Kasnacheev
Hello! What do I need to run to observe the problem? I run ServerNodeCodeStartup but it runs OK. If there should be any images in your message, they're not there. Regards, -- Ilya Kasnacheev пт, 19 июн. 2020 г. в 11:12, manueltg89 : > Hi. I attach example project. I explain a

Re: Data Consistency Question

2020-06-19 Thread Ilya Kasnacheev
Hello! I'm not sure what you are trying to do and why you felt the need to over-complicate the solution. Regards, -- Ilya Kasnacheev пн, 15 июн. 2020 г. в 09:10, adipro : > Can you please suggest an efficient solution? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >

Re: IgniteCheckedException

2020-06-19 Thread Ilya Kasnacheev
Hello! Such spring XML config cannot be started by ignite.sh, it should be started as part of a Spring application. Regards. -- Ilya Kasnacheev вт, 16 июн. 2020 г. в 10:43, kay bae : > Hello, I start node using command > > ' sh ignite.sh ./config/config.xml & ' >

Re: primary keys

2020-06-19 Thread Ilya Kasnacheev
Hello! It seems that the index is not used. Please try creating an explicit index over these 3 fields. Regards, -- Ilya Kasnacheev пт, 19 июн. 2020 г. в 00:38, narges saleh : > Hello Ilya, > Here is the info. In this query only one table is involved. > There are about 4M records in

Re: 2.7.6 to 2.8.1 migration issue

2020-06-18 Thread Ilya Kasnacheev
new cache in a new group, then delete the old conflicting cache. Regards, -- Ilya Kasnacheev чт, 18 июн. 2020 г. в 18:47, Andrey Davydov : > > > Hello, > > > > We test migration from 2.7.6 to 2.8.1 in our DEV environment and got > problem: new code doesn’t start o

Re: primary keys

2020-06-18 Thread Ilya Kasnacheev
Hello! Please show DML for your tables as well as query plans. Regards, -- Ilya Kasnacheev чт, 18 июн. 2020 г. в 16:11, narges saleh : > Thanks Ilya. > Now I can see the complete plan, and it shows scanning the large tables > (but not the others). Increasing index size didn't

Re: Achieve uniform data distribution easily

2020-06-18 Thread Ilya Kasnacheev
Hello! Data distribution will only be uniform if affinity key distribution is uniform, and may still go +/- 10% between nodes. Regards, -- Ilya Kasnacheev чт, 18 июн. 2020 г. в 09:41, VincentCE : > Thank you for your answer. We are aware of that our approach is not the > clean > o

Re:

2020-06-18 Thread Ilya Kasnacheev
Hello! I do not recommend relying on this order. It may change if you have more than one node. It can also change without warning. Regards, -- Ilya Kasnacheev пт, 12 июн. 2020 г. в 21:44, Prasad Bhalerao : > I am executing following SQL in ignite. As you can see there is no order > by

Re: ignite web agent issue

2020-06-18 Thread Ilya Kasnacheev
Hello! I have 3.6.3 installed. Regards, -- Ilya Kasnacheev пт, 12 июн. 2020 г. в 09:40, itsmeravikiran.c : > Could you please let me know, what is the supported mongodb version. > Please let me know the mongodb version, which your using. > > > > -- > Sent from: http:

Re: primary keys

2020-06-18 Thread Ilya Kasnacheev
versions may not be able to search by its fields. Regards, -- Ilya Kasnacheev чт, 18 июн. 2020 г. в 13:13, narges saleh : > Hi All, > > Shouldn't primary keys result in indexes and if so, shouldn't I be able to > see them when I list indexes? > Does inline index size appli

Re: HashMap warning when using PutAll()

2020-06-18 Thread Ilya Kasnacheev
Hello! If your Map is a singleton (only one pair) the warning should not be printed :) Regards, -- Ilya Kasnacheev ср, 17 июн. 2020 г. в 23:22, Raymond Wilson : > Hi Ilya, > > Thank you for the SortedDictionary pointer. > > I am not sure what you mean by 'size-1 colle

Re: HashMap warning when using PutAll()

2020-06-17 Thread Ilya Kasnacheev
Hello! The warning should not be issued for size-1 collections. In dotnet, you should use SortedDictionary with putAll. Regards, -- Ilya Kasnacheev сб, 13 июн. 2020 г. в 09:43, Raymond Wilson : > If the answer is that the consumer of the C# client should order the items > before c

Re: ignite work dir

2020-06-16 Thread Ilya Kasnacheev
Hello! Try setting IgniteConfiguration.workDirectory to some writable path. Regards, -- Ilya Kasnacheev чт, 11 июн. 2020 г. в 18:58, narges saleh : > Hi Ilya, > IGNITE_HOME is /opt/ignite and in ignite-log4j, the log file set to > > I don't have any issue on the server

Re: Apache Ignite with Spring framework

2020-06-16 Thread Ilya Kasnacheev
local compute tasks, etc. Regards, -- Ilya Kasnacheev вт, 16 июн. 2020 г. в 16:11, kay : > Hello, > > Does the Apache Ignite operate on a spring framework basis? > > Can I register a spring controller in classpath at server remote node and > use it? > (using component s

Re: ignite work dir

2020-06-11 Thread Ilya Kasnacheev
, -- Ilya Kasnacheev чт, 11 июн. 2020 г. в 17:55, narges saleh : > Hi All, > > What's the best way to set ignite's work dir on the client side, > considering that the client and server nodes run under different users. > I am setting both IGNITE_HOME and IGNITE_WORK_DIR syst

Re: Need to sync two apache ignite cache DB using ip address

2020-06-11 Thread Ilya Kasnacheev
Hello! Yes, you should specify both local and remote addresses in discovery SPI section: https://apacheignite.readme.io/docs/tcpip-discovery#static-ip-finder Regards, -- Ilya Kasnacheev чт, 11 июн. 2020 г. в 15:07, rakshita04 : > So are you saying apache ignite automatically does that. &

Re: Need to sync two apache ignite cache DB using ip address

2020-06-11 Thread Ilya Kasnacheev
Hello! There are ways to do that (affinity backup filter), but why would you want to? You are much better off relying on Ignite's data model when using Apache Ignite. Regards, -- Ilya Kasnacheev чт, 11 июн. 2020 г. в 15:02, rakshita04 : > Hi Ilya, > > I want one node to be

Re: Need to sync two apache ignite cache DB using ip address

2020-06-11 Thread Ilya Kasnacheev
Hello! If you declare your caches as REPLICATED they will be kept in sync. One node will be master of half entries and the other will be master of the remaining half. Regards, -- Ilya Kasnacheev чт, 11 июн. 2020 г. в 14:36, rakshita04 : > Hi Team, > > We have 2 apache ignite DBs l

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