Forums

Lock wait timeout exceeded; try restarting transaction

Hello , hope someone can help ! query: UPDATE items_mw dt, mw_c tt SET dt.wC = tt.wC WHERE dt.i_id = tt.i_id; rise error : Lock wait timeout exceeded; try restarting transaction

do you have multiple queries updating those rows at the same time?