Hugopvigo

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Forum: Plugins
    In reply to: [WooCommerce] Huge number of Pending and Past Due Scheduled Actions
    Thread Starter Hugopvigo

    (@hugosuop)

    1 year, 1 month ago

    Hello @doublezed2 !

    Thanks for reply.

    My System Status report is here: https://pastebin.com/hvM0vUEB

    Now i’m running in crontab
    */4 * * * * /usr/local/bin/wp cron event run --due-now --path=/var/www/html/wordpress >> /var/log/wp-system-cron.log 2>&1

    To prevent processes from getting stuck without running, but also to avoid overloading the server. Now CPU usage is like a charm, whereas before it was constantly at 50/60% with 6 CPUs.

    And the cron log seems to be working:

    tail -f /var/log/wp-system-cron.log
Executed the cron event 'action_scheduler_run_queue' in 0.032s.
Success: Executed a total of 1 cron event.
Executed the cron event 'jetpack_sync_cron' in 0.017s.
Executed the cron event 'jetpack_sync_full_cron' in 0.012s.
Executed the cron event 'action_scheduler_run_queue' in 0.028s.
Success: Executed a total of 3 cron events.
Executed the cron event 'action_scheduler_run_queue' in 0.035s.
Executed the cron event 'jetpack_sync_cron' in 0.022s.
Executed the cron event 'jetpack_sync_full_cron' in 0.026s.
Success: Executed a total of 3 cron events.
Executed the cron event 'action_scheduler_run_queue' in 0.032s.
Executed the cron event 'jetpack_sync_cron' in 0.027s.
Executed the cron event 'jetpack_sync_full_cron' in 0.015s.
Executed the cron event 'wp_privacy_delete_old_export_files' in 0.014s.
Success: Executed a total of 4 cron events.

    Any other recommendations or suggestions? The truth is, going from having tens of thousands of tasks to what it is now makes me think something wasn’t right with the processes or the management of product attributes, or some plugin was affecting it.

    Thanks!”

    Forum: Plugins
    In reply to: [WooCommerce] Huge number of Pending and Past Due Scheduled Actions
    Thread Starter Hugopvigo

    (@hugosuop)

    1 year, 1 month ago

    Hi again,


    After disabling:
    define('DISABLE_WP_CRON', true);

    And remove the stuck actions
    wp db query "
    1956 UPDATE wp_actionscheduler_actions
    1957 SET status = 'failed'
    1958 WHERE status = 'in-progress'
    1959 AND scheduled_date_gmt < (UTC_TIMESTAMP() - INTERVAL 30 MINUTE);
    1960 " --path=/var/www/html/wordpress

    And run the system cron tasks, works fine and the performance of the server is better. No high CPU usage peaks.”

    Data store: ActionScheduler_DBStore
    Runner: ActionScheduler_QueueRunner
    Version: 3.9.2
    +———-+——–+—————————+—————————+
    | status | count | oldest | newest |
    +———-+——–+—————————+—————————+
    | canceled | 85 | 2025-04-17 11:11:43 +0200 | 2025-04-17 11:11:43 +0200 |
    | complete | 136725 | 2025-04-16 05:14:37 +0200 | 2025-04-17 10:43:35 +0200 |
    | failed | 20 | 2025-04-15 18:02:51 +0200 | 2025-04-16 22:44:38 +0200 |
    | pending | 9 | 2025-04-17 12:59:56 +0200 | 2025-05-01 13:00:00 +0200 |
    +———-+——–+—————————+—————————+

    Should we keep the function?
    define('DISABLE_WP_CRON', true);

    Best!

    Forum: Plugins
    In reply to: [WooCommerce] Huge number of Pending and Past Due Scheduled Actions
    Thread Starter Hugopvigo

    (@hugosuop)

    1 year, 1 month ago

    wp action-scheduler status
    Data store: ActionScheduler_DBStore
    Runner: ActionScheduler_QueueRunner
    Version: 3.9.2
    +————-+——–+—————————+—————————+
    | status | count | oldest | newest |
    +————-+——–+—————————+—————————+
    | canceled | 70 | 2025-04-17 01:30:18 +0200 | 2025-04-17 01:30:18 +0200 |
    | complete | 125987 | 2025-04-16 05:14:37 +0200 | 2025-04-17 01:29:33 +0200 |
    | failed | 18 | 2025-04-15 18:02:51 +0200 | 2025-04-16 22:44:38 +0200 |
    | in-progress | 1 | – | – |
    | pending | 10732 | 2025-04-16 22:45:58 +0200 | 2025-05-01 13:00:00 +0200 |
    +————-+——–+—————————+—————————+

Viewing 3 replies - 1 through 3 (of 3 total)