Bug #33968 Crash in _ftb_climb_the_tree via a boolean query
Submitted: 21 Jan 2008 22:58 Modified: 22 Jan 2008 0:03
Reporter: Adam Dixon Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: FULLTEXT search Severity:S3 (Non-critical)
Version:4.1.21 OS:Linux
Assigned to: CPU Architecture:Any

[21 Jan 2008 22:58] Adam Dixon
Description:
Crash in _ftb_climb_the_tree via a boolean query;

Thread 10 (Thread 1147570496 (LWP 30095)):
#0  0x00000000006f3068 in _ftb_climb_the_tree ()
No symbol table info available.
#1  0x00000000006f2aec in ft_boolean_find_relevance ()
No symbol table info available.
#2  0x00000000004b1a6c in Item_func_match::val ()
No symbol table info available.
#3  0x000000000049db5f in Item::send ()
No symbol table info available.
#4  0x00000000004f28dc in select_send::send_data ()
No symbol table info available.
#5  0x00000000005454a5 in end_send ()
No symbol table info available.
#6  0x00000000005440fa in sub_select ()
No symbol table info available.
#7  0x000000000053d7b5 in do_select ()
No symbol table info available.
#8  0x000000000053486a in JOIN::exec ()
No symbol table info available.
#9  0x0000000000535a4c in mysql_select ()
No symbol table info available.
#10 0x0000000000532167 in handle_select ()
No symbol table info available.
#11 0x0000000000511425 in mysql_execute_command ()
No symbol table info available.
#12 0x0000000000516438 in mysql_parse ()
No symbol table info available.
#13 0x000000000050ffec in dispatch_command ()
No symbol table info available.
#14 0x000000000050fc4c in do_command ()
No symbol table info available.
#15 0x000000000050f4cf in handle_one_connection ()
No symbol table info available.
#16 0x0000003d322062f7 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#17 0x0000003d306ce86d in clone () from /lib64/libc.so.6
No symbol table info available.
#18 0x0000000000000000 in ?? ()
No symbol table info available.

How to repeat:
See Private comments.
[21 Jan 2008 22:58] Adam Dixon
GDB BT output full.

Attachment: gdb_1table.txt (text/plain), 6.93 KiB.

[21 Jan 2008 22:59] Adam Dixon
Following my.cnf used.

[mysqld]
ft_min_word_len = 1
ft_stopword_file = ''
[21 Jan 2008 23:20] Adam Dixon
mysql> show variables like 'ft_%';
...
| ft_min_word_len          | 2              | 

Does not cause a crash. Setting of 1 does.
[22 Jan 2008 0:03] Adam Dixon
Looks to be a duplicate of http://bugs.mysql.com/bug.php?id=11392

This bug does not repeat in 4.1.24 from bk.