MySQL Bugs: #35887: Maria: INSERT hangs in FULLTEXT index code

Bug #35887	Maria: INSERT hangs in FULLTEXT index code
Submitted:	7 Apr 2008 21:52	Modified:	25 Jun 2008 13:03
Reporter:	Guilhem Bichot	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Maria storage engine	Severity:	S3 (Non-critical)
Version:	5.1-maria	OS:	Linux (32 bit)
Assigned to:	Jani Tolonen	CPU Architecture:	Any

Description:
I took fulltext3.test, added "engine=maria transactional=0" to both CREATE TABLE statements, and run it on the latest Maria tree. It hangs here:
T@4    : | | | | | | | | <_ma_write_init_block_record
T@4    : | | | | | | | | >_ma_ft_add
T@4    : | | | | | | | | | enter: keynr: 0
T@4    : | | | | | | | | | >_ma_ft_parserecord
T@4    : | | | | | | | | | | >my_malloc
T@4    : | | | | | | | | | | | my: size: 144  my_flags: 48
T@4    : | | | | | | | | | | | exit: ptr: 0x8ea7d60
T@4    : | | | | | | | | | | <my_malloc
T@4    : | | | | | | | | | | >init_alloc_root
T@4    : | | | | | | | | | | | enter: root: 0x8eac380
T@4    : | | | | | | | | | | <init_alloc_root
T@4    : | | | | | | | | | | >_ma_ft_parse
T@4    : | | | | | | | | | | | >_ma_ft_segiterator_init
T@4    : | | | | | | | | | | | <_ma_ft_segiterator_init
T@4    : | | | | | | | | | | | >maria_ft_parse_init
T@4    : | | | | | | | | | | | | >init_tree
T@4    : | | | | | | | | | | | | | enter: tree: 0xb6aa0274  size: 16
T@4    : | | | | | | | | | | | | | >init_alloc_root
T@4    : | | | | | | | | | | | | | | enter: root: 0xb6aa03a0
T@4    : | | | | | | | | | | | | | <init_alloc_root
T@4    : | | | | | | | | | | | | <init_tree
T@4    : | | | | | | | | | | | <maria_ft_parse_init
T@4    : | | | | | | | | | | | >_ma_ft_segiterator
T@4    : | | | | | | | | | | | <_ma_ft_segiterator
T@4    : | | | | | | | | | | | >maria_ft_parse
T@4    : | | | | | | | | | | | <maria_ft_parse
T@4    : | | | | | | | | | | | >maria_ft_parse_internal
T@4    : | | | | | | | | | | | | >maria_ft_simple_get_word
in this query:
T@4    : | | query: INSERT INTO t1 VALUES(0xA3C2)
and stays at 100% CPU. Looks like an infinite loop.

How to repeat:
see description.

We forgot to apply the fix for BUG#29464 to Maria when we merged 5.1 into Maria on Oct 5 2007. We'll identify all that we missed in this merge and the previous one of Jul 7, apply to Maria, and then we can re-test this testcase.

Patch pushed http://lists.mysql.com/maria/77

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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html