Stuck for 7 days “WooCommerce is updating the database in the background”

  • Resolved hdaackda

    (@hdaackda)


    9 months, 1 week ago

    Updated Woocommerce version to 8.6.1 (WordPress 6.4.3) and it asked me to update Woocommerce database.

    I clicked it but its been a week and its still stuck

    When I go to “View Progress”, this is what I see

    “woocommerce_run_update_callback

    Pending

    • 'update_callback' => 'wc_update_860_remove_recommended_marketing_plugins_transient'

    “woocommerce-db-updates Non-repeating”

    I’ve tried manually running it but then I get the message again asking me to update WooCommerce database. I’ve looked at older solutions, tried clearing cache, transients etc, but that didn’t help.
    Also the sales value are stuck on main dashboard (total figure is not getting updated)

    If I go to WordPress -> System Status -> Logs and see “Fatal Errors”, this is what I see:

    “

    Critical Uncaught InvalidArgumentException: Unidentified action 2671093 in /wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:1085 Additional context{ “error”: { “type”: 1, “file”: “\/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/data-stores\/ActionScheduler_DBStore.php”, “line”: 1085 }, “backtrace”: [ “”, “#0 \/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/data-stores\/ActionScheduler_HybridStore.php(305): ActionScheduler_DBStore->mark_failure()”, “#1 \/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/abstracts\/ActionScheduler_Abstract_QueueRunner.php(120): ActionScheduler_HybridStore->mark_failure()”, “#2 \/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/abstracts\/ActionScheduler_Abstract_QueueRunner.php(98): ActionScheduler_Abstract_QueueRunner->handle_action_error()”, “#3 \/wp-content\/plugins\/woocommerce\/packages\/action-scheduler\/classes\/ActionScheduler_QueueRunner.php(169): ActionScheduler_Abstract_QueueRunner->process_action()”, “#4 \/home\/dada” ] }

    On further inspection, there may be an issue with Action Scheduler.. Get this message “Action Scheduler migration in progress. The list of scheduled actions may be incomplete.”

    Just checked, pending actions are over 200,000!! What do I do??

    Please help ??

    • This topic was modified 9 months, 1 week ago by hdaackda. Reason: further checking
Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter hdaackda

    (@hdaackda)

    “Action Scheduler: 294821 past-due actions found; something may be wrong.”

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @hdaackda,

    These pending actions are cron jobs that use WordPress WP-Cron to function. However, sometimes server issues might prevent these cron jobs from executing properly.

    To fix WP-Cron and pending action scheduler related issues, you can follow the detailed guide shared here: https://woo.com/document/subscriptions/develop/complete-guide-to-scheduled-events-with-subscriptions/#section-4

    You can also run a conflict test to help you identify the cause of the issue. More info: https://woo.com/document/how-to-test-for-conflicts/

    Let us know how that goes for you.

    Thread Starter hdaackda

    (@hdaackda)

    @shameemreza thanks, figured it out, marking this as resolved. Issue was created by Woo Square plugin 4.5.0. It was creating hundreds of requests every second on a loop so it was clogging the requests. They have apparently now fixed the plugin, so do update to 4.5.1

    I also deleted all the pending requests from that plugin’s hook “wc_square_init_payment_token_migration” from the database using SQL (literally over half a million) and then woocommerce database got updated.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Stuck for 7 days “WooCommerce is updating the database in the background”’ is closed to new replies.