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

    XMLWordPrintable

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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13564 TRUNCATE TABLE and undo tablespace truncation are not compatible with Mariabackup

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-19768 Mariabackup should write warning during backup if server does not have innodb_log_optimize_ddl=OFF set

          • Major - Major loss of function.
          • Open

          Activity

            People

              marko Marko Mäkelä
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.