Re: Test Ignite Client

Hi Humphrey, Consider forcing server mode on the client https://apacheignite.readme.io/docs/clients-vs-servers#section-forcing-server-mode-on-client-nodes. Another option is to enforce bean definition registration order. You could explicitly order configurations so that server bean gets

Re: Adding custom processor in Ignite Node

Hi, 1) Why do you want to implement your own processor? 2) Have you considered using Ignite's compute grid and other features instead? If yes, what problems do you anticipate? Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Re:Re: Node can not join cluster

As you could see in the logs [09:06:26,657][WARNING][main][TcpDiscoverySpi] Node has not been connected to topology and will repeat join process. Check remote nodes logs for possible error messages. Note that large topology may require significant time to start. Increase

Re: Ignite node getting stopped by itself

Hi, Could you please share full logs so that the surroundings of the problem could be checked? Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: thread number tradeoff

Hi, I think setting appropriate thread pools size to 2 should work for you. Just check which thread pools need to be adjusted depending on your use case. It's worth noting that having 8 nodes per machine you are sacrificing throughput for response time. Kind regards, Alex -- Sent from:

Re: SQL Count(*) returns incorrect count

Hi, For an example of table creation via native API please check https://apacheignite-sql.readme.io/docs/schema-and-indexes#section-overview. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Node can not join cluster

Hi, >From logs, I can see that the node was not able to connect to the cluster due to a timeout issue. It could be caused by GC or network issue. Please check the logs of other nodes, especially of the coordinator node fcc47ef7-f080-4f88-93f5-2bc221dd1fcf. Kind regards, Alex -- Sent from:

Re: Trying to pass memory arguments to Ignite.sh - ./bin/ignite.sh -J -Xms2g -Xmx10g -v config/IgnitePOC-NoCacheInfo.xml

Hi, Yes, you are right. Probably -J"-Xms4g -Xmx8g" should have worked too. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Cache listener for new keys

Hello, FYI. There is a ticket that should introduce the desired behavior. https://issues.apache.org/jira/browse/IGNITE-425 Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Is it possible to change notify event for continuous query

Hi, As for now, it's not possible out of the box. There is a correponding ticket for that https://issues.apache.org/jira/browse/IGNITE-425. Meanwhile, you could pass the results via an auxiliary caches and configure corresponding continuous queries for them. Kind regards, Alex -- Sent from:

Re: Cache listener for new keys

Hello, OK. How do you use these registries after that? I don't think that there is a need to keep version in the key. Ignite guarantees that a cache contains the latest version at each moment. Probably the only things you need to keep in the key object are id and type. Even if you need to handle

Re: how to set SQL timeout for the cluster?

Hi, For now, it's possible to set timeout only on the query based level, i.e. setTimeout(). You could create a utility factory method for the Query instances that would set up the required timeout and use it throughout the code. Kind regards, Alex -- Sent from:

Re: Count mismatch for a cache between ignitevisor & Sqlline

Hi, Could you please check, what result would produce a regular Ignite SqlFieldsQuery? Would it be the same result as for Sqlline? Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Failed to instantiate Spring XML application context

Hi, Looks like you don't have required Ignite libs on your classpath. Please check your classpath for its presence. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: why the records not zero after execute "cache -clear"

Hello, I was not able to reproduce the problem on my side. Could there be a chance that you had stopped a server node with persistence before calling cache -clear? Is the problem reproducible? How do you stop nodes? Is it kill -9 or something else? Please share Ignite configuration used for

Re: Cache listener for new keys

I mentioned continuous queries and listener filters because you probably have some logic around keys that could be handled by these means. As an option, you could utilize Ignite messaging. Of course, you could have a separate cache containing only keys that you would update. Could you describe

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, Please share the full log. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Re:Re: Re:Re: index about jdbc thin mode

Hi, Your configuration perfectly works on my side. Make sure that you are connecting to the server node with an appropriate configuration of indexes. I'm afraid, that without a complete reproducer it's not possible to figure out the reason. Kind regards, Alex -- Sent from:

