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

Mariabackup does not support O_DIRECT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.3.18, 10.4.8
    • N/A
    • Backup
    • None

    Description

      # mariabackup --print-defaults
      mariabackup would have been started with the following arguments:
      --innodb_flush_method=O_DIRECT
      # mariabackup --version
      mariabackup based on MariaDB server 10.3.18-MariaDB Linux (x86_64)
      

      # strace -ffff -s2048 -e trace=open mariabackup --innodb_flush_method=O_DIRECT --backup 2>&1 | grep t1
      open("./test/t1.ibd", O_RDONLY|O_CLOEXEC) = 8
      open("./test/t1.ibd", O_RDONLY|O_CLOEXEC) = 13
      [pid  2909] open("/root/mgtmp/xtrabackup_backupfiles/test/t1.ibd", O_WRONLY|O_CREAT|O_EXCL|O_NOFOLLOW|O_CLOEXEC, 0660) = 6
      [01] 2019-10-10 03:16:46 Copying ./test/t1.ibd to /root/mgtmp/xtrabackup_backupfiles/test/t1.ibd
      [pid  2907] open("./test/t1.frm", O_RDONLY|O_CLOEXEC) = 8
      [pid  2907] open("/root/mgtmp/xtrabackup_backupfiles/test/t1.frm", O_WRONLY|O_CREAT|O_EXCL|O_NOFOLLOW|O_CLOEXEC, 0660) = 9
      [01] 2019-10-10 03:16:47 Copying ./test/t1.frm to /root/mgtmp/xtrabackup_backupfiles/test/t1.frm
      

      # strace -ffff -s2048 -e trace=open mariabackup --innodb_flush_method=O_DIRECT --backup 2>&1 | grep O_DIRECT[^O]
      #
      

      Upgrading does not help:

      # mariabackup --print-defaults
      mariabackup would have been started with the following arguments:
      --innodb_flush_method=O_DIRECT
       
      # mariabackup --version
      mariabackup based on MariaDB server 10.4.8-MariaDB Linux (x86_64)
      

      # strace -ffff -s2048 -e trace=open mariabackup --innodb_flush_method=O_DIRECT --backup 2>&1 | grep t1
      open("./test/t1.ibd", O_RDONLY|O_CLOEXEC) = 8
      open("./test/t1.ibd", O_RDONLY|O_CLOEXEC) = 13
      [pid  2479] open("/root/mgtmp/xtrabackup_backupfiles/test/t1.ibd", O_WRONLY|O_CREAT|O_EXCL|O_NOFOLLOW|O_CLOEXEC, 0660) = 6
      [01] 2019-10-10 03:11:26 Copying ./test/t1.ibd to /root/mgtmp/xtrabackup_backupfiles/test/t1.ibd
      

      # strace -ffff -s2048 -e trace=open mariabackup --innodb_flush_method=O_DIRECT --backup 2>&1 | grep O_DIRECT[^O]
      #
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            mg MG
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.