1030 - Got error 122 from storage engine

SELECT c.*, cm.*, cd.*, pro.promotion_id FROM categories c INNER JOIN categories_master cm ON c.categories_id = cm.categories_master_id AND cm.status IN (0) LEFT JOIN categories_description cd ON c.categories_id = cd.categories_master_id AND cd.language_id = 2 LEFT JOIN promotion_categories pro_c ON c.categories_id = pro_c.categories_id LEFT JOIN promotion pro ON pro_c.promotion_id = pro.promotion_id AND pro.promotion_status IN (0) AND pro.start_date <= 1466863003 AND pro.end_date >= 1466863003 AND pro.shop_promotion = 0 WHERE cm.parent_id IS NULL GROUP BY c.categories_id ORDER BY cm.sort_order

[TEP STOP]