Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.14
-
None
-
None
-
RHEL 9.6, with mariadb from mariadb repo (not the RHEL included version)
Description
Running a backup with:
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>
|
More info on some of the skipped tables:
MariaDB [ls533]> SHOW TABLE STATUS WHERE Name = 'lime_answers';
|
+--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+--------------------+----------+----------------+---------+--------------------+-----------+
|
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary |
|
+--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+--------------------+----------+----------------+---------+--------------------+-----------+
|
| lime_answers | MyISAM | 10 | Dynamic | 2770 | 21 | 59072 | 281474976710655 | 108544 | 0 | 4542 | 2024-07-22 14:08:28 | 2025-08-28 18:54:06 | 2024-07-22 14:08:28 | utf8mb4_unicode_ci | NULL | | | 288230376151710720 | N |
|
+--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+--------------------+----------+----------------+---------+--------------------+-----------+
|
 |
MariaDB [ls533]> SHOW TABLE STATUS WHERE Name = 'lime_defaultvalues';
|
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+--------------------+----------+----------------+---------+--------------------+-----------+
|
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary |
|
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+--------------------+----------+----------------+---------+--------------------+-----------+
|
| lime_defaultvalues | MyISAM | 10 | Dynamic | 182 | 20 | 3640 | 281474976710655 | 9216 | 0 | 195 | 2024-07-22 14:08:28 | 2025-08-28 16:32:30 | 2024-07-22 14:08:28 | utf8mb4_unicode_ci | NULL | | | 288230376151710720 | N |
|
+--------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+--------------------+----------+----------------+---------+--------------------+-----------+
|
Attachments
Issue Links
- is caused by
-
MDEV-32932 port backup features from MariaDB Enterprise
-
- Closed
-