[MDEV-23106] Unable to recognize/import partitioned tables from physical MySQL databases. - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4.13, 10.5.4
Fix Version/s: 10.8.8, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2, 11.2.1
Component/s: Partitioning, Storage Engine - InnoDB
Labels:
Environment:
CentOS 7

In MySQL 5.7:

create table example (

name varchar(20) NOT NULL,

logblob blob NOT NULL,

created datetime NOT NULL,

primary key (name, created)

) engine=InnoDB default charset=utf8

partition by hash( to_days(created))

partitions 10;

Stop server & physically copy datadir, or remove MySQL binaries & replace with MariaDB binaries.
Start server.
Try to access table:

MariaDB [t38689]> select count(*) from example;

ERROR 1932 (42S02): Table 't38689.example' doesn't exist in engine

Try running mysql_upgrade:

Repairing tables

t38689.example

Error    : Table 't38689.example' doesn't exist in engine

status   : Operation failed

Problem confirmed with tables partitioned by HASH, COLUMN, KEY, RANGE, and LIST.

is duplicated by

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

relates to

MDEV-31417 ASAN errors in ha_partition::create_handlers upon upgrading from MySQL 5.7 with partitioned tables

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.