Re: [2.9.1]in SYS.METRICS View some data is always 0

2021-02-01 Thread Ilya Kasnacheev
|| | cache.SQL_PUBLIC_PERSON.QueryMinimalTime | 21 || | cache.SQL_PUBLIC_PERSON.QuerySumTime | 84 | | Regards, -- Ilya Kasnacheev сб, 30 янв. 2021 г. в 05:10, 38797715 <38797...@qq.com>: > Hello Ilya,

Re: [2.9.1]in SYS.METRICS View some data is always 0

2021-01-29 Thread Ilya Kasnacheev
| | | cache.foo.QuerySumTime | 424| | Regards, -- Ilya Kasnacheev чт, 28 янв. 2021 г. в 14:42, 38797715 <38797...@qq.com>: > Hello Ilya, > > if use sqlline execute sql, the feedback result of the following > statement is c

Re: [2.7.6] Unsupported protocol version: -76 with thin client.

2021-01-29 Thread Ilya Kasnacheev
Thank you. https://issues.apache.org/jira/browse/IGNITE-13401 for the curious. Regards, -- Ilya Kasnacheev пт, 29 янв. 2021 г. в 12:04, Alex Plehanov : > Ilya, you can find reproducer in test > IgniteBinaryTest.testBinaryTypeWithIdOfMarshallerHeader > In this thread, we are talk

Re: Ignite service

2021-01-29 Thread Ilya Kasnacheev
Hello! You can run code on both server or client node, so it is up to you to decide where do you want to call deploy. No, you cannot register C# services using Spring XML Regards, -- Ilya Kasnacheev вт, 19 янв. 2021 г. в 00:54, Jigna : > Hi, > > I have another question for Ignit

Re: [2.7.6] Unsupported protocol version: -76 with thin client.

2021-01-29 Thread Ilya Kasnacheev
Hello! Do you have reproducer for that entity name issue? I would very much like to check that. Why do you need to add 'x' to it? Regards, -- Ilya Kasnacheev чт, 28 янв. 2021 г. в 16:26, Maximiliano Gazquez : > So we fixed it like this > > private static String fixEntityName

Re: [2.7.6] Unsupported protocol version: -76 with thin client.

2021-01-28 Thread Ilya Kasnacheev
Hello! I don't think you can use a more recent version of thin client with older server version. New thin client features usually require support from the server side as well. Regards, -- Ilya Kasnacheev ср, 27 янв. 2021 г. в 21:45, jjimeno : > Hello, > > Thanks for your answer. >

Re: [2.9.1]in SYS.METRICS View some data is always 0

2021-01-28 Thread Ilya Kasnacheev
cache: JDBC query may operate on zero or more caches. We could map these queries back to participating caches, but I don't see that we do that. You could still use sql.queries.user. metrics: SELECT * FROM sys.metrics WHERE name LIKE 'sql%' ORDER BY name; Regards, -- Ilya Kasnacheev ср, 27 янв

Re: Re[2]: Performance of Ignite as key-value datastore. C++ Thin Client.