Re: Re:Re: index about jdbc thin mode

Hi, Actually, the same exact code I sent you works as expected on my side. Could you share a reproducer so that I can take a look at it? At least, please Ignite configuration and how you run explain query via thin JDBC driver. Kind regards, Alex -- Sent from:

Re: index about jdbc thin mode

Hi, Just to clarify, the same result I have while running using the thin JDBC driver. Class.forName("org.apache.ignite.IgniteJdbcThinDriver"); try ( Connection conn = DriverManager.getConnection("jdbc:ignite:thin://localhost:10800"); PreparedStatement

Re: index about jdbc thin mode

Hi, Not sure, what's wrong with your code. Either IX_T_BD_StatusFid or IX_T_BD_CUSTOMER should have been taken. I removed JPA related annotations and checked your code, it gave me the following plan: [[SELECT __Z0.FID AS __C0_0, __Z0.FNUMBER AS __C0_1 FROM

Re: Can the cache key and affinity key be different

Hi, To collocate A and B with C you need to introduce custom key classes for A and B that will include @AffinityKeyMapped annotation on a C's ID field. An example of how to implement such a key could be found here

Re: Ignite in docker (Native Persistence)

Hi, You need to create volumes and map them to the ${IGNITE_HOME}/work/db or any other path that you might have specified via setPersistentStorePath. These volumes should outlive the Ignite containers and thus it will be possible to reuse them on restart. It's worth trying docker-compose,

Re: Web Console on Kubernetes Cluster

Hi, Please take a look at this documentation section https://apacheignite.readme.io/docs/resource-injection. If you are going to inject @SpringResource you need to adopt IgniteSpringBean. Make sure that you have checked its JavaDoc before using it because some caution should be taken due to its

Re: Number of open file handles keeps on increasing on Ignite node on adding a new cache

Hi, Do you use Ignite Persistent Store? If that's the case, then for each cache partition there is a corresponding file created. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: QueryEntity Based Configuration

Hi, Crossposting from the mail list, since looks like something is broken and some messages don't get it here. On Mon, Nov 27, 2017 at 1:48 AM, daniels wrote: Hi dear afedotov.I have a question,related to your claim "Indexes for nested collections and in particular for maps are not

Re: Adding user attribute after node has started

Hi, Node attributes can be added only before node startup. To start a cache on specific nodes you could use CacheConfiguration#setNodeFilter Ignite#compute(org.apache.ignite.cluster.ClusterGroup) accepts a cluster group which could be, for example ignite.cluster().forAttribute(...). As well,

Re: QueryEntity Based Configuration

You could introduce an additional Model data cache that will store *data* for each Model as it is usually done in a regular ORM systems (http://docs.jboss.org/hibernate/orm/5.2/userguide/html_single/Hibernate_User_Guide.html#collections-map) The key for the Model data cache should include the key

Re: QueryEntity Based Configuration

Hi, Indexes for nested collections and in particular for maps are not supported. If you need indexes for data please consider analyzing and refactoring the problem domain. You could either flatten map so that its keys become fields of the Model or move data into separate cache/caches related to

Re: No Error/Exception on Data Loss ?

Hi, If a client is up before a node leaves the cluster then it could listen to org.apache.ignite.events.EventType#EVT_NODE_LEFT and org.apache.ignite.events.EventType#EVT_NODE_FAILED events. If a client may start after a possible server node failure, then there is no solution out of the box but

Re: Ignite Transaction with Locks but not SERIALIZABLE user case.

Hello, increment/decrement is a read-modify-write operation, so to achieve the desired behavior you need to lock the key and perform the operation under that lock. So you need to use a transaction mode and isolation level that meet the requirements. For this case, you could use the approach

Re: map types in Cassandra

Hi, It's hard to say for sure what is the problem without the logs. But obviously, it's a configuration issue. Please take a look at the corresponding documentation https://apacheignite-mix.readme.io/docs/ignite-with-apache-cassandra

Re: insert data took too much time

Hi, Did you have a chance to compare the results with cache.put performance? You mentioned that you set writeBehind to true, so do you have a cache store configured? What is the INSERT rate for the underlying DB in this case? Did you enable persistent store option? What is CPU and memory

Re: Cache pre-loading question

Hi, By "custom" CacheStore I meant that you could implenent a CacheStore with your custom read/write logic, but since you are using CacheJdbcPojoStore it should be OK. IgniteCache does have loadCache method. Please take a look at

Re: Cache pre-loading question

Hi Franck, Yes. You would need to implement the same mapping logic in your client populating a cache via data streamer. A custom CacheStore or CacheJdbcPojoStore should be an easier approach in case of an underlying DB, especially if you need read-through/write-through semantics as well. Kind

Re: (Cross Platform)c# wrapper for java CacheStoreAdapter for database persistence

Hi, Please take a look at the end of the following documentation section Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Possible dead lock when number of jobs exceeds thread pool

Hi Raymond, Yes. Bringing C# client in sync with Java version is on plans. Of course, C# client will always be a bit outdated in terms of features of Java client. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Number of Caches

Hi, Actually, the number of caches is mostly restricted by the available memory, since every cache implies about 20M overhead. So, for 3K caches a rough estimate is 3000 * 20M = 6M ~ 59G. Please share full logs for the client node. Kind regards, Alex -- Sent from:

Re: Multiple Ignite Clusters using the same Zookeeper cluster

Hi, Have you tried setting different base paths for each grid via TcpDiscoveryZookeeperIpFinder#setBasePath ? Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Query performance affected by record size?

Hi, Probably you have pretty much data that satisfies the condition. Try running EXPLAIN command to check the query plan. In general, it's better to move child objects into a separate cache and establish a relation via affinity

Re: Write Behind Performance

Hi Rick, 1) As for now, there is no API for checking write-behind queue size. In any case, such method would provide only an approximate result. 2) You should carry out some testing to figure out the appropriate balance between the batch size and flush frequency that will fit your particular

