Re: Affinity Service

Hi, What does your service do? Maybe it's better to replace it with a simple remote closure execution calls and use ComputeGrid for your use case? If this works for you, you can use affinityRun and affinityCall method to achieve collocation with data and proper failover [1]. [1] https://apacheign

Re: SQL Query on REST APIs

Hi, Francesco. I’ve found the problem in your second query: http://hostaddress:8080/ignite?cmd=qryexe&Type=Integer&=cacheName=traccia&pzs=10&qry=order+by+%5FVAL+desc+limit+10 According https://apacheignite.readme.io/docs/rest-api#sql-query-execute parameter "Page size for the query" must have na

is there any document to introduce the high availability of Ignite ?

Hi , all I research the high availability of Ignite, is there any document for this? for example, if added one node or removed one node to the cluster, how the data rebalance in all nodes ? and when during rebalancing , what the impact to the client ? is it will impact the client access

Re: Re: argument type mismatch of oracle TIMESTAMP field when call loadCache

Sorry Bob. I forgot to attach patch to issue. On Fri, Jul 1, 2016 at 7:19 AM, 胡永亮/Bob wrote: > hello, * Vasiliy * > > I saw the issue, the status is the following: > > *Status:* Patch Available > > But, I check the code in the github: > https://github.com/apache/ignite/b

Re: Continuous Query

In my case the remote filters are being called and return true appropriately, however it seems that the local listeners are not always being called. I am trying to understand what could be going wrong, starting with ruling out a possible misunderstanding of the framework behavior regarding events p

Re: IgniteCache remove cache data, repeated calls to the'deleteAll'CacheStore method many times, which is the reason?

Hi, If you want to enable IgniteCache asynchronous function (setWriteBehindEnabled (true)), and let IgniteCache in call'put','putAll','remove','removeAll' trigger CacheStore corresponding "add",'addAll','delete','deleteAll'. This scene to real now? The proposed IgniteCache increases the'update'met

re: ignite group indexing not work problem

