xiaoweiX
|
Hi,
Ever since we activated wpml on our site, we have seen increased frequency of database deadlocks. e.g.
[Thu Jun 08 18:16:40.822766 2023] [php7:notice] [pid 16833] [client 172.71.210.164:12610] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_actionscheduler_actions SET attempts = attempts+1, status='in-progress', last_attempt_gmt = '2023-06-08 10:16:40', last_attempt_local = '2023-06-08 18:16:40' WHERE action_id = 1137512 made by do_action('wp_ajax_nopriv_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_DBStore->log_execution
I searched for a solution and landed on this thread: https://wpml.org/forums/topic/wordpress-database-error-deadlock-found-when-trying-to-get-lock-7/
which is marked resolved. I wonder what was the working fix?
Thanks
Shawn
|
Bobby
Supporter
Languages:
English (English )
Timezone:
America/Los_Angeles (GMT-08:00)
|
Hi there,
Did you recently migrate this site by any chance?
Go to WPML->Support->Troubleshooting-> Clear the Cache in WPML
Do you currently have any drop-in plugins? Such as CDN-cache for example.
|
xiaoweiX
|
Hi,
No, site is not recently migrated.
Done Clear WPML Cache.
Only one drop-in plugin, advanced-cache.php - which is provided by WPRocket.
|
Bobby
Supporter
Languages:
English (English )
Timezone:
America/Los_Angeles (GMT-08:00)
|
Did the troubleshooting action help?
Is the deadlock happening a few moments after WPMl is activated or do we need to perform an action to reproduce it?
Deactivate WPML and it's add-on plugins -> delete and re install with a fresh version from https://wpml.org/downloads/
Let me know your results, please.
|
