PHP message: WordPress database error Deadlock found when trying to get lock

I’m trying to fix this deadlock issue on my site without luck. I’m using WordFence and when I disable it, the error is gone. I disabled the plugin by removing it completely and reinstall it again, but the error also appear whenever I reinstall it.

Note that I have uninstalled the plugin completely as suggested by WordFence.

Anyone know what’s causing this?

Here’s the log on my server:

2018/09/14 01:13:38 [error] 21753#21753: *2868716 FastCGI sent in stderr: “PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1536912818’, ‘no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::createLock, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_Wpdb->default_query” while reading response header from upstream, client: 34.232.72.139, server: mysite.com, request: “GET /2017/09/19/sample-article/feed/ HTTP/1.1”, upstream: “fastcgi://127.0.0.1:9011”, host: “mysite.com”
2018/09/14 01:13:57 [error] 21753#21753: *2869493 FastCGI sent in stderr: “PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1536912837’, ‘no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::createLock, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_Wpdb->default_query” while reading response header from upstream, client: 54.241.188.65, server: mysite.com, request: “GET /test-article/ HTTP/1.1”, upstream: “fastcgi://127.0.0.1:9011”, host: “mysite.com”, referrer: “search.yahoo.com/”
2018/09/14 01:14:03 [error] 21753#21753: *2869668 FastCGI sent in stderr: “PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1536912842’, ‘no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::createLock, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_Wpdb->default_query” while reading response header from upstream, client: 13.56.241.76, server: mysite.com, request: “GET /2013/07/17/testing/ HTTP/1.1”, upstream: “fastcgi://127.0.0.1:9011”, host: “philnews.ph”, referrer: “android-app://com.google.android.googlequicksearchbox”
2018/09/14 01:14:03 [error] 21753#21753: *2869683 FastCGI sent in stderr: “PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1536912843’, ‘no’) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::createLock, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_Wpdb->default_query” while reading response header from upstream, client: 54.193.113.108, server: mysite.com, request: “GET /sample/ HTTP/1.1”, upstream: “fastcgi://127.0.0.1:9011”, host: “mysite.com”, referrer: “mysite.com/articl1/”
2018/09/14 01:15:14 [error] 21753#21753: *2871964 FastCGI sent in stderr: “PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO `pn_wfconfig` (`name`, `val`, `autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1536912914’, ‘no’) made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::veryFirstAction, wfConfig::createLock, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TCDbCache_Wpdb->query, W3TCDbCache_WpdbInjection->query, W3TCDbCache_Wpdb->default_query

Read more here:: PHP message: WordPress database error Deadlock found when trying to get lock

Leave a Reply

Your email address will not be published. Required fields are marked *