after we’ve upgraded magento a few weeks ago to the latest this worked fine. sometimes i got the same hangs too before - i had to restart mysql or my vps and that helped.
but now it looks like i am unable to do anything except process the orders.
whatever product i try to modify, clone, create new product, clear cache i got errors
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
restarted mysql result is the same.
any idea what is happening? because of this i am unable to update any product.
i would be happy to pay for professional help too as this become a real issue for us.
shop page is: www.greenaqua.hu