ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ignite TC Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-10884) Failure to perform non-MVCC SQL from transactions
Date Fri, 11 Jan 2019 13:20:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-10884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16740371#comment-16740371
] 

Ignite TC Bot commented on IGNITE-10884:
----------------------------------------

{panel:title=-&gt; Run :: MVCC Cache: No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
[TeamCity *-&gt; Run :: MVCC Cache* Results|https://ci.ignite.apache.org/viewLog.html?buildId=2770400&amp;buildTypeId=IgniteTests24Java8_RunMvccCache]

> Failure to perform non-MVCC SQL from transactions
> -------------------------------------------------
>
>                 Key: IGNITE-10884
>                 URL: https://issues.apache.org/jira/browse/IGNITE-10884
>             Project: Ignite
>          Issue Type: Bug
>          Components: mvcc, sql
>    Affects Versions: 2.7
>            Reporter: Ilya Kasnacheev
>            Assignee: Roman Kondakov
>            Priority: Blocker
>             Fix For: 2.8
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> MVCC was added with expectation is that it would not affect existing KV transactional
code, neither SQL on non-TRANSACTIONAL_SNAPSHOT caches.
> However, this turned not to be the case: if you open an OPTIMISIC SERIALIZABLE transaction
and do SQL query to fetch data from table, exception will be thrown with *Only pessimistic
repeatable read transactions are supported at the moment*
> {code}
> Exception in thread "main" 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 IgniteTransactionTester.testTransactionException(IgniteTransactionTester.java:53)
> 	at IgniteTransactionTester.main(IgniteTransactionTester.java:38)
> Caused by: class org.apache.ignite.internal.processors.query.IgniteSQLException: Only
pessimistic repeatable read transactions are supported at the moment.
> 	at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.tx(MvccUtils.java:690)
> 	at org.apache.ignite.internal.processors.cache.mvcc.MvccUtils.tx(MvccUtils.java:671)
> 	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.runQueryTwoStep(IgniteH2Indexing.java:1793)
> 	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunDistributedQuery(IgniteH2Indexing.java:2610)
> 	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunPrepared(IgniteH2Indexing.java:2315)
> 	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2209)
> 	at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2135)
> 	at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2130)
> 	at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
> 	at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2707)
> 	at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2144)
> 	at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:685)
> 	... 4 more
> {code}
> This is a major regression towards 2.6. Please see linked reproducer (IgniteTransactionTester
class).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message