DML & Transactions

[yzhdanov]

Guys (esp Alex P and Sergi),

Do we preserve transactional semantics of updates?

In other words, does the following make sense? and when it does not?

startTx()
insert into blabla...
update bla bla...
commit()

--Yakov

[Sergi]

Not yet, we need MVCC over PageMemory for this. Probably it will arrive in
some 2.x version.

Sergi

2017-02-09 7:42 GMT+03:00 Yakov Zhdanov <[hidden email]>:

> Guys (esp Alex P and Sergi),
>
> Do we preserve transactional semantics of updates?
>
> In other words, does the following make sense? and when it does not?
>
> startTx()
> insert into blabla...
> update bla bla...
> commit()
>
> --Yakov
>

[yzhdanov]

Guys, I think we should explicitly state this on readme.io - Do not use DML
within transactions.

And probably throw an exception on such attempts.

--Yakov

2017-02-09 12:08 GMT+07:00 Sergi Vladykin <[hidden email]>:

> Not yet, we need MVCC over PageMemory for this. Probably it will arrive in
> some 2.x version.
>
> Sergi
>
> 2017-02-09 7:42 GMT+03:00 Yakov Zhdanov <[hidden email]>:
>
> > Guys (esp Alex P and Sergi),
> >
> > Do we preserve transactional semantics of updates?
> >
> > In other words, does the following make sense? and when it does not?
> >
> > startTx()
> > insert into blabla...
> > update bla bla...
> > commit()
> >
> > --Yakov
> >
>

[dsetrakyan]

On Wed, Feb 8, 2017 at 10:20 PM, Yakov Zhdanov <[hidden email]> wrote:

> Guys, I think we should explicitly state this on readme.io - Do not use
> DML
> within transactions.
>
> And probably throw an exception on such attempts.
>

Absolutely agree. I would say that DML within transactions is not supported
yet. We expert to have support for it in version 2.x.

> --Yakov
>
> 2017-02-09 12:08 GMT+07:00 Sergi Vladykin <[hidden email]>:
>
> > Not yet, we need MVCC over PageMemory for this. Probably it will arrive
> in
> > some 2.x version.
> >
> > Sergi
> >
> > 2017-02-09 7:42 GMT+03:00 Yakov Zhdanov <[hidden email]>:
> >
> > > Guys (esp Alex P and Sergi),
> > >
> > > Do we preserve transactional semantics of updates?
> > >
> > > In other words, does the following make sense? and when it does not?
> > >
> > > startTx()
> > > insert into blabla...
> > > update bla bla...
> > > commit()
> > >
> > > --Yakov
> > >
> >
>

[daradurvs]

Hello everyone.

Sergi, you wrote about the MVCC.

It's very interesting and perspective.

Someone already does it?

2017-02-09 9:25 GMT+03:00 Dmitriy Setrakyan <[hidden email]>:

> On Wed, Feb 8, 2017 at 10:20 PM, Yakov Zhdanov <[hidden email]>
> wrote:
>
> > Guys, I think we should explicitly state this on readme.io - Do not use
> > DML
> > within transactions.
> >
> > And probably throw an exception on such attempts.
> >
>
> Absolutely agree. I would say that DML within transactions is not supported
> yet. We expert to have support for it in version 2.x.
>
>
> > --Yakov
> >
> > 2017-02-09 12:08 GMT+07:00 Sergi Vladykin <[hidden email]>:
> >
> > > Not yet, we need MVCC over PageMemory for this. Probably it will arrive
> > in
> > > some 2.x version.
> > >
> > > Sergi
> > >
> > > 2017-02-09 7:42 GMT+03:00 Yakov Zhdanov <[hidden email]>:
> > >
> > > > Guys (esp Alex P and Sergi),
> > > >
> > > > Do we preserve transactional semantics of updates?
> > > >
> > > > In other words, does the following make sense? and when it does not?
> > > >
> > > > startTx()
> > > > insert into blabla...
> > > > update bla bla...
> > > > commit()
> > > >
> > > > --Yakov
> > > >
> > >
> >
>

[dmagda]

Updated DML limitations section
http://apacheignite.gridgain.org/v1.8/docs/dml#section-transactional-support <http://apacheignite.gridgain.org/v1.8/docs/dml#section-transactional-support>

Feel free to edit if needed.

—
Denis

> On Feb 8, 2017, at 10:20 PM, Yakov Zhdanov <[hidden email]> wrote:
>
> Guys, I think we should explicitly state this on readme.io - Do not use DML
> within transactions.
>
> And probably throw an exception on such attempts.
>
> --Yakov
>
> 2017-02-09 12:08 GMT+07:00 Sergi Vladykin <[hidden email]>:
>
>> Not yet, we need MVCC over PageMemory for this. Probably it will arrive in
>> some 2.x version.
>>
>> Sergi
>>
>> 2017-02-09 7:42 GMT+03:00 Yakov Zhdanov <[hidden email]>:
>>
>>> Guys (esp Alex P and Sergi),
>>>
>>> Do we preserve transactional semantics of updates?
>>>
>>> In other words, does the following make sense? and when it does not?
>>>
>>> startTx()
>>> insert into blabla...
>>> update bla bla...
>>> commit()
>>>
>>> --Yakov
>>>
>>

[dmagda]

Hello,

Yes, MVCC has already been being designed and developed by multiple community members including Sergi.

If you prefer to take a big feature for dev then I would suggest considering these tasks:
https://ignite.apache.org/community/contribute.html#pick-ticket <https://ignite.apache.org/community/contribute.html#pick-ticket>

—
Denis

> On Feb 9, 2017, at 2:22 AM, Vyacheslav Daradur <[hidden email]> wrote:
>
> Hello everyone.
>
> Sergi, you wrote about the MVCC.
>
> It's very interesting and perspective.
>
> Someone already does it?
>
> 2017-02-09 9:25 GMT+03:00 Dmitriy Setrakyan <[hidden email]>:
>
>> On Wed, Feb 8, 2017 at 10:20 PM, Yakov Zhdanov <[hidden email]>
>> wrote:
>>
>>> Guys, I think we should explicitly state this on readme.io - Do not use
>>> DML
>>> within transactions.
>>>
>>> And probably throw an exception on such attempts.
>>>
>>
>> Absolutely agree. I would say that DML within transactions is not supported
>> yet. We expert to have support for it in version 2.x.
>>
>>
>>> --Yakov
>>>
>>> 2017-02-09 12:08 GMT+07:00 Sergi Vladykin <[hidden email]>:
>>>
>>>> Not yet, we need MVCC over PageMemory for this. Probably it will arrive
>>> in
>>>> some 2.x version.
>>>>
>>>> Sergi
>>>>
>>>> 2017-02-09 7:42 GMT+03:00 Yakov Zhdanov <[hidden email]>:
>>>>
>>>>> Guys (esp Alex P and Sergi),
>>>>>
>>>>> Do we preserve transactional semantics of updates?
>>>>>
>>>>> In other words, does the following make sense? and when it does not?
>>>>>
>>>>> startTx()
>>>>> insert into blabla...
>>>>> update bla bla...
>>>>> commit()
>>>>>
>>>>> --Yakov
>>>>>
>>>>
>>>
>>