Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Hello! I'm not aware of any other settings to avoid OOME for SQL queries. Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Hello Ilya Kasnacheev, using Ignite 2.6. SQL through Tableau using ODBC connection is getting OOME when selct 8 from table without limit. I have set export IGNITE_SQL_FORCE_LAZY_RESULT_SET=true in ignite.sh. What else should I configure to avoid OOME when using ODBC? thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Great, It works perfectly, thankyou. Bhaskar -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Hello! You have to put export before it to pass it to Apache Ignite: export IGNITE_SQL_FORCE_LAZY_RESULT_SET=true Regards, -- Ilya Kasnacheev 2018-08-01 16:58 GMT+03:00 ApacheUser : > Hello Ilya Kasnacheev, > > I set IGNITE_SQL_FORCE_LAZY_RESULT_SET=true just below > ENABLE_ASSERTIONS="0" in ignite.sh but still I am getting out of memory > error when I do select * from table. Is this right place to set this > parameter? please confirm. > > > Thanks > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Hello Ilya Kasnacheev, I set IGNITE_SQL_FORCE_LAZY_RESULT_SET=true just below ENABLE_ASSERTIONS="0" in ignite.sh but still I am getting out of memory error when I do select * from table. Is this right place to set this parameter? please confirm. Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Hello! I'm not aware of such parameters. Regards, -- Ilya Kasnacheev 2018-07-03 19:18 GMT+03:00 ApacheUser : > Thanks Ilya, > Appreciate your help, > > Is there any parameter in COnfig file to control the number of rows or > amount of resources a clinet connection can use and if exceeds disconnect? > > thanks > Bhaskar > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Thanks Ilya, Appreciate your help, Is there any parameter in COnfig file to control the number of rows or amount of resources a clinet connection can use and if exceeds disconnect? thanks Bhaskar -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Hello! Unfortunately I'm not aware of any practices that will make Ignite (or indeed any DB) foolproof. I know that people use human DBAs for that purpose, which control which statements are allowed to be run on production and which aren't. Regards, -- Ilya Kasnacheev 2018-07-02 21:01 GMT+03:00 ApacheUser : > Thanks Ily , > could share any guidelines to control groupby?, Like didicated client nodes > for connectivity from Tableau and SQL? > Thanks > Bhaskar > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Thanks Ily , could share any guidelines to control groupby?, Like didicated client nodes for connectivity from Tableau and SQL? Thanks Bhaskar -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Hello again! It seems that I had a copy-paste problem here: the actual flag name is IGNITE_SQL_FORCE_LAZY_RESULT_SET Regards, -- Ilya Kasnacheev 2018-07-02 16:53 GMT+03:00 Ilya Kasnacheev : > Hello! > > You can set IGNITE_SQL_LAZY_RESULT_SET=true (environment variable or JVM > system property) on all nodes since Apache Ignite 2.5, make sure that all > queries run with lazy=true. > > It will still not save you from some scenarios such as runaway GROUP BYs, > but from SELECT * it would. > > Regards, > > -- > Ilya Kasnacheev > > 2018-06-28 23:17 GMT+03:00 ApacheUser : > >> Evgenii, >> what happens if the user doesn't set that limit or forget to set on client >> tool?, >> >> we set that but some one testing without the lazy=true to prove that >> Apache >> Ignite is not stable. >> >> Thanks >> >> >> >> -- >> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >> > >
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Hello! You can set IGNITE_SQL_LAZY_RESULT_SET=true (environment variable or JVM system property) on all nodes since Apache Ignite 2.5, make sure that all queries run with lazy=true. It will still not save you from some scenarios such as runaway GROUP BYs, but from SELECT * it would. Regards, -- Ilya Kasnacheev 2018-06-28 23:17 GMT+03:00 ApacheUser : > Evgenii, > what happens if the user doesn't set that limit or forget to set on client > tool?, > > we set that but some one testing without the lazy=true to prove that Apache > Ignite is not stable. > > Thanks > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Evgenii, what happens if the user doesn't set that limit or forget to set on client tool?, we set that but some one testing without the lazy=true to prove that Apache Ignite is not stable. Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
There is a lazy flag for jdbc string: jdbc:ignite:thin:// 192.168.0.15/lazy=true Evgenii 2018-06-28 22:38 GMT+03:00 ApacheUser : > Evgenii, > > We use Ignite-as Im Memory Database for Tableau and SQL, we dont use Java. > We use spark to load data into Ingite by Spark streaming realtime data. > So if any user runs select * from table, the server nodes going OOME. We > need to control that behaviour i sthere any way? > > Thanks > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
Evgenii, We use Ignite-as Im Memory Database for Tableau and SQL, we dont use Java. We use spark to load data into Ingite by Spark streaming realtime data. So if any user runs select * from table, the server nodes going OOME. We need to control that behaviour i sthere any way? Thanks -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SqlFieldsQuery Cannot create inner bean 'org.apache.ignite.cache.query.SqlFieldsQuery
There is no such field in IgniteConfiguration: https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/configuration/IgniteConfiguration.html Why do you think that it should work? You can set lazy flag when you creating SqlFieldsQuery object from java Evgenii 2018-06-28 20:32 GMT+03:00 ApacheUser : > Hi Ignite Team, > > I am trying set SqlFieldsQuery to seTLazy to avoid OOME on Server nodes. By > Config file has below setting > > > > > > > > > > but getting below error: > > []# bin/ignite.sh > class org.apache.ignite.IgniteException: Failed to instantiate Spring XML > application context > [springUrl=file:/data/ignitedata/apache-ignite-fabric-2.5.0-bin/config/ > default-config.xml, > err=Error creating bean with name 'ignite.cfg' defined in URL > [file:/data/ignitedata/apache-ignite-fabric-2.5.0-bin/ > config/default-config.xml]: > Cannot create inner bean > 'org.apache.ignite.cache.query.SqlFieldsQuery#5f9d02cb' of type > [org.apache.ignite.cache.query.SqlFieldsQuery] while setting bean property > 'SqlFieldsQuery'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean > with name 'org.apache.ignite.cache.query.SqlFieldsQuery#5f9d02cb' defined > in > URL > [file:/data/ignitedata/apache-ignite-fabric-2.5.0-bin/ > config/default-config.xml]: > Instantiation of bean failed; nested exception is > org.springframework.beans.BeanInstantiationException: Failed to > instantiate > [org.apache.ignite.cache.query.SqlFieldsQuery]: No default constructor > found; nested exception is java.lang.NoSuchMethodException: > org.apache.ignite.cache.query.SqlFieldsQuery.()] > at > org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils. > java:990) > at org.apache.ignite.Ignition.start(Ignition.java:355) > at > org.apache.ignite.startup.cmdline.CommandLineStartup. > main(CommandLineStartup.java:301) > Caused by: class org.apache.ignite.IgniteCheckedException: Failed to > instantiate Spring XML application context > [springUrl=file:/data/ignitedata/apache-ignite-fabric-2.5.0-bin/config/ > default-config.xml, > err=Error creating bean with name 'ignite.cfg' defined in URL > [file:/data/ignitedata/apache-ignite-fabric-2.5.0-bin/ > config/default-config.xml]: > Cannot create inner bean > 'org.apache.ignite.cache.query.SqlFieldsQuery#5f9d02cb' of type > [org.apache.ignite.cache.query.SqlFieldsQuery] while setting bean property > 'SqlFieldsQuery'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean > with name 'org.apache.ignite.cache.query.SqlFieldsQuery#5f9d02cb' defined > in > URL > [file:/data/ignitedata/apache-ignite-fabric-2.5.0-bin/ > config/default-config.xml]: > Instantiation of bean failed; nested exception is > org.springframework.beans.BeanInstantiationException: Failed to > instantiate > [org.apache.ignite.cache.query.SqlFieldsQuery]: No default constructor > found; nested exception is java.lang.NoSuchMethodException: > org.apache.ignite.cache.query.SqlFieldsQuery.()] > at > org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl. > applicationContext(IgniteSpringHelperImpl.java:392) > at > org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl. > loadConfigurations(IgniteSpringHelperImpl.java:104) > at > org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl. > loadConfigurations(IgniteSpringHelperImpl.java:98) > at > org.apache.ignite.internal.IgnitionEx.loadConfigurations( > IgnitionEx.java:744) > at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx. > java:945) > at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx. > java:854) > at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx. > java:724) > at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx. > java:693) > at org.apache.ignite.Ignition.start(Ignition.java:352) > ... 1 more > Caused by: org.springframework.beans.factory.BeanCreationException: Error > creating bean with name 'ignite.cfg' defined in URL > [file:/data/ignitedata/apache-ignite-fabric-2.5.0-bin/ > config/default-config.xml]: > Cannot create inner bean > 'org.apache.ignite.cache.query.SqlFieldsQuery#5f9d02cb' of type > [org.apache.ignite.cache.query.SqlFieldsQuery] while setting bean property > 'SqlFieldsQuery'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean > with name 'org.apache.ignite.cache.query.SqlFieldsQuery#5f9d02cb' defined > in > URL > [file:/data/ignitedata/apache-ignite-fabric-2.5.0-bin/ > config/default-config.xml]: > Instantiation of bean failed; nested exception is > org.springframework.beans.BeanInstantiationException: Failed to > instantiate > [org.apache.ignite.cache.query.SqlFieldsQuery]: No default constructor > found; nested exception is java.lang.NoSuchMethodException: >
