Re: Durable memory with native persistence isssue

2018-10-25 Thread debashissinha
I am using tpcds to to benchmark ignite with above configuration . I generate 1gb of data for the table store_sales and then manually create the table and indexes . Then from sql line I use copy from statement to load the data file into the table. As per the tpcds matrix the no of rows processed

Re: Client node get stuck when reconnecting to cluster

2018-10-25 Thread akurbanov
Hello, Partition map exchange is a cluster-wide operation that needs to be finished before cluster becomes operational on a updated topology in your case. It was triggered by node leaving cluster prior to start of the current one. To find out the reason why it hangs please provide logs from

Re: Durable memory with native persistence isssue

2018-10-25 Thread akurbanov
Hello, This seems to be not a performance-related question, the fact that you have mismatch between inserted rows count and count(*) doesn't feel right and seems to be the primary issue to resolve. Could you please give more detail on how you are trying to load your data, what is your node

Re: cotinuousquery -> Requesting mapping from grid failed for [ platformId=1, typeId=1173251103]

2018-10-25 Thread akurbanov
Hello, This issue seems to be raised as you didn't specify binary configuration for your C# type. Since you create your entity via sqlline (actually it doesn't matter where do you create it), Ignite knows nothing about C# type mapping to Java type: /Caused by: java.lang.ClassNotFoundException:

Re: odbc 2.7 columns issue

2018-10-25 Thread wt
Thanks Igor I didn't think about the underscores in the names. Will try it in the morning. Thanks for the tip, hopefully it will get me over the line for the demo to the COO. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: remote filter for ContinuousQuery on C#

2018-10-25 Thread jcalahor
that helped, thx! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

cotinuousquery -> Requesting mapping from grid failed for [ platformId=1, typeId=1173251103]

2018-10-25 Thread jcalahor
H, i'm getting exception on the server nodes when a new City record is added . The c# code is below: namespace ignite_test { class Program { class CityEventListener : ICacheEntryEventListener { public void OnEvent(IEnumerable> evts) {

Re: npe: Failed to reinitialize local partition

2018-10-25 Thread Ilya Kasnacheev
Hello! What is the cache template here, and where is it defined? I don't see any changes to the test. Can you modify it so that it will display your case? Regard, -- Ilya Kasnacheev чт, 25 окт. 2018 г. в 5:31, wangsan : > IgniteTwoRegionsRebuildIndexTest.java > < >

Re: Cluster freeze with SSL enabled and JDK 11

2018-10-25 Thread Ilya Kasnacheev
Hello! I have tried to run the test with protocol "TLSv1.2", didn't see any difference. Regards, -- Ilya Kasnacheev ср, 24 окт. 2018 г. в 20:23, Loredana Radulescu Ivanoff : > Hello again, > > I am working on getting the full SSL logs over to you, but I have one more > question in between:

Re: Total Size seems to keep growing

2018-10-25 Thread ilya.kasnacheev
Hello! After more experiments with your reproducer, I have filed an issue: https://issues.apache.org/jira/browse/IGNITE-10011 Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cache access blocked on destroy

2018-10-25 Thread akurbanov
Hello, I would definitely suggest you to upgrade to latest Ignite versions as a vast number of issues has been fixed since 1.9: https://issues.apache.org/jira/browse/IGNITE-6035 https://issues.apache.org/jira/browse/IGNITE-2714 https://issues.apache.org/jira/browse/IGNITE-8531

Re: odbc 2.7 columns issue

2018-10-25 Thread Igor Sapego
Ok, This is an another bug, related to escaped table names. See [1]. I'm working on it currently. Meanwhile you can use tables without underscores in names as a workaround. [1] - https://issues.apache.org/jira/browse/IGNITE-10009 Best Regards, Igor On Thu, Oct 25, 2018 at 10:13 AM wt wrote:

Re: Automated cache generation to clone a SQL schema?

2018-10-25 Thread Alexey Kuznetsov
Hi, sv! Before ignite-2.0 & Web Console there was "Schema Import Utility" See https://github.com/apache/ignite/tree/ignite-1.9/modules/schema-import Code of that utility is written on Java. It simply read metadata from JDBC and generate stuff. You can write you own custom utility in a couple

