Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19769

Mariabackup should write warning during backup if server does not have innodb_safe_truncate=ON set

    Details

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vlad.lesin Vladislav Lesin
                Reporter:
                GeoffMontee Geoff Montee
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: