Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.6.11
-
None
Description
test scenario:
1. create 1M file (e.g file1M.bin), file can contain zeros or random data
2. start thread which executes
`INSERT INTO Test
VALUES (LOAD_FILE('/tmp/file1M.bin'))`
in the loop
3. in another thread:
create table (e.g `CREATE TABLE table1 (i INT, s VARCHAR(1024))`) and put some number of rows into it (in my test 10000)
make a first part of backup:
`sudo mariadb-backup -utest_user -pct570c3521fCCR# --backup --target-dir=backup/base_backup_dir `
4. create another table, put data into it, make a next part of the backup:
`sudo mariadb-backup -utest_user -pct570c3521fCCR# --backup --incremental-basedir=backup/base_backup_dir --target-dir=backup/inc_backup_dir_2 `
5. repeat step 4 several times
6. try to prepare backup for restore:
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
|
....
|
Result:
two first parts are ok, 3rd failed:
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.6.11-MariaDB debian-linux-gnu (x86_64)
|
[00] 2022-11-17 15:28:47 incremental backup from 1311892709 is enabled.
|
[00] 2022-11-17 15:28:47 cd to /home/ubuntu/backup_prepare/base_backup_dir/
|
[00] 2022-11-17 15:28:47 open files limit requested 0, set to 1024
|
[00] 2022-11-17 15:28:47 This target seems to be already prepared.
|
[00] 2022-11-17 15:28:47 error: This incremental backup seems not to be proper for the target. Check 'to_lsn' of the target and 'from_lsn' of the incremental.
|
attached backup.tar.gz - files created by mariadb-backup
The error looks similar to MDEV-29685, which is reproducible only for 10.3 and 10.4
Attachments
Issue Links
- relates to
-
MDEV-14992 BACKUP: in-server backup
-
- Open
-
-
-
- Closed
-