[ANNOUNCE] Apache Ignite 2.14.0 Released

know if you encounter any problems: https://ignite.apache.org/community/resources.html#ask -- With best regards, Taras Ledkov

Re: What does javax.cache.CacheException: Failed to execute map query on remote node mean?

t;> Caused by: org.h2.message.DbException: Hexadecimal string with odd number of >> characters: "5" [90003-197] -- With best regards, Taras Ledkov

Re:Cache Exception for specific parameter values

Hi, Could you provide the original exception from the map node? It must be available at the log files of the map node.

Re: Failed to Scan query data by partition index after insert data using DML

(BinaryContext.java:680) ... 27 more Taras Ledkov wrote Hi, Please take a look at the documentation of the CREATE TABLE [1] Use: CREATE TABLE tableName (id LONG PRIMARY KEY, name VARCHAR) WITH "|CACHE_NAME=|cacheName" Please pay attention to other options. Its may be useful to

Re: Failed to Scan query data by partition index after insert data using DML

; //nothing return here! I tried SQL_PUBLIC_TABLENAME as cache name, I got Exception: java.lang.ClassNotFoundException: SQL_PUBLIC_TABLENAME_7b146bba_cd7f_452f_8abc *Q: How can I query data inserted by DML using partition index? Thanks.* -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Understanding SQL join performance

first level aggregation results to the reducer? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: SQL query performance with JOIN and ORDER BY or WHERE

Thomas. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ <http://apache-ignite-users.70518.x6.nabble.com/> -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Slow SQL query when joining on a REPLICATED Cache

-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: very fast loading of very big table

dgain.com/resources/blog/how-fast-load-large-datasets-apache-ignite-using-key-value-api> [2] https://m.habr.com/ru/post/526708/ <https://m.habr.com/ru/post/526708/> -- Отправлено из мобильного приложения Яндекс.Почты -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Ignite Client Node OOM Issue

o you use SQL queries? Is it possible to share your client node configuration? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ <http://apache-ignite-users.70518.x6.nabble.com/> -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Ignite 2.8.0. Heap mem issue

download from Jumbo mail link. https://jumboiskon.tportal.hr/download/eeab9848-2494-4ab7-a2cb-88766db0fafa Thanks, Dren -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Ignite memory leaks in 2.8.0

that creates detached connection, finish and join thread. Remove link to thread. Repeat. пн, 23 мар. 2020 г., 15:49 Taras Ledkov <mailto:tled...@gridgain.com>>: Hi, Thanks for your investigation. Root cause is clear. What use-case is causing the leak? I've created the issue

Re: Ignite memory leaks in 2.8.0

a.lang.Thread, value: java.lang.ThreadLocal$ThreadLocalMap #2 Link to IgniteKernal leaks to ThreadLocal variable, so when we start/stop many instances of Ignite in same jvm during testing, we got many stopped “zomby” ignites on ThreadLocal context of main test thread and it cause OutOfMemory after some dozens of tests. Andrey. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Query timeout

supported in 2.8.0? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Query timeout

Hi, queryTimeout=N in seconds according with JDBC specification: java.sql.Statement#setQueryTimeout On 23.03.2020 12:47, breathem wrote: Hi all, Is there any way to set query timeout parameter in JDBC url? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov

Re: java.lang.IllegalMonitorStateException: attempt to unlock read lock, not locked by current thread

same connection at different time.My code works well in ignite 2.7 and it also works when I set lazy=false in ignite 2.8. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: ERROR: h2 Unsupported connection setting "MULTI_THREADED"

ation.main(LoaderApplication.java:14) ~[main/:na] Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported connection setting "MULTI_THREADED" [90113-200]         at org.h2.message.DbException.getJdbcSQLException(DbException.java:622) ~[h2-1.4.200.jar:1.4.200]

Re: JDBC Thin Client does not return

, pg31 wrote: Hi Thank You for the reply Denis. Please find the logs attached. The query was still running Create_IDX_Stuck.zip <http://apache-ignite-users.70518.x6.nabble.com/file/t2770/Create_IDX_Stuck.zip> -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledko

Re: Ignite performance - sudden drop after upgrade from 2.3.0

. We do not waive any confidentiality by misdelivery. If you receive this communication in error, any use, dissemination, printing or copying is strictly prohibited; please destroy all electronic and paper copies and notify the sender immediately. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Get all cache entries

