[MDEV-29685] Incremental backup does not work Created: 2022-10-03  Updated: 2023-08-25  Resolved: 2023-08-25

Status: Closed
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.3.36, 10.4.26
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Timofey Turenko Assignee: Timofey Turenko
Resolution: Not a Bug Votes: 0
Labels: None

Attachments: File backup.tar.gz     HTML File log104_short    
Issue Links:
Relates
relates to MDEV-30026 incremental backup creates broken fil... Closed

 Description   

test scenarion:

1. create one table, make first backup

sudo mariadb-backup -utest_user -p**** --backup --target-dir=backup/base_backup_dir

2. create second table, create next part of backup:
sudo mariadb-backup -utest_user -p**** --backup --incremental-basedir=backup/base_backup_dir --target-dir=backup/inc_backup_dir_2

repeat it several times

3. clean DB directory, start backup prepare:

sudo mariadb-backup --prepare --target-dir=backup_prepare/base_backup_dir
sudo mariadb-backup --prepare --target-dir=backup_prepare/base_backup_dir --incremental-dir=backup_prepare/inc_backup_dir_2
sudo mariadb-backup --prepare --target-dir=backup_prepare/base_backup_dir --incremental-dir=backup_prepare/inc_backup_dir_3

the last command fails:

sudo mariadb-backup --prepare --target-dir=backup_prepare/base_backup_dir --incremental-dir=backup_prepare/inc_backup_dir_3
mariadb-backup based on MariaDB server 10.4.26-MariaDB debian-linux-gnu (x86_64)
[00] 2022-10-03 11:43:22 incremental backup from 900277 is enabled.
[00] 2022-10-03 11:43:22 cd to /home/vagrant/backup_prepare/base_backup_dir/
[00] 2022-10-03 11:43:22 open files limit requested 0, set to 65536
[00] 2022-10-03 11:43:22 This target seems to be already prepared.
[00] 2022-10-03 11:43:22 error: This incremental backup seems not to be proper for the target. Check 'to_lsn' of the target and 'from_lsn' of the incremental.

full test log is attached (log104), files created by mariadb-backup - backup.tar.gz
the same test is ok for 10.5, 10.6, 10.7, 10.8, 10.9



 Comments   
Comment by Timofey Turenko [ 2023-08-16 ]

The documentation issue is open

Test now uses scenario from CS doc https://mariadb.com/kb/en/incremental-backup-and-restore-with-mariabackup/

Comment by Timofey Turenko [ 2023-08-25 ]

test is re-implemented according https://mariadb.com/kb/en/incremental-backup-and-restore-with-mariabackup/

Comment by Timofey Turenko [ 2023-08-25 ]

it is a documentation issue

Generated at Thu Feb 08 10:10:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.