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

            I"m not getting the error, maybe it depends on configuration somehow – could you please attach your cnf files?
            What is the error code ALTER fails with, as shown in the client?

            cvicentiu, any ideas about this?

            elenst Elena Stepanova added a comment - I"m not getting the error, maybe it depends on configuration somehow – could you please attach your cnf files? What is the error code ALTER fails with, as shown in the client? cvicentiu , any ideas about this?
            jhejl Jan Hejl added a comment -

            Bash, mysql binary output:

            ERROR 1017 (HY000) at line 1: Can't find file: 'scanner' (errno: 2 "No such file or directory")
            

            Config file attached.

            jhejl Jan Hejl added a comment - Bash, mysql binary output: ERROR 1017 (HY000) at line 1: Can't find file: 'scanner' (errno: 2 "No such file or directory") Config file attached.
            jhejl Jan Hejl added a comment -

            Any ideas?

            jhejl Jan Hejl added a comment - Any ideas?

            jhejl,

            are you still having this problem?
            If you do – what does ERROR 1017 (HY000) at line 1: Can't find file: 'scanner' (errno: 2 "No such file or directory") relate to, what were you attempting to execute?

            elenst Elena Stepanova added a comment - jhejl , are you still having this problem? If you do – what does ERROR 1017 (HY000) at line 1: Can't find file: 'scanner' (errno: 2 "No such file or directory") relate to, what were you attempting to execute?

            If you have further information on the issue, please comment and we will re-open the report.

            elenst Elena Stepanova added a comment - If you have further information on the issue, please comment and we will re-open the report.

            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.