[MDEV-29253] Detect incompatible MySQL partition scheme and either convert them or report to user and in error log. Created: 2021-01-06 Updated: 2023-09-28 Resolved: 2023-06-25 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Partitioning |
| Fix Version/s: | 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2, 11.2.1 |
| Type: | Task | Priority: | Major |
| Reporter: | Juan | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||||||
| 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;
|
| Comments |
| Comment by Michael Widenius [ 2022-08-05 ] |
|
We need to look at supporting partitioned InnoDB tables from MySQL 5.7 |
| Comment by Michael Widenius [ 2023-06-01 ] |
|
Will be solve as part |
| Comment by Michael Widenius [ 2023-06-25 ] |
|
Fixed as part of Pushed to 10.6 tree |