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-11499) SQL: DML should not use batches by default
Date Thu, 11 Apr 2019 08:52:00 GMT

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

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

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

> SQL: DML should not use batches by default
> ------------------------------------------
>
>                 Key: IGNITE-11499
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11499
>             Project: Ignite
>          Issue Type: Task
>          Components: sql
>            Reporter: Vladimir Ozerov
>            Assignee: Taras Ledkov
>            Priority: Major
>             Fix For: 2.8
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> Currently DML apply updates in batches equal to {{SqlFieldsQuery.pageSize}}. This is
prone to deadlocks. Instead, we should apply updates one-by-one by default. Proposal:
> # Introduce {{SqlFieldsQuery.updateBatchSize}} property, set it to {{1}} by default
> # Print a warning about deadlock to log if it is greater than 1
> # Add it to JDBC and ODBC drivers
> # Add it to other languages



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

Mime
View raw message