- This topic has 10 replies, 4 voices, and was last updated 4 months, 3 weeks ago by Fabiana.
January 15, 2020 at 10:27 am #1133236Dan
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.
DanJanuary 15, 2020 at 11:02 am #1133271TomLead DeveloperLead Developer
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 🙂January 15, 2020 at 12:08 pm #1133358Dan
Thanks, Tom. If you need any more information, let me know.January 16, 2020 at 2:18 am #1133787Dan
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.
DanJanuary 16, 2020 at 10:12 am #1134350TomLead DeveloperLead 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 🙂January 27, 2020 at 7:13 am #1145758Michael
Is it safe now to remove all these entries from the options table Tom?January 27, 2020 at 7:19 am #1145764Michael
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?January 27, 2020 at 9:53 am #1145976TomLead DeveloperLead Developer
Yes, you can delete them.
Simply leaving your image sizing options in Customize > Layout > Blog will prevent them from happening.January 27, 2020 at 11:11 am #1146041Michael
Thanks for the info.January 27, 2020 at 3:34 pm #1146247TomLead DeveloperLead DeveloperFebruary 6, 2020 at 1:32 pm #1157065Fabiana
I just had the same problem. I had to delete more than 600.000 lines from the database. Looking forward to some fix. Thanks!
- You must be logged in to reply to this topic.