Bug #82971 FTS query exceeds result cache limit
Submitted: 13 Sep 2016 13:54 Modified: 13 Sep 2016 17:22
Reporter: Craig Carnell Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6.29 OS:Red Hat
Assigned to: CPU Architecture:Any

[13 Sep 2016 13:54] Craig Carnell
Description:
Description:
InnoDB full-text queries fail with error "ERROR 188 (HY000): FTS query exceeds result cache limit" using the maximum values of innodb_ft_result_cache_limit and innodb_ft_total_cache_size.

The failing queries executed properly when the engine was MyISAM.

How to repeat:
Convert a large MyISAM FTS table to InnoDB. Execute queries that work with the MyISAM table on the InnoDB table.

Get error message
ERROR 188 (HY000): FTS query exceeds result cache limit

ALTER TABLE eventDetails ENGINE = InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

How to repeat:
This is a duplication of the bug:

https://bugs.mysql.com/bug.php?id=80296

Suggested fix:
This has already been fixed in 5.7.x. Please back port to 5.6.x.
[13 Sep 2016 17:22] Sinisa Milivojevic
Hi!

A patch for 5.7 is very large, so it can not be ported back to 5.6.

Sorry for the inconvenience.