[Resolved] wp_image_processing_queue_batch records in wp_options table

Home Forums Support wp_image_processing_queue_batch records in wp_options table

Viewing 11 posts - 1 through 11 (of 11 total)
  • Author
    Posts
  • #1133236
    Dan

    This duplicates what I posted here here, but I was afraid that issue might be overlooked as it is marked ‘Resolved’. And this also gives me an opportunity to share the URL.

    Here’s the issue:

    I just noticed something similar, with 135,000+ β€˜wp_image_processing_queue_batch…’ entries in my wp_options table. I asked my host, citing this GP support thread/reply.

    They responded to me, linking to this thread. Has this issue been addressed in a GP release subsequent to this thread?

    I first began using GP back in October 2019. Am currently up-to-date with GP 2.4.1 + GP Premium 1.9.1.

    I can delete the wp_options records, but am seeking to address the root cause. Any ideas appreciated.

    Thanks,
    Dan

    #1133271
    Tom
    Lead Developer
    Lead Developer

    Hi there,

    This kind of thing is an anomaly, but it bothers me that it can happen (I think I’ve seen it 2 or 3 times).

    I have a plan to completely re-write the way image resizing is handled in GPP. I’ll do my best to get it done in GPP 1.10 πŸ™‚

    #1133358
    Dan

    Thanks, Tom. If you need any more information, let me know.

    #1133787
    Dan

    I’m passing along the last exchange I had with my host. They said: “We also checked the GP Premium plugin and found that it does the background processing and has those keys reference but it’s not quite clear how they do the cleanup or deleting the entries after.”

    I deleted the 135,000+ wp_options table entries, but they unfortunately continue to regenerate.

    Thanks,
    Dan

    #1134350
    Tom
    Lead Developer
    Lead Developer

    The cleanup should happen automatically. In some cases, it seems like it gets stuck and doesn’t. That’s why we’ll be replacing the resizer completely πŸ™‚

    #1145758
    Michael

    Is it safe now to remove all these entries from the options table Tom?

    #1145764
    Michael

    I just read the previous posts again, looks like it is safe to delete them. I too have a huge amount of these. Anything we can do to stop them being generated again in the meantime?

    #1145976
    Tom
    Lead Developer
    Lead Developer

    Yes, you can delete them.

    Simply leaving your image sizing options in Customize > Layout > Blog will prevent them from happening.

    #1146041
    Michael

    Ok,

    Thanks for the info.

    #1146247
    Tom
    Lead Developer
    Lead Developer
    #1157065
    Fabiana

    I just had the same problem. I had to delete more than 600.000 lines from the database. Looking forward to some fix. Thanks!

Viewing 11 posts - 1 through 11 (of 11 total)
  • You must be logged in to reply to this topic.