ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitriy Pavlov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-6935) SQL TX: Locking protocol for simple queries
Date Tue, 26 Jun 2018 17:51:20 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-6935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dmitriy Pavlov updated IGNITE-6935:
-----------------------------------
    Fix Version/s:     (was: 2.6)
                   2.7

> SQL TX: Locking protocol for simple queries
> -------------------------------------------
>
>                 Key: IGNITE-6935
>                 URL: https://issues.apache.org/jira/browse/IGNITE-6935
>             Project: Ignite
>          Issue Type: Task
>          Components: cache, sql
>            Reporter: Vladimir Ozerov
>            Assignee: Igor Seliverstov
>            Priority: Major
>              Labels: iep-3
>             Fix For: 2.7
>
>
> We need to develop locking protocol for SQL queries. Design considerations:
> 1) Use {{GridNeaLockRequest|Response}} as a template for new messages
> 2) Cover only queries which doesn't require reduce stage (see server-side DML optimization
code, e.g. {{GridH2DmlRequest}}).
> 3) When next entry is found, try locking it. If it is already locked, then register current
TX as candidate in MVCC manager and go to the next row. Other TXes will notify use when entries
are released. Send a response when all entries are locked.
> 4) Read entry version before locking and after. If they doesn't match (i.e. concurrent
modification occurred), then throw an exception.



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

Mime
View raw message