Process lock

-- HikaShop version -- : 6.3
-- Joomla version -- : 4
-- PHP version -- : 8.3.3

When checking Check database The process stops at the last check OK User email addresses synchronized and returns the error Error Lock wait timeout exceeded; try restarting transaction.

Site and admin works. But Orders are not processed. All get the status created regardless of the payment method. I cannot change the order status.

No errors in error logs. Only some warnings.

I found a long-running query 1464752 (UPDATE sjifs_acym_user JOIN sjifs_hikashop_user by email), which runs >6000s and blocks sjifs_hikashop_user. Is this posible culprit?