There may be several reasons:
1)Rare checkpoints;
2)Historical rebalancing;
3)Large transactions.

reason='too big size of WAL without checkpoint' - means that there are too many 
segments without a checkpoint.This is possible with a heavy data load.

01.03.2021, 19:35, "narges saleh" <[email protected]>:
> Hi All,
>
> What could be the reason for the wal folder filling up and the message "too 
> big size of WAL without checkpoint"? Too small or too big checkpoint interval 
> or buffer?
>
> [2021-02-28 09:12:12,9811][INFO 
> ][db-checkpoint-thread-#108][GridCacheDatabaseSharedManager] Checkpoint 
> started [checkpointId=5c947ef6-d9c3-40a2-b99e-09ffdaddd304, 
> startPtr=FileWALPointer [idx=25903, fileOff=12783980, len=228894], 
> checkpointBeforeLockTime=92ms, checkpointLockWait=0ms, 
> checkpointListenersExecuteTime=19ms, checkpointLockHoldTime=22ms, 
> walCpRecordFsyncDuration=58ms, writeCheckpointEntryDuration=9ms, 
> splitAndSortCpPagesDuration=214ms,  pages=229075, reason='too big size of WAL 
> without checkpoint']
>
> thanks
  • wal issues narges saleh
    • Re: wal issues ткаленко кирилл

Reply via email to