Hi Daniel,
Done: MDEV-37634
Please let me know if there is anything I can add, help, do or test.
MJ
On 9/11/25 10:26, Daniel Black via discuss wrote:
This looks highly suspicious.
Can you create a bug report please https://jira.mariadb.org/?
Include your MariaDB version and the types of the tables in the "at it
is in exclude list"
On Wed, 10 Sept 2025 at 23:41, sacawulu via discuss
<[email protected]> wrote:
Hi,
I wonder if someone can explain the following mariabackup behaviour.
I am running this mariabackup command:
mariabackup --backup --host=localhost --port=3306 --parallel=2 --galera-info
--extra-lsndir=/data/mariabackup --stream=mbstream | pigz >
/data/mariabackup/full_20250910.backup.stream.gz
We observe the databases and tables scrolling by, as they are backupped.
However, we also see many "Skip table" lines like:
<snip>
[00] 2025-09-10 14:54:00 Started BACKUP STAGE BLOCK_DDL
[00] 2025-09-10 14:54:00 Acquired locks for BACKUP STAGE BLOCK_DDL
[00] 2025-09-10 14:54:00 Start scanning common engine tables, need backup
locks: 1, collect log and stat tables: 0
[00] 2025-09-10 14:54:00 Skip table 533.lime_answers at it is in exclude list
[00] 2025-09-10 14:54:00 Skip table 533.lime_conditions at it is in exclude list
[00] 2025-09-10 14:54:00 Skip table 533.lime_assessments at it is in exclude
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_assessments at it is in exclude
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_asset_version at it is in exclude
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_asset_version at it is in exclude
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_defaultvalues at it is in exclude
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_defaultvalue_l10ns at it is in
exclude list
[00] 2025-09-10 14:54:00 Skip table 533.lime_boxes at it is in exclude list
[00] 2025-09-10 14:54:00 Skip table 533.lime_defaultvalue_l10ns at it is in
exclude list
<snip>
But as you can see in my actual command, I am not excluding anything.
When extracting/preparing the created backup, we can see that the tables
are in fact present in the backup.
Note, the above tables ONLY appear as a "Skipped table" line, and never
as a "Copied file" line.
Is this expected? Should I question the completeness of my backups...?
MJ
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
