RE: Continuous queries and duplicates

I will take a look, thanks! But, upon further investigation, it appears that there is no isolation whatsoever between the initial query and the listener in ContinuousQuery. The initial query can pick up entries added after it started and which had been already sent to the local listener. This

Re: “Binary type has different field types” Error when using Date type field in Key or Value

Hello! Can you post a small reproducer project which will demonstrate this behavior? Regards, -- Ilya Kasnacheev ср, 28 нояб. 2018 г. в 00:03, rishi007bansod : > I am trying to use java.util.Date type field in my Ignite Key and Value > objects. But when I start caching data in same Ignite

Re: Can we have different Segmentation Policy in same cluster grid?

Hello! Have you tried it? What was the result? Regards, -- Ilya Kasnacheev вт, 27 нояб. 2018 г. в 09:03, Hemasundara Rao < hemasundara@travelcentrictechnology.com>: > Hi, > Can we have different Segmentation Policy in same cluster grid? > () > Let 's say I have grid with 3 node server

Re: Why GridDiscoveryManager onSegmentation use StopNodeFailureHandler?

Hello! It will use IgniteConfiguration.segmentationPolicy. You can just try setting it to RESTART_JVM. Regards, -- Ilya Kasnacheev вт, 27 нояб. 2018 г. в 17:18, wangsan : > Can I use LifecycleEventType.AFTER_NODE_STOP to stop jvm? if segment event > happens? > > > > -- > Sent from:

Re: Invalid property 'statisticsEnabled' is not writable

Hello! I was able to start a stand-alone node with such configuration. What are the steps to reproduce this failure? Regards, -- Ilya Kasnacheev вт, 27 нояб. 2018 г. в 21:23, ApacheUser : > Hi Team, > > we have 6 node Ignite cluster, loading data with Spark. recently we have > added

Re: Cache Structure

Hello! You can implement Binarylizable which will serialize your objects so that your relevant k1 and k2 are stored as entries in BinaryObject. You can then add QueryEntity to cache to be able to index them properly. Regards, -- Ilya Kasnacheev чт, 15 нояб. 2018 г. в 01:33, Ramin Farajollah :

Re: GridProcessorAdapter fails to start due to failure to initialise WAL segment on Ignite startup

Hi Ilya, We don’t change the WAL segment size from the default values. The only activity that occurred was stopping a node, making a minor change (not related to persistence) and rerunning the node. Raymond. Sent from my iPhone On 1/12/2018, at 2:52 AM, Ilya Kasnacheev wrote: Hello! "WAL

Re: Failed to fetch SQL query result

Hello! Does this happen every time? If so, which is the # of row on which it will happen? Regards, -- Ilya Kasnacheev вт, 27 нояб. 2018 г. в 10:09, yangjiajun <1371549...@qq.com>: > Hello. > > I did a scan query on a table which has 8w records and tried to go through > all records in the

Re: ODBC driver build error

Hello! You will have much easier time just taking a pre-built installer out of nightly build: https://ci.ignite.apache.org/viewLog.html?buildId=lastSuccessful=Releases_NightlyRelease_RunApacheIgniteNightlyRelease=artifacts=1#!-oll7z3tvqsdk,-1fllqn9a26ew6,1e6erfmy67dj4,enpgjwyte3hs Regards, --

Re: ODBC driver build error

You are right, this document needs update. I'll file a ticket for this task. Best Regards, Igor On Fri, Nov 30, 2018 at 5:53 AM Ray wrote: > Thank you for the reply Igor, > > After adding legacy_stdio_definitions.lib in the linker's input, I built > the > ODBC driver successfully. > > I want

Re: Slow select distinct query on primary key

Please provide explain plan of the query to check that index is use. *EXPLAIN {your select statement}* Also I noticed ACCOUNT_ID have length 50. Need to increase of inline index size for the index. Try create index with the follow command *CREATE INDEX PERF_POSITIONS_IDX ON PERF_POSITIONS

Re: Ignite cluster going down frequently

