Another synchronizeConfigSettings issue

  • Resolved nvr21

    (@nvr21)


    5 years, 1 month ago

    Hello,
    As many other users that are running WordPress on a LiteSpeed server the error log is full of commands out of sync.
    The hosting provider told me that there is nothing wrong on their end.
    I need a fix for this issue.
    Diagnostic info was sent by forum username.
    Many thanks in advance.

    FROMxx_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
    [17-Apr-2021 12:44:05 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 xx_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 1 replies (of 1 total)
  • Plugin Support wfpeter

    (@wfpeter)

    5 years, 1 month ago

    Hi @nvr21, thanks for dropping us a message about this and sorry to see you’re having trouble with these errors.

    I’m mindful that I don’t want to ping you backwards and forwards between us and your host but when this has cropped up before, the log entries we’ve been sent show that this error is not unique to Wordfence and can also occur with other plugins. It seems like MySQL/MariaDB is stopping, reconnecting and leaving the connection in a state that somehow causes this error to appear.

    Please also refer to this topic that turned out to be an intermittent load issue at the server end: https://ww.wp.xz.cn/support/topic/commands-out-of-sync-can-we-get-a-resolution-please/

    In general, we recommend:

    • Making sure the MySQL server is up to date.
    • Checking the MySQL error logs to see if there was an error or restart around the times these occur.
    • Checking the access log to see if there is a hit around the time these errors occur.
    • Possibly checking the syslog, to see if there were any unusual errors logged by the OS around the same time.

    Your host may be able to help you with some of these logs and point you in the right direction when considering matching timestamps to see what’s happening in the database at the time of the errors.

    Thanks,

    Peter.

Viewing 1 replies (of 1 total)

The topic ‘Another synchronizeConfigSettings issue’ is closed to new replies.