[MDEV-15651] Killed update query hangs in "Unlocking tables" with custom build #18409 from 10.2-compatibility Created: 2018-03-23 Updated: 2018-11-05 Resolved: 2018-11-05 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Update |
| Affects Version/s: | N/A |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Marko Mäkelä |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
A user running a custom MariaDB 10.2.13 build with build #18409 from the 10.2-compatibility branch killed an update query, and the query stuck around for over an hour. They had to kill the server to make it go away. Maybe this is related to |
| Comments |
| Comment by Elena Stepanova [ 2018-04-01 ] |
|
Or |
| Comment by Marko Mäkelä [ 2018-04-05 ] |
|
The latest is #18904:
There is also #18409:
(The parent commit in each of these exists in the bb-10.2-ext branch.) The newer build (18904) included a merge of MariaDB 10.2 as of February 22 (February 22). I think it is very plausible that the hangs were fixed by The older build (18409) included a merge of MariaDB 10.2 as of January 26. It is also missing some FOREIGN KEY fixes in 10.2.13 ( |
| Comment by Marko Mäkelä [ 2018-04-05 ] |
|
In my opinion, this should be fixed by merging 10.2 to bb-10.2-compatibility. If that is out of the question, then by cherry-picking the |
| Comment by Alexander Barkov [ 2018-06-15 ] |
|
Marko, I reminded support team that upgrade is needed. Can you please further work with support on this issue? Thanks. |
| Comment by Marko Mäkelä [ 2018-06-25 ] |
|
The 2 |