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

mariadb-10.5 hangs on "query cache lock" on DROP DATABASE

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.5.5, 10.6
    • N/A
    • Locking, Query Cache
    • mariadb 10.5.5-1
      archlinux 5.7.12-arch1-1

      query_cache_type = 1
      query_cache_size = 64M

    Description

      ever since upgrading to 10.5 (from 10.4.14) we experience strange hangs of the mariadb server. This is a nice example:

      818 xx localhost xxx-2_1-unittest Query 14945 closing tables DROP DATABASE IF EXISTS `xxx-2_1-20200821055757` 0.000
      2002 xxx localhost xxx-1_3-20200821055909 Killed 14879 Waiting for query cache lock INSERT INTO xxx 0.000
      2030 root localhost   Query 0 starting show processlist 0.000

      there seems to be no real relation between the DROP and the INSERT as they operate on completely different databases (they have no relation). I also have examples where there are multiple (killed) Waiting for query cache lock threads and a single DROP closing tables

      The mariadbd consumes 100% CPU but I'm not sure what it's doing. strace shows some futex calls

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29760 DROP DATABASE hangs when particular query cache is present

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

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Closed
            		86d 15h 16m 1
            Elena Stepanova made transition -
            Closed Stalled
            		232d 8h 11m 1
            Sergei Golubchik made transition -
            Stalled Open
            		14d 23h 13m 1
            Daniel Black made transition -
            Open In Progress
            		491d 15h 34m 1
            Daniel Black made transition -
            In Progress Closed
            		2h 28m 1

            People

              danblack Daniel Black
              sjon sjon
              Votes:
              6 Vote for this issue
              Watchers:
              12 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.