Title: serious problem
Last modified: June 6, 2021

---

# serious problem

 *  Resolved [zz102p](https://wordpress.org/support/users/zz102p/)
 * (@zz102p)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/serious-problem-7/)
 * Hi, from that day on, errors began to arrive in the database, namely
 *     ```
       [06-Jun-2021 15:44:26 UTC] База данных WordPress возвратила ошибку Commands out of sync; you can't run this command now в ответ на запрос SELECT *, CASE 
       WHEN <code>type</code> = 3 THEN 0
       WHEN <code>type</code> = 4 THEN 1
       WHEN <code>type</code> = 7 THEN 2
       WHEN <code>type</code> = 6 THEN 3
       WHEN <code>type</code> = 5 THEN 4
       WHEN <code>type</code> = 9 THEN 5
       WHEN <code>type</code> = 8 THEN 6
       WHEN <code>type</code> = 2 THEN 7
       WHEN <code>type</code> = 1 THEN 8
       ELSE 9999
       END AS <code>typeSort</code>, CASE 
       WHEN <code>type</code> = 3 THEN <code>parameters</code>
       WHEN <code>type</code> = 4 THEN <code>parameters</code>
       WHEN <code>type</code> = 1 THEN <code>IP</code>
       WHEN <code>type</code> = 9 THEN <code>IP</code>
       WHEN <code>type</code> = 5 THEN <code>IP</code>
       WHEN <code>type</code> = 6 THEN <code>IP</code>
       WHEN <code>type</code> = 7 THEN <code>IP</code>
       WHEN <code>type</code> = 2 THEN <code>IP</code>
       WHEN <code>type</code> = 8 THEN <code>IP</code>
       ELSE 9999
       END AS <code>detailSort</code>
        FROM <code>wp_wfblocks7</code> WHERE <code>type</code> IN (7) AND (<code>expiration</code> = 0 OR <code>expiration</code> > UNIX_TIMESTAMP()) ORDER BY <code>typeSort</code> ASC, <code>id</code> DESC, выполненный wfWAFIPBlocksController::synchronizeConfigSettings, wfBlock::lockouts, wfBlock::allBlocks
       ```
   
 * I also noticed that the plug-in periodically causes sharp jumps in resource consumption,
   namely “processes” and “RAM”, which does not allow registered users to visit 
   the site, the site freezes. the problem arose exactly 2 weeks ago

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

 *  Thread Starter [zz102p](https://wordpress.org/support/users/zz102p/)
 * (@zz102p)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/serious-problem-7/#post-14525795)
 * after disabling the plugin, the site’s work returned to normal, the error ceased
   to manifest itself, both in the database and on the site
 *  Plugin Support [wfpeter](https://wordpress.org/support/users/wfpeter/)
 * (@wfpeter)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/serious-problem-7/#post-14527630)
 * Hi [@zz102p](https://wordpress.org/support/users/zz102p/), thanks for getting
   in touch.
 * At the moment, whilst this absolutely _does_ happen with database operations 
   Wordfence is attempting, our latest study of customer error logs point to the
   exact same error message also showing across database queries for multiple plugins.
   This suggests to us that there is another problem with the database itself stopping,
   reconnecting and leaving the connection in a state where this error can occur.
 * Please also refer to this topic that turned out to be an intermittent load issue
   at the server end: [https://wordpress.org/support/topic/commands-out-of-sync-can-we-get-a-resolution-please/](https://wordpress.org/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. If you do discover any additional 
   information while looking into the logs that you feel may assist us or other 
   customers, please feel free to let us know here.
 * Thanks,
 * Peter.
 *  Thread Starter [zz102p](https://wordpress.org/support/users/zz102p/)
 * (@zz102p)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/serious-problem-7/#post-14528670)
 * I used CDN Cloudflare, when I turn it off, then such errors come out, when I 
   turn it back on, then these errors disappear.
 *  Thread Starter [zz102p](https://wordpress.org/support/users/zz102p/)
 * (@zz102p)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/serious-problem-7/#post-14530672)
 * no other errors in the database
 *  Plugin Support [wfpeter](https://wordpress.org/support/users/wfpeter/)
 * (@wfpeter)
 * [5 years, 1 month ago](https://wordpress.org/support/topic/serious-problem-7/#post-14531963)
 * Hi [@zz102p](https://wordpress.org/support/users/zz102p/), I have spoken to our
   development team again regarding this issue.
 * You or your host may see something in the logs where the database server disconnects/
   restarts in the logs at the time these errors occur, but we haven’t seen evidence
   of this yet from previous customers so we can’t rule out a silent failure either.
 * It’s possible that this error occurs during brute force attacks, so the database
   is busy trying to handle all the traffic. Since Wordfence is trying to keep track
   of failed logins so it can lock out the attackers while letting in genuine users,
   it does take some resources. Seeing the errors only when Cloudflare is off means
   that Cloudflare is likely decreasing load on the server by serving cached pages
   to some users, or also blocking some of the attacks before they reach the server.
 * Thanks,
 * Peter.

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

The topic ‘serious problem’ is closed to new replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [wfpeter](https://wordpress.org/support/users/wfpeter/)
 * Last activity: [5 years, 1 month ago](https://wordpress.org/support/topic/serious-problem-7/#post-14531963)
 * Status: resolved