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

Unable to recognize/import partitioned tables from physical MySQL databases.

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          is duplicated by

          Task - A task that needs to be done. MDEV-29253 Detect incompatible MySQL partition scheme and either convert them or report to user and in error log.

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31417 ASAN errors in ha_partition::create_handlers upon upgrading from MySQL 5.7 with partitioned tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              monty Michael Widenius
              juan.vera Juan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 8d 5m
                  8d 5m

                  Git Integration

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