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

Cannot reorganize partitions after upgrade to 10.0.30

    XMLWordPrintable

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

              Unassigned Unassigned
              jhejl Jan Hejl
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.