Title: PHP message: WordPress database error Deadlock found when trying to get lock Last modified: September 14, 2018 --- # PHP message: WordPress database error Deadlock found when trying to get lock * Resolved [jaypabs](https://wordpress.org/support/users/jaypabs/) * (@jaypabs) * [7 years, 9 months ago](https://wordpress.org/support/topic/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, > W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\ > _CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection- > >query, W3TC\DbCache_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, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching- > >query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection- > >query, W3TC\DbCache_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, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching- > >query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection- > >query, W3TC\DbCache_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, W3TC\DbCache_Wpdb- > >query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying- > >query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_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, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection_QueryCaching- > >query, W3TC\_CallUnderlying->query, W3TC\DbCache_Wpdb->query, W3TC\DbCache_WpdbInjection- > >query, W3TC\DbCache_Wpdb->default_query - This topic was modified 7 years, 9 months ago by [jaypabs](https://wordpress.org/support/users/jaypabs/). - This topic was modified 7 years, 9 months ago by [jaypabs](https://wordpress.org/support/users/jaypabs/). Viewing 15 replies - 1 through 15 (of 25 total) 1 [2](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/page/2/?output_format=md) [→](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/page/2/?output_format=md) * Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/) * (@wfphil) * [7 years, 8 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10703086) * Hi, * Can you try flushing all W3TC caches, disable database caching and let me know if that helps please. * Thanks. * Thread Starter [jaypabs](https://wordpress.org/support/users/jaypabs/) * (@jaypabs) * [7 years, 8 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10703469) * Hi, * I already flushed the W3TC cache and disable disable caching without luck. I even tried disabling W3TC. But the error still persist. * Any additional troubleshooting? * Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/) * (@wfphil) * [7 years, 8 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10729032) * Hi [@jaypabs](https://wordpress.org/support/users/jaypabs/) * If database W3TC database caching was properly disabled and all caches were cleared then we don’t think we’re doing anything that should be able to cause deadlocks on our own. * It could be possible another plugin is locking tables (maybe a backup plugin?), and broke in a way that it left a table locked when it’s no longer doing any work. Or, maybe it was still running a backup and taking excessively long. * If your site is not on shared hosting we suggest restarting MySQL, to see if that helps, or if it still occurs after that. * For finding the original cause, it might help to know if you are using an uncommon backup plugin, or backups outside of WordPress. * It also might be worth checking if the **wfConfig** table needs to be repaired. * Thank you. * [christoxl](https://wordpress.org/support/users/christoxl/) * (@christoxl) * [7 years, 8 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10772569) * I have the same problem, lots of deadlock errors since one of the last updates of the plugin, I didn’t notice it until the Top 5 Ips Blocked list was completely empty, here is some example of logs that I’m having. * `2018/10/11 14:25:28 [error] 9847#9847: *1141333 FastCGI sent in stderr: "PHP message: WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT IGNORE INTO 'wp_wfConfig' ('name', 'val',' autoload') VALUES ('wfSyncGeoIP.lock', '1539285927', '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" while reading response header from upstream, client: 139.217.198.125, server: mysite. com, request: "GET /some-page/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/ php-fpm/php-fpm.sock:", host: "mysite.com"` * By the way , I’m not using any cache or backup plugin, hope you can help me with this issue. * Thanks in advance. * Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/) * (@wfphil) * [7 years, 8 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10776088) * [@christoxl](https://wordpress.org/support/users/christoxl/) – As per forum guidelines below can you open your own topic please: * _“Unless users have the exact same version of WordPress on the same physical server hosted by the same hosts with the same plugins, theme, and configurations, then the odds are the solution for one user will not be the same for another. For this reason, we recommend people start their own topics.”_ * Thank you. * Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/) * (@wfphil) * [7 years, 8 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10788087) * Hi [@jaypabs](https://wordpress.org/support/users/jaypabs/), * Since I haven’t heard back from you I am assuming that the instructions solved your issue so I am marking this topic as resolved. * If however, for whatever reason, you are still experiencing this issue and it is not resolved please respond to the post, which moves it back up the queue, and mark this topic as “not resolved”. * Thank you. * Thread Starter [jaypabs](https://wordpress.org/support/users/jaypabs/) * (@jaypabs) * [7 years, 7 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10788670) * Hi, * I have already done all the suggestion and the problem is still there. * Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/) * (@wfphil) * [7 years, 7 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10795966) * Hi [@jaypabs](https://wordpress.org/support/users/jaypabs/), * Thank you for the update that this isn’t resolved yet. * We would like to have a look at your Wordfence diagnostics report. Please go to the top of the “**Diagnostics**” tab on the Wordfence “**Tools**” page. There will be a “**SEND REPORT BY EMAIL**” button to send the diagnostics report. Enter** phil [at] wordfence [dot] com** as the email and **[@jaypabs](https://wordpress.org/support/users/jaypabs/)** as the forum username please. * Once you have emailed me the diagnostics report can you reply here to let me know that it has been sent. This is important in the unlikely event that your installation of WordPress is having an issue with sending mail. * Thank you. * Thread Starter [jaypabs](https://wordpress.org/support/users/jaypabs/) * (@jaypabs) * [7 years, 7 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10798188) * Hi, * Just send the email under the Diagnostics tab. * Thank you * Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/) * (@wfphil) * [7 years, 7 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10811113) * Hi [@jaypabs](https://wordpress.org/support/users/jaypabs/), * Thank you for sending the diagnostics report. * It is under investigation. * Thank you. * [Barry](https://wordpress.org/support/users/barrypersonalctonet/) * (@barrypersonalctonet) * [7 years, 7 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10854038) * Any news on this? I am seeing the same error on one of my sites. * Barry * Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/) * (@wfphil) * [7 years, 7 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10854812) * Hi [@barrypersonalctonet](https://wordpress.org/support/users/barrypersonalctonet/) * We would like to have a look at your Wordfence diagnostics report too. Please go to the top of the “Diagnostics” tab on the Wordfence “Tools” page. There will be a “SEND REPORT BY EMAIL” button to send the diagnostics report. Enter phil[ at] wordfence [dot] com as the email and [@barrypersonalctonet](https://wordpress.org/support/users/barrypersonalctonet/) as the forum username please. * Once you have emailed me the diagnostics report can you reply here to let me know that it has been sent. This is important in the unlikely event that your installation of WordPress is having an issue with sending mail. * Thank you. * Thread Starter [jaypabs](https://wordpress.org/support/users/jaypabs/) * (@jaypabs) * [7 years, 7 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10855010) * Hi [@wfphil](https://wordpress.org/support/users/wfphil/), * It’s been 2 weeks and 4 days since I send the diagnostic report. Any update on it? * Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/) * (@wfphil) * [7 years, 7 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10856393) * Hi [@jaypabs](https://wordpress.org/support/users/jaypabs/) * It is still under investigation. * As soon as I have an update for you I will be able to send a reply. * Thank you. * [neltseng](https://wordpress.org/support/users/neltseng/) * (@neltseng) * [7 years, 6 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/#post-10889667) * Hi, * Same problem here, it’s cause cpu overloading, we are hosting on AWS EC2 and database on RDS. We have checked the RDS’s cpu log and it’s seems no unusual loading process. * `WordPress \xe8\xb3\x87\xe6\x96\x99\xe5\xba\xab\xe9\x8c\xaf\xe8\xaa\xa4\xef\xbc\ x9aDeadlock found when trying to get lock; try restarting transaction \xe7\x94\ xb1\xe6\x8c\x87\xe4\xbb\xa4 INSERT IGNORE INTO`wp_wfConfig`(`name`,`val`,`autoload`) VALUES ('wfSyncGeoIP.lock', '1542386443', 'no') \xe5\xbc\x95\xe7\x99\xbc\xef\ xbc\x8c\xe9\x8c\xaf\xe8\xaa\xa4\xe4\xbe\x86\xe8\x87\xaa 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` Viewing 15 replies - 1 through 15 (of 25 total) 1 [2](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/page/2/?output_format=md) [→](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/page/2/?output_format=md) The topic ‘PHP message: WordPress database error Deadlock found when trying to get lock’ is closed to new replies. * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865) * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/) * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq) * [Support Threads](https://wordpress.org/support/plugin/wordfence/) * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/) * 25 replies * 6 participants * Last reply from: [wfphil](https://wordpress.org/support/users/wfphil/) * Last activity: [7 years, 5 months ago](https://wordpress.org/support/topic/php-message-wordpress-database-error-deadlock-found-when-trying-to-get-lock/page/2/#post-11002654) * Status: resolved