PHP message: Deadlock found

  • CharleyBoy

    (@charleyboy)


    6 years ago

    Hi,
    I have been having a lot of error messages lately in my logs. Every few hour, I also get some 500.

    In my log file, I see lines like this one:
    $starting transaction for request INSERT IGNORE INTOwp_wfConfig(name,val,autoload`) VALUES (‘wfSyncGeoIP.lock’, ‘1541969***’, ‘no’) made by require(‘wp-blog-h$
    2018/11/11 17:03:06 [error] 975#975: *1237071 FastCGI sent in stderr: “PHP message: Database error WordPress Deadlock found when trying to get lock; try restarting transaction for request INSERT IGNORE INTO wp_wfConfig (name, val, autoload) VALUES (‘wfSyncGeoIP.lock’, ‘1541973***’, ‘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: 66.***.***.**, server: exemple.com, request: “GET /?wordfence_lh=1&hid=4306778CD8ECF9CD9B890E76D1C0FD96&r=0.8929710348003269 HTTP/1.1”, upstream: “fastcgi://unix:/run/php/php7.0-fpm.sock:”, host: “exemple.com”, referrer: “https://exemple.com/2018/11/11/article/”`

    What is happening?
    Thanks,

    • This topic was modified 6 years ago by CharleyBoy.
    • This topic was modified 6 years ago by CharleyBoy.
Viewing 6 replies - 1 through 6 (of 6 total)
  • wfasa

    (@wfasa)

    Hi @charleyboy,

    Can you send me a diagnostics report from Wordfence please?

    Navigate to Wordfence > Tools and Select the Diagnostics tab. At the top, click the button that says “Send Report by Email.” Change the email address to [email protected] and please provide your forum username so I know who the mail is coming from.

    Thanks!

    Thread Starter CharleyBoy

    (@charleyboy)

    Done, thank you.

    wfasa

    (@wfasa)

    Hi Charley,
    Thanks. I got your diagnostics. We’ve made a bit of progress on debugging this and we think it may be happening on sites where the GeoLite2-Country.mmdb (The GeoIP country database) fails to sync as it should.

    I’m not sure how comfortable you are modifying the database directly via phpMyAdmin but if you are, you can try this

    1. Delete GeoLite2-Country.mmdb file located in wflogs
    2. Delete “_transient_timeout_wfSyncGeoIPActive” and “_transient_wfSyncGeoIPActive” from the wp_options table

    If that works, let me know!

    Thread Starter CharleyBoy

    (@charleyboy)

    Ok we are giving it a try

    Hi @charleyboy,

    I’ll be taking over this thread now!

    Let me know if you are able to get it working ??

    Dave

    Thread Starter CharleyBoy

    (@charleyboy)

    Hi,
    We did what was proposed, but we are still getting tons of 500 errors. Mostly when we are doing something in the admin panel, like a new article. Visitors dont seem to have that problem.

    2018/12/06 08:32:52 [error] 976#976: *7384734 FastCGI sent in stderr: "PHP message: Erreur de la base de données WordPress Deadlock found when trying to get lock; try restarting transaction pour la requête INSERT IGNORE INTO'wp_wfConfig'('name','val', $
2018/12/06 11:22:21 [crit] 976#976: accept4() failed (24: Too many open files)
2018/12/06 11:22:21 [crit] 976#976: *7406911 open() "/var/www/html/wp-content/uploads/2018/12/unite-9-auteure.jpg" failed (24: Too many open files), client: 24.203.206.223, server: exemple.com, request: "GET /wp-content/uploads/2018/12/unite-9-auteu$
2018/12/06 11:22:21 [crit] 976#976: accept4() failed (24: Too many open files)
2018/12/06 11:22:21 [crit] 976#976: accept4() failed (24: Too many open files)
2018/12/06 11:22:21 [crit] 976#976: *7406934 open() "/var/www/html/wp-content/uploads/2018/12/unite-9-auteure.jpg" failed (24: Too many open files), client: 70.82.222.87, server: exemple.com, request: "GET /wp-content/uploads/2018/12/unite-9-auteure$
2018/12/06 11:22:21 [crit] 976#976: accept4() failed (24: Too many open files)
2018/12/06 11:22:21 [crit] 976#976: *7406903 open() "/var/www/html/wp-content/uploads/2018/12/unite-9-auteure-1024x543.jpg" failed (24: Too many open files), client: 204.48.95.65, server: exemple.com, request: "GET /wp-content/uploads/2018/12/unite-$
2018/12/06 11:22:21 [crit] 976#976: *7406966 open() "/var/www/html/wp-content/uploads/2018/12/unite-9-auteure.jpg" failed (24: Too many open files), client: 2001:56b:dc48:5700:c453:f7e9:7f1:cf2c, server: exemple.com, request: "GET /wp-content/upload$
2018/12/06 11:22:21 [crit] 976#976: *7406942 open() "/var/www/html/wp-content/uploads/2018/12/unite-9-auteure-1024x543.jpg" failed (24: Too many open files), client: 70.53.200.183, server: exemple.com, request: "GET /wp-content/uploads/2018/12/unite$
2018/12/06 11:22:21 [crit] 976#976: *7406954 open() "/var/www/html/wp-content/uploads/2018/12/unite-9-auteure.jpg" failed (24: Too many open files), client: 70.81.210.25, server: exemple.com, request: "GET /wp-content/uploads/2018/12/unite-9-auteure$
2018/12/06 11:22:21 [crit] 976#976: accept4() failed (24: Too many open files)
2018/12/06 11:22:21 [crit] 976#976: accept4() failed (24: Too many open files)
2018/12/06 11:22:21 [crit] 976#976: accept4() failed (24: Too many open files)
2018/12/06 11:22:21 [crit] 976#976: accept4() failed (24: Too many open files)
2018/12/06 11:22:22 [crit] 976#976: accept4() failed (24: Too many open files)
    • This reply was modified 5 years, 11 months ago by CharleyBoy.
    • This reply was modified 5 years, 11 months ago by CharleyBoy.
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘PHP message: Deadlock found’ is closed to new replies.