Bug #33033 | MySQL/InnoDB crashes with simple select range query | ||
---|---|---|---|
Submitted: | 6 Dec 2007 11:21 | Modified: | 20 Nov 2010 23:27 |
Reporter: | Alexey Stroganov | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
Version: | 6.0.4pre | OS: | Any |
Assigned to: | Sergey Petrunya | CPU Architecture: | Any |
[6 Dec 2007 11:21]
Alexey Stroganov
[6 Dec 2007 11:23]
Alexey Stroganov
Test case for the bug
Attachment: bug_innodb_select_range.test (application/octet-stream, text), 348 bytes.
[6 Dec 2007 19:44]
Calvin Sun
Change to Optimizer team since it is MRR related.
[23 Jan 2008 21:41]
Sergey Petrunya
The bug can be observed when DS-MRR is switched off, too.
[23 Jan 2008 21:49]
Sergey Petrunya
The problem seems to be more related to index condition pushdown. If I switch it off (by putting return at the top of ha_innobase::idx_cond_push(), there is currently no way to switch it off from SQL layer), the crash doesn't happen, neither with DS-MRR, nor with default MRR implementation.
[24 Jan 2008 0:13]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/41184 ChangeSet@1.2790, 2008-01-24 03:46:18+03:00, sergefp@mysql.com +3 -0 BUG#33033 "MySQL/InnoDB crashes with simple select range query" - If we've walked off the end of the range, still make the btr_pcur_store_position() call. If we're currently filling row prefetch cache (see row_sel_push_cached_row_for_mysql()), we will try to continue doing the scan after we've returned all records from the cache, and that is when we'll need correct btr position.
[13 Mar 2008 19:27]
Bugs System
Pushed into 6.0.5-alpha
[17 Apr 2008 23:33]
Sergey Petrunya
Sure, note for the change log: The new "index condition pushdown" optimization could cause server crash when used with range access method over an InnoDB table.
[18 Apr 2008 15:34]
Paul DuBois
Noted in 6.0.5 changelog.
[16 Aug 2010 6:39]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100816062819-bluwgdq8q4xysmlg) (version source revid:alik@sun.com-20100816062612-enatdwnv809iw3s9) (pib:20)
[13 Nov 2010 16:04]
Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (merge vers: 5.6.99-m4) (pib:21)
[20 Nov 2010 23:27]
Paul DuBois
Noted in 5.6.1 changelog.
[23 Nov 2010 2:13]
Paul DuBois
Correction: No 5.6.1 changelog entry. Bug does not appear in any released 5.6.x version.