mariadb "Last checkpoint at" behavior broken when inserting data since 10.5.7 and nobody cares? This breaks mariabackup inc backups (even still in 10.9.x)!
We have a major issue with mariadb-server starting from 10.5.7 as described below, thank your for your time.
MariaBackup and the values in file "xtrabackup_
BEFORE 10.5.7
Checkpoint Value is increased every time you insert/commit data
Full backup -> Size 70GB
inc 1 backup: ~25mb
inc 2 backup : ~25mb
and so on
STARTING FROM 10.5.7 (until even newest 10.9.x) it changes
Checkpoint Value is NOT INCREASING. Only mariadb service restart changes it so far. So leaves us with gigantic inc backups
Full backup -> Size 70GB
inc 1 backup: Size 70GB + x
inc 2 backup : Size 70GB + xy
so every inc backup is BIGGER than the Full backup at the beginning!
the faulty behavior is supported by the inc file output:
backup_type = incremental
from_lsn = 1049533741592
to_lsn = 1049533741592
last_lsn = 1050057849314
to_lsn and from_lsn are NOT INCREASING until we restart the whole database - which is clear because mariadb-server doesn't change the checkpoint values. Why is that???
What am I missing? I noticed some parameter changes in 10.5.7:
Question information
- Language:
- English Edit question
- Status:
- Answered
- For:
- MariaDB Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask Sebastian Bergmann for more information if necessary.