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

LP:605767 - DDL + insert delayed + kill causes infinite hang and 100% cpu waiting for tables

    XMLWordPrintable

Details

    Description

      This a hanging MySQL bug reported against 5.0.70, 5.1.30 and 5.5.0 that I just ran into with MariaDB 5.1.39.

      A long running DDL plus a kill plus making heavy use of insert delayed for ad serving resulted in a hang and a processlist just like the one shown in the MySQL bug report: http://bugs.mysql.com/bug.php?id=41114

      I'm not sure if it is still present in the current MariaDB but there is a test case attached to the bug:
      http://bugs.mysql.com/file.php?id=10757

      Attachments

        Activity

          People

            Unassigned Unassigned
            caseyforbes Casey Forbes (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.