Application closing after java.net.SocketTimeoutException

2020-12-21 Thread rakshita04
Hi Team, We are using ignite for persistent data between two nodes running on separate machines. sometimes our application stops with below error logs and exception- [01:18:39,477][SEVERE][tcp-disco-srvr-[:47500]-#3][TcpDiscoverySpi] Failed to accept TCP connection. java.net.SocketTimeoutException

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

2020-12-21 Thread siva
Hi, But i am facing same issue. not sure missing any configuration? 1.added jar file in libs folder 2.added function in default config at ignite installation config directory. 3.added function in both client and server nodes xml file. I have restarted my application .Net client and server nodes.

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

2020-12-21 Thread Ilya Kasnacheev
Hello! Seems to work for me: ~/Downloads/apache-ignite-slim-2.9.0-bin% mkdir -p org/mycustomsqlfunction ~/Downloads/apache-ignite-slim-2.9.0-bin% cd org/mycustomsqlfunction ~/Downloads/apache-ignite-slim-2.9.0-bin/org/mycustomsqlfunction% cat > MyCustomSQLFunction.java package org.mycustomsqlfunc

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

2020-12-21 Thread siva
Hi, i have tried like below in both case i am getting error 1.Without cache name 0: jdbc:ignite:thin://127.0.0.1/> select Custom_Json_Value("",""); Error: Failed to parse query. Function "CUSTOM_JSON_VALUE" not found; SQL statement: select Custom_Json_Value("","") [90022-197] (state=42000,code=

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 enough data). Is

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

2020-12-21 Thread Naveen
I did mention all these 5 properties mentioned, but still fails with the following messageFailed to read incoming message (not enough data).Is there is something I am missing hereThanks -- Sent from: http://apache-ignit

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 Kasnach

RE: Getting error Node is out of topology (probably, due to short-time network problems)

2020-12-21 Thread BEELA GAYATRI
Hi Igor, We have Observed the CPU and memory utilizations on the servers where these nodes are running and the CPU utilizations are very less . Still we are observing the issue (sometimes we are getting jvm pauses after that node is getting out of topology, sometimes without jvm pauses no

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

2020-12-21 Thread siva
Hi, I have created and defined customsqlfunction IGNITE_HOME=apache-ignite-2.7.6-bin added Function jar at apache-ignite-2.7.6-bin\libs And added cache configuration in default-config

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 a follow-up

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

2020-12-21 Thread Ilya Kasnacheev
Hello! You just need to set the following connection properties in dbeaver's connection settings: https://ignite.apache.org/docs/latest/SQL/JDBC/jdbc-driver sslMode Enables SSL connection. Available modes: - require: SSL protocol is enabled on the client. Only SSL connection is avail