You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ignite.apache.org by Yakov Zhdanov <yz...@apache.org> on 2017/02/09 04:42:46 UTC

DML & Transactions

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

Re: DML & Transactions

Posted by Denis Magda <dm...@apache.org>.

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 <da...@gmail.com> 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 <ds...@apache.org>:
> 
>> On Wed, Feb 8, 2017 at 10:20 PM, Yakov Zhdanov <yz...@apache.org>
>> 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 <se...@gmail.com>:
>>> 
>>>> 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 <yz...@apache.org>:
>>>> 
>>>>> 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
>>>>> 
>>>> 
>>> 
>>

Re: DML & Transactions

Posted by Vyacheslav Daradur <da...@gmail.com>.

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 <ds...@apache.org>:

> On Wed, Feb 8, 2017 at 10:20 PM, Yakov Zhdanov <yz...@apache.org>
> 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 <se...@gmail.com>:
> >
> > > 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 <yz...@apache.org>:
> > >
> > > > 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
> > > >
> > >
> >
>

Re: DML & Transactions

Posted by Dmitriy Setrakyan <ds...@apache.org>.

On Wed, Feb 8, 2017 at 10:20 PM, Yakov Zhdanov <yz...@apache.org> 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 <se...@gmail.com>:
>
> > 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 <yz...@apache.org>:
> >
> > > 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
> > >
> >
>

Re: DML & Transactions

Posted by Denis Magda <dm...@apache.org>.

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 <yz...@apache.org> 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 <se...@gmail.com>:
> 
>> 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 <yz...@apache.org>:
>> 
>>> 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
>>> 
>>

Re: DML & Transactions

Posted by Yakov Zhdanov <yz...@apache.org>.

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 <se...@gmail.com>:

> 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 <yz...@apache.org>:
>
> > 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
> >
>

Re: DML & Transactions

Posted by Sergi Vladykin <se...@gmail.com>.

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 <yz...@apache.org>:

> 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
>