2021-01-27 Thread Ilya Kasnacheev
Hello! It seems to me that you should never use messageQueueLimit - if you ever saturate your network it will break down your cluster. Regards, -- Ilya Kasnacheev ср, 27 янв. 2021 г. в 15:55, Zhenya Stanilovsky : > 1. Yes i know about this message, don`t pay attention (just remove it). I

Re: [2.9.1]in SYS.METRICS View some data is always 0

2021-01-27 Thread Ilya Kasnacheev
Hello! These values are per-node, as far as I know. Is it possible that you have connected to a node which does not handle any queries (as reducer, anyway)? Regards, -- Ilya Kasnacheev вт, 26 янв. 2021 г. в 13:48, 38797715 <38797...@qq.com>: > Hi, > > We found that SYS.METRICS

Re: Regarding Connection timed out observed during client startup

2021-01-27 Thread Ilya Kasnacheev
nodes. I don't think you should be diagnosing this issue by counting "Established outgoing communication connection" messages. Regards, -- Ilya Kasnacheev вт, 26 янв. 2021 г. в 23:38, VeenaMithare : > Hi Ilya, > > >>Generally a reducer node will need to connect to al

Re: Regarding Connection timed out observed during client startup

2021-01-26 Thread Ilya Kasnacheev
Hello! Generally a reducer node will need to connect to all map nodes while doing SQL query. You will not see this message if connection was already up. Regards, -- Ilya Kasnacheev вт, 26 янв. 2021 г. в 17:11, VeenaMithare : > Hi Ilya, > > >>I don't think it could have affe

Re: Ignite rebalancing when a server is rebooted w/ persistance enabled.

2021-01-26 Thread Ilya Kasnacheev
know it will only be used under specific circumstances, maybe you didn't get lucky here. Regards, -- Ilya Kasnacheev чт, 14 янв. 2021 г. в 20:02, maxi628 : > Sorry, I'm attaching the log here ignite_eviction.log > < > http://apache-ignite-users.70518.x6.nabble.co

Re: Regarding Connection timed out observed during client startup

2021-01-26 Thread Ilya Kasnacheev
successfully. Setting low TxTimeoutOnPartitionMapExchange will lead to aborting of all your transactions when PME happens. Why would you want that, as opposed to the default when transactions finish and PME happens? Regards, -- Ilya Kasnacheev ср, 20 янв. 2021 г. в 17:50, VeenaMithare : > >

Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

2021-01-25 Thread Ilya Kasnacheev
Hello! Why not: SELECT t.*, t._val from materials t INNER JOIN ... Regards, -- Ilya Kasnacheev чт, 21 янв. 2021 г. в 19:19, siva : > Hi, > > It's working fine in "select _val from mytesttable" query but in case of > sub > query or joins it's failing with an er

Re: Ignite with Docker on Raspberry Pi

2021-01-25 Thread Ilya Kasnacheev
Hello! This does look like some control.sh issue, such as that it is unable to complete request and activation never happens. Can you try to activate this node in some other way, such as connecting a thick client node to it and doing client.cluster().state(ACTIVE) from there? Regards, -- Ilya

Re: Ignite with Docker on Raspberry Pi

2021-01-25 Thread Ilya Kasnacheev
Hello! 52 seconds response time suggests you have a timeout here. Maybe you run out of memory when checkpoint page buffer is considered? Maybe your system starts swapping? Can you enable INFO logging and share complete log from your server node? Regards, -- Ilya Kasnacheev сб, 23 янв. 2021 г

Re: SQL strategy for Apache Ignite 3.0

2021-01-25 Thread Ilya Kasnacheev
3.0 is in a very early stage where only a handful of features are being prototyped. 2.x will remain being the workhorse in the observable future in my opinion. Regards, -- Ilya Kasnacheev пн, 25 янв. 2021 г. в 11:50, Lukas Eder : > Hello folks, > > I'm currently working on the jOOQ in

Re: Regarding Connection timed out observed during client startup

2021-01-20 Thread Ilya Kasnacheev
Hello! 5. Yes, it will do exponential backout based on those values. 6. I'm not sure what is the optimal value, it depends on your env. Regards, -- Ilya Kasnacheev ср, 20 янв. 2021 г. в 14:23, VeenaMithare : > Thanks Ilya, > > I will check if adding localhost improves the issue

Re: Regarding Connection timed out observed during client startup

2021-01-20 Thread Ilya Kasnacheev
Hello! It seems that you have network problems. It's possible that you have more than one network/interface and some combinations are causing problems. Please try to specify localHost property on every node pointing to a current actual external IP address of the node. Regards, -- Ilya

Re: Apache Ignite cluster node not loading all data from external DB

2021-01-20 Thread Ilya Kasnacheev
Hello! Do you see any exceptions in server nodes' logs? Can you please show your cache store configuration? Regards, -- Ilya Kasnacheev пт, 15 янв. 2021 г. в 22:30, gvaidya : > I am completely new to Apache Ignite and trying out some examples for > evaluating IMDG capabilities of Ign

Re: 2.8.1 : Continuous Query Initial query not returning any result sometimes

2021-01-19 Thread Ilya Kasnacheev
Hello! Does this happen if you just run this SQL query during client start-up? Can you reproduce this by bringing nodes down and back up? Regards, -- Ilya Kasnacheev вт, 19 янв. 2021 г. в 15:11, VeenaMithare : > No . Its a SQL query. > > > > -- > Sent from: http://apache-

Re: 2.8.1 : Continuous Query Initial query not returning any result sometimes

2021-01-19 Thread Ilya Kasnacheev
Hello! What kind of initial query do you have? Is it a scan query? Regards, -- Ilya Kasnacheev пн, 18 янв. 2021 г. в 19:44, VeenaMithare : > Hi Team, > > Our env : > Servers : 3 > Cache Configuration : REPLICATED > > In one of our clients, the continuous query - Initial

Re: Error:data-streamer-stripe....Timed out while waiting for schema update.

2021-01-19 Thread Ilya Kasnacheev
new BinaryTypeConfiguration(typeof (TestModel)) } }; (then set it to IgniteConfiguration.BinaryConfiguration) Especially if you're using DataStreamer and not Cache API. If that does not help, please provide a reproducer project which demonstrates the issue. Regards, -- Ilya Kasnacheev чт, 14 янв. 2021

Re: 2.8.1 : INFO org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi [] - Accepted incoming communication connection

2021-01-19 Thread Ilya Kasnacheev
Hello! Network may be relevant here. Can you try disconnect from your network (turn off wi/fi, unplug ethernet) and re-try? Regards, -- Ilya Kasnacheev вт, 19 янв. 2021 г. в 12:45, VeenaMithare : > The reproducer code works fine on my home mac ( I dont see the 100s of > logs)

Re: Partition mapping to Ignite node

2021-01-19 Thread Ilya Kasnacheev
Hello! I think that you should just use AffinityBackupFilter, turn exclNeighbors off. And please try to make it stateless/in sync between nodes. I can't imagine what happens otherwise. Regards, -- Ilya Kasnacheev пн, 18 янв. 2021 г. в 21:58, colinc : > We have found that the simplest

Re: 2.8.1 : INFO org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi [] - Accepted incoming communication connection

2021-01-19 Thread Ilya Kasnacheev
Hello! It's interesting, but I still can't reproduce the issue. Does not seem to happen to me. Maybe somebody else will chime in. Regards, -- Ilya Kasnacheev чт, 14 янв. 2021 г. в 20:47, VeenaMithare : > Hi Ilya, > > Please find the video recording of the issue I face. &g

Re: Client stuck on startup

2021-01-14 Thread Ilya Kasnacheev
Hello! It is possible that Linux is more lenient towards creation of massive number of threads. Regards, -- Ilya Kasnacheev ср, 13 янв. 2021 г. в 19:44, VeenaMithare : > Let me debug this a bit more. Also I will try and capture another set of > thread dumps when this occurs again. This

Re: incorrect partition map exchange behaviour

2021-01-14 Thread Ilya Kasnacheev
Hello! I have just looked at this issue today, and the relevant fix seems to be https://issues.apache.org/jira/browse/IGNITE-11147 Regards, -- Ilya Kasnacheev ср, 13 янв. 2021 г. в 20:26, tschauenberg : > Sorry about mixing the terminology. My post was meant to be about the

Re: 2.8.1 : INFO org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi [] - Accepted incoming communication connection

2021-01-14 Thread Ilya Kasnacheev
Hello! I am using your reproducer and I did not change dependencies, so I assume it's on 2.8.1 if your reproducer uses it. Yes, I'm running both server and client from the reproducer. Maybe you could record a screencast where you run it and get the result that you describe? Regards, -- Ilya

Re: [External]Re: Exporter usage of Ignite 2.8.0

2021-01-14 Thread Ilya Kasnacheev
Hello! This sounds like a correct approach. Regards, -- Ilya Kasnacheev чт, 14 янв. 2021 г. в 15:07, facundo.maldonado : > As far as I know it's not possible to call statically a non-factory > method, a > void method like PrometheusStatsCollector.createAndRegister(). >

Re: not able to change keyspace name when Using 3rd Party Persistence (Cassandra) Together with Ignite Native Persistence

2021-01-14 Thread Ilya Kasnacheev
Hello! Looks overall correct. Regards, -- Ilya Kasnacheev чт, 14 янв. 2021 г. в 11:43, xmw45688 : > 1) My testing shows that CassandraCacheStoreFactory is read from xml config > once if the cache name does not exist in Ignite Persistence. It appears > that > CassandraCacheStore

Re: 2.8.1 : INFO org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi [] - Accepted incoming communication connection

2021-01-13 Thread Ilya Kasnacheev
connection [locAddr=/0:0:0:0:0:0:0:1:47100, rmtAddr=/0:0:0:0:0:0:0:1:34890] Once on the server node after client restart. Regards, -- Ilya Kasnacheev вт, 12 янв. 2021 г. в 18:11, VeenaMithare : > This issue is also observed if two different clients exist on the same > box. > Steps to

Re: Client stuck on startup

2021-01-13 Thread Ilya Kasnacheev
Hello! But are they collected after the client node has already left? Not to mention that server nodes too have an obscene number of threads, and as such are vulnerable to the same problem. Regards, -- Ilya Kasnacheev ср, 13 янв. 2021 г. в 18:25, VeenaMithare : > Hello, > > Thread

Re: incorrect partition map exchange behaviour

2021-01-13 Thread Ilya Kasnacheev
Hello! Does it happen to work on 2.9.1, or will fail too? I recommend checking it since I vaguely remember some discussions about late affinity assignments fix. Regards, -- Ilya Kasnacheev сб, 9 янв. 2021 г. в 03:11, tschauenberg : > Here's my attempt to demonstrate and also provide l

Re: Client stuck on startup

2021-01-13 Thread Ilya Kasnacheev
Hello! Please provide full thread dump from server nodes. Of course, you will need to kill client JVM first. Regards, -- Ilya Kasnacheev ср, 13 янв. 2021 г. в 17:09, VeenaMithare : > > a. If you see the thread dump, it shows these locked synchronizers >Locked ownable sync

Re: Client stuck on startup

2021-01-13 Thread Ilya Kasnacheev
Hello! I'm not sure what happens on the server nodes. Restarting the JVM with this client should be enough. Regards, -- Ilya Kasnacheev вт, 12 янв. 2021 г. в 19:14, VeenaMithare : > Okay, thanks Ilya . After it gets this issue, the app doesnt startup till > I > restart my ser

Re: Client stuck on startup

2021-01-12 Thread Ilya Kasnacheev
Hello! Shutdown hook means that JVM decided to stop. Probably due to thread creation error if you ask me. It seems that the node has never finished initialization, judging by that log. Regards, -- Ilya Kasnacheev пн, 11 янв. 2021 г. в 19:25, VeenaMithare : > >>Try to use some

Re: Node Segmentation Error

2021-01-12 Thread Ilya Kasnacheev
=60, offheap=17.0GB, heap=48.0GB] It's hard to say what caused this issue. Maybe there was indeed a short-lived network glitch. Regards, -- Ilya Kasnacheev пт, 8 янв. 2021 г. в 09:23, BEELA GAYATRI : > Hi Ilya, > > > > PFA., all 16 nodes logs and the node8 h

Re: Application closing after java.net.SocketTimeoutException

2021-01-12 Thread Ilya Kasnacheev
Hello! I don't think anyone is working on this issue currently. You may try to tackle it yourself if you wish, submit a patch for inclusion. Regards, -- Ilya Kasnacheev сб, 9 янв. 2021 г. в 11:27, rakshita04 : > we increased the "failureDetectionTimeout" to 4 minutes in our xml

Re: not able to change keyspace name when Using 3rd Party Persistence (Cassandra) Together with Ignite Native Persistence

2021-01-12 Thread Ilya Kasnacheev
ant to your use case, I'm just reminding you to take care of its life cycle. Does this change work for you? Regards, -- Ilya Kasnacheev вт, 12 янв. 2021 г. в 06:30, xmw45688 : > Thanks for your recommendations! > 1) The dynamicConfigurationReload is not able to reset once > cacheStoreFacto

Re: Client stuck on startup

2021-01-11 Thread Ilya Kasnacheev
Hello! I don't know since it's impossible to check thread dump with such a high number of threads. I suspect it's possible. I also don't see any log for client, only thread dump. Can you attach it as well? Try to use some realistic value such as 64. Regards, -- Ilya Kasnacheev пн, 11 янв

Re: Can we disable/enable WAL of a cache with thin client

2021-01-11 Thread Ilya Kasnacheev
Hello! You should see the WAL disable/enable messages in the logs of server nodes: Global state for group durability has changed [name=MY_CACHE, enabled=true] It's on INFO log level. Regards, -- Ilya Kasnacheev чт, 7 янв. 2021 г. в 09:19, Naveen : > Thanks Stephen > > How do we ve

Re: [External]Re: Exporter usage of Ignite 2.8.0

2021-01-11 Thread Ilya Kasnacheev
Hello! It should be doable: just transfer these object instantiations and static method calls to Spring XML. Make sure that they happen in the correct order. I genuinely don't know if there's an easier way, I expect there's not. Regards, -- Ilya Kasnacheev ср, 6 янв. 2021 г. в 20:05

Re: Client stuck on startup

2021-01-11 Thread Ilya Kasnacheev
Hello! Are you sure that you really need a 1024 thread striped pool? What happens if it's only 16? Regards, -- Ilya Kasnacheev пн, 11 янв. 2021 г. в 17:55, VeenaMithare : > HI , > > One of the clients on my windows box sometimes gets stuck up on startup . > I > see this in

Re: Continuous Queries and SQL

2021-01-11 Thread Ilya Kasnacheev
Hello! Currently, the only way to do efficient parent-child join is SQL since it has secondary indexes. I guess you need to trigger SQL from continuous query. Regards, -- Ilya Kasnacheev пн, 11 янв. 2021 г. в 14:44, Goncalo Carvalho : > Hi, > > I'm looking for advice on what is

Re: Failed to generate REDUCE query. Data table found:"

2021-01-07 Thread Ilya Kasnacheev
Hello! Indeed it seems like a bug. I have filed a ticket: https://issues.apache.org/jira/browse/IGNITE-13961 Regards, -- Ilya Kasnacheev ср, 6 янв. 2021 г. в 14:18, siva : > Hi, > please find the below given cache config and models class details. > > cache > config: > htt

Re: Node Segmentation Error

2021-01-07 Thread Ilya Kasnacheev
Hello! Do you also have logs from other server nodes? Here, I don't see anything particularly suspicious. Maybe there indeed were some short-term network problems? Regards, -- Ilya Kasnacheev ср, 6 янв. 2021 г. в 15:04, BEELA GAYATRI : > Dear Team, > > > > We are running 1

Re: Re[4]: Questions related to check pointing

2021-01-07 Thread Ilya Kasnacheev
Hello! I think it's a sensible explanation. Regards, -- Ilya Kasnacheev ср, 6 янв. 2021 г. в 14:32, Raymond Wilson : > I checked our code that creates the primary data region, and it does set > the minimum and maximum to 4Gb, meaning there will be 1,000,000 pages in > th

Re: graceful shutdown for C++ applications

2021-01-07 Thread Ilya Kasnacheev
Hello! This will happen when this file is deleted while the instance is running. Not sure who deleted it. Maybe you tried to start another node with the same consistent id in the background? You should avoid calling setActive() every time since it will lead to data loss. Regards, -- Ilya

Re: not able to change keyspace name when Using 3rd Party Persistence (Cassandra) Together with Ignite Native Persistence

2021-01-07 Thread Ilya Kasnacheev
in the Cassandra cache store, e.g. dynamicConfigurationReload={true/false} Please note that you also need to factor in Spring when updating data source life cycle = i.e. the data source may come from local Spring context on each node. Feel free to file a ticket and contribute. Regards, -- Ilya

Re: not able to change keyspace name when Using 3rd Party Persistence (Cassandra) Together with Ignite Native Persistence

2021-01-05 Thread Ilya Kasnacheev
may improve Cassandra cache store to track environment changes. Regards, -- Ilya Kasnacheev вт, 5 янв. 2021 г. в 04:38, xmw45688 : > Hi Ilya, > > Thanks for your guidance and happy new year! Sorry for late catchup. > > You are right, Ignite Native Persistence does track the c

Re: [ANNOUNCE] Apache Ignite 2.9.1 Released

2021-01-04 Thread Ilya Kasnacheev
Hello! Don't see why you can't upgrade 2.7.6 -> 2.9.1 straight. Regards, -- Ilya Kasnacheev пн, 4 янв. 2021 г. в 15:17, ihalilaltun : > Hi Yaroslav, > > We are at v2.7.6 and want to upgrade the latest version, do you have any > directives for this kind of upgrade method

Re: Service grid performance downgrade after enabling persistence

2021-01-04 Thread Ilya Kasnacheev
Hello! I don't think this should happen. What do thread dumps show? Regards, -- Ilya Kasnacheev чт, 31 дек. 2020 г. в 07:47, xingjl6280 : > Hi team, > > Just wandering what happened behind a remote service call. > Is there anything persisted for a service call? Or the

Re: Feature request: On demand thread dumps from Ignite

2021-01-04 Thread Ilya Kasnacheev
Hello! I guess you could find a way to run ThreadDumpPrinterTask or better yet a VisorThreadDumpTask. I guess we should have thread dumping in the upcoming ignitectl. Can you file a ticket? Regards, -- Ilya Kasnacheev вт, 29 дек. 2020 г. в 10:42, Raymond Wilson : > Hi Zhenya, > &g

Re: scanquery is not working, however SQL select and retrieving a single records works fine

2021-01-04 Thread Ilya Kasnacheev
and recreate this cache. Regards, -- Ilya Kasnacheev чт, 31 дек. 2020 г. в 10:20, Naveen : > HI > > Scanquery on a cache is not working, but simple GET with a key and select > statement on SQL console working fine. This is the error I get on the > client > side > > Ignit

Re: Re[4]: Questions related to check pointing

2021-01-04 Thread Ilya Kasnacheev
Hello! I guess it's pool.pages() * 3L / 4 Since, counter intuitively, the default ThrottlingPolicy is not ThrottlingPolicy.DISABLED. It's CHECKPOINT_BUFFER_ONLY. Regards, -- Ilya Kasnacheev чт, 31 дек. 2020 г. в 04:33, Raymond Wilson : > Regards this section of c

Re: Error Codes

2021-01-02 Thread Ilya Kasnacheev
l, we need to decide what's our target. Is it log, or is it API? Regards, -- Ilya Kasnacheev пт, 1 янв. 2021 г. в 02:07, Michael Cherkasov : > Hi folks, > > I was thinking how we can simplify Ignite clusters troubleshooting and the > best of course if the cluster can do self-hea

Re: Enabling cache statistics does not seems to work cache created thru SQL with a cache template

2020-12-31 Thread Ilya Kasnacheev
Hello! I think you need to check the new metrics: https://ignite.apache.org/docs/latest/monitoring-metrics/new-metrics You can then export them with OpenCensus. Regards, -- Ilya Kasnacheev вт, 29 дек. 2020 г. в 09:51, Naveen : > Yeah, it works > > > {"successStatus":0

Re: Moving caches between data regions

2020-12-31 Thread Ilya Kasnacheev
Hello! It is not possible, you may create a new cache in a desired data region and then migrate your data. Regards, -- Ilya Kasnacheev чт, 31 дек. 2020 г. в 11:34, Raymond Wilson : > I have an Ignite cluster with a collection of caches spread across two > data regions, both conf

Re: Is Model class OR a value object mandatory for inserting the data thru non SQL API

2020-12-30 Thread Ilya Kasnacheev
Hello! Sounds correct to me. Regards, -- Ilya Kasnacheev ср, 30 дек. 2020 г. в 14:23, Naveen : > On the same email chain what is the best way to create a cache, which > should work for both KV, Binary and SQL CREATE TABLE IF NOT EXISTS > curated.TEST_1_COPY ( test_id VARCHAR, test_f

Re: Application closing after java.net.SocketTimeoutException

2020-12-30 Thread Ilya Kasnacheev
Hello! I can see the following ticket in our JIRA: https://issues.apache.org/jira/browse/IGNITE-13504 However, I don't see any obvious workaround from Ignite side. Maybe it may be configured in your network stack. Regards, -- Ilya Kasnacheev пн, 21 дек. 2020 г. в 19:40, rakshita04 : >

Re: Cluster hangs at times when making calls with Ignite thin client Java, but works thru SQLLine console

2020-12-28 Thread Ilya Kasnacheev
Hello! Maybe it is related to https://issues.apache.org/jira/browse/IGNITE-13863? If it is not, please provide thread dumps from nodes in the cluster. Regards, -- Ilya Kasnacheev чт, 24 дек. 2020 г. в 14:36, Naveen : > HI > > We do use Ignite 2.8.1 and use Java thin client for a

Re: Enabling cache statistics does not seems to work cache created thru SQL with a cache template

2020-12-28 Thread Ilya Kasnacheev
quot;response":{"reads":1,"writes":1,"hits":0,"misses":1}} % Regards, -- Ilya Kasnacheev чт, 24 дек. 2020 г. в 14:57, Naveen : > HI > > Created a cache template me

Re: Populate table created by JDBC

2020-12-28 Thread Ilya Kasnacheev
Hello! Have you also tried adding wrap_value=false parameter to your DDL statement? OtherwiseIgnite will assume you have a one-field POJO as a value. Regards, -- Ilya Kasnacheev пн, 28 дек. 2020 г. в 14:16, Surkov.Aleksandr : > Hi igniters! > > I have created a table using JDBC. An

Re: DataBricks Spark/Scala Opportunity

2020-12-28 Thread Ilya Kasnacheev
Hello! Please avoid discussion of topics unrelated to Apache Ignite usage. This is not a general-purpose bulletin board. Thanks, -- Ilya Kasnacheev вт, 22 дек. 2020 г. в 21:21, sri hari kali charan Tummala < kali.tumm...@gmail.com>: > Hi Apache Ignite Community, >

Re: Questions related to check pointing

2020-12-28 Thread Ilya Kasnacheev
value, meaning that checkpoints will be purely sequential without any pauses between them. 3. I don't think that default throttling mechanism will emit any warnings. What do you see in thread dumps? Regards, -- Ilya Kasnacheev ср, 23 дек. 2020 г. в 12:48, Raymond Wilson : > Hi, > > We

Re: configuring DBEaver to connect to Ignite cluster with SSL enabled

2020-12-28 Thread Ilya Kasnacheev
Hello! I believe I told you what to do specifically. You can also just append all of your SSL-related settings to JDBC connection string, like you will do with sqlline tool. Regards, -- Ilya Kasnacheev пн, 28 дек. 2020 г. в 10:41, Naveen : > HI Ilya > > Almost there, but still not c

Re: configuring DBEaver to connect to Ignite cluster with SSL enabled

2020-12-24 Thread Ilya Kasnacheev
Hello! This may be caused by https://issues.apache.org/jira/browse/IGNITE-11312 You can either wait for 2.9.1 which will fix it, or prepend all properties' names with "ignite.jdbc." Regards, -- Ilya Kasnacheev чт, 24 дек. 2020 г. в 14:10, Naveen : > I did specify SSLContex

Re: How to extracts value from json string in .Net Ignite

2020-12-24 Thread Ilya Kasnacheev
Hello! Yes, it should work like that. Templates don't do anything until you create a cache with them. You can also create a simple empty table instead of putting it in a template. Regards, -- Ilya Kasnacheev чт, 24 дек. 2020 г. в 12:03, siva : > Hi, > Thank you all for help. >

Re: Ignite Custom SQL functions not working with Generic function return type

2020-12-23 Thread Ilya Kasnacheev
Hello! 65 is RAWTOHEX. You can't return Object from the function. You have to return some supported SQL type. Regards, -- Ilya Kasnacheev ср, 23 дек. 2020 г. в 18:50, siva : > Hi, > I am using .Net Client and Server app with Ignite v2.7.6. > > i have created custom sql funct

Re: configuring DBEaver to connect to Ignite cluster with SSL enabled

2020-12-23 Thread Ilya Kasnacheev
Hello! Did you also specify a SSL socket factory? Regards, -- Ilya Kasnacheev ср, 23 дек. 2020 г. в 18:18, Naveen : > I do this entry in the server config > > > class="org.apache.ignite.configuration.ClientConnectorConfiguration"> > >

Re: not able to change keyspace name when Using 3rd Party Persistence (Cassandra) Together with Ignite Native Persistence

2020-12-23 Thread Ilya Kasnacheev
Hello! Why do you think that change should be on Ignite Persistence side? You said yourself that Ignite Persistence tracks the changes in class definition, it's the Cassandra store that does not. Regards, -- Ilya Kasnacheev ср, 23 дек. 2020 г. в 00:17, xmw45688 : > Thanks for your suggest

Re: How to extracts value from json string in .Net Ignite

2020-12-22 Thread Ilya Kasnacheev
Hello! I think you need to specify your JAR file with the -JvmClasspath argument of ignite.exe or corresponding IgniteConfiguration class property. Regards, -- Ilya Kasnacheev вт, 22 дек. 2020 г. в 11:03, siva : > Hi, > I have added custom function jar file and added cache configu

Re: How to extracts value from json string in .Net Ignite

2020-12-21 Thread Ilya Kasnacheev
1: jdbc:ignite:thin://localhost/"MyTemplateFu> select custom_json_value('','') foo; ++ | FOO | ++ | Test | +----+ 1 row selected (0,108 seconds)

Re: configuring DBEaver to connect to Ignite cluster with SSL enabled

2020-12-21 Thread Ilya Kasnacheev
Hello! Looks OK. Did you also enable SSL in the ClientConnectorConfiguration? Regards, -- Ilya Kasnacheev пн, 21 дек. 2020 г. в 16:44, Naveen : > I did mention all these 5 properties mentioned, but still fails with the > following message Failed to read incoming message (not enoug

Re: How to extracts value from json string in .Net Ignite

2020-12-21 Thread Ilya Kasnacheev
Hello! I don't think that you need to qualify functions with schema name. Please try it verbatim. You can specify default schema in the connection string, or alternatively try to do actual select from that table: https://ignite.apache.org/docs/latest/SQL/JDBC/jdbc-driver Regards, -- Ilya

Re: not able to change keyspace name when Using 3rd Party Persistence (Cassandra) Together with Ignite Native Persistence

2020-12-21 Thread Ilya Kasnacheev
Hello! I think that maybe you could try coding such a cache store which will update this information. It's just that the default Cassandra store doesn't seem to. Regards, -- Ilya Kasnacheev сб, 19 дек. 2020 г. в 05:17, xmw45688 : > Thanks for your confirmation, Ilya. > > I do have

Re: configuring DBEaver to connect to Ignite cluster with SSL enabled

2020-12-21 Thread Ilya Kasnacheev
properties, the JSSE property javax.net.ssl.trustStore is used. sslTrustCertificateKeyStorePassword Trust store password. If sslMode is require and the trust store password isn’t specified in the Ignite properties, the JSSE property javax.net.ssl.trustStorePassword is used. Regards, -- Ilya Kasnacheev

Re: Failed to send message to remote node error

2020-12-18 Thread Ilya Kasnacheev
Hello! Please provide complete log files from both nodes. These errors may be a sign of node leaving some time ago. Regards, -- Ilya Kasnacheev чт, 17 дек. 2020 г. в 19:43, rakshita04 : > Hi Teams, > > I am using apache-ignite 2.8.0 version for our C++ applications. >

Re: How to extracts value from json string in .Net Ignite

2020-12-18 Thread Ilya Kasnacheev
, -- Ilya Kasnacheev чт, 17 дек. 2020 г. в 20:14, siva : > Hi All, > I have .Net ClientServer Ignite Application.And Table Model annotation with > QuerySQLField. > In Tables some of column contains json string. > > How to extracts value from json string field in query? > > *for

Re: partition-exchanger system-critical thread blocked

2020-12-18 Thread Ilya Kasnacheev
Hello! I don't think running client nodes in kubernetes is supported. You can only use thin client inside k8s if your server nodes are outside. Regards, -- Ilya Kasnacheev вт, 15 дек. 2020 г. в 20:25, Gangaiah Gundeboina : > Hi Ilya, > > Our server nodes not running in kubernetes, s

Re: not able to change keyspace name when Using 3rd Party Persistence (Cassandra) Together with Ignite Native Persistence

2020-12-16 Thread Ilya Kasnacheev
Hello! This is currently by design that cache configuration, of which cache store configuration is a part, cannot be changed after the cache is started. Regards, -- Ilya Kasnacheev ср, 16 дек. 2020 г. в 04:29, xmw45688 : > Thank you for your answer. I'm able to load the data from Cassan

Re: partition-exchanger system-critical thread blocked

2020-12-15 Thread Ilya Kasnacheev
Hello! I think it is only available in 2.9.0. Prior to 2.9.0, clients outside of kubernetes may not connect to k8s cluster. Regards, -- Ilya Kasnacheev вт, 15 дек. 2020 г. в 14:55, Gangaiah Gundeboina : > Hi Ilya, > > We are using 2.7.6 version, is it available in the version. >

Re: partition-exchanger system-critical thread blocked

2020-12-15 Thread Ilya Kasnacheev
behind-nat Regards, -- Ilya Kasnacheev пн, 14 дек. 2020 г. в 21:07, Gangaiah Gundeboina : > Hi Ilya, > > We have configured atomictyMode 'ATOMIC' for all caches it's not > transactional, below is our cache configuration for one of the caches. > > ###

Re: Why does TextQuery failed to find result

2020-12-14 Thread Ilya Kasnacheev
Hello! Ok, I see. Seems I have answered in a different thread. Regards, -- Ilya Kasnacheev пн, 14 дек. 2020 г. в 19:15, siva : > Hi, > Not sure why format code ,images are not receiving in email. > Please find > Here is the Nabble code link > < > http://apache-

Re: Ignite cache TextQuery on JsonString data Field

2020-12-14 Thread Ilya Kasnacheev
Hello! I'm not sure that our text indexing will tokenize your JSON correctly. Can you try just putting some simple word in that field and trying text search? Regards, -- Ilya Kasnacheev пн, 30 нояб. 2020 г. в 16:39, siva : > Hi All, > I am using ApacheIgnite2.7.6 .Net Core.And I hav

Re: partition-exchanger system-critical thread blocked

2020-12-14 Thread Ilya Kasnacheev
Hello! Can you provide stack trace from that thread? No, this is a different thread than exchange worker. I don't think that cluster is supposed to fail clients in this case. We have timeout for transactions waiting on PME now. Regards, -- Ilya Kasnacheev сб, 12 дек. 2020 г. в 10:23

Re: Why does TextQuery failed to find result

2020-12-14 Thread Ilya Kasnacheev
Hello! Unfortunately I can't see any image here. Please provide a link or plain text. Regards, -- Ilya Kasnacheev пн, 14 дек. 2020 г. в 17:55, siva : > Hi, > Actually I am creating Indexing and creating cache with typeof(interface) > which is implemented by model class. > >

Re: Regarding Partition Map exchange Triggers

2020-12-14 Thread Ilya Kasnacheev
Hello! cache.close() will not cause a PME. cache.destroy() (or DROP TABLE) will. Regards, -- Ilya Kasnacheev пн, 14 дек. 2020 г. в 12:39, VeenaMithare : > >>Looking at your stack traces it seems that the cache you accessed in the > SQL query was stopped right before the new

Re: Ignite cache TextQuery on JsonString data Field

2020-12-14 Thread Ilya Kasnacheev
Hello! Unfortunately, nothing is visible in your e-mails. Please provide images/files as links. Regards, -- Ilya Kasnacheev пн, 30 нояб. 2020 г. в 20:00, siva : > Hi, > please find the Cache configuration details give below. > > > > > > > > -- > Sent from: ht

Re: Re[2]: [2.9.0]NPE on invoke IgniteCache.destroy()

2020-12-14 Thread Ilya Kasnacheev
Hello! Why don't you do it yourself if you have the understanding of the issue? It seems you're the only one ATM. Regards, -- Ilya Kasnacheev ср, 9 дек. 2020 г. в 09:27, Zhenya Stanilovsky : > looks like we deactivate pageMem concurrently with cp pageWrite, plz > someone fill the

Re: How do we set statisticsEnabled for cache created thru JDBC SQL like create table

2020-12-14 Thread Ilya Kasnacheev
Hello! You can define a cache template, use this template to create your tables. https://ignite.apache.org/docs/latest/configuring-caches/configuration-overview#cache-templates Regards, -- Ilya Kasnacheev пн, 14 дек. 2020 г. в 14:04, Naveen : > HI > > We do have created cache

Re: Native persistence and upgrading

2020-12-14 Thread Ilya Kasnacheev
Hello! All of 2.x are compatible, meaning you can upgrade from 2.x to 2.y, y > x, while keeping your persistence files. Yes, I think we should document this somewhere: https://issues.apache.org/jira/browse/IGNITE-13851 Regards, -- Ilya Kasnacheev пн, 14 дек. 2020 г. в 16:09, xero : >

Re: Why does TextQuery failed to find result

2020-12-14 Thread Ilya Kasnacheev
): https://apacheignite-net.readme.io/docs/sql-queries#configuring-sql-indexes-using-attributes I just don't see how your GetOrCreateCache will work given that the cache will always be created, and that it's too late to add cache cfgs to client config once it's already started. Regards, -- Ilya

Re: streaming behaviour with streamingPerNodeBufferSize parameter

2020-12-11 Thread Ilya Kasnacheev
Hello! Please check out https://ignite.apache.org/docs/latest/data-streaming and IgniteDataStreamer documentation for the meaning of those settings. Regards, -- Ilya Kasnacheev чт, 10 дек. 2020 г. в 21:44, shivakumar : > Hi > I'm trying to do SQL stream to load data to ignite cluster f

Re: Regarding long running transaction

2020-12-11 Thread Ilya Kasnacheev
Hello! It is possible that the thread was terminated before you have issued commit() or rollback() on that transaction. ACTIVE state means that you haven't. Regards, -- Ilya Kasnacheev чт, 10 дек. 2020 г. в 16:53, VeenaMithare : > Hi , > > I see this in my transaction log : > 2

Re: Unable to free disk space after keys are removed in ignite 2.7.0

2020-12-11 Thread Ilya Kasnacheev
Hello! You may delete old records, then this disk space will be reused when adding new records. Regards, -- Ilya Kasnacheev чт, 10 дек. 2020 г. в 19:08, VeenaMithare : > Hi Ilya, > > I have a question related to this : > >>Then, WAL will usually only grow and

Re: ThinClient issues

2020-12-09 Thread Ilya Kasnacheev
Hello! I think you need a core pool of server nodes, larger pool of clients with client connector to handle thin client connections, and supply all these clients' addressed to thin clients. Regards, -- Ilya Kasnacheev чт, 3 дек. 2020 г. в 23:29, Wolfgang Meyerle < wolfgang.m

Re: Why does TextQuery failed to find result

2020-12-09 Thread Ilya Kasnacheev
Hello! Please show your code. Regards, -- Ilya Kasnacheev ср, 2 дек. 2020 г. в 15:14, siva : > Hi, > Thanks for the reply. > I am already using Thick client.But not able to get result from Cache > Query.And it's returning empty result. > > Quite i didn't understand w

Re: subscribe

2020-12-09 Thread Ilya Kasnacheev
Hello! Please use user-subscr...@ignite.apache.org Regards, -- Ilya Kasnacheev вс, 6 дек. 2020 г. в 14:28, Naveen Kumar : > Please subscribe me > > -- > Thanks & Regards, > Naveen Bandaru >

<    1   2   3   4   5   6   7   8   9   10   >