Search not working

apiuser · ‎08-30-2016

Feature request from mc388, posted on GitHub Nov 27, 2015

Hi,

I just installed magento 2 with sample data and try to search for a product. After starting the search, mysql has a query which now is running over 27 minutes and it is still running.

Here the query:

INSERT INTO `search_tmp_5658146c0b72c8_28632618` SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('back*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index`
 LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
 LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = '1' WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('back*' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000 /* statement may be truncated */

apiuser · ‎08-30-2016

Comment from maghamed, posted on GitHub May 25, 2016

@EmilyPepperman and @mc388 could you please provide exact version of MySQL on which you reproduce the bug? Because on our infrastructure Search works as expected. Seems that was a MySQL bug which has been fixed in one of the MySQL releases.

apiuser · ‎08-30-2016

Comment from robfico, posted on GitHub May 25, 2016

ok, we upgraded from MySQL 5.7.10 to latest 5.7.12, and the search now completes without any issue. Looks like MySQL fixed a bug that Magento was triggering previously.

apiuser · ‎08-30-2016

Comment from EmilyPepperman, posted on GitHub May 25, 2016

This morning upgraded MySQL to 5.7.12 and all is well! @maghamed

apiuser · ‎08-30-2016

Comment from daim2k5, posted on GitHub May 25, 2016

@mc388 did you tried the MySQL to 5.7.12 ?

apiuser · ‎08-30-2016

Comment from mc388, posted on GitHub Jun 01, 2016

@daim2k5 we switched back to mysql 5.6.