Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.6.6, 10.7.2, 10.8.1, 10.6.7, 10.6.8, 10.7.3, 10.7.4, 10.8.2, 10.8.3, 10.9.1
Description
mariabackup writes space id of each table to stdout once per second, despite space id not having changed:
MariaDB [(none)]> select space, name from information_schema.INNODB_SYS_TABLESPACES where space=56;
|
+-------+--------------------------+
|
| space | name |
|
+-------+--------------------------+
|
| 56 | mysql/innodb_index_stats |
|
+-------+--------------------------+
|
1 row in set (0.001 sec)
|
# grep DDL /mnt/holland/mariabackup/20220718_205103/mariabackup.log |
|
awk '{print $NF}' | sort | uniq -c | head -3
|
|
503 "./mysql/gtid_slave_pos.ibd"
|
503 "./mysql/innodb_index_stats.ibd"
|
503 "./mysql/innodb_table_stats.ibd"
|
|
# awk '/DDL.*innodb_index_stats/ {print $7" "$8" "$9}' /mnt/holland/mariabackup/20220718_205103/mariabackup.log |
|
sort | uniq -c
|
|
503 modify 56 "./mysql/innodb_index_stats.ibd"
|
|
|
# awk '/DDL.*innodb_index_stats/ {print}' /mnt/holland/mariabackup/20220718_205103/mariabackup.log |
|
tail -3
|
|
[00] 2022-07-18 20:54:39 DDL tracking : modify 56 "./mysql/innodb_index_stats.ibd"
|
[00] 2022-07-18 20:54:40 DDL tracking : modify 56 "./mysql/innodb_index_stats.ibd"
|
[00] 2022-07-18 20:54:41 DDL tracking : modify 56 "./mysql/innodb_index_stats.ibd"
|
Attachments
Issue Links
- is caused by
-
MDEV-26326 MDEV-24626 (remove synchronous page0 write) seems to cause mariabackup to skip valid ibd file.
- Closed