‘wp_wfblocks7’ WordPress database error Commands out of sync

  • Resolved adampoly

    (@adampoly)


    2 years, 8 months ago

    This error is appearing in error_log every day that our site does the 3 day scan with Wordfence. What is it and how can it be fixed?

    Other plugins we use include the LiteSpeed caching plugin. This is happening on all sites where we also have the litespeed cache. turning off caching, this erorr doesn’t happen.

    FROMwp_wfblocks7WHEREtypeIN (1, 8, 9, 2, 5, 6) AND (expiration= 0 ORexpiration> UNIX_TIMESTAMP()) ORDER BYtypeSortASC,id` DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::ipBlocks, wfBlock::allBlocks
    [14-Mar-2022 03:55:07 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2
    WHEN type = 6 THEN 3
    WHEN type = 5 THEN 4
    WHEN type = 9 THEN 5
    WHEN type = 8 THEN 6
    WHEN type = 2 THEN 7
    WHEN type = 1 THEN 8
    ELSE 9999
    END AS typeSort, CASE
    WHEN type = 3 THEN parameters
    WHEN type = 4 THEN parameters
    WHEN type = 1 THEN IP
    WHEN type = 9 THEN IP
    WHEN type = 5 THEN IP
    WHEN type = 6 THEN IP
    WHEN type = 7 THEN IP
    WHEN type = 2 THEN IP
    WHEN type = 8 THEN IP
    ELSE 9999
    END AS detailSort
    FROM wp_wfblocks7 WHERE type IN (7) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::lockouts, wfBlock::allBlocks`

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @adampoly,

    We see posts about this exact issue come up fairly often and have been sent many cases of log information from our customers where the exact same error is also reporting the same error for other WordPress plugins at various times.

    For this reason, we believe that the issue is related to the database itself where MySQL/MariaDB is stopping, reconnecting and leaving the connection in a state that somehow causes this query error to appear.

    We usually request that you or your host check the database server logs and other logs for the website(s) on the server such as syslog etc. to see what else is going on with the server at the timestamp of these issues. I would expect the database to be unavailable temporarily, either because it is restarting or has crashed.

    This customer was having intermittent load issues on their server:
    https://www.ads-software.com/support/topic/commands-out-of-sync-can-we-get-a-resolution-please/

    Although investigation isn’t conclusive here, Elegant Themes looks to be experiencing similar “Commands out of sync” issues on a server also flagging these problems with wfblocks7, likely pointing to the access to the database itself being the problem: https://www.ads-software.com/support/topic/database-error-wfblocks7/

    To assist us see whether there’s a consistent element between your case and others, such as host, can you send a diagnostic report to wftest @ wordfence . com? You can find the link to do so at the top of the Wordfence > Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    NOTE: It should look as follows – Screenshot of Tools > Diagnostic > Send by Email

    Thanks,

    Peter.

    I’ll send that along too, since we’re in the same boat.

    It could be a coincidence, but this began not long after installing the Super Page Cache for Cloudflare plugin (no, I really, really don’t want to uninstall it to test that theory) in early March, especially since it seems to be working fine (as is Wordfence, best as I can tell).

    We do not use the LiteSpeed caching plugin, but the server is LiteSpeed.

    We’ve had Wordfence for a long time and haven’t made any recent changes to it.

    It’s logged multiple times a day, but I have no idea what the pattern is.

    I ran a check of our database in Cpanel: it passes.

    Our __wfblocks7 is a mere 0.01MB. The database overall is a little under 400MB.

    Site Health Status is fine in WordPress.

    WordPress: 5.9.2
    PHP: 7.4.28
    MySQL Version: 10.3.34-MariaDB

    If you received that log, did anything jump out? It continues.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘‘wp_wfblocks7’ WordPress database error Commands out of sync’ is closed to new replies.