Skip to content

checkpoint_wal_threshold doesn't account WALs created before a restart #9811

@sergepetrenko

Description

@sergepetrenko

Bug description
The wal size counter since last checkpoint is reset to 0 on instance restart.
Steps to reproduce

  1. Set box.cfg{wal_max_size=512, checkpoint_wal_threshold=10*512} -- there should be approximately 10 xlogs between checkpoints.
  2. write some data, restart the instance, write some more data.
  3. Check the created xlogs and snaps:
-rw-r--r--  1 s.petrenko  staff   5,0K 14 мар 11:22 00000000000000001426.snap <-- first snap
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001426.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001434.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001442.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001450.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001458.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001466.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001474.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001482.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:22 00000000000000001490.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001498.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001506.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001514.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001522.xlog
-rw-r--r--  1 s.petrenko  staff   379B 14 мар 11:23 00000000000000001530.xlog
-rw-r--r--  1 s.petrenko  staff   5,0K 14 мар 11:23 00000000000000001535.snap <-- next snap after 14 xlogs (it's not clear why 14 and not 10)
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001535.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001543.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001551.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001559.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001567.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001575.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001583.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001591.xlog
-rw-r--r--  1 s.petrenko  staff   191B 14 мар 11:23 00000000000000001599.xlog <-- restart happened here
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001600.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001608.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001616.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001624.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001632.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001640.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001648.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001656.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001664.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001672.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001680.xlog
-rw-r--r--  1 s.petrenko  staff   520B 14 мар 11:23 00000000000000001688.xlog
-rw-r--r--  1 s.petrenko  staff   328B 14 мар 11:23 00000000000000001696.xlog <-- no snap for 22 xlogs.

Metadata

Metadata

Assignees

Labels

2.11Target is 2.11 and all newer release/master branchesbugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions