[MDEV-19769] Mariabackup should write warning during backup if server does not have innodb_safe_truncate=ON set Created: 2019-06-15  Updated: 2023-10-12

Status: Open
Project: MariaDB Server
Component/s: Backup, Data Definition - Alter Table, mariabackup, Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-13564 TRUNCATE TABLE and undo tablespace tr... Closed
relates to MDEV-19768 Mariabackup should write warning duri... Open

 Description   

In MariaDB 10.2, some DDL statements can lead to inconsistent backups unless the server has innodb_safe_truncate=ON set. See MDEV-13564 for more information.

https://mariadb.com/kb/en/library/mariabackup-overview/#concurrent-ddl-and-backup-issues

https://mariadb.com/kb/en/library/innodb-system-variables/#innodb_safe_truncate

Maybe Mariabackup in MariaDB 10.2 should write a warning if a backup is taken when innodb_safe_truncate=ON is not set? i.e. something like this?:

[Warning] The server does not have innodb_safe_truncate set to ON. If certain DDL statements are executed during the backup, then the backup can be inconsistent.

 Comments   
Comment by Ralf Gebhardt [ 2023-10-12 ]

I have removed the fixVersion for this task as it is one of 5.5, 10.1, 10.2, 10.3, which are EOLed.

Please add a new fixVersion if you plan to work on this task for a not EOLed versions.

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