Re:Ignite .NET - Delete statement

I am using java driver, and also i am seeing this problem. if delete statement delete only one row data, there is no errors. and if the delete statement delete multi-row data, the below exception occurs. cloud you please take a look at this ASAP? thanks, Martin At 2017-12-04 17:38:00,

Re: memory usage in 2.3

Thank you Denis,I think OOM is caused by invalid configuration. for I supposed ignite use on-heap memory,  I set a very big value for -Xmx -Xms, in this way, memory left for off-heap and other programs is limited. We are run testing now, till now all seems good.

Re: PHP and Apache Ignite - very slow query

ok, I will try to build cluster on 3 machines and I will prepare tests one more time. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Understanding configurations for IGFS

Hi, I'm trying to understand the configuration parameters for IGFS. My use case is using IGFS with a secondary file system, thus acting as a cache for a hadoop file system, without having to modify any existing application (just the input and output path that will now use the igfs scheme). In the

Re: PHP and Apache Ignite - very slow query

Ignite’s strength is an ability to store and process data in a distributed way in-memory. It means that while Ignite might loose to an RDBMS in a single machine comparison scenario, it will outperform in the scenarios where a lot of data is stored cluster wide. Considering this, try to start a

Re: memory usage in 2.3

Shawn, If you still need to use the on-heap caching by some reason make sure you enabled an eviction policy: https://apacheignite.readme.io/docs/evictions#section-java-heap-cache Otherwise the on-heap cache will grow

Re: Problems with explain statemenz

The result set is different when you add explain - it only returns execution plans: https://apacheignite-sql.readme.io/docs/performance-and-debugging#using-explain-statement However, you're trying to get values for multiple columns which are not there, therefore it fails. -Val -- Sent from:

Problems with explain statemenz

