WordPress database error Deadlock found

We have had consistent issues with upgrading our version of WP Offload SES Lite in our WordPress multisite. We typically test plugin updates in both a dev and qa environment before pushing to production. Our dev environment is setup with multiple servers and the qa environment has a single server. Every time we try to update to the latest version of the plugin, we see a consistent issue in our error logs for both environments:

[13-Oct-2020 02:19:28 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROMwwcmsp_optionsWHEREoption_name= '_transient_wposes_doing_cron_check' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, DeliciousBrains\WP_Offload_SES\Queue\Queue_Status->check_status, delete_transient, delete_option

We did try pushing to prod despite this error once and several of our sites started having 1-2 day delays with receiving emails. We’d love to get this plugin updated but can’t risk having our sites not receive email as many are using it for critical web form submissions that must be timely.

Note – we have about 1,000 sites on our multisite currently.

I’m hoping someone from the team can provide insight as to why this is happening and/or what we might be able to do to fix it. Thanks!

• This topic was modified 4 years, 1 month ago by jennaklinner.