Bug #653 mysqld got signal 11
Submitted: 13 Jun 2003 13:27 Modified: 14 Jun 2003 4:25
Reporter: [ name withheld ] Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:3.23.51 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[13 Jun 2003 13:27] [ name withheld ] 
Description:
MySQL is occasionally reporting "signal 11" errors.
The error log shows the complete backtrace.  I resolved the stack dump to the following:

0x806edf4 handle_segfault__Fi + 428
0x811fd28 pthread_sighandler + 184
0x8118681 bmove512 + 209
0x80eae3a _mi_fetch_keypage + 62
0x80f755f _mi_search_pos + 63
0x80f782f _mi_record_pos + 127
0x80f771a mi_records_in_range + 134
0x80b8a50 records_in_range__9ha_myisamiPCcUi16ha_rkey_functionT2UiT4 + 52
0x80b087b check_quick_keys__FP13st_qsel_paramUiP7SEL_ARGPcUiT3Ui + 1271
0x80b1d47 check_quick_select__FP13st_qsel_paramUiP7SEL_ARG + 87
0x80ad755 test_quick_select__10SQL_SELECTUlUlUlb + 1137
0x808dfe8 make_join_statistics__FP4JOINP13st_table_listP4ItemP16st_dynamic_array + 2592
0x808c6b6 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 1830
0x80759f0 mysql_execute_command__Fv + 812
0x8079a8c mysql_parse__FP3THDPcUi + 216
0x8074bb4 do_command__FP3THD + 1460
0x8073f67 handle_one_connection__FPv + 655

How to repeat:
Seems to happen at random.  I don't know if this is due to a hardware problem (bad memory - segmentation fault) or whether it would be fixed if I upgraded the version of MySQL.
[14 Jun 2003 4:25] MySQL Verification Team 
It could be an old bug, or it could be an un-resolved bug.

But we need a repeatable test case, id est a set of SQL commands and / or options
that would always lead to crash.