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

    XMLWordPrintable

    Details

    • Sprint:
      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

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              hholzgra Hartmut Holzgraefe
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: