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

Mariabackup does not support O_DIRECT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.3.18, 10.4.8
    • Fix Version/s: N/A
    • Component/s: Backup
    • Labels:
      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

            Assignee:
            Unassigned
            Reporter:
            mg MG
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: