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

DROP DATABASE hangs when particular query cache is present

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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23527 mariadb-10.5 hangs on "query cache lock" on DROP DATABASE

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25023 MariaDB 10.5 - DROP DATABASE locked

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            NevenIvanov Neven Ivanov created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            Affects Version/s 10.5 [ 23123 ]
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.7 [ 24805 ]
            Affects Version/s 10.8 [ 26121 ]
            Affects Version/s 10.9 [ 26905 ]
            Affects Version/s 10.10 [ 27530 ]
            Assignee Oleksandr Byelkin [ sanja ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Summary MariaDB 10.6 DROP DATABASE when particular query cache is present DROP DATABASE when particular query cache is present
            elenst Elena Stepanova made changes -
            Summary DROP DATABASE when particular query cache is present DROP DATABASE hangs when particular query cache is present
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            danblack Daniel Black made changes -
            Assignee Oleksandr Byelkin [ sanja ] Daniel Black [ danblack ]
            danblack Daniel Black made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            danblack Daniel Black made changes -
            Fix Version/s 10.5.19 [ 28511 ]
            Fix Version/s 10.6.12 [ 28513 ]
            Fix Version/s 10.7.8 [ 28515 ]
            Fix Version/s 10.9.5 [ 28519 ]
            Fix Version/s 10.9.6 [ 28520 ]
            Fix Version/s 10.10.3 [ 28521 ]
            Fix Version/s 10.11.2 [ 28523 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            Assignee Oleksandr Byelkin [ sanja ] Daniel Black [ danblack ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]

            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.