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

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.

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.

Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.