MySQL Bugs: #6269: Crashes with full-text search

Bug #6269	Crashes with full-text search
Submitted:	26 Oct 2004 19:35	Modified:	7 Dec 2004 21:01
Reporter:	Jim Winstead	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S1 (Critical)
Version:	4.1.6	OS:	Linux (Linux 2.6)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

Description:
Full-text queries intermittently cause crashes (server segfaults) which require the involved table 
to be repaired on startup. Sample backtrace:

0x808afd3 handle_segfault + 423
0x82d6968 pthread_sighandler + 184
0x82949c0 FTB_WORD_cmp + 16
0x82adc3c _downheap + 124
0x829572f ft_boolean_read_next + 203
0x80fa1a0 ft_read__9ha_myisamPc + 60
0x80c7149 join_ft_read_next__FP14st_read_record + 37
0x80c61f9 sub_select__FP4JOINP13st_join_tableb + 305
0x80c5e86 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 514
0x80bc993 exec__4JOIN + 4279
0x80bce5d 
mysql_select__FP3THDPPP4ItemP13st_table_listUiRt4List1Z4ItemP4ItemUiP8st_orderT7T5T7UlP1
3select_resultP18st_select_lex_unitP13s + 821
0x80b9ea6 handle_select__FP3THDP6st_lexP13select_result + 150
0x809ae39 mysql_execute_command__FP3THD + 4533
0x809e889 mysql_parse__FP3THDPcUi + 169
0x8098dcf dispatch_command__F19enum_server_commandP3THDPcUi + 1643
0x8098758 do_command__FP3THD + 188
0x8097e97 handle_one_connection + 615
0x82d411c pthread_start_thread + 220
0x82fda9a thread_start + 4

How to repeat:
Use supplied test data and test query, and hope it crashes.

I was able to repeat the behavior reported with 4.1.7 source server
only with the second query (CREATE TEMPORARY TABLE.....)

ERROR 2013 (HY000): Lost connection to MySQL server during query.

Thank you for the bug report.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

fixed in 4.1.8