Delete transient – WordPress database error Deadlock

Hi,

Recently our site has been throwing a constant error (every ~3 seconds) about MYSQL Deadlock… Our logs show that it is a new error:

WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name LIKE '\\\\_transient\\\\_%1466643601' ORDER BY option_id LIMIT 1000; made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, WC_API->handle_rest_api_requests, WC_API->handle_v2_rest_api_request, WC_API_Server->serve_request, WC_API_Server->dispatch, call_user_func_array, WC_API_Products->edit_product, wp_update_post, wp_insert_post, wp_transition_post_status, do_action('transition_post_status'), call_user_func_array, WC_Post_Data::transition_post_status, WC_Post_Data::delete_product_query_transients, WC_Cache_Helper::get_transient_version, WC_Cache_Helper::delete_version_transients

The function delete_version_transients located in web/app/plugins/woocommerce/includes/class-wc-cache-helper.php:110 seems to be the problem – or at least part of it.

The only update we made – and could be relevant with this error’s timeline – is installing the woocommerce-direct-checkout plugin

Could you shed some light and help me fix it, please? It is bringing down our site constantly.

Thank you

Woocommerce -> Version 2.4.13
WooCommerce Direct Checkout -> Version 1.1.2
W3 Total Cache -> 0.9.4.1

https://ww.wp.xz.cn/plugins/woocommerce/