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

DROP DATABASE hangs when particular query cache is present

    XMLWordPrintable

Details

    Description

      Hi,

      With MariaDB 10.6 ( no matter of the subversion but tested mostly with 10.6.10 ) when particular query cache is present you are unable to drop database.

      You will need the files all.sql and source_db_schema.sql which are attached to this task.

      Then just execute from bash console:

      mysql -e "create database source_db"
       
       
       
      mysql source_db < source_db_schema.sql
       
      mysql -e 'RESET QUERY CACHE';
       
      mysql -e "create database destination_db" ;  mysqldump source_db | mysql destination_db
       
      mysql 'source_db' -e "select option_name from VbVoptions;" ;
       
       
       
          mysql destination_db < all.sql; 
       
          mysql -e "drop database destination_db ;"
       
          echo "drop successfully"
      

      source_db_schema.sql
      all.sql

      In summary if specific query cache is present, you are unable to drop database and it just hangs (MariaDB uses 100% cpu) and no restart ( without "kill -9" ) can be performed .

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              NevenIvanov Neven Ivanov
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.