WordPress database error Deadlock found when trying to get lock;

I have also emailed you the report This is the complete error –

[Mon Nov 25 09:37:00.557083 2019] [:error] [pid 1143] [client 10.0.203.4:10172] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE faro_options SET option_value = ‘a:40:{i:0;s:21:\\”polylang/polylang.php\\””welcome-email-editor/sb_welcome_email_editor.php\\”;i:34;s:23:\\”wordfence/wordfence.php\\”;i:35;s:40:\\”wordpress-seo-premium/wp-seo-premium.php\\”;i:36;s:31:\\”wp-all-export/wp-all-export.php\\”;i:37;s:44:\\”wp-custom-taxonomy-meta/wp-texonomy-meta.php\\”;i:38;s:29:\\”wp-mail-smtp/wp_mail_smtp.php\\”;i:39;s:35:\\”wp-media-folder/wp-media-folder.php\\”;}’ WHERE’active_plugins’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/ip2location-redirection/ip2location-redirection.php’), IP2LocationRedirection->__construct, update_option, W3TC\\DbCache_Wpdb->update, W3TC\\DbCache_WpdbInjection_QueryCaching->update, W3TC\\_CallUnderlying->update, W3TC\\DbCache_Wpdb->update, W3TC\\DbCache_WpdbInjection->update, W3TC\\DbCache_Wpdb->default_update, W3TC\\DbCache_Wpdb->query, W3TC\\DbCache_WpdbInjection->query, W3TC\\DbCache_Wpdb->default_query

Hi @sakshirangas

This isn’t related to Wordfence at all but I have an idea of what might be the cause so I have asked my co-workers to take a look too to see if we can point you in the right direction.

Hi @sakshirangas

If you disable database caching in W3 Total Cache then the error is likely to be fixed. If you want to continue using database caching in W3 Total Cache then you will need to ask them to help you resolve it.