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

        Details

        • Type: Bug
        • Status: Closed
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None

          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

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #41114 - DDL + insert delayed + kill causes infinite hang and 100% cpu waiting for tables

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  ratzpo Rasmus Johansson added a comment -

                  Launchpad bug id: 605767

                  Show
                  ratzpo Rasmus Johansson added a comment - Launchpad bug id: 605767
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  According to comments in the upstream bug, the problem was reproducible on 5.5.0, but not on 5.5.10 (most likely got fixed along with MDL changes which were pushed around 5.5.3).

                  Show
                  elenst Elena Stepanova added a comment - According to comments in the upstream bug, the problem was reproducible on 5.5.0, but not on 5.5.10 (most likely got fixed along with MDL changes which were pushed around 5.5.3).

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      caseyforbes Casey Forbes
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: