Percona server 5.5 completely stalls during import (myloader)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
| MySQL Server |
Unknown
|
Unknown
|
||
| Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Laurynas Biveinis | |
| 5.5 |
Fix Released
|
High
|
Laurynas Biveinis | |
| 5.6 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
The problem seem to be caused by: innodb_
description: | updated |
Unfortunately some of the symbol information is missing in gdb dump, does the server have debug info packages installed?
No, how does that work? Installing the percona-
Please just retry the gdb command after having the package installed.
I will do that.
Output of:
gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)
With percona-
Thanks. I am analysing the dump.
Did this started happening after an upgrade? If yes, can you tell the latest PS 5.5 version which worked for you?
Hard to say, it's on new hardware, new installation.
On our previous setup we never encountered the problem (in our normal workload). But we never do mass imports there and we also have different hardware there so it's hard to compare...
tags: | added: i62298 |
Mischa and everybody experiencing random hangs on 5.5.46 / 5.6.27, please test server build with a preliminary fix, available at:
5.5: http://
5.6: http://
(please click through the blue dots to navigate to the right packages for your system).
Please confirm whether with these packages the problem does not occur anymore. In case it still does, please repeat the previous procedure: 1) make sure the debug info package is installed; 2) get the server to hanged state; 3) execute "gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)" and post here its output.
I'll try to test them today.
Is there any reason why I would need to avoid using innodb_
On our machines we have:
* single SSD
* multiple SSD, software RAID
* multiple SSD, hardware RAID
But non of them have SSD cards.
I assume this is asked in the context of the current bug, i.e. why keep_average causes this hang. But it's not keep_average itself which is the cause of the bug (if the fix is confirmed), but rather increased mutex pressure. The bug has probability of appearing with any adaptive flushing setting.
Yes, in the context of the current bug.
We don't have the problem when we use innodb_
If our analysis is correct then 1) the bug has a probability of appearing with any innodb_
We will post the final bug analysis after we have confirmations that the issue disappeared.
I've had 52 successful imports (before patch not more than +/- 5) last night so it looks like it fixed our problem.
tags: | added: innodb upstream |
Yura Sorokin (yura-sorokin) wrote : | #17 |
Fixed by Oracle in 5.5.49, 5.6.30 and 5.7.12.
5.5 commit: 93e6f38
https:/
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
Output of:
gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)