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

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.

Hi!

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

Sorry for the inconvenience.

Page generated in 0.049 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.