[MDEV-4277] Crash inside mi_killed_in_mariadb() with myisammrg Created: 2013-03-15 Updated: 2013-03-22 Resolved: 2013-03-21 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.1, 5.5.30, 5.3.12 |
| Fix Version/s: | 10.0.2, 5.5.31, 5.3.13 |
| Type: | Bug | Priority: | Major |
| Reporter: | Peter (Stig) Edwards | Assignee: | Sergei Petrunia |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
RedHat EL 5.3 2.6.18-274.7.1.el5 x86_64 using bintar mariadb-5.3.12-Linux-x86_64.tar.gz |
||
| Attachments: |
|
| Description |
|
Hello and thank you for mariadb-5.3.12-Linux-x86_64.tar.gz Had a crash on a recently upgraded (from MySQL 5.1.48) today, wondering if the backtrace might look like a known issue. I do not have a reproducer at the moment. Thanks.
|
| Comments |
| Comment by Elena Stepanova [ 2013-03-15 ] |
|
Hi Peter, I don't think we've seen any similar crashes recently. |
| Comment by Elena Stepanova [ 2013-03-15 ] |
|
Peter, thank you, I'm able to reproduce it based on the info you provided. Will add a test case soon. |
| Comment by Peter (Stig) Edwards [ 2013-03-15 ] |
|
That is great news. I am impressed. Thank you. I was contemplating a roll back, and may still have to do so if it repeats, so I am particularly interested if there is an optimizer switch I can turn off to avoid hitting the bug (or not). |
| Comment by Elena Stepanova [ 2013-03-15 ] |
|
Yes, in my version of the test case the crash happens with index_merge=on,index_merge_intersection=on. Turning off at least one of these prevents the crash (and changes the plan so there is no index_merge/intersect anymore). Of course it still might be different on your data, but I think it's worth trying. |
| Comment by Elena Stepanova [ 2013-03-16 ] |
|
The test case is attached (mdev-4277.test). It's plain SQL which can be used both in MTR or in MySQL client. |
| Comment by Sergei Petrunia [ 2013-03-19 ] |
|
Committed a patch. Need a review discussion for it. |
| Comment by Sergei Petrunia [ 2013-03-21 ] |
|
The fix is pushed into MariaDB-5.3 tree. |
| Comment by Peter (Stig) Edwards [ 2013-03-22 ] |
|
Thank you. |