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

mariabackup fails when innodb_max_dirty_pages_pct contains a fraction (is not an integer)

Details

    Description

      Hi,

      I have set innodb_max_dirty_pages_pct to 0.5 and the database is starting and working fine with this setting. However, mariabackup fails:

      Unknown suffix '.' used for variable 'innodb_max_dirty_pages_pct' (value '0.5')
      		 
      /opt/mysql/bin/mariabackup: Error while setting value '0.5' to 'innodb_max_dirty_pages_pct'

      This issue was fixed in xtrabackup 2.4.15 (https://jira.percona.com/browse/PXB-1807).

      Cheers,
      Volker

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          vklasen Volker Klasen created issue -
          vklasen Volker Klasen made changes -
          Field Original Value New Value
          Description Hi,

          I have set innodb_max_dirty_pages_pct to 0.5 and the database is starting and working fine with this setting. However, mariadbbackup fails:

          {code}
          Unknown suffix '.' used for variable 'innodb_max_dirty_pages_pct' (value '0.5')
          /opt/mysql/bin/mariabackup: Error while setting value '0.5' to 'innodb_max_dirty_pages_pct'
          {code}

          This issue was fixed in xtrabackup 2.4.15 (https://jira.percona.com/browse/PXB-1807).

          Cheers,
          Volker           		Hi,

          I have set innodb_max_dirty_pages_pct to 0.5 and the database is starting and working fine with this setting. However, mariabackup fails:

          {code}
          Unknown suffix '.' used for variable 'innodb_max_dirty_pages_pct' (value '0.5')
          /opt/mysql/bin/mariabackup: Error while setting value '0.5' to 'innodb_max_dirty_pages_pct'
          {code}

          This issue was fixed in xtrabackup 2.4.15 (https://jira.percona.com/browse/PXB-1807).

          Cheers,
          Volker
          elenst Elena Stepanova made changes -
          Component/s mariabackup [ 14500 ]
          Component/s Backup [ 13902 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Assignee Andrei Elkin [ elkin ]
          elenst Elena Stepanova made changes -
          Assignee Andrei Elkin [ elkin ] Vladislav Lesin [ vlad.lesin ]
          vklasen Volker Klasen made changes -
          Affects Version/s 10.4.11 [ 24013 ]
          vklasen Volker Klasen added a comment -

          This is the fix's commit in Percona's Xtrabackup:

          https://github.com/percona/percona-xtrabackup/commit/5265f42e290573e9591f8ca28ab66afc051f89a3

          vklasen Volker Klasen added a comment - This is the fix's commit in Percona's Xtrabackup: https://github.com/percona/percona-xtrabackup/commit/5265f42e290573e9591f8ca28ab66afc051f89a3
          vklasen Volker Klasen added a comment -

          Still an issue in 10.4.17

          vklasen Volker Klasen added a comment - Still an issue in 10.4.17
          julien.fritsch Julien Fritsch made changes -
          Assignee Vladislav Lesin [ vlad.lesin ] Vladislav Vaintroub [ wlad ]
          wlad Vladislav Vaintroub made changes -
          Assignee Vladislav Vaintroub [ wlad ] Julien Fritsch [ julien.fritsch ]
          vklasen Volker Klasen made changes -
          Affects Version/s 10.5.11 [ 25734 ]
          julien.fritsch Julien Fritsch made changes -
          Assignee Julien Fritsch [ julien.fritsch ]
          stephanvos Stephan Vos added a comment -

          Any progress on this and does this effect the latest mariabackup bundled with 10.5.6?

          stephanvos Stephan Vos added a comment - Any progress on this and does this effect the latest mariabackup bundled with 10.5.6?
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 98796 ] MariaDB v4 [ 141465 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Fix Version/s 10.2 [ 14601 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.3 [ 22126 ]
          danblack Daniel Black made changes -
          Labels Papercut beginner-friendly
          danblack Daniel Black made changes -
          Assignee Daniel Black [ danblack ]
          danblack Daniel Black made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          danblack Daniel Black made changes -
          Assignee Daniel Black [ danblack ] Andrew Hutchings [ JIRAUSER52179 ]
          Status Confirmed [ 10101 ] In Review [ 10002 ]
          batonac Kevin Shenk added a comment -

          Hi, this has become an outstanding issue for me and my clients. Any chance we could get this patch committed?

          batonac Kevin Shenk added a comment - Hi, this has become an outstanding issue for me and my clients. Any chance we could get this patch committed?
          TheLinuxJedi Andrew Hutchings (Inactive) made changes -
          Fix Version/s 10.4.33 [ 29516 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Fixed [ 1 ]
          Status In Review [ 10002 ] Closed [ 6 ]
          JIraAutomate JiraAutomate made changes -
          Fix Version/s 10.5.24 [ 29517 ]
          Fix Version/s 10.6.17 [ 29518 ]
          Fix Version/s 10.11.7 [ 29519 ]
          Fix Version/s 11.0.5 [ 29520 ]
          Fix Version/s 11.1.4 [ 29024 ]
          Fix Version/s 11.2.3 [ 29521 ]

          People

            TheLinuxJedi Andrew Hutchings (Inactive)
            vklasen Volker Klasen
            Votes:
            2 Vote for this issue
            Watchers:
            4 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.