nku...@iitdgroup.ru> тел.: 84995021375 доб. 320 моб. тел.: 79260948887 115114, Москва, Дербеневская ул., 20-27 -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: BLOB with JDBC Driver

Hi, But SQL type BLOB isn't supported by Ignite. Please use BINARY SQL type. 06.03.2019 18:40, Taras Ledkov пишет: Hi, The JDBC Blob is supported by JDBC v2 driver (thick driver based on Ignite client node). Thin JDBC driver hasn't supported Blob yet. 06.03.2019 13:50, KR Kumar пишет: Hi

Re: Data streamer has been closed.

, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: SQLFieldsQuery timeout is not working

. Is timeout dependent on the resultset size as well? Also, is there any way through which I can customize H2 timeout scanned row count (instead of 4k rows). -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: SQLFieldsQuery timeout is not working

QueryCancelledException and times out. Is timeout dependent on the resultset size as well? Also, is there any way through which I can customize H2 timeout scanned row count (instead of 4k rows). -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: SQLFieldsQuery timeout is not working

am I missing. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Sample configuration for one cache [name=KSDATA] and use it with JDBC (client do not find schema)

ook <https://www.facebook.com/gfiinformatique>Twitter <https://twitter.com/gfiinformatique>Instagram <https://www.instagram.com/gfiinformatique/>LinkedIn <https://www.linkedin.com/company/gfi-informatique>YouTube <https://www.youtube.com/user/GFIinformatique> — cid:image006.jpg@01D2F97F.AA6ABB50 <http://www.gfi.world/> -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: custom plugin question - jdbc client

etc. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Basic Subquery Failure

;merge_sorted": __C1_0 IS ?1 ++/ WHERE __C1_0 IS ?1 ORDER BY 1 /++ index sorted ++/: NAME = __Z0__NAME */ ON 1=1 WHERE __Z0__NAME = SUB__Z2.NAME GROUP BY __Z0__NAME" -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Index not getting created

;Customer".CUSTOMER where ACCOUNT_ID_LIST ='A10001'; ++ |ACCOUNT_ID_LIST | ++ | A10001 | ++ 1 row selected (1.641 seconds) 0: jdbc:ignite:thin://127.0.0.1> On Th

Re: Index not getting created

SqlLine.start(SqlLine.java:373) at sqlline.SqlLine.main(SqlLine.java:265) 0: jdbc:ignite:thin://127.0.0.1> -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/ -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: JdbcQueryExecuteResult cast error

inResultSet.java:714) What's  suggestion? Thanks. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Failed to run reduce query locally

strange the query fails only when exactly one record is returned in result set -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Failed-to-run-reduce-query-locally-tp16403.html Sent from the Apache Ignite Users mailing list archive at Nabble.com. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Passing parameters to IgniteBiPredicate

or) System.out.println(p.toString()); }| It fails silently. I have also tried creating a class that implements the IgniteBiPredicate that takes the value as a parameter on the constructor. Has anyone had experience pushing a scan query with parameters? Thanks ! -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Fetch column names in sql query results

in context: http://apache-ignite-users.70518.x6.nabble.com/Fetch-column-names-in-sql-query-results-tp14089.html Sent from the Apache Ignite Users mailing list archive at Nabble.com. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Hadoop + IGFS + Hive+Tez

for hadoop? I want just save all word of wordcount processing in a grid cache between 2 node server. There's no log of the task because the application crash before task.. The node are connected via lan. Thanks 2017-06-21 16:59 GMT+02:00 Taras Ledkov <tled...@gridgain.com <mailt

Re: Hadoop + IGFS + Hive+Tez

-users.70518.x6.nabble.com/Hadoop-IGFS-Hive-Tez-tp14012.html Sent from the Apache Ignite Users mailing list archive at Nabble.com. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Affinity Issue(Collocate compute) in Ignite JDBC Query

in context: http://apache-ignite-users.70518.x6.nabble.com/Affinity-Issue-Collocate-compute-in-Ignite-JDBC-Query-tp13338p13685.html Sent from the Apache Ignite Users mailing list archive at Nabble.com. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Same Affinity For Same Key On All Caches

