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

innodb_force_recovery = 6 cannot recover ANY DATA when change buffer not empty

Details

    • 10.1.11, 10.1.14

    Description

      Innodb force recovery settings prevent its own recovery. In innodb_force_recovery=6 and read only mode, no reason to expect change or doublewrite buffers to be empty. It does however complain about the change buffer not being empty:

      [ERROR] InnoDB: Change buffer must be empty when --innodb-read-only is set!

      Same bug in MySQL:
      https://bugs.mysql.com/bug.php?id=77476

      Attachments

        Issue Links

          Activity

            dignus81 Johan Kooijman created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            Assignee Jan Lindström [ jplindst ]
            Labels upstream
            elenst Elena Stepanova made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.11 [ 30 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.11 [ 30 ] 10.1.11, 10.1.14 [ 30, 51 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2016-04-27 08:12:25.0 2016-04-27 08:12:25.274
            jplindst Jan Lindström (Inactive) made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s 10.1.14 [ 21804 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 72527 ] MariaDB v4 [ 149817 ]

            People

              jplindst Jan Lindström (Inactive)
              dignus81 Johan Kooijman
              Votes:
              3 Vote for this issue
              Watchers:
              5 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.