Scan doesn't complete

Hello saxoflora,
could you check yourself or verify with your host to see if the setting innodb_log_file_size needs to be increased?

Hi wfasa

Thanks for replying. I will check with my host.

saxoflora

Hello

My host doubled the size of innodb_log_file_size and the scan is still hanging.

I’ve done a little more investigation and notice the following:

I have one main WordPress installation in the root folder and the scan completes successfully.

I have 4 other installations in subfolders of the root installation and none of these complete, all hitting the same error decribed above.

On the option screen, the “Scan files outside your WordPress installation” is unchecked.

Thanks for your help.

Hello again!
I’m afraid we haven’t seen this error on any sites before and the way you describe it makes it seem like it’s probably some setting on your site that needs to be changed.

All these installs are running against their own separate databases, is that correct?

I spent almost a month on this prior and I fixed it by excluding graphic files from the scan. It was excluding the .jpg and .png files that fixed it for me and allowed me to complete a scan.

In the options Menu – “Exclude files from scan that match these wildcard patterns. (One per line).”

*.sql
*.mp3
*.pdf
*.jpg
*.png

Thanks Greg. I’ll try this!

Hey saxoflora,
just wanted to check in here to see if the fix suggested by Greg worked? Also curious if you would consider sending me a diagnostics report. I could use it to have a closer look at this issue. Go to Wordfence “Diagnostics” page and at the bottom click the button that says “Send Report by Email”. Change the prefilled address to [email protected] and please provide your username so I know who the mail is coming from. Please let me know when you have sent it so I can go grab it and file it in the correct location. Thanks in advance.

wfasa, thanks for checking. The fix suggested by Greg did not work.

I just sent you the Diagnostics (along with the result of the scan).

The site has its own database but sits as a subdirectory of another site.

When I run a scan on the “umbrella” site with the option “Scan files outside your WordPress installation” checked, the scan completes. So I assume it’s keeping me safe. However, it would be good if the scan worked on the subsites.

Thank you so much for reaching out!

Hi wfasa,

I have the latest version of WordPress (4.7.3) and the latest Wordfence installed (6.3.5), and I’m still getting the following error when I perform a scan:

Error finishing writing value for wfsd_engine (MySQLi error: [1105] Parameter of prepared statement which is set through mysql_send_long_data() is longer than ‘max_long_data_size’ bytes)

I’ve just sent you a diagnostic report, as per your instructions above. Hope that’s okay.

Thanks in advance for your help!

Following…I’m getting this as well on a website.

Similar anyway, this is my error message:

Error finishing writing value for wfsd_engine (MySQLi error: [1118] The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.)

I fixed this today finally. The error is dead correct. There is not enough room for the REDO logs to hold all of the changes. I had to log into my MYSQL server and execute a command to see how big the redo logs were.

Open your MySQLin linux shell and execute this command

show variables like ‘innodb_log%’;

The size returned is in Byres. Mine was 1048576 which = 1MB

I needed to bump the number to 6 MB or 6291456 and restart mysql to get the change to take effect. My host had a place to change InnoDB Log File Size and if you don’t. Call tech support and tell them to set InnoDB Log File Size to 6 MB and try another scan. If you see the error again keep bumping it up in small increments.

Warning. My host told me if you set the number too high. You can’t recover and your database won’t allow you to shrink that number. So please, bump the InnoDB Log File Size in small 1 MB increments until your scan finishes. ??

I hope this works for everyone.