Hello! [04:45:53,179][WARNING][tcp-disco-msg-worker-#2%StaticGrid_NG_Dev%][TcpDiscoverySpi] Timed out waiting for message delivery receipt (most probably, the reason is in long GC pauses on remote node; consider tuning GC and increasing 'ackTimeout' configuration property). Will retry to send

Re: HELLO WORLD GA EXAMPLE

Hello! GA examples are standalone as far as my understanding goes. You don't need to launch Ignite node explicitly. Can you try killing it and restarting the example? Otherwise, as it tells you, enable peer-class-loading or add ML jars to libs/ Regards, -- Ilya Kasnacheev пт, 30 нояб. 2018

Re: Slow select distinct query on primary key

Andrew, 60 will be enough also :) It was just quick calculated value with rounding. Real inline size for the case is 53: 1 /* byte, type code */ + 2 /* short, length of array */ 50 /* data size for ANSI chars */ пт, 30 нояб. 2018 г. в 14:09, Andrey Mashenkov : > Yuri, how did you get inline

Re: Slow select distinct query on primary key

Yuri, how did you get inline size 60? I'd think 55 should be enough to inline Account_ID. 55 = 1 /* byte, type code */ + 4 /* int, array lenght */ + 50 /* data size for ANSI chars */ On Fri, Nov 30, 2018 at 1:25 PM Юрий wrote: > Please provide explain plan of the query to check that index is

Re: Ignite benchmarking with YCSB

Hello! I'm afraid I have no idea anymore. Will it help if you decrease number of YCSB threads? Is it possible that YCSB uses the same key over and over again? Regards, -- Ilya Kasnacheev пт, 30 нояб. 2018 г. в 09:05, summasumma : > Hi Ilya, > > I have tried to set the following and rerun the

Re: JDBC Streaming

Hello! Can you create a small reproducer project which will exhibit this behavior? Put it on e.g. Github. Note that 'streaming mode' in Client driver and Client driver itself are near-deprecated. So there may be some rough edges. However, there are streaming mode tests in Apache Ignite and they

Re: Fair queue polling policy?

Hello, I have found this discussion about the same topic and indeed the example there works and the queues poll fair. And when I tweak the sleep after put and take, so that

Re: Is there any way to speed up delete data or drop table?

Hello! Maybe dropping a cache will be somewhat faster when this cache is a part of existing cache group: https://apacheignite.readme.io/docs/cache-groups Regards, -- Ilya Kasnacheev чт, 29 нояб. 2018 г. в 16:44, yangjiajun <1371549...@qq.com>: > Hello. > > We need to fully sync data from

Re: Configuration of ignite

Hello! You should keep pageSize the default, and checkpointBufferSize should be tuned up until you only see checkpoints with reason 'timeout', i.e. when you will not be running out of it. You should be aiming for an optimal maxSize/checkpointBufferSize mix. Regards, -- Ilya Kasnacheev чт, 29

Re: GridProcessorAdapter fails to start due to failure to initialise WAL segment on Ignite startup

Hello! "WAL segment size change is not supported" Is there a chance that you have changed WAL segment size setting between launches? Regards, -- Ilya Kasnacheev чт, 29 нояб. 2018 г. в 02:39, Raymond Wilson : > I'm using Ignite 2.6 with the C# client. > > I have a running cluster that I was

Re: Continuous queries and duplicates

Hello! There should be isolation in AI 2.7 as an experimental feature. Regards, -- Ilya Kasnacheev пн, 26 нояб. 2018 г. в 12:53, Sobolewski, Krzysztof < krzysztof.sobolew...@gs.com>: > Thanks. This is a little disappointing. ScanQuery would probably work, but > it’s not as efficient (can’t

Re: Slow select distinct query on primary key

Here is the explain plan. 0: jdbc:ignite:thin://127.0.0.1/> EXPLAIN SELECT DISTINCT ACCOUNT_ID FROM PERF_POSITIONS; 'PLAN' 'SELECT DISTINCT __Z0.ACCOUNT_ID AS __C0_0 FROM PUBLIC.PERF_POSITIONS __Z0 /* PUBLIC."_key_PK" */' 'SELECT DISTINCT __C0_0 AS ACCOUNT_ID FROM PUBLIC.__T0 /*

Re: Slow select distinct query on primary key

Hello! > only 1 out of the 16 available cores get spiked to 100%, while the rest remain idle This is to be expected unless you crank query parallelism up: https://apacheignite.readme.io/docs/sql-performance-and-debugging#query-parallelism Unfortunately, the setting is only available via cache