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

Cannot reorganize partitions after upgrade to 10.0.30

    Details

      Description

      After upgrading MariaDB server from version 10.0.29 to version 10.0.30 i'm unable to reoganize partitions in my DB (table structure attached) with command:

      LOCK TABLE scanner WRITE;
      alter table scanner reorganize partition pMAX INTO (partition p1492218001 values less than (1492218001), partition pMAX values less than MAXVALUE);
      

      mysqld.err shows:

      170323 12:32:25 [ERROR] Could not rename table from ./dbname/scanner#P#p1490880727#TMP# to ./dbname/scanner#P#p1490880727 because destination db does not exist
      170323 12:32:25 [ERROR] Could not rename table from ./dbname/scanner#P#pMAX#TMP# to ./dbname/scanner#P#pMAX because destination db does not exist
      170323 12:32:25 [ERROR] Could not rename table from ./dbname/scanner#P#pMAX#TMP# to ./dbname/scanner#P#pMAX because destination db does not exist
      170323 12:32:25 [ERROR] Failed to execute action for entry = 5 from ddl log
      

      I'm a bit afraid this was introduced with https://github.com/MariaDB/server/commit/dc1c9e69d0

      Downgrading to 10.0.29 helped.
      Even dump and restore was a solution, but I would like to ommit dump/restore solution, there's a lot of DB and lot more data.

      Any hints?

        Attachments

        1. my.cnf
          2 kB
        2. scanner.sql
          2 kB

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jhejl Jan Hejl
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: