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

Concurrent DDL can break xtrabackup-v2 SST in 10.2

    XMLWordPrintable

Details

    Description

      Concurrent DDL can cause xtrabackup to see the following error in MariaDB 10.2:

      [FATAL] InnoDB: An optimized(without redo logging) DDLoperation has been performed. All modified pages may not have been flushed to the disk yet.
      

      This problem is described here:

      https://www.percona.com/blog/2017/08/08/avoiding-the-an-optimized-without-redo-logging-ddloperation-has-been-performed-error-with-percona-xtrabackup/

      This also seems to effect xtrabackup-v2 SSTs. Should the SST script use the --lock-ddl-per-table option in 10.2 to avoid this?

      Attachments

        Issue Links

          Activity

            People

              anikitin Andrii Nikitin (Inactive)
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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