ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ryabov Dmitrii (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-4188) Savepoints support inside of Ignite Transactions
Date Mon, 17 Sep 2018 12:26:00 GMT

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

Ryabov Dmitrii commented on IGNITE-4188:
----------------------------------------

{panel:title=Possible Blockers|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Binary Objects (Simple Mapper Basic){color} [[tests 0 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=1850179]]
* TxSavepointsTransactionalCacheTest.testPutWithExplicitTx (last started)

{color:#d04437}Basic 1{color} [[tests 0 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=1850276]]
* TxSavepointsTransactionalCacheTest.testPutWithExplicitTx (last started)

{color:#d04437}Cache (Restarts) 1{color} [[tests 0 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=1850256]]
* GridCacheReplicatedNodeRestartSelfTest.testRestartWithTxPutAllFourNodesTwoBackups (last
started)

{color:#d04437}Queries 1{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=1850265]]
* IgniteBinaryCacheQueryTestSuite: IndexingCachePartitionLossPolicySelfTest.testReadWriteSafeWithBackupsAfterKillCrd
- 0,0% fails in last 100 master runs.

{color:#d04437}SPI{color} [[tests 2|https://ci.ignite.apache.org/viewLog.html?buildId=1850215]]
* IgniteSpiTestSuite: TcpCommunicationSpiDropNodesTest.testOneNode - 0,0% fails in last 100
master runs.

{color:#d04437}PDS 2{color} [[tests 2|https://ci.ignite.apache.org/viewLog.html?buildId=1850239]]
* IgnitePdsTestSuite2: IgnitePdsPartitionFilesDestroyTest.testPartitionFileDestroyCrashRecovery1
- 0,0% fails in last 100 master runs.

{color:#d04437}PDS (Direct IO) 2{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=1850235]]
* IgnitePdsNativeIoTestSuite2: IgniteWalFormatFileFailoverTest.testFailureHandlerTriggered
- 0,0% fails in last 100 master runs.

{color:#d04437}Cache 5{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=1850263]]
* IgniteCacheWithIndexingTestSuite: CacheTtlAtomicPartitionedSelfTest.testDefaultTimeToLiveLoadAll
- 0,0% fails in last 100 master runs.

{color:#d04437}Continuous Query 1{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=1850189]]
* IgniteCacheQuerySelfTestSuite3: CacheContinuousWithTransformerPartitionedSelfTest.testContinuousWithTransformerAndRegularListenerAsync
- 0,0% fails in last 100 master runs.

{color:#d04437}Compute (Grid){color} [[tests 2|https://ci.ignite.apache.org/viewLog.html?buildId=1850187]]
* IgniteBinaryObjectsComputeGridTestSuite: GridMultithreadedJobStealingSelfTest.testJoinedNodeCanStealJobs
- 0,0% fails in last 100 master runs.

{color:#d04437}Java Client{color} [[tests 2|https://ci.ignite.apache.org/viewLog.html?buildId=1850201]]
* IgniteClientTestSuite: ClientReconnectionSelfTest.testFailedInit - 0,0% fails in last 100
master runs.

{panel}
[TeamCity Run All|http://ci.ignite.apache.org/viewLog.html?buildId=1850279&amp;buildTypeId=IgniteTests24Java8_RunAll]

> Savepoints support inside of Ignite Transactions
> ------------------------------------------------
>
>                 Key: IGNITE-4188
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4188
>             Project: Ignite
>          Issue Type: Task
>            Reporter: Denis Magda
>            Assignee: Ryabov Dmitrii
>            Priority: Major
>             Fix For: 2.7
>
>
> A savepoint is a special mark inside a transaction that allows all commands that are
executed after it was established to be rolled back, restoring the transaction state to what
it was at the time of the savepoint.
> Here is a reference to the similar functionality implemented by some of RDBMs vendors.
> https://www.postgresql.org/docs/8.1/static/sql-savepoint.html
> https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10001.htm
> http://dev.mysql.com/doc/refman/5.7/en/savepoint.html
> Consider the following example.
> {code}
> BEGIN;
> INSERT INTO table1 VALUES (1); 
> SAVEPOINT my_savepoint; 
> INSERT INTO table1 VALUES (2); 
> ROLLBACK TO SAVEPOINT my_savepoint; 
> INSERT INTO table1 VALUES (3); 
> COMMIT;
> {code}
> The execution result must guarantee that only values 1 and 3 are inserted into table1.
> In Ignite, it should be supported this way (preserving the same behavior as above).
> {code}
> Ignite ignite = ....;
> IgniteCache<Integer, Integer> c = ....;
> try (Transaction tx = ignite.transactions().txStart()) {    
>     c.put(1, 1);
>     
>     tx.savepoint("mysavepoint");
>     
>     c.put(2, 2);
>     
>     tx.rollbackToSavepoint("mysavepoint");
>     
>     c.put(3, 3);
>     
>     tx.commit();
> }
> {code}
> As a summary the following has to be supported on Ignite side:
> - The {{savepoint}} method which will set a named transaction savepoint with a name of
an identifier.
> - Multiple savepoints defined within a transaction. The names of the savepoints have
to differ from each other. If the current transaction has a savepoint with the same name,
the old savepoint is deleted and a new one is set.
> - The {{rollbackToSavepoint}} method that will roll back all the changes done after a
specific checkpoint establishment.
> - The {{releaseCheckpoint}} method that will destroy a savepoint, keeping the effects
of commands executed after it was established.
> - Full support of the behavior listed above at the level of ODBC and JDBC drivers and
DML (will be handled under separate tickets).
> - The behavior has to be support for all transactional modes.
> Original proposal on the dev list:
> http://apache-ignite-developers.2346864.n4.nabble.com/TX-savepoints-td12041.html



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

Mime
View raw message