Hi, I am trying to do an explain analysis on an SQL statement: SqlFieldsQuery sql = new SqlFieldsQuery( " explain SELECT act.id as id, act.actDef as actDef, act.status, act.prio as prio, o.orgId, p.userId " + " FROM Activity as act left

Re: WEBINARS: Apache Ignite Essentials for Architects and Java Developers

Igniters, The second part of the series is already tomorrow at 11:00am PT / 2:00pm ET: https://ignite.apache.org/events.html#in-memory-computing-essentials-architects-and-developers-part-2 The goal for this part is to explain the benefits of affinity collocation and how to apply it in

Re: How do I register a class for a use by the BinaryMarshaller

John, This should be done via BinaryConfiguration: https://apacheignite.readme.io/docs/binary-marshaller#configuring-binary-objects Javadoc is incorrect, I will file a ticket to fix it. -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: PHP and Apache Ignite - very slow query

Thanks for reply. What do you mean with "warmed up" the JVM prior testing? How can I do this? Do you mean to prepare JAVA application with some SQL queries like my PHP scripts from first post, and run it in JVM to check query time? -- Sent from:

Re: Cache listener for new keys

I know about continuous queries, but they also send both value and key(or is the possibility to change the event to send only the key for continuous queries?). I used ignite cache as a cache so sometimes I read from it, but I am doing local register from keys on the ignite-client so I need to be

Re: How do I register a class for a use by the BinaryMarshaller

This doesn't work but I'm looking for an equivalent of this, which is described here: https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/IgniteBinary.html org.apache.ignite.examples.client.binary.Employee On Tue,

How do I register a class for a use by the BinaryMarshaller

Hi, How do I register a class, in the XML config file, to be used by the Binary Marshaller? Assume I have IgniteCache, I want the xml config equivalent for: binaryMarsh.context().descriptorForClass(Point.class, false) Thanks,

Re: Cache listener for new keys

Hi, Could you please describe what are you trying to achieve with this logic? Entry related events usually send both the key and the value. You could take a look at continuous queries instead https://apacheignite.readme.io/docs/continuous-queries. As well, you could specify filters for local or

Re: javax.cache.CacheException: Failed to run map query remotely.

Hi Alex, I was running this on Eclipse and this the exception printed on the console. May I know what else you need for this to investigate?, Thanks Raj On Tue, Dec 12, 2017 at 10:44 PM, afedotov wrote: > Hi, > > Please share the full log. > > Kind regards, >

Re: javax.cache.CacheException: Failed to run map query remotely.

Hi, Please share the full log. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Cache Data Not Available in Other Server Nodes

Here is the code Snippet which shows how we put data to the cache. public void method(argType arg){ while (true){ try(Transaction tx=ignite.transactions().txStart(TransactionConcurrency.OPTIMISTIC,TransactionIsolation.SERIALIZABLE)){ workflowRunStateIgniteCache.put(arg);

Cache listener for new keys

I have Ignite cache and entry listener for that cache generates event with the entry key and entry value. Most of the times I am interested only in key and not in value, is it possible to create listener that will notify me with new key and based on this I can decide If i load the value from

Re: Affinity - Join query on the collocated data taking 90 seconds

Hi Nikolai No, may be you were looking at the different config XML I am using IgnitePOC-client.xml, this is the content of this XML. Config XML does not have (not using the server XML which has AccountCache & CustomeCache Java Class name is - DataLoadAffinity.java where I am creating the cache

javax.cache.CacheException: Failed to run map query remotely.

Hi, I am using Ignite 2.3 and was doing a cache query to get some details but got below error while executing the query. can you please let me know why I am getting this error ? javax.cache.CacheException: Failed to run map query remotely. at

Re: Ignite Cache Data Not Available in Other Server Nodes

Can you share code snippet which shows how you put data to the cache? On Tue, Dec 12, 2017 at 12:26 PM, Harshil garg wrote: > Sorry , forgot to attach the xml used for configuring cache. > > > > > > > http://www.springframework.org/schema/beans; >

Re: cluster hanged when client node put data into the caches

Hello, You don't have to use synchronization for Ignite Cache API. This instance already is threadsafe. I recommend to read the following documentation page: https://apacheignite.readme.io/docs/jvm-and-system-tuning On Sun, Dec 10, 2017 at 4:49 PM, Aurora <2565003...@qq.com> wrote: > @Nikolai >

Re: Affinity - Join query on the collocated data taking 90 seconds

Hello! I've looked at your project and seems you confised cache names. Cache configuration contains "AccountCache" and "CustomerCache", but for streaming you use "Customer" and "Account" caches. On Tue, Dec 12, 2017 at 4:50 PM, Naveen wrote: > Hi All > > Had any one

Re: ignite in yarn

Hello Ranjit! Just a few days ago there were discussions where we set up Ignite with YARN. Steps to run it (on AWS in that case) are described here: http://apache-ignite-users.70518.x6.nabble.com/Error-running-ignite-in-YARN-td18280.html#a18577 (Hopefully you won't need to apply patch since

Re: PHP and Apache Ignite - very slow query

Sorry, then I got you wrong. In this case your results are of course comparable. Cheers Wolfram On 12/12/2017 22:14, bagsiur wrote: Maybe Im not explain everythinnk correctly. I run mysql queries by PHP of course So, one more time: I prepare the same database, first db in MySQL and second

Re: PHP and Apache Ignite - very slow query

Maybe Im not explain everythinnk correctly. I run mysql queries by PHP of course So, one more time: I prepare the same database, first db in MySQL and second in Apache Ignite. Database have the same size and number of rows (~6 milion rows). I prepare the same PHP script (as in my first post)

Re: Can Ignite me used for everyday processes, storage, reading, writing, etc. together with SQL

Rick, You are testing Ignite in mode that will not show its true power. Ignite is a _Distributed_ system, so, it _can_ outperform classic DB in distributed mode. On Tue, Dec 12, 2017 at 2:34 PM, Rick Alexander wrote: > No clusters setup yet, 1 node, 1 host, running on a

Re: PHP and Apache Ignite - very slow query

Hi! If you don't run both queries from PHP, you cannot really compare the results. Running queries from the mysql console means that you don't have to establish a connection, which takes quite some time. You don't have to use ODBC to connect to MySQL, PDO will do a fine job and makes your

Re: PHP and Apache Ignite - very slow query

Hi and thank you for your answer. Im not test mysql with odbc driver and at this moment my goal is to find more faster solution like mysql. I know that mysql is working on native mysql driver and ODBC is a third-party driver but this is recommended solution in official Apache Ignite

Re: Affinity - Join query on the collocated data taking 90 seconds

Hi All Had any one got a chance look into this issue. As mentioned, I am using Affinity key and IgniteDataStreamer to load data of 10M. This is how my code looks like Customer cache - PartyID is the primary key IgniteDataStreamer streamer =

Re: queryParallelism in server XML

Hi, Please try the following example: Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

queryParallelism in server XML

Dears; How can I enable CacheConfiguration.queryParallelism in server XML? BR -- This email, and the content it contains, are intended only for the persons or entities to which it is addressed. It may contain sensitive, confidential and/or privileged material. Any review, retransmission,

Re: memory usage in 2.3

Hi Shawn, > how to disable off heap completely? You cannot disable off-heap. As of 2.0, Apache Ignite stores all the data outside of java heap. > does it mean half in on-heap and half in off-heap? On-heap caching allows to get a subset of the data into java heap and can be useful for scenarios

Re: Cache store class not found exception

It's correct link to the related thread http://apache-ignite-users.70518.x6.nabble.com/CacheStore-being-serialized-to-client-td1931.html On Mon, Dec 11, 2017 at 7:31 PM, Nikolai Tikhonov wrote: > Hello! > > Apache Ignite requires that CacheStore classes should be in

ignite in yarn

Hi , Can anyone share the experience of using ignite in yarn mode and the steps to set it up in CDH ? Thanks, Ranjit

memory usage in 2.3

Hi,I upgrade my ignite version from 1.9 to 2.3. In 1.9, We store all data in memory. I know that in ignite 2.0+, ignite use off-heap memory by default.so I change my code like below:  config.setOnheapCacheEnabled(true);but after running several hours, my server is crash for

Re: Access Cache Deployed from a server node where Cache is not deployed

Hi Andrey I have figured out the problem, actually my cluster node was kept in debug mode for long. As a result that node got detached from the cluster giving an IllegaStateException. Now the actual issue I am facing is whenever I am trying to access cache deployed from other server nodes , it

Re: PHP and Apache Ignite - very slow query

Do you test MySql through PHP and ODBC as well? Have you "warmed up" the JVM prior testing? Also, I can see code which is not related to Apache Ignite but can take a lot of time, i.e. printing of 60500 records. Best Regards, Igor On Tue, Dec 12, 2017 at 11:37 AM, bagsiur

Re: Re: Re: Re: Re: Re: Re: Re: Re:Poor performance select query with jdbc thin mode

Lucky, If you want to run queries with *JOIN*s, you should make sure, that entries are collocated. It means, that all data for a* JOIN* should be available on a single node. You may have many nodes, but each row of the result should be composed of the data, that is stored within a single data

Re: Ignite Cache Data Not Available in Other Server Nodes

Sorry , forgot to attach the xml used for configuring cache. http://www.springframework.org/schema/beans; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; xmlns:context="http://www.springframework.org/schema/context; xsi:schemaLocation="

Re: Ignite Cache Data Not Available in Other Server Nodes

Hi Nikolai I haven't removed any data from other nodes. How data can be removed manually from cache manually ?? I have three cache deployed in Data Node which is configured using this below xml. I have data getting saved in workflowRunStateCache which I verified in web console. But when I am

PHP and Apache Ignite - very slow query

Firstly, sorry for my English. I start to use Apache Ignite with PHP (PDO, UnixODBC, Ignite ODBC driver). I successfully installed it and configured Ignite, DSN and ODBC on my linux server (Debian). I installed php-odbc extension and everything looks well. I start Apache Ignite by:

Re: Data lose in query

Exactly, I have faced the same problem and posted this question to the forum, not yet got any response. Thanks On 12-Dec-2017 1:48 PM, "Ahmad Al-Masry" wrote: > Hi; > I added @AffinityKeyMapped to the fields in the model generated by web > console. > But I also noticed that