Commands out of sync

  • Resolved swissspaceboy

    (@swissspaceboy)


    1 year, 8 months ago

    Hello,

    I see that in the latest patch, you did some things around the commands out of sync error. Many thanks for that.

    I got one this morning. on 2 sites. Can you check? I got it in the past sometimes with table “wfhits”.

    [22-Jun-2023 03:35:21 UTC] WordPress database error Commands out of sync; you can't run this command now for query SHOW FULL COLUMNS FROM ctn_wfhits made by wfLog->logHit, wfRequestModel->save, wfModel->save, wfModel-> insert

    [23-Jun-2023 17:41:00 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT * FROM ctn_users WHERE user_login = 'xxx' LIMIT 1 made by wfLog->logHit, wfLog->logHitOK, get_current_user_id, wp_get_current_user, _wp_get_current_user, apply_filters('determine_current_user'), WP_Hook->apply_filters, wp_validate_logged_in_cookie, wp_validate_auth_cookie, get_user_by, WP_User::get_data_by
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @swissspaceboy, thanks for your message.

    These certainly look like less verbose messages than we’ve seen in the past, which could be down to the preventative measures we’ve tried to take in the latest release. However, we would still conclude that it looks like the database has had an issue and tried to reconnect in the middle of processing a hit.

    The first one might be run in the shutdown handler, but the second is in?apply_filters(), which looks like it’s earlier in the process.

    If we could get complete error logs to see what other errors occurred around the same time as these, including mysql/mariadb logs and/or the syslog. If you are able to get those to us, please send them in an email to wftest @ wordfence . com, including your username in the subject line, and responding here so I can take a look for it.

    Thanks,
    Peter.

    Thread Starter swissspaceboy

    (@swissspaceboy)

    Hi Peter,

    I will not be able to provide more logs on this as I am on a shared server with no access to system logs. I checked in the past with my ISP and no errors on their side. The database is also not restarted.

    Sorry for not being able to help more.

    Didier.

    Plugin Support wfpeter

    (@wfpeter)

    Hi @swissspaceboy, no need to apologize!

    We will still attempt to gather as much information about these “out of sync” cases as possible from other customers if they are able, and remain committed to reducing issues such as this where we can.

    Our future release notes will include entries about this we’re able to make further improvements.

    Thanks again,
    Peter.

    Thread Starter swissspaceboy

    (@swissspaceboy)

    The only that I can tell is that it started when my ISP upgraded the MariaDB. My WP version did not change. I upgraded to the latest WP 6.2.2, theme, plugins, etc, but the error still remains.

    I suspect there is an issue with the database indeed, or with the SQL driver. But again, not much that I as the end user can do about it.

    Thanks for your support!

    Didier.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Commands out of sync’ is closed to new replies.