Bug #43448 | Server crashes on multi table delete with Innodb | ||
---|---|---|---|
Submitted: | 6 Mar 2009 10:11 | Modified: | 26 Feb 2010 9:57 |
Reporter: | Nidhi Shrotriya | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S3 (Non-critical) |
Version: | 6.0.11 | OS: | Linux |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | index_condition_pushdown, optimizer_switch |
[6 Mar 2009 10:11]
Nidhi Shrotriya
[6 Mar 2009 10:53]
Sveta Smirnova
Thank you for the report. I believe this is duplicate of bug #37415 as backtrace is same.
[13 Nov 2009 11:32]
Olav Sandstå
This bug is wrongly classified as a duplicate of Bug#37415. Instead it is likely a duplicate of Bug#43360. The crash is still reproducible when ICP is enabled for InnoDB. I am setting this back to verified in order to remember to consider if we should include the MTR test case in the test suite after Bug#43360 has been fixed.
[13 Nov 2009 12:24]
Olav Sandstå
Valgrind reports the following memory corruption when ICP is enabled in InnoDB (the same as in Bug#43360): ==664== Invalid write of size 8 ==664== at 0x8F020C: build_template(row_prebuilt_struct*, THD*, TABLE*, ha_innobase*, unsigned) (ha_innodb.cc:3437) ==664== by 0x8F3323: ha_innobase::change_active_index(unsigned) (ha_innodb.cc:4637) ==664== by 0x8F3492: ha_innobase::index_init(unsigned, bool) (ha_innodb.cc:4309) ==664== by 0x5812B3: handler::ha_index_init(unsigned, bool) (handler.h:1559) ==664== by 0x702FD7: join_read_always_key(st_join_table*) (sql_select.cc:16982) ==664== by 0x70653C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:16311) ==664== by 0x7062BB: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:16581) ==664== by 0x70658C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:16316) ==664== by 0x7062BB: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:16581) ==664== by 0x70658C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:16316) ==664== by 0x71421A: do_select(JOIN*, List<Item>*, TABLE*, Procedure*) (sql_select.cc:15874) ==664== by 0x731B69: JOIN::exec() (sql_select.cc:2929) ==664== by 0x72C183: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List<Item>&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:3120) ==664== by 0x68AC9E: mysql_execute_command(THD*) (sql_parse.cc:3427) ==664== by 0x68FB0D: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5979) ==664== by 0x690FEA: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1076)
[13 Nov 2009 14:41]
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/90364 3709 Olav Sandstaa 2009-11-13 Test case for Bug#43448 Server crashes on multi table delete with Innodb Simplified test case based on the test case from the bug report. Adding this to the optimizer_unfixed_bugs suite until this bug has been fixed. @ mysql-test/suite/optimizer_unfixed_bugs/r/bug43448.result Result file for Bug#43448 Server crashes on multi table delete with Innodb @ mysql-test/suite/optimizer_unfixed_bugs/t/bug43448.test Test case for Bug#43448 Server crashes on multi table delete with Innodb
[13 Nov 2009 14:51]
Olav Sandstå
Test case pushed to the optimizer_unfixed_bug suite in mysql-6.0-codebase-bugfizing branch.
[20 Nov 2009 12:57]
Bugs System
Pushed into 6.0.14-alpha (revid:kostja@sun.com-20091120124947-yi6h2jbgw0kbciwm) (version source revid:olav@sun.com-20091113144107-wha5qk9d78mx50tl) (merge vers: 6.0.14-alpha) (pib:13)
[19 Jan 2010 12:44]
Olav Sandstå
This bug is a duplicate of Bug#43360 and/or Bug#36981. I have verified that this crash does no longer occur after applying the fixes for these two bugs. Test case for this bug is committed here: http://lists.mysql.com/commits/97367
[3 Feb 2010 9:32]
Olav Sandstå
Patch containing updated version of test case: http://lists.mysql.com/commits/99022
[26 Feb 2010 9:50]
Olav Sandstå
Patch containing test case pushed to mysql-6.0-codebase-bugfixing with revision-id: olav@sun.com-20100226091930-qxvakxmcp6463t5w .
[26 Feb 2010 9:57]
Olav Sandstå
Closing this as duplicate of Bug#36981.
[6 Mar 2010 10:29]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100306102742-yw9zzgw9ac5r65m5) (version source revid:bar@mysql.com-20100305074327-h09o5lw290s04lcf) (merge vers: 6.0.14-alpha) (pib:16)
[16 Aug 2010 6:37]
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:25]
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)