not in, not exists sql result is not correct

Hi, We are using ignite 2.8.1, with this sql statement, SELECT * FROM orders p WHERE NOT exists (SELECT accountid FROM account b WHERE b.accountid = p.accountid); Retured result accountid actually exists in table account, change to NOT IN also is not correct. But I have another table result is

Remote Cluster ServiceGrid debug

Hi, I have a cluster running on the cloud server, now met some issues, is it possible that I can connect with client in local to debug the service? If ok, how do that, thanks. Thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ignite NPE when try to loadCache from persistent mysql database

Hi Experts, When try to loadCache from 3rd party mysql database, (this.balanceCache.loadCache(null);) met ignite NullPointerException, thanks a lot for some clues, 10:21:15,376 [mgmt-#66] ERROR org.apache.ignite.internal.processors.task.GridTaskWorker - Failed to obtain remote job result polic

Re: Ignite 3rd party persistency DataSourceBean Config in Java

More Exceptions here, thanks 06:29:58,723 [mgmt-#66] ERROR org.apache.ignite.internal.processors.task.GridTaskWorker - Failed to obtain remote job result policy for result from ComputeTask.result(..) method (will fail the whole task): GridJobResultImpl [job=C2 [c=LoadCacheJobV2 [keepBinary=false]

Re: Ignite 3rd party persistency DataSourceBean Config in Java

hi Thanks a lot. Correct the setDataSourceFactory, met ignite nullPointerException below, appreciate for the suggestions, thanks. javax.cache.integration.CacheLoaderException: java.lang.NullPointerException at org.apache.ignite.internal.processors.cache.store.GridCacheStoreManagerAdapter.

Re: Ignite 3rd party persistency DataSourceBean Config in Java

Thanks a lot Kasnacheev, I have used the below mysqlDataSource, but still met the exception, any ideas? thanks a lot. 'org.apache.ignite.IgniteException: Failed to initialize cache store (data source is not provided).' public void setJdbcStoreConfig(CacheConfiguration config) { System.o

Re: Ignite 3rd party persistency DataSourceBean Config in Java

Thanks Srikanta, I'm using below code, with CacheJdbcPojoStoreFactory, for the dsMySQL_Test dataSourceBean, I try configured in the default-config.xml, but it will show 'IgniteException: Failed to load bean in application context [beanName=dsMySQL_Test, ', so I am seeking which object can use to

Re: Ignite 3rd party persistency DataSourceBean Config in Java

Need suggestions, thanks a lot. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ignite 3rd party persistency DataSourceBean Config in Java

Hi Experts, >From the ignite 3rd party rdbms persistency doc, it shows the example with xml config, like below, Can help an example how to do at the java code? Use which bean? thanks, And btw, as currently, ignite dialet not support the postgresql, how can we use the postgresql to

IgniteTxOptimisticCheckedException

Hi Guru, We met below two kinds of Optimistic exceptions when doing the transactions, we use OPTIMISTIC and SERIALIZABLE isolation, do you have any suggestions, or if we change to PESSIMISTIC, any risks on that, such as performance or other exceptions? thanks. {"log":"Caused by: org.apache.ignit

Re: First 10 long running cache futures [total=1]

thanks, are there any hints that can find/locate the operations that impact the server? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

First 10 long running cache futures [total=1]

Hi Guru, we met an exception on below, it impacts system no responses, any suggestions how to identify the case? 12:18:10,035 [grid-timeout-worker-#39] WARN org.apache.ignite.internal.diagnostic - First 10 long running cache futures [total=1] 12:18:10,035 [grid-timeout-worker-#39] WARN org.a

Re: Ignite Backup and Restore

Hi, any suggestions? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Backup and Restore

And yes, btw, is there a tools that help export data and import data, for logical backup and restore like the traditional database? Thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite Backup and Restore

Hello Anton, Not met this data lost yet, just want to make data backup/restore policy. Or, actually, in ignite there is no this kind of concept, as already in cluster? And will auto restore data? As our ignite instance data is very critical, we need care about the data safety. Thanks. -- Se

Ignite Backup and Restore

Hi Guru, Any docs about the Ignite backup and restore mechanism, how to recover the data if data lost from cache. Now, we separate the WAL and DB to different folders, once met the data lost, how do I recover data from the wal? Thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble

Re: Ignite authenticationEnabled queries

thanks a lot, with statement works. Btw, created a new user , but cannot connect to the instance, anything else need settle done? thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Ignite authenticationEnabled queries

not works, still show error, ALTER USER "ignite" SET password 'abcdefg' ; SQL Error [1001] [42000]: Failed

Ignite Cache exists but table lost

Hi Guru, We found a problem that, caches exists, we can get/set successfully, and file also exists in the work folder, but cannot see the related table by jdbc thin access, the cache was created by java code, not by sql scripts. sometimes can see it, but sometimes not, really surprise, not sure

Ignite authenticationEnabled queries

Hi Guru, Enabled the authentication with below configuration, it is ok for jdbc thin client with ignite/ignite to connect to server, but found cannot change ignite's password, will say no this user. And created new user cannot access, and no where to grant priviledges, how can we go? thanks a lo

Ignite SSL security

Hi Guru, I am try to implement the SSL security, default-config.xml like below, I have generated the server.jks and trust.jks with command 'keytool -genkey -alias ignite -keystore server.jks -keyalg RSA' and put the file server.jks to the $IGNITE_HOME folder, but when restart ignite, met below

Re: Ignite Spring Integration

For more clear, i am using the bin/ignite.sh to start the ignite server, and using the uri hot deployment, my business logic is in the igniteSerivce, and need spring annotation/configuration support. case 1, we deploy our package jar into the ./libs folder, all works fine, but this way cannot hot

Re: Ignite Spring Integration

Thanks, we are not building spring boot application with ignite support, we are trying this scenario, build up the service with Spring Annotation involve, and package into the urideployment folder for service hot deployment. If we put this package into the ignite $IGNITE_HOME/libs folder, then all

Ignite Spring Integration

Hi Guru, I am integrating the Spring into the Ignite, when deploying service, with metho deployNodeSingleton, met no bean found exception, show as below, which lead the Suppressed: class org.apache.ignite.IgniteCheckedException: Error occured during service initialization: [locId=13760585-1342-47

Re: UriDeployment Exception

Finally get works for this approach, it due to my maven package issue, thanks a lot. 1. copy the dependency libs to ignite ./libs; 2. copy the package classes into the urideployment folder. No need the ignite.xml, and no need to restart the server, it will use the latest code. thanks again.

Re: UriDeployment Exception

hi Evgenii, After serveral tried, seems in the Jar package, need META-INF/ignite.xml descriptor, my one like is, -> http://www.springframework.org/schema/beans"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:util="http://www.springframework.org/schema/util"; x

Re: UriDeployment Question

complete exception is like below, Exception in thread "grid-uri-scanner-#2" java.lang.NoClassDefFoundError: org/osgi/service/jdbc/DataSourceFactory at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:756) at java.secu

Re: UriDeployment Question

I tried even with the 2.8.1, but exception still there, I have already copied the ignite-osgi and ignite-osgi-paxlogging libs to the ./libs folder, java.lang.NoClassDefFoundError: org/osgi/service/jdbc/DataSourceFactory at java.lang.ClassLoader.defineClass1(Native Method) at java.

Re: UriDeployment Question

thanks, i am using 2.8.0 version. btw, when start the server, met below exception, I am not sure if due to this issue, Caused by: java.lang.ClassNotFoundException: org.osgi.framework.BundleActivator at java.net.URLClassLoader.findClass(URLClassLoader.java:382) at java.lang.ClassL

UriDeployment Question

Hi Expert, I am trying the UriDeployment, the xml setting is, file:///home/myProjects/price-processor-ignite/target/ When ignite startup, I can find the something generated in

How to close/cancel a running tasks?

Hi Experts, Say I have a while (true) task, which help monitoring/handling the MQ messages. Once I need change the logic, how I redeploy the task? how I cancel this task and let the cluster using the new logic jar? Do I need restart all cluster nodes? But my cluster nodes have other tasks runnin

Re: How Ignite launch the ./libs Jar

thanks Ilya, lifecyclebean just verified works. Can you share the "configure Ignite to automatically register service" related links? thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: How Ignite launch the ./libs Jar

Thanks a lot Ilya. My confusion is, where to fire the task, does Ignite will help launch this task when startup the ignite instance? I have tried, but not found any logs output. If ignite cannot help launch, only load the class into memory, then where to fire/trigger this tasks? need a separate

Re: How Ignite launch the ./libs Jar

Can I understand the task deployment like this: package jar to ./libs, Ignite only will load this class into instance, but will not trigger that, task will only trigger by outside the ignite client or jdbc or jmx? In this case, outside programmer only need to know the taskName, and call this task

Re: How to create a compute tasks which uses Cache and transaction?

Hi Denis, "use the REST API shared by Dmtriy to trigger the task." How to do that? can you share more details, now I have the task deployed to the ./libs, but don't know how to trigger, or ignite will help auto trigger, as task already describe in the META-INF/ignite.xml? And btw, does it must

Re: How Ignite launch the ./libs Jar

thanks a lot Alex. I saw my jar from the java process. But cannot see the logs I print out from the ignite console, I am not sure whether the task run or not run, My META-INF/ignite.xml defined as below, http://www.springframework.org/schema/beans"; xmlns:xsi="http://www.w3.org/2001/

How Ignite launch the ./libs Jar

Hi , need your help, or give a link, or give a hint on this deployment, Ignite Jar deployment case, Say I have a jar package with the main-class defined, and put it into the ./libs folder, what will the ignite do, ignite how to launch this Jar? Which is the endpoint for Ignite launch this Jar? A