Re: TcpDiscoveryS3IpFinder AmazonS3Exception: Slow Down

Hi Dave, Probably switching to VPC increased the request rate what caused the mentioned exception. Please share the corresponding Ignite logs. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: Possible dead lock when number of jobs exceeds thread pool

Raymond, Yes. Your understanding is correct, that should be the reason of starvation. Please take a look at custom thread pools https://apacheignite.readme.io/v2.2/docs/thread-pools#section-custom-thread-pools. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Possible dead lock when number of jobs exceeds thread pool

Hi, That actually looks like a starvation in public pool where compute tasks are processed. Please share PerformRenderer() source. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Query performance affected by record size?

Hi, Could you please share the queries you run against the cache? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: RESTART_JVM Segmentation Policy

Hi, Ignite provides only scaffolding for your custom implementation. GridGain provides some out of the box realizations. For more details and hints please refer to the GridGain documentation on the subject. As well, please note that

Re: UPDATE SQL for nested BinaryObject throws exception.

Hi, FYI. Created tickets related to the subject: 1) https://issues.apache.org/jira/browse/IGNITE-6265 2) https://issues.apache.org/jira/browse/IGNITE-6266 3) https://issues.apache.org/jira/browse/IGNITE-6268 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: UPDATE SQL for nested BinaryObject throws exception.

Hi, Actually, flattening the nested properties with aliases works only for one level as for now. Looks like it's a bug. I'll file a JIRA ticket for this. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: fetching all the tasks already scheduled and to know the status of the task

Hi, You could use *ignite*.compute().activeTaskFutures() to get the map of all the active tasks started from the *ignite* node. Kind regards, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: UPDATE SQL for nested BinaryObject throws exception.

