Plugin creates cron tasks (wp_options table)

  • Resolved sirderpington

    (@sirderpington)


    7 years, 4 months ago

    Hi,

    we were facing an issue due to which the table row with the option_name column = “cron” in the wp_options table got polluted with more and more tasks of the HugeIT Gallery plugin.

    The tasks look like this example.

    { [1499087223]=> array(1) { [“hugeit_image-gallery_opt_in_cron”]=> array(1) { [“40cd750bba9870f18aada2478b24840a”]=> array(3) { [“schedule”]=> string(27) “hugeit-image-gallery-weekly” [“args”]=> array(0) { } [“interval”]=> int(604800) } } } [1499087227]=> array(1) { [“hugeit_image-gallery_opt_in_cron”]=> array(1) { [“40cd750bba9870f18aada2478b24840a”]=> array(3) { [“schedule”]=> string(27) “hugeit-image-gallery-weekly” [“args”]=> array(0) { } [“interval”]=> int(604800) } } }

    We have no idea why they’re there and won’t stop getting added. It seems like every time _set_cron_array($crons) gets called in the cron.php of WordPress there is a new entry of your plugin in the serialized array.

    The issue however gets resolved as soon as we deactive the plugin (v.2.2.2)

    Is there any clue you might have to solve this issue?
    It pretty much came out of nowhere.

Viewing 15 replies - 16 through 30 (of 31 total)

  • JosephSB,

    For now, apply the patch by harrison. It completely fixes the problem.

    • This reply was modified 7 years, 4 months ago by feldon30.

    Dear feldon30,

    Is everything working fine now? Is the issue fixed or we can help you somehow?
    If you need our assistance, we will be happy to help.

    Thanks

    @feldon30 – For some reason it does not completely fix the problem. It does somewhat but I’m still seeing higher than usual CPU usage (compared to the period before the update) which is weird so I had to disable the plugin.
    I still cant wrap my head around how they did not issue an emergency update since this is a BIG problem.

    Dear josephsb

    We are sorry for inconveniences you have faced.
    Let me kindly mention that the release with a bug fix will be available within 24 hours but if your case is very urgent, we will be happy to provide the link for downloading the fixed version if you contact us directly via our Contact Us page or LiveChat.

    We will wait for your replies
    Thanks in advance

    What a mess! A client’s site was taken down because of this plugin. I deleted the plugin this morning, and it was still making queries when the site came back up. So the host took it down again.

    How do I stop the zombie queries?

    And why has it taken two weeks to fix it? I don’t know what triggered it for me only a couple of days ago. I’ve had the plugin for months.

    But my host threatened to suspend my account because I couldn’t figure out what was querying the server even after I deleted the plugin.

    Thread Starter sirderpington

    (@sirderpington)

    If you’re still having troubles even after removing or deactivating the plugin, you might want to try this query:

    UPDATE wp_options 
SET option_value = ""
WHERE option_name = "cron"

    The option_name “cron” row in the wp_options table is the row that should cause your page to slow down so massively because it was spammed by the plugin.
    No guarantee but it definitely helped me.

    Thanks, @siderpington. I’ll give it a try.

    Thread Starter sirderpington

    (@sirderpington)

    @roamingchile You might wanna backup that row, just to be sure

    @sirderpington, thank you! The webhost has put the site back up. Client will be happy, and I am relieved.

    Dear josephsb, feldon30, lapinservices, harrisonsmith, sirderpington, Christian Rüggeberg

    I am glad to inform that we have released the new update where the issue with cron jobs is fixed. Please update your Image Gallery plugin to the latest version available in WordPress. If the cron codes still exist after the update, please delete them manually or contact us and we will be happy to help. Let me kindly mention that after deleting the codes the problem will not appear again.

    We apologize for the issues you have faced
    We will wait for your feedbacks.
    Thanks in advance

    Hello all,

    This thread is very much unresolved – can someone pease mark it as such. Every one of our sites has crashed do to this same issue – HUGE IT producing thousands of cron logs which eventually crashed our server.

    After spending a very large amount of time with our host we were able to recover the sites, however there are still thousand of “cron” logs in our databases that were not removed by following HUGE IT instructions (install updated plugin)

    This has already cost our business an enormous amount of time to fix – and it’s crucial that we get a fix from HUGE IT immediately.

    Failure by HUGE-IT to produce a fix here will force our team to look into legal options to recover lost time and money, along with the additional development resources we will need to clean our servers.

    Dear maxbatt,

    Please be kindly informed that the issue with the cron jobs has been resolved in the latest 2.2.5 version of the plugin.
    If you have updated the plugin to the latest version and still have issues, please, contact us directly and we will be glad to have a look and try to find out what was gone wrong.

    We will wait for your results.
    Thanks

    This is simply untrue – the issue is not resolved.

    Version 2.2.5 does stop the plugin from spamming the server, but it does not address the previous cron records that we cannot remove from our database. Over 60 thousand entries!

    We really need a tool (or method) for removing these records.

    Thread Starter sirderpington

    (@sirderpington)

    @maxbatt

    UPDATE wp_options 
SET option_value = ""
WHERE option_name = "cron"

    Try this statement on your database. You might want to create a backup before though. It basically deletes all the entries created by the plugin.

Viewing 15 replies - 16 through 30 (of 31 total)
  • The topic ‘Plugin creates cron tasks (wp_options table)’ is closed to new replies.