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

"XtraDB/InnoDB Recovery Modes" page claims DROP TABLE can be executed

    XMLWordPrintable

Details

    Description

      https://mariadb.com/kb/en/innodb-recovery-modes/ contains the following paragraph:

      To recover the tables, you can execute SELECTs to dump data, and DROP TABLE to remove corrupted tables.

      The claim that DROP TABLE can be executed is only true for some modes. In reality, DROP TABLE (and any other manipulation) is disallowed starting from mode 4:

      > DROP TABLE familipedia.page;
      ERROR 1036 (HY000): Table 'page' is read only

      Indeed, https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html explains that "An innodb_force_recovery setting of 4 or greater places InnoDB in read-only mode." (although that seems to be inaccurate for MySQL, as the same page claims mode 4 supports DROP TABLE).

      Note that it would be appreciated to make it clear if purging MariaDB data is the only solution when MariaDB fails to start in mode 3.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            Chealer Philippe Cloutier
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.