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

CREATE fails after DROP without FRM

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.5
    • 10.5.7
    • Server
    • None

    Description

      Reproduce

      --source include/have_innodb.inc
      		 
      --let $DATADIR= `select @@datadir`
      		 
       
      		 
      create table parent (id int not null, primary key (id)) engine=innodb;
      		 
      select * from parent;
      		 
      --remove_file $datadir/test/parent.frm
      		 
       
      		 
      drop table parent;
      		 
      create table parent (id int not null, primary key (id)) engine=innodb;
      		 
       
      		 
      # Cleanup
      		 
      drop table parent;

      Result

      mysqltest: At line 9: query 'create table parent (id int not null, primary key (id)) engine=innodb' failed: 1050: Table 'parent' already exists

      Related tests

      main.drop_table_force

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-16417 Store Foreign Key metadata outside of InnoDB

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review
          is caused by

          Task - A task that needs to be done. MDEV-11412 Ensure that table is truly dropped when using DROP TABLE

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

          Activity

            Ascending order - Click to sort in descending order
            midenok Aleksey Midenkov created issue -
            midenok Aleksey Midenkov made changes -
            Field Original Value New Value
            Description h3. Reproduce
            {code:sql}
            --source include/have_innodb.inc
            --let $DATADIR= `select @@datadir`

            create table parent (id int not null, primary key (id)) engine=innodb;
            select * from parent;
            --remove_file $datadir/test/parent.frm

            drop table parent;
            create table parent (id int not null, primary key (id)) engine=innodb;

            # Cleanup
            drop table parent;
            {code}

            h3. Result
            {code}
            mysqltest: At line 9: query 'create table parent (id int not null, primary key (id)) engine=innodb' failed: 1050: Table 'parent' already exists
            {code}

            h3. Related tests
            main.drop_table_force
            midenok Aleksey Midenkov made changes -
            midenok Aleksey Midenkov made changes -
            midenok Aleksey Midenkov made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            midenok Aleksey Midenkov made changes -
            Fix Version/s 10.5 [ 23123 ]
            midenok Aleksey Midenkov made changes -
            Component/s Server [ 13907 ]
            midenok Aleksey Midenkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenkov [ midenok ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Aleksey Midenkov [ midenok ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            midenok Aleksey Midenkov made changes -
            Fix Version/s 10.5.6 [ 24508 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5.7 [ 25019 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5.6 [ 24508 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 112838 ] MariaDB v4 [ 158279 ]

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.