Hi Alexei, I cannot reproduce this issue again. After restarting my ignite server, my query time reduced to 6ms (remote call). Once I come up with the same problem again, I will tell you and give you the query plan. Thanks for your help again. Kevin 发件人: Alexei Scherbakov [mailto:alexey.sche

Re: Re: argument type mismatch of oracle TIMESTAMP field when call loadCache

hello, Vasiliy I saw the issue, the status is the following: Status: Patch Available But, I check the code in the github: https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/cache/store/jdbc/CacheAbstractJdbcStore.java Th

Re: Non-cluster mode

Hi Peter, It sound like you just don't give enough heap memory to a node. Heap memory is still required, even if you store all the data off heap. Can you try to your JVM at least 2GB and check if this helps? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/

Re: Performance issue on Ignite ODBC API

Hi, Agneeswaran, As I said, internally ODBC driver retrieves data in pages, not one by one. It only returns one row to user by call but it retrieve data from the remote node in pages, not one by one. However, I have checked now and found out that by some reason default page size is very small. Yo

Re: Performance issue on Ignite ODBC API

Hi Igor, We have checked our configuration details and we suspect that the performance degradation is with the SQLFetch(stmt); This issue happens only with the client server model not with the odbc-example. Lets say, Database has Row count as 10 and column count as 5. Please see the following c

Re: SQL Query on REST APIs

Hi, Francesco. Sniffing web console traffic won't help you, because an agent directly connects to web console server. Do you have any antivirus or firewall software? If yes try to disable them. You could also try to sniff what happens then you sending a query request to rest server. 2016-06-29

Re: Error while loading data into cache with BinaryObject as key field

> What was returned as the type name before? As I see from your code that you used some getter to retrieve the name. I have a IgniteCache. The type name for the key object before was a string "My_Object_ValueType" and "My_Object_KeyType". I didn't follow why doesn't it work with these typenames.

Re: Error while loading data into cache with BinaryObject as key field

Hi, > I realized that the error disappears if I hard code the typeName while > constructing the BinaryObjectBuilder. > ignite.binary().builder("ConstantString”); What was returned as the type name before? As I see from your code that you used some getter to retrieve the name. > 1. Wha

Re: Error while loading data into cache with BinaryObject as key field

Hi, 1. Type name can be the actual class name if you plan to work with cache value as java object. 2. Avoid names reserved to SQL keywords. 3. Put key columns into key binary object. To fetch everything use SqlFieldsQuery like: select _key,_val from ... or use SqlQuery 2016-06-30 16:11 GMT+03:00

Re: How to overcome short-time network problems?

Hi Kamal, There are several options how this kind of exception may be processed by the kernel. See org.apache.ignite.plugin.segmentation.SegmentationPolicy for more details. In your scenario you can set IgniteConfiguration.setSegmentationPolicy(SegmentationPolicy.RESTART_JVM). In any case ar

Re: performance of CacheEvents

Hi Lin, First of all, I would suggest using Continuous Queries [1] since this functionality provide much stronger delivery guarantees rather than basic events sub-system. Next, how your benchmark looks like? Just want to see what and how you measure. [1] https://apacheignite.readme.io/docs/con

Re: Error while loading data into cache with BinaryObject as key field

I realized that the error disappears if I hard code the typeName while constructing the BinaryObjectBuilder. ignite.binary().builder("ConstantString"); Few questions based on this 1. What is the significance of the typeName except the fact that it is used while querying? 2. What are th

Re: Problem with installing ODBC Driver

Sumptuously! It is working. Thank you Igor! -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Problem-with-installing-ODBC-Driver-tp5914p6018.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Problem with installing ODBC Driver

By default, ODBC driver will try to connect to unnamed cache ("null" cache), which seems to be non-existing in your case. Best Regards, Igor On Thu, Jun 30, 2016 at 4:09 PM, Igor Sapego wrote: > Hi, > > Have you specified "Cache" connection string argument? You should specify > any existent cac

Re: Problem with installing ODBC Driver

Hi, Have you specified "Cache" connection string argument? You should specify any existent cache there, which is needed to perform queries. In your case it seems like "Cache=Person" or "Cache=Organization" will do the trick. Best Regards, Igor On Thu, Jun 30, 2016 at 3:44 PM, vinisman wrote: >

Re: Problem with installing ODBC Driver

Ok, now i connected with Tableau Desktop. And can see objects in caches. The next step i am trying to query ignite and have error: "Cache doesn't exist (did you configure it?): null"

Error while loading data into cache with BinaryObject as key field

I am using ignite version 1.6 and getting an error while loading data from a csv file through DataStreamer into a IgniteCache. The error is Failed to execute compound future reducer: GridCompoundFuture [rdc=null, initFlag=1, lsnrCalls=0, done=false, cancelled=false, err=null, futs=[true]]class org

Affinity Service

Hello, First and Foremost, than you for this wonderful project. We have the following use case and are wondering about the best way to implement. - For each node in the cluster, we would like to deploy a single service Foo. - When a call is made using a given key, we would like ignite to stick to

How to overcome short-time network problems?

Hi, In my setup, sometimes due to network problems local node gets segmented and stopped. How to tell Ignite to retry continuously to connect with peers instead of stopping the node ? *Logs:* WARN [2016-06-30T16:26:15,370] TcpDiscoverySpi: warning(): Node is out of topology (probably, due to

Re: performance of CacheEvents

It looks like the bottleneck is the bandwidth, the eth is 1Gb, the bandwidth received in the client is 121 MB, it is almost reach the physical upper bound. Can I remove or cut off some contents in the CacheEvent? Or using the custom event? -- Original -- From

performance of CacheEvents

Hi all, I have one client node and two server node, the client registered only two events on a specified cache "cache1" , the EventType.EVT_CACHE_OBJECT_PUT and EventType.EVT_CACHE_OBJECT_REMOVED. Compared with no events case, we test the cache puts operation with yardstick. The OPS of cache

[IGFS][Semaphore] Write file concurrently from several nodes

Hi guys, We have the following usecase involving IGFS: we have an IGFS configured for our cluster and we want that each time a node in the cluster is started a file (describing the operations provided by the node) is written in the IGFS by that node. If several nodes provide the same operation, th

Re: Non-cluster mode

Hi Val, I did further tests and it looks like OutOfMemoryError shows up in case the VM isn't fast enough with its GC. If you add e.g. cache.get in a loop for every key, it's possible to reproduce it. Doing System.gc() every thousand calls takes longer, but the VM has enough time for GC and it work