- This topic has 13 replies, 2 voices, and was last updated 4 months, 2 weeks ago by Dan.
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!July 18, 2021 at 9:17 am #1860109Benjamin
Same issue. Can someone provide the SQL to delete these? Literally have hundreds of thousands of entries!July 18, 2021 at 9:51 am #1860124Benjamin
Hi Dan, how did you delete them? I’m guessing not manually. SQL statement? Would you be willing to share?July 18, 2021 at 10:07 am #1860131Dan
No guarantees that this will work. So, use at your own risk. If you aren’t familiar with SQL, you might also use a plugin like WP Data Access to query your database and delete records. Back up your database before you do any of this.
First, determine how many offending records are in your database using something like:
SELECT COUNT(*) FROM wp_options WHERE option_name LIKE ‘%wp_image_processing%’
To delete the offending records, I think I used something like below. I seem to remember having trouble deleting using wp_image_processing_queue_batch, so I think I used the more general wp_image_processing as above.
DELETE FROM wp_options WHERE option_name LIKE '%wp_image_processing_queue_batch%’
Hope it helps.
- You must be logged in to reply to this topic.