Re: Lock Wait TimeOut Different row Update/Delete

[Sulthan Hakiem]

Additional Information
from show engine innodb status result, sql witch cause lock wait timeout

1. UPDATE acc_ledger_monthly SET
alm_last_balance = ROUND(alm_beg_balance + alm_kredit - alm_debet, 2)
WHERE alm_period = p_period AND alm_branch = p_branch AND alm_acc = v_parent


2. UPDATE acc_ledger_monthly SET
alm_debet = ROUND(alm_debet - v_debet, 2),
alm_kredit = ROUND(alm_kredit - v_credit, 2)
WHERE alm_period = v_period AND alm_branch = v_branch AND alm_acc = v_acc AND alm_curr = v_curr

Why that query causing lock wait timeout? both query have alm_period and alm_branch fields different value