Hi, Currently referencing nested object's fields from SQL isn't supported for both regular Java objects and for BinaryObject-s. In other words, having class B { private String field1; } class A { private B bField; } you cannot update it like `update A set bField.field1=?` Kind

Re: Ignite 2.1.0 - Thread deadlock on DefaultSingletonBeanRegistry.getSingleton

Denis, yes I can confirm that the issue doesn't stand for 2.0. I'll drill down into the issue and will file a ticket soon. Kind regards, Alex. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Schema vs CacheName

Hi, Schema name and cache names match by default when a cache is configured via either annotations or QueryEntity-es Please refer to the following documentation section. Let me clarify your questions: Q1: You can set a schema name distinct from the default matching the cache name by calling

Re: We want to configure near cache on client so that we can handle high TPS items and avoid network call to server

Hi, 1. You can set an eviction policy distinct from the one of the underlying server cache but you can set a distinct expiration policy for a near cache as for now; there is, actually, even no NearCacheConfiguration#setExpiryPolicyFactory method 2. For example, if you have the following

Re: Configuring path of binary_meta, db directories etc

Please ignore. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite 2.1.0 - Thread deadlock on DefaultSingletonBeanRegistry.getSingleton

Hi, Looks like with IgniteSpringBean and a @SpringResource configured for a CacheStore a deadlock occurs, since IgniteSpringBean singleton creation takes a Spring internal lock and after that tries to start a cache with a CacheStore in a separate thread in a synchronous way, it sees that a

Re: We want to configure near cache on client so that we can handle high TPS items and avoid network call to server

Hi, 1. It's mostly OK, but expiry policy should be set on the main cache and it will be inherited by the near cache Please refer to this documentation section 2. It's not possible out of the box, but you could do some

Re: Configure Apache-Ignite as Out-Proc instead of in-Proc

Hi, If by *Out-Proc* you mean running Ignite as a standalone process, not as a part of an existing application, then yes, it's possible. You could run an ignite node from the shell using the startup scripts located in $IGNITE_HOME/*bin* directory. As well you could create a separate app, the

Re: Reusing CacheStores connections?

Hi, Please consider using some kind of pooled DataSource instead of using simple DriverManager.getConnection for obtaining a connection. Kind regards, Alex. On Tue, Aug 29, 2017 at 5:57 AM, Matt-2 [via Apache Ignite Users] < ml+s70518n16468...@n6.nabble.com> wrote: > Hi, > > Following the

Re: Cache.destroy() & close() does not delete SwapFile Ignite 2.0

Hi, Deletion happens on next startup of the node. Kind regards, Alex. On Thu, Aug 24, 2017 at 7:13 PM, Ramzinator [via Apache Ignite Users] < ml+s70518n16401...@n6.nabble.com> wrote: > Hi > > It appears that even when the ignite node shuts down, it does not delete > the created cache files. >

Re: Scalebility of Inite Threads

Hi, Please properly subscribe to the mailing list so that the community can receive email notifications for your messages. To subscribe, send an empty email to user-subscr...@ignite.apache.org and follow simple instructions in the reply. I've some questions to clarify: 1. What do you mean by

Re: fetching all the tasks already scheduled and to know the status of the task

Hi, 1. For scheduling jobs, you can take a look at the cron based scheduler . It provides facilities for scheduling jobs locally, but you can run any distributed task from that scheduled task. 2. Information about all the jobs associated

Re: serious problem: wiindows >>cmd >>jboss-4>>Error displaying Chinese encoding

Hi, Please properly subscribe to the mailing list so that the community can receive email notifications for your messages. To subscribe, send an empty email to user-subscr...@ignite.apache.org and follow simple instructions in the reply. Please try calling *chcp 65001* before starting Ignite

Re: Using One Grid for Web Session management and ClusterSingleton

Hi, What for do you want to obtain a reference to the WebSession cache? Web session clustering is designed to be transparent to the user. If you need to store something else in a cache then just create an additional cache suited just for your needs. Sharing web sessions cache for other entities

