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

Detect incompatible MySQL partition scheme and either convert them or report to user and in error log.

Details

    Description

      Despite advertising itself as "plugin replacement for MySQL" MariaDB uses a different partitioning scheme. In addition, it is unable to detect the incompatible partition scheme when started on a MySQL-generated physical database, and produces column mismatch errors, failures in mysql_upgrade, and InnoDB data dictionary inconsistencies.

      It would be very helpful for administrators if they could see a message when these errors happen letting them know that InnoDB has encountered an incompatible and unsupported partition scheme, and recommend starting over with the corrupted tabled dumped logically and then dropped from the source.

      We should consider extending mariadb-upgrade to automatically convert MySQL 5.7 InnoDB partitioned tables to MariaDB partitioned tables.

      Things to check;

      • Is each InnoDB partition is it's own table space ?
      • Is it possible to convert the partitions to MariaDB type independent InnoDB partition tables
      • Can we create MariaDB .frm and .par files from MySQL .frm file or InnoDB
        dictionary / InnoDB internal partition information.

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Julien Fritsch made transition -
            Open Closed
            56d 14h 39m 1
            Michael Widenius made transition -
            Closed Stalled
            519d 32m 1
            Michael Widenius made transition -
            Stalled In Progress
            300d 3h 13m 1
            Michael Widenius made transition -
            In Progress Closed
            23d 21h 23m 1

            People

              monty Michael Widenius
              juan.vera Juan
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.