LPexportBug605767.xml
[MDEV-625] LP:605767 - DDL + insert delayed + kill causes infinite hang and 100% cpu waiting for tables Created: 2010-07-15 Updated: 2013-03-27 Resolved: 2013-03-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | ||
| Reporter: | Casey Forbes (Inactive) | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad, upstream | ||
| Attachments: |
LPexportBug605767.xml
|
| 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: |
| Comments |
| Comment by Rasmus Johansson (Inactive) [ 2012-03-22 ] |
|
Launchpad bug id: 605767 |
| Comment by Elena Stepanova [ 2013-03-27 ] |
|
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). |