Re: How to prevent Ignite downtime when adding tables & caches

2020-02-21 Thread akorensh
Yes, Tables created dynamically in caches that use a persistent data region will be stored to disk. You can try by enabling persistence for the default data region. Create a test table, populate w/data, shutdown ignite then restart, data should be there. Thanks, Alex -- Sent

Re: How to prevent Ignite downtime when adding tables & caches

2020-02-21 Thread Devin Bost
We're using native persistence for each of them. Does dynamic cache creation work for tables? Is it possible to create tables dynamically that have persistence? Devin G. Bost On Wed, Feb 19, 2020 at 11:16 AM akurbanov wrote: > Hello, > > There is no need to restart the cluster if you want to

Re: How to access IGFS file written one node from other node in cluster ??

2020-02-21 Thread Preetiiii
Then how to create shared file system or is there any way to access/modify file written by one node in cluster by other node ?? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite yarn resources keep on increasing

2020-02-21 Thread ChandanS
The problem is I am not able to kill my ignite yarn application even though exception has been thrown while starting the ignite and the resources of the ignite-yarn spark job keeps piling up. Please find attached image of spark web-ui. From my "StartStandalone" spark application I use to submit

Re: Connection reset by peer

2020-02-21 Thread Ilya Kasnacheev
Hello! [01:07:25,966][WARNING][tcp-comm-worker-#1%SubScriptionCluster%][TcpCommunicationSpi] Connect timed out (consider increasing 'failureDetectionTimeout' configuration property) [addr=/172.16.99.27:47100, failureDetectionTimeout=10] Failed to send message (node may have left the grid or

Re: Null Pointer Error in GridDhtPartitionsExchangeFuture

2020-02-21 Thread Ilya Kasnacheev
Hello! I have no idea, I recommend collecting a heap dump and analyzing it to locate any leaks. I think that something would indeed happen at the cluster in that time. Regards, -- Ilya Kasnacheev пт, 21 февр. 2020 г. в 06:07, wentat : > Hi Ilya, > > at the time of running the experiments in

Re: Long running query

2020-02-21 Thread Ilya Kasnacheev
Hello! Our current optimizer is not very smart. If you found an USE INDEX which allows your query to run sufficiently fast, my recommendation is to just use it. Regards, -- Ilya Kasnacheev пт, 21 февр. 2020 г. в 14:45, breathem : > Hello, > We have two tables LD (8 000 000 rows) and DRUGS

Re: How to access IGFS file written one node from other node in cluster ??

2020-02-21 Thread Ilya Kasnacheev
Hello! We do not recommend developing new IGFS applications because we are removing this feature. Regards, -- Ilya Kasnacheev пт, 21 февр. 2020 г. в 09:28, Preeti Nidgunde : > I have written IGFS java application. I want to write shared file such > that > if I write file from one node then

Re: Is Apache ignite support tiering or it only support caching??

2020-02-21 Thread Ilya Kasnacheev
Hello! Ignite has optional on-heap tier and also optional disk tier (Native Persistence will offload data there as RAM is exhausted). I wonder if that's enough for your use case. Regards, -- Ilya Kasnacheev пт, 21 февр. 2020 г. в 15:21, Preet : > I want to different tier like DRAM,

Re: REST API requests hang with no response

2020-02-21 Thread Devin Anderson
Hi Ilya, Thank you very much.  I suspect (1) is the missing piece of information I was looking for.  I'll add it when I get a chance and will report back. Thanks again, Devin On 2/21/20 4:24 AM, Ilya Kasnacheev wrote: Hello! I'll start in the reverse order: 3. If everything is OK, the

Re: C++ Node doesnot shut down

2020-02-21 Thread Ilya Kasnacheev
Hello! Can you collect stack traces (both JVM with jstack and C with gdb, if possible)? Regards, -- Ilya Kasnacheev пт, 21 февр. 2020 г. в 14:55, F.D. : > Hi igniters, > I'm using a client node in C++ to lanch several compute on a cluster, and > it's working quite well, but when I try to

Re: REST API requests hang with no response

2020-02-21 Thread Ilya Kasnacheev
Hello! I'll start in the reverse order: 3. If everything is OK, the process should take around a second (for non-persistent cluster). 2. As soon you see "Topology snapshot" in the log, the process is complete. 1. From your configuration I see suspicious that it only lists two other nodes and not

Re: Is Apache ignite support tiering or it only support caching??

2020-02-21 Thread Preetiiii
I want to different tier like DRAM, available devices as a tier. How to specify such tier option. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

C++ Node doesnot shut down

2020-02-21 Thread F.D.
Hi igniters, I'm using a client node in C++ to lanch several compute on a cluster, and it's working quite well, but when I try to close the node with every king of Ignition::Stop/StopAll(true/false), my client remain freezed. I'm using the 2.7.6. Do you have any suggestions? Thanks, F.D.

Re: REST API requests hang with no response

2020-02-21 Thread Devin Anderson
Hi Ilya, That certainly makes sense, but I'm not totally sure how to act on that information yet.  A couple questions: 1.) Given the configuration file I posted (which is basically the same on each node in the cluster, save that the IP addresses of the nodes to discover are different),

Long running query

2020-02-21 Thread breathem
Hello, We have two tables LD (8 000 000 rows) and DRUGS (130 000 rows). Following query is executed ~7 minutes that is significantly longer then in RDBMS (~1,5 sec): select d.drug_id, d.drug_name, ld.price from drugs d left outer join ld on d.drug_id = ld.drug_id and ld.org_id = 264; Explain for

Re: ERROR: h2 Unsupported connection setting "MULTI_THREADED"

2020-02-21 Thread Ilya Kasnacheev
Hello! I've heard about issues with e.g. Spring Boot overriding h2 database version and breaking our runtime. I'm not sure who else does that. Regards, -- Ilya Kasnacheev чт, 20 февр. 2020 г. в 19:24, Andrew Munn : > Thanks. Adding this runtime

Re: REST API requests hang with no response

2020-02-21 Thread Ilya Kasnacheev
Hello! Your node has never finished joining to cluster nor was able to self-discover to form a cluster of its own, as evident by: "main" #1 prio=5 os_prio=0 tid=0x7f7e8000d000 nid=0x5fed waiting on condition [0x7f7e8875f000] java.lang.Thread.State: TIMED_WAITING (sleeping) at

Re: Is Apache ignite support tiering or it only support caching??

2020-02-21 Thread Stephen Darlington
What are you trying to achieve? You can do read/write through with an external third-party database, you can use Ignite’s transactional persistence, both of which allow you to have different tiers with varied speeds/volumes of data. Regards, Stephen > On 21 Feb 2020, at 09:58, Preet

Is Apache ignite support tiering or it only support caching??

2020-02-21 Thread Preetiiii
I am looking for tiering facility. If Ignite support then send some links or info. Thanks in advance. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/