Pending Scheduled actions is slowing down my web
-
Hello I have more than half a million actions pending and a total of 3GB in the actionscheluder_actions table on the database
I have deleted completed actions but there were only 400 and there is still much pending and there is no failed or canceled.
So, all 3GB are from pending actions.
How can I solve this?
The page I need help with: [log in to see the link]
-
Hey @buenroger Have you queried which hook is clogging the actions? Run this CLI command to see:
wp db query "
SELECT hook, COUNT(*) AS count
FROM wp_actionscheduler_actions
WHERE status = 'pending'
GROUP BY hook
ORDER BY count DESC
LIMIT 10;"Be sure to make a backup and change the prefix if applicable.
After running this command figure out which plugin is related and deactivate it. If the actions are not important or stuck then decide what to do with them. ie delete.
If they’re necessary you could try running them
wp action-scheduler runIf you have subscriptions be very careful running this as you may double charge users. Once you get things cleaned up then reactivate the offending plugin.
Hi there!
Thank you for sharing the details about the large volume of pending actions in your action scheduler table. Having over half a million pending actions and 3GB of data is definitely unusual and can impact your site’s performance.
First, it’s important to determine which plugin or process is creating such a high volume of scheduled actions. for this you need to find the hook top responsible for the bulk of pending actions
You can check that by going to WooCommerce > Status > Scheduled Actions.In the table, look at the Hook column — this shows the name of the function or event tied to each scheduled action.
You can use the Search by hook field (top right) to filter and see how many actions are tied to each hook.
Use the filter by status dropdown (e.g.
Pending) to focus on just the large number of pending actions.
Alternatively you can run a CLI commad shared by “Stef ” in previous reponse.Once you identify the problematic hooks and their associated plugin(s), consider temporarily deactivating them to prevent further queue buildup.
Also, Use WP Crontrol or Action Scheduler Plugins, these plugins allow you to view scheduled actions and potentially identify why they are stuck in pending. If there’s a recurring hook flooding the scheduler, you can pause or delete those actions.In the meantime, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:
- System Status Report which you can find via WooCommerce > Status
- Fatal error logs (if any) under WooCommerce > Status > Logs.
Please use https://pastebin.com/ or https://gist.github.com/ and share a link to that paste in reply here. Once we have more information, we’ll be able to assist you further.
Thank you both for your detailed answers. You have given me too many ideas to start with the analysis of my problem. The problem is than the web is in a shared server and doesn´t have CLI and also, the admin is so slow that I get 500 error when I try to go WooCommerce > Status for example.
The web is an ecomm but all orders are transferred to an ERP and billed there
That way, we don´t have important data on woocommerce(or wordpress) so I think it would be possyble to truncate the whole table actionscheduler_actions without loosing any important change or transaction.
I´m right or there it is something else I don´t know and I´m not taking into account?
UPDATE: I get the SYstem Status Report:
WordPress Environment<br><br>WordPress address (URL): https://alimentacionmonserrat.com<br>Site address (URL): https://alimentacionmonserrat.com<br>WC Version: 9.8.1<br>Legacy REST API Package Version: El plugin Legacy REST API no está instalado en este sitio.<br>Action Scheduler Version: ✔ 3.9.2<br>Log Directory Writable: ✔<br>WP Version: 6.8.1<br>WP Multisite: –<br>WP Memory Limit: 1 GB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: es_ES<br>External object cache: – Server Environment<br><br>Server Info: LiteSpeed<br>PHP Version: 8.1.32<br>PHP Post Max Size: 128 MB<br>PHP Time Limit: 90<br>PHP Max Input Vars: 1000<br>cURL Version: 8.12.1<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.6.19-MariaDB<br>Max Upload Size: 40 MB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔ Database<br><br>WC Database Version: 9.8.1<br>WC Database Prefix: wpxs_<br>Tamaño total de la base de datos: 3671.30MB<br>Tamaño de los datos de la base de datos: 2246.33MB<br>Tamaño del índice de la base de datos: 1424.97MB<br>wpxs_woocommerce_sessions: Datos: 29.05MB + Índice: 0.52MB + Motor InnoDB<br>wpxs_woocommerce_api_keys: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_woocommerce_attribute_taxonomies: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_woocommerce_downloadable_product_permissions: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB<br>wpxs_woocommerce_order_items: Datos: 5.52MB + Índice: 2.52MB + Motor InnoDB<br>wpxs_woocommerce_order_itemmeta: Datos: 45.58MB + Índice: 52.16MB + Motor InnoDB<br>wpxs_woocommerce_tax_rates: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB<br>wpxs_woocommerce_tax_rate_locations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_woocommerce_shipping_zones: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_woocommerce_shipping_zone_locations: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB<br>wpxs_woocommerce_shipping_zone_methods: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_woocommerce_payment_tokens: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_woocommerce_payment_tokenmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_woocommerce_log: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_actionscheduler_actions: Datos: 1809.00MB + Índice: 1298.84MB + Motor InnoDB<br>wpxs_actionscheduler_claims: Datos: 0.16MB + Índice: 0.09MB + Motor InnoDB<br>wpxs_actionscheduler_groups: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_actionscheduler_logs: Datos: 20.55MB + Índice: 15.03MB + Motor InnoDB<br>wpxs_berocket_termmeta: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_braapf_product_stock_status_parent: Datos: 0.14MB + Índice: 0.08MB + Motor InnoDB<br>wpxs_braapf_product_variation_attributes: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB<br>wpxs_braapf_term_taxonomy_hierarchical: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB<br>wpxs_braapf_variable_attributes: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_commentmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_comments: Datos: 7.52MB + Índice: 1.88MB + Motor InnoDB<br>wpxs_duplicator_packages: Datos: 0.11MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_email_log: Datos: 246.52MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_e_events: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_e_notes: Datos: 0.02MB + Índice: 0.17MB + Motor InnoDB<br>wpxs_e_notes_users_relations: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB<br>wpxs_e_submissions: Datos: 0.05MB + Índice: 0.27MB + Motor InnoDB<br>wpxs_e_submissions_actions_log: Datos: 0.02MB + Índice: 0.11MB + Motor InnoDB<br>wpxs_e_submissions_values: Datos: 0.06MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_fs2ps_match: Datos: 0.27MB + Índice: 0.42MB + Motor InnoDB<br>wpxs_fs2ps_task: Datos: 4.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_fs2ps_task_log: Datos: 3.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_imagify_files: Datos: 0.02MB + Índice: 0.08MB + Motor InnoDB<br>wpxs_imagify_folders: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_links: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_litespeed_url: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_litespeed_url_file: Datos: 0.02MB + Índice: 0.08MB + Motor InnoDB<br>wpxs_options: Datos: 8.05MB + Índice: 1.11MB + Motor InnoDB<br>wpxs_pmxi_files: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_pmxi_hash: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_pmxi_history: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_pmxi_images: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_pmxi_imports: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_pmxi_posts: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_pmxi_templates: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_postmeta: Datos: 43.58MB + Índice: 34.91MB + Motor InnoDB<br>wpxs_posts: Datos: 4.52MB + Índice: 3.42MB + Motor InnoDB<br>wpxs_termmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_terms: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_term_relationships: Datos: 0.48MB + Índice: 0.41MB + Motor InnoDB<br>wpxs_term_taxonomy: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_usermeta: Datos: 1.50MB + Índice: 0.77MB + Motor InnoDB<br>wpxs_users: Datos: 0.06MB + Índice: 0.05MB + Motor InnoDB<br>wpxs_wc_admin_notes: Datos: 0.11MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wc_admin_note_actions: Datos: 0.09MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wc_category_lookup: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wc_customer_lookup: Datos: 0.05MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_wc_download_log: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_wc_orders: Datos: 0.02MB + Índice: 0.11MB + Motor InnoDB<br>wpxs_wc_orders_meta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_wc_order_addresses: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB<br>wpxs_wc_order_coupon_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_wc_order_operational_data: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_wc_order_product_lookup: Datos: 7.52MB + Índice: 8.06MB + Motor InnoDB<br>wpxs_wc_order_stats: Datos: 1.52MB + Índice: 0.44MB + Motor InnoDB<br>wpxs_wc_order_tax_lookup: Datos: 1.52MB + Índice: 0.66MB + Motor InnoDB<br>wpxs_wc_product_attributes_lookup: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wc_product_download_directories: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wc_product_meta_lookup: Datos: 0.48MB + Índice: 0.86MB + Motor InnoDB<br>wpxs_wc_rate_limits: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wc_reserved_stock: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wc_tax_rate_classes: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wc_webhooks: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wfauditevents: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfblockediplog: Datos: 0.14MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfblocks7: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB<br>wpxs_wfconfig: Datos: 1.33MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfcrawlers: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wffilechanges: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wffilemods: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfhits: Datos: 2.02MB + Índice: 0.28MB + Motor InnoDB<br>wpxs_wfhoover: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wfissues: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB<br>wpxs_wfknownfilelist: Datos: 0.14MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wflivetraffichuman: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wflocs: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wflogins: Datos: 0.13MB + Índice: 0.03MB + Motor InnoDB<br>wpxs_wfls_2fa_secrets: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB<br>wpxs_wfls_role_counts: Datos: 0.00MB + Índice: 0.00MB + Motor MEMORY<br>wpxs_wfls_settings: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfnotifications: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfpendingissues: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB<br>wpxs_wfreversecache: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfsecurityevents: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfsnipcache: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB<br>wpxs_wfstatus: Datos: 0.14MB + Índice: 0.13MB + Motor InnoDB<br>wpxs_wftrafficrates: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_wfwaffailures: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB<br>wpxs_woobe_history: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB<br>wpxs_woobe_history_bulk: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB Post Type Counts<br><br>attachment: 3755<br>br_product_filter: 1<br>custom_css: 1<br>elementor_library: 5<br>nav_menu_item: 6<br>page: 13<br>post: 1<br>product: 3945<br>revision: 1<br>shop_order: 5706<br>wp_font_face: 36<br>wp_font_family: 12<br>wp_global_styles: 2 Security<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (24)<br><br>Advanced Database Cleaner PRO: por Younes JFR. – 3.2.11<br>FiboSearch - AJAX Search for WooCommerce: por Equipo de FiboSearch – 1.30.0<br>Elementor Pro: por Elementor.com – 3.28.2<br>Elementor: por Elementor.com – 3.28.3<br>Email Log: por Sudar – 2.4.9<br>Fs2ps: por Carlos Fillol Sendra – 2.17.4.2402221310<br>Health Check & Troubleshooting: por La comunidad de WordPress.org – 1.7.1<br>WooCommerce Account Pages by Iconic: por Iconic – 1.7.1<br>Imagify: por Imagify Image Optimizer - Optimiza imágenes y convierte WebP y Avif – 2.2.5<br>LiteSpeed Cache: por LiteSpeed Technologies – 7.1<br>LoginPress: por LoginPress – 4.0.1<br>Order Delivery Date for WooCommerce (Lite version): por Tyche Softwares – 4.0.0<br>Mostrar IP del servidor y uso de memoria: por Apasionados<br>Apasionados del Marketing – 2.1.0<br><br>WC - APG Campo NIF/CIF/NIE: por Art Project Group – 3.2.0.1<br>Password Strength Settings for WooCommerce: por Daniel Santoro – 3.0.1<br>BEAR - Editor por lotes y gestor de productos profesional para WooCommerce: por realmag777 – 2.1.4.4<br>WooCommerce.com Update Manager: por Automattic – 1.0.3<br>WooCommerce AJAX Products Filter: por BeRocket – 3.1.3<br>WooCommerce Extended Coupon Features FREE: por Soft79 – 3.3.8<br>WooCommerce Checkout Manager: por QuadLayers – 7.7.0<br>WooCommerce Product Table: por Barn2 Plugins – 3.0.1<br>WooCommerce Sequential Order Numbers Pro: por SkyVerge – 1.21.4<br>WooCommerce: por Automattic – 9.8.1 (la actualización a la versión 9.8.5 está disponible)<br>Wordfence Security: por Wordfence – 8.0.5 Inactive Plugins (4)<br><br>Database Cleaner: por Jordy Meow – 1.2.2<br>Duplicator: por Duplicator – 1.5.12<br>Import and export users and customers: por codection – 1.28.6<br>MainWP Child: por MainWP – 5.4.0.6 Must Use Plugins (1)<br><br>Health Check Troubleshooting Mode: por – 1.9.1 Settings<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: EUR (€)<br>Currency Position: right<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: ✔<br>Enforce Approved Product Download Directories: ✔<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 días<br>Level threshold: –<br>Log directory size: 2 MB WC Pages<br><br>Base de la tienda: #6 - /tienda/<br>Carrito: #7 - /carrito/ - Contiene el shortcode woocommerce_cart<br>Finalizar compra: #8 - /finalizar-compra/ - Contiene el shortcode woocommerce_checkout<br>Mi cuenta: #9 - /mi-cuenta/ - Contiene el shortcode [woocommerce_my_account]<br>Términos y condiciones: #5077 - /aviso-legal/ Theme<br><br>Name: Astra Child<br>Version: 1.0.0<br>Author URL: http://wpastra.com/about/<br>Child Theme: ✔<br>Parent Theme Name: Astra<br>Parent Theme Version: 4.10.0 – 4.11.0 está disponible<br>Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme<br>Theme type: Tema clásico<br>WooCommerce Support: ✔ Templates<br><br>Overrides: – Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br>add-to-cart-with-options-stepper-layout<br><br>Disabled Features: product-data-views<br>experimental-blocks<br>coming-soon-newsletter-template<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>use-wp-horizon<br>blockified-add-to-cart<br><br>Daily Cron: ✔ Next scheduled: 2025-05-13 09:06:47 +02:00<br>Options: ✔<br>Notes: 179<br>Onboarding: skipped Action Scheduler<br><br>Completo: 1.178<br>Oldest: 2025-05-09 08:58:02 +0200<br>Newest: 2025-05-13 09:36:40 +0200<br><br>Pendiente: 6.152.263<br>Oldest: 2025-04-15 20:05:17 +0200<br>Newest: 2025-05-13 09:35:42 +0200<br><br>En curso: 1<br>Oldest: –<br>Newest: –<br><br>Fallida: 129<br>Oldest: 2025-05-12 17:17:05 +0200<br>Newest: 2025-05-13 09:31:19 +0200 Status report information<br><br>Generated at: 2025-05-13 09:37:09 +02:00<br>Hello Roger Montero,
Thank you for your reply.
I understand your site may be facing performance limitations, which can happen on shared hosting due to limited and shared resources. It might be worth considering a move to a more robust hosting provider that better suits your website’s needs.
You mentioned that all orders are transferred to your ERP system and processed there. Could you please share how this integration is set up? Specifically, does it rely on scheduled actions?
To help me look into this further, please share screenshots of your Scheduled Actions page as well as the WP Crontrol plugin’s page. You may use https://snipboard.io to upload images and share links here.
Once I have that information, I’ll be better equipped to assist you. 🙂
Scheduler actions page throws a 500 error when i try to see it but here you hace crontrol page, which I have been able to install https://snipboard.io/17OZdx.jpg
And finally I could access to my phpmyadmin table wp_actionscheduler_actions and there I have deleted completed, failed and canceled.
-
This reply was modified 1 year, 3 months ago by
Roger Montero.
every action pending is like this: wc_delete_related_product_transients_async
Hi @buenroger, being on a shared environment has nothing to do with CLI access. Most hosts allow it, even on shared plans. Who are you hosted with?
Thanks for the SSR — the issue likely comes from one of these 3 plugins:
• WP All Import (PMXI)
• Fs2ps
• BEAR (bulk editor)Since you don’t have access to CLI but do have phpMyAdmin, you can run this SQL query to clear the backlog:
DELETE FROM wpxs_actionscheduler_actions
WHERE hook = 'wc_delete_related_product_transients_async'
AND status = 'pending';Be sure to make prefix changes if applicable.
To prevent this from recurring, I recommend creating a must-use (MU) plugin with the following code. You can name the file whatever you want:
<?php
add_filter('action_scheduler_before_enqueue_hook', function ($maybe_hook, $hook) {
if ($hook === 'wc_delete_related_product_transients_async') {
return false;
}
return $maybe_hook;
}, 10, 2);You can drop this into functions.php, but using an MU plugin is more reliable since it always loads regardless of theme changes.
Lastly, be sure to update to the latest version of WooCommerce. You’re currently on 9.8.1, which is known to have a bug that floods the queue with transient deletion actions.
What is this hook related to: woocommerce_run_product_attribute_lookup_update_callback?
It seems it´s another one with many pending actions…
Hi again @buenroger
Totally fair to look at that second hook, but let’s stick to proper procedure before jumping into something else.
Step one is making sure the first issue is cleaned up:
• Did you run the SQL I shared?
• And did you add the MU plugin to stop new actions from piling up?Once that’s confirmed and the queue is reduced, we can move on to that other hook. Otherwise, you’ll just be chasing symptoms without fixing the root issue.
I do run the sql and I add the filter to the functions.php on my child theme.
The queue is now clean and i can visit every page on my admin without 500 errors
Great, good to hear @buenroger – glad to hear the queue is cleared and the admin’s working again.
I’d still recommend moving that filter from functions.php to the MU plugin folder. That way it runs no matter what theme is active and ensures long-term stability. If you don’t have an MU folder create one “mu-plugins”.
After that, keep an eye on whether the queue starts growing again. If it does, or if you see other hooks like
woocommerce_run_product_attribute_lookup_update_callbackstacking up, we can look into those next, but only if they actually become a problem.Hello Roger Montero,
Thank you for your reply.
The queue is now clean and i can visit every page on my admin without 500 errors
I appreciate Stef for his helpful contribution to the forums and for supporting a fellow WooCommerce user.
If you need any further assistance, please don’t hesitate to reach out. I’ll be happy to help!
Best regards.
I’m actually a former core engineer @doublezed2 when the plugin first started. I’m not a user. I’m retired now.
I have checked again and wpxs_actionscheduler_actions table is not growing anymore (63 MB for now)
I have a license for WP DB Cleaner but I also learn about WP Crontrol and a bunch of useful sql queries like yours and other like DELETE FROM
wp_actionscheduler_actionsWHEREstatus= ‘failed’ which I can use also for “canceled” or “complete” or even for “pending” If I first detect wich hook is hanging my site.I will investigate further about CLI and about how to make a mu-plugin but for now I want you to know appreciate your help so much. I´m marking as resolved.
The topic ‘Pending Scheduled actions is slowing down my web’ is closed to new replies.
