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

  • Resolved jaypabs

    (@jaypabs)


    5 years, 7 months ago

    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 INTOpn_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 INTOpn_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 INTOpn_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 INTOpn_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 INTOpn_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 5 years, 7 months ago by jaypabs.
    • This topic was modified 5 years, 7 months ago by jaypabs.
Viewing 15 replies - 1 through 15 (of 25 total)
1 2
  • Plugin Support wfphil

    (@wfphil)

    5 years, 7 months ago

    Hi,

    Can you try flushing all W3TC caches, disable database caching and let me know if that helps please.

    Thanks.

    Thread Starter jaypabs

    (@jaypabs)

    5 years, 7 months ago

    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

    (@wfphil)

    5 years, 7 months ago

    Hi @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

    (@christoxl)

    5 years, 6 months ago

    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

    (@wfphil)

    5 years, 6 months ago

    @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

    (@wfphil)

    5 years, 6 months ago

    Hi @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

    (@jaypabs)

    5 years, 6 months ago

    Hi,

    I have already done all the suggestion and the problem is still there.

    Plugin Support wfphil

    (@wfphil)

    5 years, 6 months ago

    Hi @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 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

    (@jaypabs)

    5 years, 6 months ago

    Hi,

    Just send the email under the Diagnostics tab.

    Thank you

    Plugin Support wfphil

    (@wfphil)

    5 years, 6 months ago

    Hi @jaypabs,

    Thank you for sending the diagnostics report.

    It is under investigation.

    Thank you.

    Barry

    (@barrypersonalctonet)

    5 years, 5 months ago

    Any news on this? I am seeing the same error on one of my sites.

    Barry

    Plugin Support wfphil

    (@wfphil)

    5 years, 5 months ago

    Hi @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 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

    (@jaypabs)

    5 years, 5 months ago

    Hi @wfphil,

    It’s been 2 weeks and 4 days since I send the diagnostic report. Any update on it?

    Plugin Support wfphil

    (@wfphil)

    5 years, 5 months ago

    Hi @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

    (@neltseng)

    5 years, 5 months ago

    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 INTOwp_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
  • The topic ‘PHP message: WordPress database error Deadlock found when trying to get lock’ is closed to new replies.