Rubin Shrestha
Zend certified PHP/Magento developer
Rubin Shrestha
Blog

Magento 2.4 , Query execution was interrupted, query_timeout exceeded

by |Published

its given when indexing Category Products index
Category Products index process error during indexation process: SQLSTATE[70100]: <<Unknown error>>: 1907 Query execution was interrupted, query_timeout exceeded, query was: INSERT INTO catalog_category_product_index_store2_tmp (category_id, pr
oduct_id, position, is_parent, store_id, visibility) SELECT cc.entity_idAScategory_id, ccp.product_id, ccp.position, 1 AS is_parent, 2 AS store_id, IFNULL( cpvs.value, cpvd.value)
who can help me ?
Thanks

You may also like