Re: EntryProcessor and Locks

Hi, It depends on the isolation level you specify for the OPTIMISTIC transaction. Please check https://apacheignite.readme.io/docs/transactions#section-optimistic-transactions Kind regards, Alex. On Tue, Aug 15, 2017 at 2:31 AM, rajivgandhi [via Apache Ignite Users] <

Re: PeerClassLoading example using cacheLoaders

Hi, You are right, *load* method is called when there is a miss in a cache. putIfAbsent is supported by IgniteCache out of the box. I'm afraid that there is no simple way to achieve what a CacheStore offers. With any other approach, you would have to sacrifice read/write-through behavior. Kind

Re: Activation: slow and: Ignite node crashed in the middle of checkpoint.

Hi, Could you please share the logs and configuration? Actually, the activation time depends on the amount of data, network connectivity and other variables. Kind regards, Alex. On Sat, Aug 12, 2017 at 12:39 AM, Roger Fischer (CW) [via Apache Ignite Users]

Re: EntryProcessor and Locks

HI, Yes, I meant starting a transaction via igniteInstance.transactions().txStart(OPTIMISTIC, isolationLevel) and calling cache.invoke(key, entryProcessor) within its scope. Kind regards, Alex. On Mon, Aug 14, 2017 at 7:59 PM, rajivgandhi [via Apache Ignite Users] <

Re: EntryProcessor and Locks

Hi, Looks like you are not subscribed to the mailing list. Please make sure you are subscribed . Answering to your questions, with the PESSIMISTIC or implicit transactions EntryProcessor will cause a

Re: Centralized configuration management

Hi, Yes, GetOrCreateCache should do the thing in this case. Kind regards, Alex. On Mon, Aug 14, 2017 at 3:53 PM, franck102 [via Apache Ignite Users] < ml+s70518n16165...@n6.nabble.com> wrote: > Hi Alex, > > Regarding this statement: > "When you destroy or create a cache from a client node,

Re: Calling service methods from servlets

Hi, The first approach is preferable because the second one implies an additional network round trip. Kind regards, Alex. On Mon, Aug 14, 2017 at 2:44 PM, luqmanahmad [via Apache Ignite Users] < ml+s70518n16160...@n6.nabble.com> wrote: > Hi there, > > Let say we have a node singleton service

Re: Centralized configuration management

Hi, There is no option to update the configuration of an existing cache. As well, you cannot create two caches with the same name but different configurations. So, as you've correctly suggested, to achieve this, you need first to destroy a cache and then start a new one with the updated

Re: Resource Management (connection pooling) on Ignite Cluster

Hi, Please properly subscribe to the mailing list so that the community can receive email notifications for your messages. To subscribe, send an empty email to user-subscr...@ignite.apache.org and follow simple instructions in the reply. Did you have a chance to take a look at JDBC client node

Re: PeerClassLoading example using cacheLoaders

Hi, Peer class loading works only for compute closures and tasks as described here . it's not applicable for configuration classes or cache entries, so you have to copy that classes to all nodes. Kind regards, Alex. On Fri, Aug 11, 2017 at

Re: Ignite fails to allocate more memory then initially allocated when maxSize property provided in MemoryPolicyConfiguration

Hi, Provided configuration works as expected on Ignite version 2.1. On my side, in this configuration, I got 3 memory segment allocations. Have you tried requesting cache.size() after populating the cache? Please provide the full configuration files so as I could check them. Kind regards, Alex.

Re: OOM in Heap though offHeap is available/free

Hi Amit, Your understanding is correct, an on-heap cache is like a frontend for an off-heap cache. It's useful in cases when a lot of cache reads are expected. The only thing that should be considered is setting an eviction policy for on-heap cache to prevent it growing unrestrictedly. Please

Re: Ignite suitable for jobs returning fairly large data sets ?

