How to make full use of network bandwidth?

2018-01-04 Thread Michael Jay
Hi, I have two physical hosts, each host has a sever node, node A and node B. I created a table and inserted data into table via JDBCthin driver. But the performance of inserting is poor. When the bandwidth of network is 100Mbps, the throughput from node A to node B is only about 2Mbps, 1 million r

Re: JDBC Thin Client with Transactions

2018-01-04 Thread Teki
Hi Denis, When this feature will be available? Is this why I am getting the error mentioned in the below post? Please assist. Thanks in advance !! http://apache-ignite-users.70518.x6.nabble.com/insert-into-ignite-cache-from-Netezza-database-using-talend-tp19295.html -- Sent from: http://apache

insert into ignite cache from Netezza database using talend

2018-01-04 Thread Kavin
Hi, I am using talend to insert data from netezza database to ignite cache. The Netezza SQL query has joins with many tables. I am getting the below error. Are inserts supported? The server was started using a java code. The attached image contains the connection details. *Error:* [statistics] co

XML Format for Expiry Policies

2018-01-04 Thread rizal123
Hi all, Would you mind to create xml format for this java syntax. https://apacheignite.readme.io/v2.3/docs/expiry-policies cfg.setExpiryPolicyFactory(CreatedExpiryPolicy.factoryOf(Duration.ONE_MINUTE)); thanks for your help. regards. -- Sent from: http://apache-ignite-users.70518.x6.nabble.

Re: Connection problem between client and server

2018-01-04 Thread Jeff Jiao
Hi Denis, Thanks for the analysis. Today we tried to reduce the Java class path(.../lib/*) when start a server node, but it still sends all the jar files(absolute path) to client. and we also find that, it looks like client node sends its info(path...) to server node, and then server node sends

Re: java.lang.IllegalStateException: Cache has been closed:

2018-01-04 Thread Denis Mekhanikov
Hi Rajarshi! Well, it must be, that you are actually closing the cache. Check, that you didn't put cache creation into a try-with-resources. When *IgniteCache.close()* is called, then cache is destroyed. Denis чт, 4 янв. 2018 г. в 18:17, Rajarshi Pain : > Hi, > > I am using Ignite 2.3 for my ap

Re: off heap memory usage

2018-01-04 Thread Denis Mekhanikov
Hi! Looks like this metric shows only non-heap memory, consumed by JVM itself. Looks like a bug. If you want to get a picture of how much memory Ignite pages consumed, you can get *DataRegionMetrics#PhysicalMemoryPages* and multiply it by a size of a data page. To do this you should enable memory

java.lang.IllegalStateException: Cache has been closed:

2018-01-04 Thread Rajarshi Pain
Hi, I am using Ignite 2.3 for my application. But got Cache closed exception while running. This is a multi threaded application through testing on single thread. it will load the reference number from database to cache during startup and while processing a message, it will check if that particul

Re: H2 console - GridH2QueryContext is not initialized

2018-01-04 Thread Rajarshi Pain
Hi Slava, Yes it might be the root cause as i have set QueryParallelism as 4. On Thu 4 Jan, 2018, 20:25 slava.koptilin, wrote: > Hi Rajarshi, > > I was able to reproduce the issue. > It seems that using CacheConfiguration#QueryParallelism greater than 1 may > lead to this behavior. > I will inve

Re: H2 console - GridH2QueryContext is not initialized

2018-01-04 Thread slava.koptilin
Hi Rajarshi, I was able to reproduce the issue. It seems that using CacheConfiguration#QueryParallelism greater than 1 may lead to this behavior. I will investigate this use case further (will create a JIRA ticket for that bug). Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.

dotnet thin client - multiple hosts?

2018-01-04 Thread Colin Green
IgniteClientConfiguration.Host is currently a string property that appears to accept a single dotted IP address, or single host name. However, in the event that the single configured host/node goes offline, it would be useful if the client would attempt to dynamically connect to one or more additi

Re: Rest API GET command syntax with a composite primary key

2018-01-04 Thread Evgenii Zhuravlev
Hi, According to these tickets, now REST protocol interpret everything as String : https://issues.apache.org/jira/browse/IGNITE-3345 https://issues.apache.org/jira/browse/IGNITE-962 At this moment you can use *ConnectorMessageInterceptor *interface. Once you implement and configure it, you will s

Re: Cursor in TextQuery - first hasNex() is slow

2018-01-04 Thread zbyszek
Thank you Val, I am afraid it is still not clear to me What I was trying to explain above it that regardless the page size (1 or 10 or default), the duration of first next() or hasNext() is always equal to duration of fetching all data with getAll(). - in my example above pageSize is 10. Th

Rest API GET command syntax with a composite primary key

2018-01-04 Thread Naveen
Hi Am using 2.3 What is the GET syntax for REST API for a cache which has a composite key. I have a cache which has a composite key - consisting of 2 columns Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Connection problem between client and server

2018-01-04 Thread Denis Mekhanikov
Jeff, Your have indeed a lot of data sent over discovery. Almost all of it is taken by node attributes. Try reducing Java classpath and PATH environment variable. Also increasing of TCP window could help, because now a lot of small messages are sent instead of a few big ones. Cross-sending it to

off heap memory usage

2018-01-04 Thread shawn.du
Hi community,I want monitor ignite cluster off heap memory usage. if off heap available memory is less than 1G then alert. I went through ignite MBean,  find ClusterLocalNodeMetricsMXBeanImpl's NonHeapMemoryUsed. The value is too small. I don't think it is.  How can I get it?