Query loop - crash mysql

[asmar]

Hi,

After upgrading to 1.7.7.3 from 1.6 one specific category when I try to access it a select query runs in an infinitive loop thus raising the server load and eventually crashing it.

The only option to stop it is to restart mysql.

This is the query that keeps running and keeps running:

 

SELECT p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=206 AND c.nright<=217 AND ps.id_shop='1' GROUP BY p.id_product) p GROUP BY p.id_manufacturer

 

Any help is very much appreciated how to troubleshoot the bloody thing...