iPad

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: INSERT INTO `catalog_category_product_index_store1` (`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`) SELECT `cc`.`entity_id` AS `category_id`, `ccp`.`product_id`, IFNULL(ccp2.position, ccp.position + 10000) AS `position`, 0 AS `is_parent`, 1 AS `store_id`, IFNULL(cpvs.value, cpvd.value) AS `visibility` FROM `catalog_category_entity` AS `cc` INNER JOIN `temp_catalog_category_tree_index_e4b4e2d1` AS `cc2` ON cc2.parent_id = cc.entity_id AND cc.entity_id NOT IN (1) INNER JOIN `catalog_category_product` AS `ccp` ON ccp.category_id = cc2.child_id LEFT JOIN `catalog_category_product` AS `ccp2` ON ccp2.category_id = cc2.parent_id AND ccp.product_id = ccp2.product_id INNER JOIN `catalog_product_entity` AS `cpe` ON ccp.product_id = cpe.entity_id INNER JOIN `catalog_product_website` AS `cpw` ON cpw.product_id = ccp.product_id INNER JOIN `catalog_product_entity_int` AS `cpsd` ON cpsd.entity_id = cpe.entity_id AND cpsd.store_id = 0 AND cpsd.attribute_id = 97 LEFT JOIN `catalog_product_entity_int` AS `cpss` ON cpss.entity_id = cpe.entity_id AND cpss.attribute_id = cpsd.attribute_id AND cpss.store_id = 1 INNER JOIN `catalog_product_entity_int` AS `cpvd` ON cpvd.entity_id = cpe. entity_id AND cpvd.store_id = 0 AND cpvd.attribute_id = 99 LEFT JOIN `catalog_product_entity_int` AS `cpvs` ON cpvs.entity_id = cpe.entity_id AND cpvs.attribute_id = cpvd.attribute_id AND cpvs.store_id = 1 INNER JOIN `catalog_category_entity_int` AS `ccad` ON ccad.entity_id = cc.entity_id AND ccad.store_id = 0 AND ccad.attribute_id = 54 LEFT JOIN `catalog_category_entity_int` AS `ccas` ON ccas.entity_id = cc.entity_id AND ccas.attribute_id = ccad.attribute_id AND ccas.store_id = 1 LEFT JOIN `catalog_product_relation` AS `relation` ON cpe.entity_id = relation.parent_id LEFT JOIN `catalog_product_entity` AS `relation_product_entity` ON relation.child_id = relation_product_entity.entity_id LEFT JOIN `catalog_product_entity_int` AS `child_cpsd` ON child_cpsd.entity_id = relation_product_entity.entity_id AND child_cpsd.store_id = 0 AND child_cpsd.attribute_id = 97 LEFT JOIN `catalog_product_entity_int` AS `child_cpss` ON child_cpss.entity_id = relation_product_entity.entity_id AND child_cpss.attribute_id = child_cpsd.attribute_id AND child_cpss.store_id = 1 WHERE (cpw.website_id = '1') AND (IFNULL(cpss.value, cpsd.value) = 1) AND (IFNULL(cpvs.value, cpvd.value) IN (2, 3, 4)) AND (IFNULL(ccas.value, ccad.value) = 1) AND (relation.child_id IS NULL OR IFNULL(child_cpss.value, child_cpsd.value) = 1) AND (ccp.product_id IN (30, 31, 34, 35, 36, 37, 38, 39, 40, 42, 43, 44, 45, 46, 329, 330, 331, 332, 334, 336, 337, 338, 340, 344, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 359, 360, 361, 362, 363, 364, 365, 367, 368, 380, 384, 399, 400, 415, 416, 417, 427, 470, 487, 1260, 1266, 1268, 1276, 1279, 1280, 1623, 1624, 1692, 1693, 1694, 1695, 1696, 1697, 1698, 1699, 1700, 1701, 1702, 1703, 1725, 1726, 1727, 1728, 1879, 1880, 2156, 2180, 2220, 2252, 2253, 2254, 2255, 2677, 2678, 2688, 2692, 3031, 3032, 3033, 3034, 3035, 3037, 3038, 3039, 3041, 3042, 3043, 3045, 3047, 3048, 3049, 3050, 3051, 3052, 3053, 3055, 3649, 3676, 3677, 3678, 3679, 3680, 3681, 3682, 3683, 3684, 3685, 3686, 3688, 3695, 3697, 4478, 4481, 4482, 4885, 4888, 4893, 4968, 4969, 4970, 4971, 4972, 4973, 4974, 4975, 4976, 4977, 4978, 4979, 4980, 4981, 4982, 4983, 4984, 4985, 4986, 4987, 4988, 4989, 4990, 4991, 4992, 4993, 4994, 4995, 4996, 4997, 4998, 4999, 5000, 5008, 5009, 5010, 5011, 5012, 5105, 5106, 5107)) GROUP BY `cc`.`entity_id`, `ccp`.`product_id`, `visibility` ON DUPLICATE KEY UPDATE `category_id` = VALUES(`category_id`), `product_id` = VALUES(`product_id`), `position` = VALUES(`position`), `is_parent` = VALUES(`is_parent`), `store_id` = VALUES(`store_id`), `visibility` = VALUES(`visibility`)