You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "shivakumar (Jira)" <ji...@apache.org> on 2020/12/24 18:11:00 UTC

[jira] [Comment Edited] (IGNITE-13831) Move WAL archive cleanup from checkpoint to rollover

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

shivakumar edited comment on IGNITE-13831 at 12/24/20, 6:10 PM:
----------------------------------------------------------------

Hi [~ktkalenko@gridgain.com] [~ilyak] [~akalashnikov]

With latest master branch code I'm facing WAL issue, when there is a continuous stream of data (sql inserts) to sql table then WAL is growing without any limit.

This happens when there is a stream of data and at that time if I connect to visor then WAL usage will continuously grow (I have seen WAL growing more than 300GB and disk runs out of space )

The same test was working fine without any issue with December 13th master branch code, from that time this is the major change(also IGNITE13847) related to WAL segment removal, could you please check if there is any issue.

These are the WAL related parameters set as part of ignite configurations;

 <property name="writeThrottlingEnabled" value="true"/>
 <property name="checkpointFrequency" value="#\{1 * 60 * 1000}"/>
 <property name="walSegmentSize" value="#\{1L * 1024 * 1024 * 1024}"/>
 <property name="maxWalArchiveSize" value="#\{10L * 1024 * 1024 * 1024}"/>
 <property name="storagePath" value="/opt/ignite/persistence/"/>
 <property name="walPath" value="/opt/ignite/wal/"/>
 <property name="walArchivePath" value="/opt/ignite/wal/"/>
 <property name="walMode" value="FSYNC"/>

 

Regards,

Shiva 

 

  


was (Author: shm):
Hi 

With latest master branch code I'm facing WAL issue, when there is a continuous stream of data (sql inserts) to sql table then WAL is growing without any limit.

This happens when there is a stream of data and at that time if I connect to visor then WAL usage will continuously grow (I have seen WAL growing more than 300GB and disk runs out of space )

The same test was working fine without any issue with December 13th master branch code, from that time this is the major change(also [IGNITE13847|https://issues.apache.org/jira/browse/IGNITE-13847]) related to WAL segment removal, could you please check if there is any issue.

These are the WAL related parameters set as part of ignite configurations;

 <property name="writeThrottlingEnabled" value="true"/>
 <property name="checkpointFrequency" value="#\{1 * 60 * 1000}"/>
 <property name="walSegmentSize" value="#\{1L * 1024 * 1024 * 1024}"/>
 <property name="maxWalArchiveSize" value="#\{10L * 1024 * 1024 * 1024}"/>
 <property name="storagePath" value="/opt/ignite/persistence/"/>
 <property name="walPath" value="/opt/ignite/wal/"/>
 <property name="walArchivePath" value="/opt/ignite/wal/"/>
 <property name="walMode" value="FSYNC"/>

 

Regards,

Shiva 

 

  

> Move WAL archive cleanup from checkpoint to rollover
> ----------------------------------------------------
>
>                 Key: IGNITE-13831
>                 URL: https://issues.apache.org/jira/browse/IGNITE-13831
>             Project: Ignite
>          Issue Type: Improvement
>          Components: persistence
>            Reporter: Kirill Tkalenko
>            Assignee: Kirill Tkalenko
>            Priority: Major
>             Fix For: 2.10
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Users expect *DataStorageConfiguration#maxWalArchiveSize* to mean that WAL archive will not exceed this value, but it is not.
> It seems that to reduce the chance of getting into a situation when we exceed WAL archive, it will be lowed when we clean it when switching to a new segment than at the end of the checkpoint. It is proposed to move the archive cleanup to *FileWriteAheadLogManager#rollOver* when the *DataStorageConfiguration#maxWalArchiveSize* is reached.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)