Re: Cache stats like number of cache hits, misses, reads, write, avg

2018-10-25 Thread aealexsandrov
Hi, Try to set setMetrcis for both regionCfg and storageCfg too. Is it help? BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Durable memory with native persistence isssue

2018-10-25 Thread debashissinha
Hi , I want to load 1tb of data in cache and have only 9gb of ram at my disposal. I have three machines in cluster each having 9gb of memory. Please suggest how can i achieve best performance using durable memory and native persistence. I tried once but the number of rows inserted vs the

Re: Ignite locking when affinity is used.

2018-10-25 Thread kotamrajuyashasvi
Hi MYCACHE is the name of the cache that is being used. We are observing the below Exception in server logs: cache mode : TRANSACTIONAL , PESSIMISTIC , REPEATABLE_READ [01:46:41,022][SEVERE][grid-timeout-worker-#135][GridDhtColocatedCache] Failed to acquire lock for request: GridNearLockRequest

Re: Cluster is not responsive after node segmentation and reconciliation

2018-10-25 Thread Maxim.Pudov
You definitely need to increase heap size to prevent OOM errors. ./ignite.sh -J-Xmx4g If it doesn't help, provide full logs from all nodes. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Web Console, multiple clusters connected: display of cluster names

2018-10-25 Thread akurbanov
Hello, There is an issue and discussion on dev list for this: https://issues.apache.org/jira/browse/IGNITE-6597 http://apache-ignite-developers.2346864.n4.nabble.com/Cluster-name-td15490.html As a workaround you may use IGNITE_CLUSTER_NAME environment variable set for all nodes in the cluster to

Web Console, multiple clusters connected: display of cluster names

2018-10-25 Thread sv
If there is more than one cluster connected to the Web Console, is there a way to control how each cluster is named in the dropdown for the clusters? Currently being displayed as, eg, "Cluster 57B0C9E1", which is not very human-friendly. Is there a way to control this through some cluster

Re: Ignite locking when affinity is used.

2018-10-25 Thread Evgenii Zhuravlev
Hi, Here is an Ignite Key-Value Transactions Architecture design duocment: https://cwiki.apache.org/confluence/display/IGNITE/Ignite+Key-Value+Transactions+Architecture#IgniteKey-ValueTransactionsArchitecture-Transactions Evgenii чт, 25 окт. 2018 г. в 9:56, kotamrajuyashasvi : > Hi > > In my

Re: odbc 2.7 columns issue

2018-10-25 Thread wt
hi here is the odbc log file odbc.log My server configuration http://ignite.apache.org/schema/dotnet/IgniteConfigurationSection;> 127.0.0.1:47500..47509

Ignite locking when affinity is used.

2018-10-25 Thread kotamrajuyashasvi
Hi In my ignite project a key object of a cache has one of its fields as affinitykeymapped. The cache has 1 backup. Using transactional mode pessimistic and repeatable_read mode. When we acquire lock using cache.get()/put() etc.. is lock only acquired on primary node where the key is located or

Re: Cache access blocked on destroy

2018-10-25 Thread Alper Tekinalp
My ignite version is 1.9 On Thu, Oct 25, 2018 at 9:32 AM Alper Tekinalp wrote: > Hi all. > > We have such a use case that we regularly create and destroy caches on run > time. But when we destroy a cache accesses to other caches could be blocked > and our worker threads not processing any data.

Cache access blocked on destroy

2018-10-25 Thread Alper Tekinalp
Hi all. We have such a use case that we regularly create and destroy caches on run time. But when we destroy a cache accesses to other caches could be blocked and our worker threads not processing any data. Is it an expected behaviour? Is there a better way or workaround? Any suggestions or

Re: Off heap limit

2018-10-25 Thread Evgenii Zhuravlev
https://apacheignite.readme.io/docs/memory-configuration чт, 25 окт. 2018 г. в 7:25, Prasad Bhalerao : > Hi, > > Is there any limit for off heap memory? > > Thanks, > Prasad >