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

Hi,

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

Thanks.

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?

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.

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.

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

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.

Hi,

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

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.

Hi,

Just send the email under the Diagnostics tab.

Thank you

Hi @jaypabs,

Thank you for sending the diagnostics report.

It is under investigation.

Thank you.

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

Barry

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.

Hi @wfphil,

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

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.

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