wfHoover Table Huge After Scan Kill

Rhand, thanks for making the new thread. Sorry for the inconvenience, but it helps make sure we don’t miss new posts!

Normally when a scan finishes, the table should be truncated, but I haven’t seen if it does when a scan is killed while it is large. (I’ll make a note of that to test, and/or for a new feature.)

Is this a large site, with a very large number of links?

And do you know roughly how long the scan was running? You can usually find the time by looking at the times in the yellow “Scan Summary” box on the Wordfence Scan page — you might have to scroll back a while to see when it started.

It’s possible that your scans are never finishing completely, if they’re getting stuck on large files or running out of memory. You should see a message that says “Scan Complete” with some statistics and a memory report at the end of the “Scan Detailed Summary” box, if they’re working correctly.

It’s also possible that even when scans do finish, your table isn’t getting truncated — this could be due to database permissions or a flaw in the table. If the scans seem to finish correctly, but the table is still large, we can go through the potential solutions.

+1
My database was bloated in a way that it went over the limits and we were not able to write to the database, and so no one could log in, or anything really.

Is there any sign of improvement in this feature?
Being compromised this way is almost like being hacked from within .. via security plugin ?? .

2046: Thanks for the input — I’ve opened a request with the dev team to look at options for fixing and/or warning about the unusually large tables. Usually this is a sign of another problem, though. It is most likely permissions on database tables. (Wordfence needs permissions to truncate and delete records in the tables that are used during scans.)

If you’re still having a problem with the tables getting large, can you make a new post, and we can discuss the specifics of your site? (You can include a link to this post for reference — the www.remarpro.com rules ask us to have separate posts per user.)

Rhand: Also, if you are still having this problem, let us know.

Thanks!

-Matt R

FB894

Sure thing,
if anything pops up, I let you know.

(I guess the Wordfence has the same capability as the WP it self, and so it has to have appropriate permissions over the DB. )

Rhand: If you still have this problem let us know the answers to the questions in my first post above. If it only happens intermittently, we may have an improvement for that in a future version, to clean up the tables when scans have failed, but it might not help if your site’s database table permissions are not allowing the tables to be truncated. You might also need to check if your scans are completing properly, just in case.

On a holiday now, but will check the table and permissions when I am back. Thanks for the feedback so far.

Ok, I’ll watch for your reply later. Thanks for responding while on holiday!