database error Deadlock found query UPDATE `wp_wfBlocks7` ..

  • Resolved jomo

    (@jonathanmoorebcsorg)


    7 years ago

    spotted in logs:

    [28-May-2019 18:58:33 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query UPDATE wp_wfBlocks7 SET reason = ‘Blocked by login security setting’, expiration = 1559077113 WHERE expiration > UNIX_TIMESTAMP() AND type = 8 AND IP = ‘\0\0\0\0\0\0\0\0\0\0��2W�’ made by wp_xmlrpc_server->serve_request, IXR_Server->IXR_Server, IXR_Server->__construct, IXR_Server->serve, IXR_Server->call, wp_xmlrpc_server->wp_getProfile, wp_xmlrpc_server->login, wp_authenticate, apply_filters(‘authenticate’), WP_Hook->apply_filters, wordfence::authenticateFilter, wordfence::processBruteForceAttempt, wfBlock::createIP

Viewing 2 replies - 1 through 2 (of 2 total)
  • WFGerroald

    (@wfgerald)

    7 years ago

    Hey @jonathanmoorebcsorg,

    In Wordfence > Login Security > Settings can you set Require 2FA for XML-RPC call authentication to SKIPPED?

    Then make sure the Disable XML-RPC authentication is not checked?

    Please give this a try and let me know if it helps.

    Thanks,

    Gerroald

    • This reply was modified 7 years ago by WFGerroald.
    Thread Starter jomo

    (@jonathanmoorebcsorg)

    7 years ago

    I’ve left it running without making the change to see if the error reoccurred – which is hasn’t so far.
    I am seeing something else though but I will report that separately as it is probably not related.
    So closing for now as this particular error is non repeating.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘database error Deadlock found query UPDATE `wp_wfBlocks7` ..’ is closed to new replies.

  • 2 replies
  • 2 participants
  • Last reply from: jomo
  • Last activity: 7 years ago
  • Status: resolved