Hundreds of thousands of entries in wp_actionscheduler_logs

  • Hi,
    I just moved a wordpress site to a different address, and had a problem when importing the database. Always the same wp_actionscheduler_logs duplicate entry ‘0’ for key ‘primary’. I tried older backups, doesn’t matter, always same error.
    The only solution I found was run a REPAIR TABLE wp_actionscheduler_logs
    But now I find it’s creating hundreds of thousands of entries in a few hours. 80Mb of data for wp_actionscheduler_logs alone!
    How, where can I fix it? It’s slowing the site to a crawl.
    I’m on Woocmmerce’s latest version, 4.5.2
    Thanks in advance
    PS: in the time it took to wrote this message, 13,258 new rows were created

    • This topic was modified 4 years, 6 months ago by wagedu.
    • This topic was modified 4 years, 6 months ago by wagedu.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter wagedu

    (@wagedu)

    Next step, looks like a temporary fix:
    I found 9 entries, all of them completed, in “Woocommerce > Status > Scheduled Actions”
    Each one of them with “Registry” as “ignored by WP Cron” times a thousand or more.
    An example one would be:
    Hook: wpforms_admin_notifications_update
    Status: complete
    Arguments: ‘task_meta_id’ => 2
    Group: wpforms
    Non recurrent
    Scheduled Date: 0000-00-00 00:00:00 (I thought that’s weird)
    Registry: over a thousand entries, every 50 or so with exactly the same time, all of them “Ignored by WP Cron”
    ==
    After deleting all 9 COMPLETED tasks, no new rows are created in my database.

    So… where’s the problem then? I mean, that “Scheduled date” full of zeroes, can be linked to the failed action_scheduler_log Table import in the database.
    But all exported databases give the same problem when re-importing, and always on the same table: action_scheduler_log
    Indexes for table ‘wp_actionschedule_log’ Duplicate entry key ‘0’ for key Primary.
    I mean, I’ve even tried to export a database, then drop all its tables, then re-import to itself. Always same error.

    Any ideas? Hopefully it helps someone else having the same problem, as I’ve seen many threads touching on it

    shaan27491

    (@shaan27491)

    Got the same error:
    thousands of entries in wp_actionscheduler_logs

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Hundreds of thousands of entries in wp_actionscheduler_logs’ is closed to new replies.