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.
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.