| Bug #93168 | Error Code: 188 FTS query exceeds result cache limit | ||
|---|---|---|---|
| Submitted: | 13 Nov 2018 4:14 | Modified: | 13 Nov 2018 7:53 |
| Reporter: | Chiranjeeb Mondal | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.7.22 | OS: | CentOS |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Error Code: 188, FTS query exceeds result cache limit | ||
[13 Nov 2018 4:20]
Chiranjeeb Mondal
Table indexes --------------------- "Table" "Non_unique" "Key_name" "Seq_in_index" "Column_name" "Collation" "Cardinality" "Sub_part" "Packed" "Null" "Index_type" "Comment" "Index_comment" "search_file" "0" "PRIMARY" "1" "slno" "A" "8431786" \N \N "" "BTREE" "" "" "search_file" "1" "cat_id" "1" "cat_id" "A" "1769" \N \N "" "BTREE" "" "" "search_file" "1" "datetime" "1" "datetime" "A" "2634183" \N \N "" "BTREE" "" "" "search_file" "1" "live_on" "1" "live_on" "A" "2106" \N \N "" "BTREE" "" "" "search_file" "1" "filename" "1" "filename" "A" "8448811" \N \N "" "BTREE" "" "" "search_file" "1" "channel_slno" "1" "channel_slno" "A" "6" \N \N "" "BTREE" "" "" "search_file" "1" "story_type" "1" "story_type" "A" "12" \N \N "" "BTREE" "" "" "search_file" "1" "spl_catid" "1" "spl_catid" "A" "1" \N \N "" "BTREE" "" "" "search_file" "1" "priority_level_1" "1" "priority_level_1" "A" "15" \N \N "" "BTREE" "" "" "search_file" "1" "priority" "1" "priority" "A" "12" \N \N "" "BTREE" "" "" "search_file" "1" "storyid" "1" "storyid" "A" "8448811" \N \N "" "BTREE" "" "" "search_file" "1" "priority_level_4" "1" "priority_level_4" "A" "14" \N \N "" "BTREE" "" "" "search_file" "1" "classification_id" "1" "classification_id" "A" "93" \N \N "" "BTREE" "" "" "search_file" "1" "template_type" "1" "template_type" "A" "9" \N \N "" "BTREE" "" "" "search_file" "1" "cat_id1" "1" "cat_id1" "A" "1598" \N \N "" "BTREE" "" "" "search_file" "1" "poll" "1" "poll" "A" "2" \N \N "" "BTREE" "" "" "search_file" "1" "priority_level_2" "1" "priority_level_2" "A" "14" \N \N "" "BTREE" "" "" "search_file" "1" "priority_level_3" "1" "priority_level_3" "A" "14" \N \N "" "BTREE" "" "" "search_file" "1" "edit_flag" "1" "edit_flag" "A" "2" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "1" "flag_r" "A" "1" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "2" "flag_v" "A" "1" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "3" "flag_p" "A" "1" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "4" "flag_k" "A" "1" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "5" "k_count" "A" "1" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "6" "flag_i" "A" "1" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "7" "flag_g" "A" "1" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "8" "flag_e1" "A" "582" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "9" "flag_e2" "A" "1165" \N \N "" "BTREE" "" "" "search_file" "1" "flag_r" "10" "flag_e3" "A" "1165" \N \N "" "BTREE" "" "" "search_file" "1" "keywords" "1" "keywords" \N "8448811" \N \N "" "FULLTEXT" "" "" "search_file" "1" "title" "1" "title" \N "8448811" \N \N "" "FULLTEXT" "" "" "search_file" "1" "filename_2" "1" "filename" \N "8448811" \N \N "" "FULLTEXT" "" ""
[13 Nov 2018 7:53]
MySQL Verification Team
Thank you for the bug report. Duplicate of bug: https://bugs.mysql.com/bug.php?id=86036.
[13 Nov 2018 8:06]
MySQL Verification Team
How to solved "ERROR 188 (HY000): FTS query exceeds result cache limit" (Doc ID 2439029.1) https://support.oracle.com/knowledge/Oracle%20Database%20Products/2439029_1.html
Description: 1 queries executed, 0 success, 1 errors, 0 warnings Query: SELECT filename FROM `testing`.`search_file` WHERE MATCH(filename) AGAINST ("'BIH-PAT-HMU-MAT-latest-patna-news-0... Error Code: 188 FTS query exceeds result cache limit Execution Time : 0 sec Transfer Time : 0 sec Total Time : 31.245 sec ----------------------------------------------------------------------- TABLE DESCRIBE ----------------------------------------------------------------------- "Field" "Type" "Null" "Key" "Default" "Extra" "channel_slno" "int(11)" "NO" "MUL" "0" "" "cat_id" "int(11)" "NO" "MUL" "0" "" "cat_id1" "int(15)" "NO" "MUL" "0" "" "user_id" "int(11)" "NO" "" "0" "" "datetime" "datetime" "NO" "MUL" "0000-00-00 00:00:00" "" "filename" "varchar(512)" "NO" "MUL" "" "" "folder" "tinytext" "NO" "" \N "" "provider" "varchar(255)" "NO" "" "" "" "created_on" "varchar(100)" "NO" "" "" "" "title" "longtext" "NO" "MUL" \N "" "short_headline" "varchar(2000)" "NO" "" "" "" "description" "text" "NO" "" \N "" "timestamp" "varchar(100)" "NO" "" "" "" "imgflag" "int(2)" "NO" "" "0" "" "topstoryflag" "int(1)" "NO" "" "0" "" "homepage_flag" "int(1)" "NO" "" "0" "" "slug_intro" "longtext" "NO" "" \N "" "mobile_description" "text" "NO" "" \N "" "browser_title" "varchar(2000)" "NO" "" "" "" "story_type" "varchar(20)" "NO" "MUL" "" "" "edit_flag" "char(1)" "NO" "MUL" "" "" "tmp_id" "int(11)" "NO" "" "0" "" "priority" "int(3)" "NO" "MUL" "0" "" "live_on" "date" "NO" "MUL" "0000-00-00" "" "storycode" "varchar(50)" "NO" "" "" "" "mobile4567" "varchar(100)" "NO" "" "" "" "myfm" "varchar(100)" "NO" "" "" "" "bhaskartv" "varchar(100)" "NO" "" "" "" "print" "varchar(100)" "NO" "" "" "" "keywords" "text" "NO" "MUL" \N "" "priority_level_1" "int(3)" "NO" "MUL" "-1" "" "priority_level_2" "int(3)" "NO" "MUL" "-1" "" "priority_level_3" "int(3)" "NO" "MUL" "-1" "" "priority_level_4" "int(3)" "NO" "MUL" "-1" "" "priority_level_home" "int(3)" "NO" "" "-1" "" "priority_level_top" "int(3)" "NO" "" "0" "" "priority_level_mpaper" "int(3)" "NO" "" "0" "" "old_catid" "int(11)" "NO" "" "0" "" "spl_catid" "int(11)" "NO" "MUL" "0" "" "spotlight_filename" "varchar(100)" "NO" "" "" "" "feedback" "int(5)" "NO" "" "0" "" "feedback_editflag" "enum('t','f')" "NO" "" "t" "" "thumbnames" "varchar(100)" "NO" "" "" "" "tdsyndiction" "varchar(255)" "NO" "" "" "" "slno" "int(11)" "NO" "PRI" \N "auto_increment" "iitl_title" "longtext" "NO" "" \N "" "mpaper_flag" "int(1)" "NO" "" "0" "" "storyid" "int(11)" "NO" "MUL" "0" "" "breaking_news" "int(1)" "NO" "" "0" "" "photo_flipper" "int(1)" "NO" "" "0" "" "classification_id" "int(11)" "NO" "MUL" "0" "" "blog_url" "mediumblob" "NO" "" \N "" "template_type" "varchar(50)" "NO" "MUL" "normal" "" "package_type" "varchar(50)" "NO" "" "normal" "" "poll" "char(1)" "NO" "MUL" "0" "" "total" "int(11)" "NO" "" \N "" "powered_by_RTI" "enum('0','1')" "NO" "" "0" "" "flag_r" "enum('0','1')" "NO" "MUL" "0" "" "flag_v" "enum('0','1')" "NO" "" "0" "" "flag_p" "enum('0','1')" "NO" "" "0" "" "flag_k" "enum('0','1')" "NO" "" "0" "" "k_count" "int(11)" "NO" "" "0" "" "flag_i" "enum('0','1')" "NO" "" "0" "" "flag_g" "enum('0','1')" "NO" "" "0" "" "flag_e1" "enum('0','1')" "NO" "" "0" "" "flag_e2" "enum('0','1')" "NO" "" "0" "" "flag_e3" "enum('0','1')" "NO" "" "0" "" How to repeat: SHOW GLOBAL VARIABLES LIKE 'innodb_ft%'; "Variable_name" "Value" "innodb_ft_aux_table" "" "innodb_ft_cache_size" "80000000" "innodb_ft_enable_diag_print" "OFF" "innodb_ft_enable_stopword" "ON" "innodb_ft_max_token_size" "84" "innodb_ft_min_token_size" "1" "innodb_ft_num_word_optimize" "2000" "innodb_ft_result_cache_limit" "2000000000" "innodb_ft_server_stopword_table" "" "innodb_ft_sort_pll_degree" "2" "innodb_ft_total_cache_size" "640000000" "innodb_ft_user_stopword_table" "" ----------------------------------------------------------------- Error Code: 188 FTS query exceeds result cache limit