Re: JDBC Thin Client with Transactions

[devkumar]

Hi Denis,
I tested the transactional nature using SqlFieldsQuery and
cache.get()/cache.put() in PESSIMISTIC & REPEATABLE_READ mode.
case 1: update using SqlFieldsQuery in one transaction and read using
SqlFieldsQuery in another transaction on the same record and we didn't
commit any of the transaction.
  observation: Lock in write operation and read is not blocked(which
is expected).
case 2: update using SqlFieldsQuery in one transaction and read using
cache.get() in another transaction on the same record and we didn't commit
any of the transaction.
observation: whichever ran first is taking the lock and other one is
blocked 


Can you please describe transaction nature of SqlFieldsQuery and
cache.get()/cache.put() ?



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

Re: JDBCThinDriver features

[devkumar]

Thanks Evgenii,
I will try this. Are there any known limitation in terms of performance and
concurrency,  while using JDBCThin.



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

JDBCThinDriver features

[devkumar]

I want to use ignite DDL to create the table in my cache. From the
documentation (https://apacheignite.readme.io/v2.2/docs/distributed-ddl), I
see that the following 4 parameters are available for WITH clause -

TEMPLATE
BACKUPS
ATOMICITY
CACHEGROUP
AFFINITYKEY

I want to know if there are any other parameters that can be set in v2.1
If not, is there any plan to add more parameters? I am interested in the
following cache settings -
1. CopyOnRead
2. PartitionLossPolicy
3. QueryParallelism
4. ReadFromBackup
5. RebalanceBatchSize
6. RebalanceThrottle
7. RebalanceTimeout
8. OnheapCacheEnabled
9. StatisticsEnabled

Alternatively, can I add the above cache configs to my server config.xml and
will they be applied to all the tables i create in my cache using DDL?





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

Re: Unable to access cache data in Dbeaver

[devkumar]

Issue has been resolved. There was a application issue from my side. Thanks
for the help Mike.



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

Re: Unable to access cache data in Dbeaver

[devkumar]

@Mikhail, I updated the post. I am able to get cache data in Sqlworkbench
with 20 server and 7 client node. but when i did same activity with 20
server node and 20 client node, i am seeing the cache is empty in
Sqlworkbench. while ignite api is saying that data is present in the cache.



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

Unable to access cache data in Dbeaver

[devkumar]

My ignite serve is having 20 nodes and 20 clients. i am able to connect to
the cache using DBeaver. But not able to see any records in DBeaver for any
of the cache, while ignite get-cache-size API response is showing that
records are present in the cache.
Please refer to the screenshot for more information

 

 



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

Re: Unable to start 2.1 with durable memory

[devkumar]

Hi,
I started the server as per your suggestion and getting the following error
:-

Ignite Command Line Startup, ver. 2.0.0#20170430-sha1:d4eef3c6
2017 Copyright(C) Apache Software Foundation

class org.apache.ignite.IgniteException: Failed to instantiate Spring XML
application context (make sure all classes used in Spring configuration are
present at CLASSPATH)
[springUrl=file:/Users/dkumar9/Desktop/IgniteCluster/apache-ignite-fabric-2.1.0-bin/bin/../examples/config/persistentstore/example-persistent-store.xml]
at
org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:949)
at org.apache.ignite.Ignition.start(Ignition.java:350)
at
org.apache.ignite.startup.cmdline.CommandLineStartup.main(CommandLineStartup.java:302)
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to
instantiate Spring XML application context (make sure all classes used in
Spring configuration are present at CLASSPATH)
[springUrl=file:/Users/dkumar9/Desktop/IgniteCluster/apache-ignite-fabric-2.1.0-bin/bin/../examples/config/persistentstore/example-persistent-store.xml]
at
org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl.applicationContext(IgniteSpringHelperImpl.java:387)
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:668)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:869)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:778)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:648)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:617)
at org.apache.ignite.Ignition.start(Ignition.java:347)
... 1 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'ignite.cfg' defined in URL
[file:/Users/dkumar9/Desktop/IgniteCluster/apache-ignite-fabric-2.1.0-bin/bin/../examples/config/persistentstore/example-persistent-store.xml]:
Cannot create inner bean
'org.apache.ignite.configuration.PersistentStoreConfiguration#5ae63ade' of
type [org.apache.ignite.configuration.PersistentStoreConfiguration] while
setting bean property 'persistentStoreConfiguration'; nested exception is
org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find
class [org.apache.ignite.configuration.PersistentStoreConfiguration] for
bean with name
'org.apache.ignite.configuration.PersistentStoreConfiguration#5ae63ade'
defined in URL
[file:/Users/dkumar9/Desktop/IgniteCluster/apache-ignite-fabric-2.1.0-bin/bin/../examples/config/persistentstore/example-persistent-store.xml];
nested exception is java.lang.ClassNotFoundException:
org.apache.ignite.configuration.PersistentStoreConfiguration
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:313)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:122)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1531)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1276)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
at
org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl.applicationContext(IgniteSpringHelperImpl.java:381)
... 9 more
Caused by: org.springframework.beans.factory.CannotLoadBeanClassException:
Cannot find class
[org.apache.ignite.con

Re: Unable to start 2.1 with durable memory

[devkumar]

Hi,

i am using following configuration to start ignite server. 





http://www.springframework.org/schema/beans";
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
   xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd";>





















java.lang.Long
   
org.apache.ignite.examples.model.Organization






















127.0.0.1:47500..47502









Logs i already shared.



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Unable-to-start-2-1-with-durable-memory-tp15841p15886.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Unable to start 2.1 with durable memory

[devkumar]

I have set the IGNITE_HOME and still not able to start the ignite.

./ignite.sh ../examples/config/persistentstore/example-persistent-store.xml
I am using this command to start the ignite.

According to the logs, It is not able find bean with name
'org.apache.ignite.configuration.PersistentStoreConfiguration.

Do we need any library for using PersistentStoreConfiguration class?




--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Unable-to-start-2-1-with-durable-memory-tp15841p15877.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Unable to start 2.1 with durable memory

[devkumar]

I have both libraries inside lib folder of ignite.
The problem occurs only when i put below configuration in my ignite
configuration.


  


I am able to start the ignite server by removing above property.





--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Unable-to-start-2-1-with-durable-memory-tp15841p15845.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Unable to start 2.1 with durable memory

[devkumar]

Hi,
I am unable to start server with durable memory enable. I am getting the
following error :- 

class org.apache.ignite.IgniteException: Failed to instantiate Spring XML
application context (make sure all classes used in Spring configuration are
present at CLASSPATH)
[springUrl=file:/Users/dkumar9/Desktop/IgniteCluster/apache-ignite-fabric-2.1.0-bin/bin/../examples/config/persistentstore/example-persistent-store.xml]
at
org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:949)
at org.apache.ignite.Ignition.start(Ignition.java:350)
at
org.apache.ignite.startup.cmdline.CommandLineStartup.main(CommandLineStartup.java:302)
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to
instantiate Spring XML application context (make sure all classes used in
Spring configuration are present at CLASSPATH)
[springUrl=file:/Users/dkumar9/Desktop/IgniteCluster/apache-ignite-fabric-2.1.0-bin/bin/../examples/config/persistentstore/example-persistent-store.xml]
at
org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl.applicationContext(IgniteSpringHelperImpl.java:387)
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:668)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:869)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:778)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:648)
at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:617)
at org.apache.ignite.Ignition.start(Ignition.java:347)
... 1 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'ignite.cfg' defined in URL
[file:/Users/dkumar9/Desktop/IgniteCluster/apache-ignite-fabric-2.1.0-bin/bin/../examples/config/persistentstore/example-persistent-store.xml]:
Cannot create inner bean
'org.apache.ignite.configuration.PersistentStoreConfiguration#23e028a9' of
type [org.apache.ignite.configuration.PersistentStoreConfiguration] while
setting bean property 'persistentStoreConfiguration'; nested exception is
org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find
class [org.apache.ignite.configuration.PersistentStoreConfiguration] for
bean with name
'org.apache.ignite.configuration.PersistentStoreConfiguration#23e028a9'
defined in URL
[file:/Users/dkumar9/Desktop/IgniteCluster/apache-ignite-fabric-2.1.0-bin/bin/../examples/config/persistentstore/example-persistent-store.xml];
nested exception is java.lang.ClassNotFoundException:
org.apache.ignite.configuration.PersistentStoreConfiguration
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:313)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:122)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1531)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1276)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:866)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
at
org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl.applicationContext(IgniteSpringHelperImpl.java:381)
... 9 more
Caused by: org.springframework.beans.factory.CannotLoadBeanClassException:
Cannot find class
[org.apache.ignite.configuration.PersistentStoreConfiguration] for bean with
name 'org.apache.ignite.configuration.Pe