Re: [RESOLVED] when JDBC query result larger than heap...?

Found the solution... 'Query Lazy Loading' ( https://apacheignite-sql.readme.io/docs/performance-and-debugging ) -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

when JDBC query result larger than heap...?

How can I process a large resultset from a JDBC query, that requires more memory than is available for heap space? I have tried 'paging' with SQL 'OFFSET' and 'FETCH FIRST/NEXT ROW(S) ONLY' - but still run out of memory ...regardless of the 'paging' size. -- Sent from:

Memory related questions

Greetings all. I have a few questions regarding memory. 1.) I am running ignite inside docker container. How can I increase heap memory to ignite node when started? I tried with passing -Xmx (I pass it to docker run command like this: -e "JAVA_OPTS=-Xmx3g") parameter but when node starts it

Re: Tcp discover server thread got terminated

Hello! It seems that your node had segmented (due to network glitch or long GC), and stumbled on the following bug: https://issues.apache.org/jira/browse/IGNITE-8751 You could upgrade to 2.7 to make it go away, but it won't solve the original node segmentation reason. Regards, -- Ilya

Re: cache configurations in a grid

Hello! I guess myIgnite.configuration() will only return what node has started with, including cache configurations. It's not ugly. You should definitely be using myIgnite.cache("FOO").getConfiguration(CacheConfiguratin.class); Regards, -- Ilya Kasnacheev пт, 1 февр. 2019 г. в 00:59, Scott

Re: checkpoint marker is present on disk, but checkpoint record is missed in WAL

Hello! It's hard to say outright. Can you provide full log before node crash? Is there a chance that you ran out of disk space? What's your WALMode? Regards, -- Ilya Kasnacheev пт, 1 февр. 2019 г. в 08:16, radha jai : > Hi, >Ignite has been deployed on k8s has 12 ignite-servers, which

Re: [External]Re: Object unmarshalling issue in ignite 2.7

Hello! I think so. Note that there are several *statisticsEnabled* in different parts of config. Regards, -- Ilya Kasnacheev пт, 1 февр. 2019 г. в 15:04, : > Thanks for the update Ilya, definitely saves a lot of time. > > > > Just to clarify, disabling metrics you mean disabling the cache >

Re: SQL FETCH examples?

Hello! SELECT * FROM table ORDER BY row LIMIT 1? SELECT * FROM table ORDER BY row LIMIT OFFSET 1? Regards, -- Ilya Kasnacheev пт, 1 февр. 2019 г. в 13:52, joseheitor : > Hi Ignite Team, > > Do you have any examples illustrating the use of SQL: > > FETCH FIRST/NEXT ROW(S) ONLY > > ??? >

RE: [External]Re: Object unmarshalling issue in ignite 2.7

Thanks for the update Ilya, definitely saves a lot of time. Just to clarify, disabling metrics you mean disabling the cache "statisticsEnabled" metric right ? Thanks and Regards, Kamlesh Joshi From: Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com] Sent: Friday, February 1, 2019 4:02 PM To:

Re: Unable to form connection between ignite(v 2.7) node inside kubernetes-1.11.3

Hello! Looks like https://kubernetes.default.svc.cluster.local:443 is not reachable from your nodes. Why would that be? I have particularly no idea since I'm not aware of k8s internals. Regars, -- Ilya Kasnacheev пт, 1 февр. 2019 г. в 14:17, Lalit Jadhav : > Hello, > > Below is

Re: Unable to form connection between ignite(v 2.7) node inside kubernetes-1.11.3

Hello, Below is Configuration for kubernetes IPFinder. TcpDiscoverySpi spi = new TcpDiscoverySpi(); TcpDiscoveryKubernetesIpFinder ipFinder = new TcpDiscoveryKubernetesIpFinder(); spi.setIpFinder(ipFinder); IgniteConfiguration cfg = new IgniteConfiguration(); cfg.setDiscoverySpi(spi);

SQL FETCH examples?

Hi Ignite Team, Do you have any examples illustrating the use of SQL: FETCH FIRST/NEXT ROW(S) ONLY ??? Thanks, Jose -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Object unmarshalling issue in ignite 2.7

Hello! I'm afraid this is a known issue of 2.7: https://issues.apache.org/jira/browse/IGNITE-10925 Not sure which work-arounds are here other than disabling metrics. Regards, -- Ilya Kasnacheev пт, 1 февр. 2019 г. в 08:10, : > Hi All, > > > > I am trying to preload the data using below code