Hello, Please properly subscribe to the mailing list so that the community can receive email notifications for your messages. To subscribe, send an empty email to user-subscr...@ignite.apache.org and follow simple instructions in the reply. Ignite can cope with such cases but it's highly

Re: Query about running SQL with durable memory

Hi, The count should be 15. If a page is not found in RAM, then the durable memory will request it from the Persistent Store. Please check https://apacheignite.readme.io/v2.1/docs/distributed-persistent-store#section-usage Are you observing a different behavior? Kind regards, Alex. On Sun,

Re: Query by java joda DateTime.

Hi, Unfortunately, Joda time types are not supported by Ignite, thus as every unsupported type, it's treated inside as a BinaryObject. The comparison is performed on hash codes of BinaryObjects representing DateTime-s, hence unpredictable results. I would recommend you use ScanQuery

Re: Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalMonitorStateException: Attempted to release write lock while not holding it

Hi Ankit, Sorry I was busy a bit lately. I'll proceed with the investigation and give you an update. Kind regards, Alex. On Tue, Aug 1, 2017 at 5:31 PM, Ankit Singhai [via Apache Ignite Users] < ml+s70518n15860...@n6.nabble.com> wrote: > Please check folks > > On 31-Jul-2017 13:33, "Ankit

Re: Node discovery between IPV4 and IPV6 nodes

Hello, Please properly subscribe to the mailing list so that the community can receive email notifications for your messages. To subscribe, send an empty email to user-subscr...@ignite.apache.org and follow simple instructions in the reply. Have you tried setting -Djava.net.preferIPv4Stack=true

Re: Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalMonitorStateException: Attempted to release write lock while not holding it

Ankit thanks for the info. I'll try to reproduce it on my side and get back to you. Kind regards, Alex. On Thu, Jul 27, 2017 at 10:05 AM, Ankit Singhai [via Apache Ignite Users] < ml+s70518n15716...@n6.nabble.com> wrote: > Hi Alex, > Yes it is reproducible every time. > Linux Version:- > Linux

Re: Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalMonitorStateException: Attempted to release write lock while not holding it

Hi Ankit, Is the issue reproducible on every run or intermittent? What are the OS and JDK versions in each environment? Please share full logs. As well, could you please share a Maven/Gradle based reproducer? Kind regards, Alex 27 июля 2017 г. 8:09 AM пользователь "Ankit Singhai [via Apache

Re: Custom SQL Functions

Hello, 1) No, functions can't be overloaded. Functions with the same name must have a different number of parameters 3) To register a class with custom SQL functions via XML just use regular Spring bean notation ... Functions1.class Functions2

Re:Re: encountering a character encoding problem when DML SQL is used

are encountering this problem. is there any configuration that can set as encoding? or is there any API method can do this? thanks, Martin At 2017-07-20 00:34:45, "afedotov" <[hidden email] <http:///user/SendEmail.jtp?type=node=15149=0>> wrote: Hi Martin, I've checked the

Re: SQL Syntax error in cross-cache query

Hi, You need either adjust entity/table name to the upper case like *select ID from "personCache".PERSON p limit 5* or add a config option

Re: SQL Syntax error in cross-cache query

Hi Bob, Due to some reason my answer has got in another conversation, so duplicating it here. Hi, You need either adjust entity/table name to the upper case like *select ID from "personCache".PERSON p limit 5* or add a config option

Re: Ignite client not seeing cache created by server

Hi Maureen, Make sure that at cfg.setIndexedTypes(GeoCoordinate.class, SurveyImage.class) you are specifying key-value pairs for each type you want to register. I mean it should be cfg.setIndexedTypes(SomeGeoCoordinateKey.class, GeoCoordinate.class, SomeSurveyImageKey.class, SurveyImage.class)

Re: encountering a character encoding problem when DML SQL is used

Hi Martin, I've checked the same with 2.0 and it works on my side. Which version of Ignite do you use? Do you call it from Java, .NET or C++ ? Please check that source files encoding is consistent. It's better to stick with UTF-8. Kind regards, Alex. On Wed, Jul 19, 2017 at 4:47 AM, Martin

