Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1807

xtrabackup does not accept fractional values for innodb_max_dirty_pages_pct

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.4.12
    • Fix Version/s: 2.4.15, 8.0.7
    • Component/s: innobackupex script
    • Labels:
    • Environment:

      mysql 5.7.17

      xtrabackup 2.4.12

      Description

      当我使用xtrabackup 2.4.12备份mysql 5.7.17时发生错误,失败日志如下:

      innobackupex: [ERROR] Unknown suffix '.' used for variable 'innodb_max_dirty_pages_pct' (value '90.0000')
      innobackupex: [ERROR] innobackupex: Error while setting value '90.0000' to 'innodb_max_dirty_pages_pct'

      mysql配置文件中设置innodb_max_dirty_pages_pct = 90.0000

      如果将innodb_max_dirty_pages_pct设置为90(把小数点去掉)则备份过程不会发生错误。

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  sergei.glushchenko Sergei Glushchenko
                  Reporter:
                  tianch zhtch
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 3 hours, 5 minutes
                    3h 5m