New to the community? Start here

[Defender Pro] WP-DEFENDER – WordPress database error The size of BLOB/TEXT data

I am getting a large amount of errors logged (8G and growing) to the php_errorlog in public_html/ and public_html/wp-admin
————-
[29-Oct-2019 11:50:04 UTC] WordPress database error The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size for query INSERT INTO wpdg_options (option_name, option_value, autoload) VALUES (‘wdfcontent’,….
also get similar error for UPDATE for same option_name.

Tue, 29 Oct 2019 12:32:26
More Defender Pro discussions
Defender Pro
  • Adam
    • Support Gorilla

    Hi zig

    I hope you’re well today and thank you for your question!

    I’ve never heard about that happening before and I only found one mention of that in the past so I did a bit more research and I believe this issue seem to be related to the internal Defender caching that’s created/used during file scanning.

    In short: when you run file scan in Defender it is attempting to “cache” internally some files to speed things up. It would also “clean up” after itself usually but apparently it’s not only not happening here but also for some reason the process is breaking.

    If it was happening on my site, I’d start with following test:

    – temporarily disable Defender
    – search database (using phpMyAdmin) for the “wdfcontent” row in “wp_options” table and remove it if it’s there
    – remove all those php error logs (though you might want to download them instead for reference if you want to; if necessary they would be regenerated anyway)
    – clear all cache on site and especially any server-side cache (particularly – flush object cache if there is any)

    – enable Defender again and leave it for a while without running File Scan (make sure that scheduled file scan is disabled) and see if the same thing starts to happen again

    – if not – run File Scan in Defender manually first and check for the issue again
    – if it’s still not happening – set scheduled scans and keep an eye on that error log.

    If that won’t help, we’ll need to investigate that closer to find out what’s triggering the issue so let me know please and in such case I’ll need full, direct access to site and server so our developers could check it – if so, I’ll provide you with a save way of sending them to us.

    Kind regards,
    Adam

  • zig
    • WPMU DEV Initiate

    Thank you for your reply.

    This is still happening to some of my sites on one of my servers. I am trying to narrow in on which sites and what they have in common. I’ll keep you updated, in case anyone else has this same issue.