All-Caches-tp10829p11006.html <http://apache-ignite-users.70518.x6.nabble.com/Same-Affinity-For-Same-Key-On-All-Caches-tp10829p11006.html> Sent from the Apache Ignite Users mailing list archive at Nabble.com <http://Nabble.com>. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Detecting terminal condition for group of items in Ignite cache.

zero. -- Taras Ledkov Mail-To: tled...@gridgain.com On Wed, Dec 14, 2016 at 2:02 PM, begineer <redni...@gmail.com> wrote: > Hi, > My sample application processes trades for different companies stored in > Ignite cache. When all trades for particular company reaches SUCCESS stage,

Re: Not able to join cluster with Zookeeper based IP finder

Please provide the logs from all 3 nodes. Also please provide FULL logs if it is possible: [15:05:05] Quiet mode. [15:05:05] ^-- To see **FULL** console log here add -DIGNITE_QUIET=false or "-v" to ignite.{sh|bat} On Mon, Dec 5, 2016 at 6:22 PM, ghughal wrote: >

Re: Problem with ReentranLocks on shutdown of one node in cluster

Hi, Thanks a lot for reproducible scenario and for the test. I create the issue to track: https://issues.apache.org/jira/browse/IGNITE-4369. On Wed, Nov 30, 2016 at 7:35 PM, vladiisy wrote: > Hi, > > i have a problem with my application using reentrant locks, they seems to >

Re: Not able to join cluster with Zookeeper based IP finder

Hi, So, is the case reproduced only when the nodes are started simultaneously? Could you add any delay between instances starts? Looks like an issue. Please provide the logs, please. On Thu, Dec 1, 2016 at 1:29 AM, ghughal wrote: > We are seeing intermittent issue

Re: Ignite - FileNotFoundException

I guess 64K-128K must be enough. On 13.10.2016 13:04, Anil wrote: What is the recommended file descriptor limit for ignite data load ? Thanks. On 13 October 2016 at 15:16, Taras Ledkov <tled...@gridgain.com <mailto:tled...@gridgain.com>> wrote: Please check the file de

Re: Ignite - FileNotFoundException

:565) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at java.lang.Thread.run(Thread.java:745) Looks like it is due to high load. How can we avoid this exception? thanks. Thanks. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Loading Hbase data into Ignite

hub.com/apache/ignite/tree/master/examples <https://github.com/apache/ignite/tree/master/examples> is there any approach where each ignite node loads the data of one hbase region ? Do you have any recommendations ? Thanks. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Getting Error [grid-timeout-worker] when running join query on Single Ignite Node

4xm~#type' AND T.prop5 = '1oh~#some_prop1') AND T.val0 = '1eg~' AND T.val5 = '0') AS QS6 LIMIT 100 PS: I've been able to run the similar query with join and that doesn't give the above error logs. Please help me with that. -- Thanks & Regard Manish Mishra Software Consultant, Knoldus Software, LLP -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Out of order updates for CacheEntryListeners and multi-cache transactions

pdates-for-CacheEntryListeners-and-multi-cache-transactions-tp7864.html Sent from the Apache Ignite Users mailing list archive at Nabble.com. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Optimizing Local Cache Iteration

anywhere to deserialize the offheap data before it is shipped to another node during a rebalance? Or am I barking up the wrong tree on this one entirely? I have done all of the typical optimizations such as turning off copyOnRead, reducing backups, setting a large heap, etc. Thanks -- Taras

Re: Re: Increase Ignite instances can't increase the speed of compute

Hi, How many MatchingJobs do you submit? On Tue, Sep 13, 2016 at 12:29 PM, 胡永亮/Bob wrote: > Hello, Vladislav > > The following is some code. > > ... > IgniteCompute compute = ignite.compute();//.withAsync(); > > compute.run(new

Re: Finding Key to Node Mapping

sm:+90 536 222 76 01 > <%2B90%20553%20489%2044%2099>* > *www.evam.com <http://www.evam.com/>* > <http://www.evam.com> > -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: partitions' balance among ignite nodes

the Apache Ignite Users mailing list archive at Nabble.com. -- Taras Ledkov Mail-To: tled...@gridgain.com

Re: Ignite Compute - Rebalance Scenario

l> Sent from the Apache Ignite Users mailing list archive at Nabble.com. -- Taras Ledkov Mail-To: tled...@gridgain.com