Hi Prasad, > javax.cache.CacheException: Only pessimistic repeatable read transactions are > supported at the moment. Exception mentioned by you should happen only for cache with TRANSACTIONAL_SNAPSHOT atomicity mode configured. Have you configured TRANSACTIONAL_SNAPSHOT atomicity for any cache? As Denis mentioned there are number of bugs related to TRANSACTIONAL_SNAPSHOT, e.g. [1].
[1] https://issues.apache.org/jira/browse/IGNITE-10520 вс, 6 янв. 2019 г. в 20:03, Denis Magda <[email protected]>: > > Hello, > > Ignite versions prior to 2.7 never supported transactions for SQL queries. > You were enlisting SQL in transactions for your own risk. Ignite version 2.7 > introduced true transactional support for SQL based on MVCC. Presently it's > in beta with GA to be available around Q2-Q3 this year. The community is > working on optimizations. > > Please refer to this docs for more details: > https://apacheignite.readme.io/docs/multiversion-concurrency-control > https://apacheignite-sql.readme.io/docs/transactions > https://apacheignite-sql.readme.io/docs/multiversion-concurrency-control > > -- > Denis > > On Sat, Jan 5, 2019 at 7:48 PM Prasad Bhalerao <[email protected]> > wrote: >> >> Can someone please explain if anything has changed in ignite 2.7. >> >> Started getting this exception after upgrading to 2.7. >> >> >> ---------- Forwarded message --------- >> From: Prasad Bhalerao <[email protected]> >> Date: Fri 4 Jan, 2019, 8:41 PM >> Subject: Re: Getting javax.cache.CacheException after upgrading to Ignite >> 2.7 >> To: <[email protected]> >> >> >> Can someone please help me with this? >> >> On Thu 3 Jan, 2019, 7:15 PM Prasad Bhalerao <[email protected] >> wrote: >> >> > Hi >> > >> > After upgrading to 2.7 version I am getting following exception. I am >> > executing a SELECT sql inside optimistic transaction with serialization >> > isolation level. >> > >> > 1) Has anything changed from 2.6 to 2.7 version? This work fine prior to >> > 2.7 version. >> > >> > After changing it to Pessimistic and isolation level to REPEATABLE_READ it >> > works fine. >> > >> > >> > >> > >> > >> > >> > *javax.cache.CacheException: Only pessimistic repeatable read transactions >> > are supported at the moment.at >> > org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:697)at >> > org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:636)at >> > org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy.query(GatewayProtectedCacheProxy.java:388)at >> > com.qualys.agms.grid.dao.AbstractDataGridDAO.getFieldResultsByCriteria(AbstractDataGridDAO.java:85)* >> > >> > Thanks, >> > Prasad >> > -- Best regards, Ivan Pavlukhin
