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

BLACKHOLE is no longer active in 10.1 by default, mysql_upgrade not handling the situation

Details

    • 10.1.22

    Description

      MariaDB 10.1 binary packages no longer come with BLACKHOLE storage engine compiled in, it comes as a loadable plugin now instead, which is not loaded by default.

      When upgrading a 10.0 instance with a BLACKHOLE table in it mysql_upgrade detects the problem, but doesn't fix it.

      [...]
      		 
      Phase 5/6: Checking and upgrading tables
      		 
      Processing databases
      		 
      information_schema
      		 
      performance_schema
      		 
      test
      		 
      test.t1
      		 
      Error    : Unknown storage engine 'BLACKHOLE'
      		 
      error    : Corrupt
      		 
       
      		 
      Repairing tables
      		 
      test.t1
      		 
      Error    : Unknown storage engine 'BLACKHOLE'
      		 
      error    : Corrupt
      		 
      [...]

      Suggested fix: make mysql_upgrade check I_S.TABLES for unknown storage engine messages in TABLE_COMMENTS, and issue appropriate INSTALL [PLUGIN|SONAME] statements for the bundled engine plugins before actually trying to check and repair tables.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11943 I_S.TABLES inconsistencies with tables with unknown storage engine

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova added a comment -

            "No longer active" is also true for ARCHIVE and FEDERATED.

            elenst Elena Stepanova added a comment - "No longer active" is also true for ARCHIVE and FEDERATED.
            hholzgra Hartmut Holzgraefe added a comment -

            Proposed fix: https://github.com/MariaDB/server/pull/304

            hholzgra Hartmut Holzgraefe added a comment - Proposed fix: https://github.com/MariaDB/server/pull/304
            anikitin Andrii Nikitin (Inactive) added a comment -

            It looks the change was introduced in 10.1.0 as part of https://jira.mariadb.org/browse/MDEV-6248
            I confirmed that with 'official' 10.1.0 packages on wheezy and centos6 - neither SHOW ENGINES nor SHOW PLUGINS mentions archive nor blackhole with 'empty' config files.

            anikitin Andrii Nikitin (Inactive) added a comment - It looks the change was introduced in 10.1.0 as part of https://jira.mariadb.org/browse/MDEV-6248 I confirmed that with 'official' 10.1.0 packages on wheezy and centos6 - neither SHOW ENGINES nor SHOW PLUGINS mentions archive nor blackhole with 'empty' config files.

            People

              serg Sergei Golubchik
              hholzgra Hartmut Holzgraefe
              Votes:
              2 Vote for this issue
              Watchers:
              8 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.