0

After reboot my server I get the below error in all listing pages, please advice,

2 exception(s):

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[HY000]: General error: 1030 Got error 1 from storage engine, query was: INSERT INTO search_tmp_5ec86db450add4_38423720 SELECT main_select.entity_id, SUM(score) AS relevance FROM (SELECT DISTINCT search_index.entity_id, (((0) + (0)) * 1) AS score FROM catalog_product_index_eav AS search_index INNER JOIN cataloginventory_stock_status AS stock_index ON stock_index.product_id = search_index.entity_id AND stock_index.website_id = 0 AND stock_index.stock_id = 1 INNER JOIN catalog_category_product_index_store1 AS category_ids_index ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (search_index.attribute_id = 99 AND search_index.value in ('2', '4') AND search_index.store_id = '1') AND (category_ids_index.category_id in ('41'))) AS main_select GROUP BY entity_id ORDER BY relevance DESC, entity_id DESC LIMIT 10000 Exception #1 (PDOException): SQLSTATE[HY000]: General error: 1030 Got error 1 from storage engine

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[HY000]: General error: 1030 Got error 1 from storage engine, query was: INSERT INTO search_tmp_5ec86db450add4_38423720 SELECT main_select.entity_id, SUM(score) AS relevance FROM (SELECT DISTINCT search_index.entity_id, (((0) + (0)) * 1) AS score FROM catalog_product_index_eav AS search_index INNER JOIN cataloginventory_stock_status AS stock_index ON stock_index.product_id = search_index.entity_id AND stock_index.website_id = 0 AND stock_index.stock_id = 1 INNER JOIN catalog_category_product_index_store1 AS category_ids_index ON search_index.entity_id = category_ids_index.product_id AND category_ids_index.store_id = '1' WHERE (search_index.store_id = '1') AND (search_index.attribute_id = 99 AND search_index.value in ('2', '4') AND search_index.store_id = '1') AND (category_ids_index.category_id in ('41'))) AS main_select GROUP BY entity_id ORDER BY relevance DESC, entity_id DESC LIMIT 10000 #1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:303]

2 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]

3 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]

4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:546]

5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:613]

6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/Interceptor.php:128]

7 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() called at [vendor/magento/framework/Search/Adapter/Mysql/TemporaryStorage.php:117]

8 Magento\Framework\Search\Adapter\Mysql\TemporaryStorage->storeDocumentsFromSelect() called at [vendor/magento/framework/Search/Adapter/Mysql/Adapter.php:92]

9 Magento\Framework\Search\Adapter\Mysql\Adapter->query() called at [vendor/magento/module-search/Model/SearchEngine.php:42]

10 Magento\Search\Model\SearchEngine->search() called at [vendor/magento/framework/Search/Search.php:85]

  • try again mysql and apache server restart – Mohit Patel May 23 at 2:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.