WF Not Closing Connections on DB

Hi

Hope we can help.

Can you identify which wf tables its holding open? Are there any scans going on? Is live view enabled while you are running these operations?

Thanks!

tim

Thanks for the quick response!

There was no scans happening. Live view was not enabled. (I’m pretty sure, the Falcon Engine is on and that disables it I believe.)

Here is the log of the tables:

[11-Sep-2014 16:20:15] Result of table check for wp_wfBadLeechers is: OK
[11-Sep-2014 16:20:15] WARNING: Result of table check for wp_wfBlocks is: 13 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:15] Result of table check for wp_wfBlocksAdv is: OK
[11-Sep-2014 16:20:15] WARNING: Result of table check for wp_wfConfig is: 70 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:15] WARNING: Result of table check for wp_wfCrawlers is: 27 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:15] WARNING: Result of table check for wp_wfFileMods is: 1 client is using or hasn't closed the table properly
[11-Sep-2014 16:20:15] WARNING: Result of table check for wp_wfHits is: 1 client is using or hasn't closed the table properly
[11-Sep-2014 16:20:15] Result of table check for wp_wfHoover is: OK
[11-Sep-2014 16:20:15] Result of table check for wp_wfIssues is: OK
[11-Sep-2014 16:20:16] WARNING: Result of table check for wp_wfLeechers is: 78 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:16] Result of table check for wp_wfLockedOut is: OK
[11-Sep-2014 16:20:16] WARNING: Result of table check for wp_wfLocs is: 4 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:16] WARNING: Result of table check for wp_wfLogins is: 38 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:16] WARNING: Result of table check for wp_wfNet404s is: 75 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:16] WARNING: Result of table check for wp_wfReverseCache is: 29 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:16] WARNING: Result of table check for wp_wfScanners is: 75 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:16] WARNING: Result of table check for wp_wfStatus is: 70 clients are using or haven't closed the table properly
[11-Sep-2014 16:20:16] Result of table check for wp_wfThrottleLog is: OK
[11-Sep-2014 16:20:16] Result of table check for wp_wfVulnScanners is: OK

Thanks for the help!

This is table corruption and likely your DB crashed which is what caused this. It’s indicative of an unstable DB rather than a problem with our plugin.

Please also check the rest of your tables, it’s likely you’ll find errors there too.

Run a full repair on the tables with problems. Then monitor both the table integrity and when/if your DB crashes. I’m guessing you’ll notice a correlation between your DB crashing (or other issues like disk corruption or disk getting full) and table corruption.

Regards,

Mark.

No other tables in the database were showing any errors. Only the tables from WordFence had these errors.

I will keep an eye on things. Maybe it was a fluke.