Debug assertion failure on shutdown if XA PREPAREd transactions exist
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Low
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
Low
|
Laurynas Biveinis |
Bug Description
2015-06-24 14:58:42 13653 [Note] InnoDB: Starting shutdown...
2015-06-24 14:58:44 11865a000 InnoDB: Assertion failure in thread 4704280576 in file trx0trx.cc line 186
InnoDB: Failing assertion: mutex_own(
thread #3: tid = 0x0002, 0x00007fff8f36a286 libsystem_
frame #0: 0x00007fff8f36a286 libsystem_
frame #1: 0x00007fff8c5c242f libsystem_
frame #2: 0x00000001102a9cc1 mysqld-
frame #3: 0x000000010febd01d mysqld-
frame #4: 0x00007fff9615cf1a libsystem_
frame #5: 0x00007fff8f36a287 libsystem_
frame #6: 0x00000001186594a0
frame #7: 0x00007fff8d318b53 libsystem_
frame #8: 0x000000011066f13d mysqld-
frame #9: 0x00000001106702ae mysqld-
frame #10: 0x000000011066d3f1 mysqld-
frame #11: 0x0000000110638bd7 mysqld-
frame #12: 0x0000000110469879 mysqld-
frame #13: 0x000000010fd0b761 mysqld-
frame #14: 0x00000001100432fb mysqld-
frame #15: 0x000000011004094d mysqld-
frame #16: 0x0000000110043825 mysqld-
frame #17: 0x000000011018a3df mysqld-
frame #18: 0x000000011018a22e mysqld-
frame #19: 0x000000011018a1b9 mysqld-
frame #20: 0x0000000110189ff3 mysqld-
frame #21: 0x0000000110711b4c mysqld-
frame #22: 0x00007fff8c5c0268 libsystem_
frame #23: 0x00007fff8c5c01e5 libsystem_
frame #24: 0x00007fff8c5be41d libsystem_
This is visible on the new upstream testcase innodb.xa_recovery on 5.6.25. The reason is that the trx sys mutex is not taken in trx_free_prepared, which is only used the single-threaded InnoDB shutdown, but trx_release_
tags: | added: ci xtradb |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-2116