Re: SQL Syntax error in cross-cache query

Could you please share your cache config or the full Ignite config, which is better. Kind regards, Alex 19 июля 2017 г. 11:03 AM пользователь "howfree [via Apache Ignite Users]" < ml+s70518n15109...@n6.nabble.com> написал: > Yes. > It came up with the error: Schema "PERSONCACHE" not found. > I

Re: SQL Syntax error in cross-cache query

Have you tried without any quotation? Kind regards, Alex 19 июля 2017 г. 9:16 AM пользователь "howfree [via Apache Ignite Users]" < ml+s70518n15102...@n6.nabble.com> написал: The following error came up: Schema "PERSONCACHE" not found. The style \"personCache\" can be separated from the Schema

Re: SQL Syntax error in cross-cache query

Hi, Looks like you have wrong schema name. Please adjust \\\"personCache\\\" to \"personCache\". Kind regards, Alex 19 июля 2017 г. 8:25 AM пользователь "howfree [via Apache Ignite Users]" < ml+s70518n15097...@n6.nabble.com> написал: In ignite 2.0: when I ran those codes: SqlFieldsQuery sql =

Re: How to access Apache Ignite service grid services from a J2ee application server

Well, before you request a service proxy you need to get an Ignite instance first so there is no way to avoid creating that Ignite instance somewhere. Do you anticipate/observe any problems with this approach? Kind regards, Alex 16 июля 2017 г. 10:46 AM пользователь "krutipatel [via Apache

Re: How to access apache-ignite service-grid services form a J2ee application

Hi, Please avoid creating duplicates of the question and keep discussion in scope of http://apache-ignite-users.70518.x6.nabble.com/How-to-access-apache-ignite-service-grid-services-form-a-J2ee-application-tp14972.html Kind regards, Alex 16 июля 2017 г. 10:14 AM пользователь "krutipatel [via

Re: How to access Apache Ignite service grid services from a J2ee application server

Hi, Have you tried using ServiceProxy from an Ignite client running inside your J2EE app? Please check https://apacheignite.readme.io/docs/service-example#section-service-proxy Kind regards, Alex 16 июля 2017 г. 10:04 AM пользователь "tmp [via Apache Ignite Users]" <

Re: Two ignite instances on a vm

n > other instance is stopped/started/restarted. > > We tried with default heartbeatFrequency as well and same behavior. In > case of large export scenarios, servers experiencing little long gc's. so > testing with heartbeatFrequency = 6 ms. > > Thanks, > Anil > >

Re: Two ignite instances on a vm

Hi, What is the log when you start the second node? Why do you need heartbeatFrequency of 6 ms? Try commenting it so that it has a default value. Kind regards, Alex. On Sat, Jul 15, 2017 at 8:27 PM, Anil [via Apache Ignite Users] < ml+s70518n14965...@n6.nabble.com> wrote: > HI Team, > > I

Re: Execute Custom function in H2 Console

Hi, If you have defined a custom function according to the https://apacheignite.readme.io/docs/miscellaneous-features#section-custom-sql-functions then to use it from H2 console you need to prefix it with the schema name of the cache where you have registered your function, for example: *SELECT

Re: Define Cache Size - Queries

Hi, Probably configuring a memory region of the desired maximum size should help you. Please refer to https://apacheignite.readme.io/docs/page-memory#section-memory-regions https://apacheignite.readme.io/docs/page-memory#section-memory-policies Kind regards, Alex. On Fri, Jul 14, 2017 at 8:02

Re: wrong data from cluster nodes while using left join

Hi, I don't quite understand your case, but with LEFT JOIN you will have results even if there is no matching id in B, that's why "FROM A.R as r LEFT JOIN B.I as T ON r.id = T.id" works. By default cross cache join will operate only on data available locally on each particular node. Probably

  1   2   >