• Resolved jet38

    (@jet38)


    Dear all,

    I get a lots of errors in my siteError.log.
    The errors seems to come from WordFence (see below)

    FROM wp_j3spte_wfblocks7 WHERE type IN (4) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC faite par wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::patternBlocks, wfBlock::allBlocks
    [04-Mar-2022 19:27:11 UTC] Erreur de la base de données WordPress : Commands out of sync; you can’t run this command now pour la requête 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

    Do you know how to fix this issue ?

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

    (@wfpeter)

    Hi @jet38, thanks for reaching out to us.

    We see posts about this exact issue from time-to-time and have been sent log information from our customers where the exact same error is also reporting for other WordPress plugins.

    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://wordpress.org/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://wordpress.org/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.

    Thread Starter jet38

    (@jet38)

    Hi Peter,

    Thank you for your help ! I sent the Report by email as you suggest.
    Also I checked with my hoster and when I get this error message :
    [16-Mar-2022 17:52:19 UTC] Erreur de la base de données WordPress : Commands out of sync; you can’t run this command now pour la requête SELECT *, CASE
    WHEN type = 3 THEN 0
    WHEN type = 4 THEN 1
    WHEN type = 7 THEN 2

    I get this error message on sql error
    2022-03-16 18:52:19 139742000793344 [Warning] Aborted connection 43652 to db: ‘s…_s…_s…’ user: ‘s…_s…_m..’ host: ‘localhost’ (Got an error writing communication packets)
    2022-03-16 18:52:19 139742013413120 [Warning] Aborted connection 43649 to db: ‘s…_s…_s…’ user: ‘s…_s…_m…’ host: ‘localhost’ (Got an error reading communication packets)

    I replace text by dot.
    Maybe it helps.

    Best regards.

    Plugin Support wfpeter

    (@wfpeter)

    Hi @jet38, thanks for your reply.

    That is helpful to confirm the connection is being aborted, but certainly still points to the same cause that we suspected where the database is unavailable. Your host may be able to help explain why exactly that is happening. If your memory limits, timeouts and other settings are all good, there could be resource problems, database software might need an update, or perhaps your site is on a shared server where resources are limited when load becomes too high across all sites residing there.

    Thanks,

    Peter.

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

The topic ‘SiteError Log’ is closed to new replies.