DROP DATABASE hangs when particular query cache is present

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 .