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

MySQL bug #84038 also affects MariaDB 10.2

Details

    Description

      MySQL bug #84038 is not reproducible on XtraDB based MariaDB 10.1 (at least not on 10.1.21 or later), but is hit in InnoDB based MariaDB 10.2.5

      How to reproduce:

      Execute the following

      mysql <<< "
      DROP DATABASE IF EXISTS test_jfg;
      DROP DATABASE IF EXISTS test_jfg2;
      CREATE DATABASE test_jfg;
      CREATE DATABASE test_jfg2;
      CREATE TABLE test_jfg.test (a int unsigned NOT NULL PRIMARY KEY);
      FLUSH TABLES test_jfg.test FOR EXPORT;"
       
      mysql <<< "
      RENAME TABLE test_jfg.test TO test_jfg2.test;
      DROP DATABASE test_jfg;"
      

      then restart mysqld

      Works fine on MariaDB 10.1, but on 10.2 it causes

      2017-05-22 15:29:31 140342278871232 [ERROR] InnoDB: Operating system error number 2 in a file operation.
      2017-05-22 15:29:31 140342278871232 [ERROR] InnoDB: The error means the system cannot find the path specified.
      2017-05-22 15:29:31 140342278871232 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
      2017-05-22 15:29:31 140342278871232 [ERROR] InnoDB: Cannot open datafile for read-only: './test_jfg/test.ibd' OS error: 71
      2017-05-22 15:29:31 140342278871232 [Note] InnoDB: The InnoDB data dictionary table SYS_DATAFILES for tablespace ID 4 was updated to use file ./test_jfg2/test.ibd.
      

      Attachments

        Issue Links

          Activity

            hholzgra Hartmut Holzgraefe created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            Assignee Marko Mäkelä [ marko ]
            Labels upstream-fixed
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            Fix Version/s 10.2.8 [ 22544 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 80880 ] MariaDB v4 [ 152197 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 144322

            People

              marko Marko Mäkelä
              hholzgra Hartmut Holzgraefe
              Votes:
              2 Vote for this issue
              Watchers:
              6 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.