Huge Action Scheduler tables

  • Hello,

    I’ve found that site database has grown up to 2GB
    and most the size is coming from tables:
    1. fc1_actionscheduler_actions – 777,8MB, 1788299 rows
    2. fc1_actionscheduler_logs – 800,1 MB, 6038759 rows

    Most of this count is for the hook: adjust_download_permissions – 1769975

    How to fix this?

Viewing 2 replies - 16 through 17 (of 17 total)

  • I have commented out lines 269:272 from woocommerce\includes\data-stores\class-wc-product-data-store-cpt.php

    /*wc_get_container()
    ->get( DownloadPermissionsAdjuster::class )
    ->maybe_schedule_adjust_download_permissions( $product );
*/

    It looks like this solves my issue of action scheduler adjust_download_permissions infinite loop. Our store doesn’t use downloadable products, but I will have to thoroughly test it nonetheless. This is a risky solution, but a necessary one, because of the extreme load on the server it caused.

    @juregolob

    Kindly open your own thread as this will help us diagnose the issue based on your own server/environment setup. See the link below to do that:
    https://www.ads-software.com/support/plugin/woocommerce/#new-topic-0

Viewing 2 replies - 16 through 17 (of 17 total)
  • The topic ‘Huge Action Scheduler tables’ is closed to new replies.