WordPress database error Deadlock found

  • Resolved sakshirangas

    (@sakshirangas)


    6 years, 6 months ago

    [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

    I am getting this issue from many days on my website and it is very active website . canyou please login to it why this issue is occuring again and again .

    Thanks in advance

Viewing 1 replies (of 1 total)
  • Plugin Contributor Marko Vasiljevic

    (@vmarko)

    6 years, 6 months ago

    Hello @sakshirangas

    I am sorry about the issue you are experiencing and I am happy to assist you with this.
    When did this issue start to occur? Have you made any recent updates (plugins, WP)?
    Does the issue persist if you disable DB Cache?
    If you are on shared hosting, it’s recommended not to use database caching.
    Moreover, using disk-database caching (on shared hosting) can make your site slower. This is so because getting data from the database can be faster than getting cached data from the disk.
    Try using Object Cache instead. Object Cache allows getting data from the database more efficiently. Its purpose is similar to what Database Cache does. But compared to Database Cache, Object cache is more efficient as it allows to process fewer requests.
    I hope this helps!

Viewing 1 replies (of 1 total)

The topic ‘WordPress database error Deadlock found’ is closed to new replies.