Process lock

  • Posts: 419
  • Thank you received: 22
  • Hikashop Business
2 days 11 hours ago #370661

-- 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.

Last edit: 2 days 11 hours ago by mojweb.

Please Log in or Create an account to join the conversation.

  • Posts: 419
  • Thank you received: 22
  • Hikashop Business
2 days 10 hours ago #370666

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?

Please Log in or Create an account to join the conversation.

  • Posts: 85203
  • Thank you received: 13909
  • MODERATOR
2 days 8 hours ago #370663

Hello,

Yes, that's very likely the cause. A query running for over 6000 seconds and locking the hikashop_user table will block any operation that needs to access that table, including order processing and status changes.

Here's what I'd recommend:

1. Kill the stuck query : ask your hosting provider to kill that specific process, or if you have phpMyAdmin access, go to the "Processes" tab and kill it from there.
2. Check AcyMailing's synchronization settings : this query is coming from AcyMailing trying to sync email addresses with HikaShop. There might be a misconfigured or overly broad sync task that's causing it to run on too many records at once. Look in AcyMailing's configuration for the HikaShop user synchronization options and make sure they are properly configured.
3. Once the query is killed, your orders should start processing normally again and you should be able to change order statuses.

If the problem recurs, it would be worth checking with the AcyMailing support team about why their sync query takes so long.

Last edit: 2 days 10 hours ago by nicolas.

Please Log in or Create an account to join the conversation.

Time to create page: 0.053 seconds
Powered by Kunena Forum