Roger Montero

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_actions WHERE status = ‘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.

What is this hook related to: woocommerce_run_product_attribute_lookup_update_callback?

It seems it´s another one with many pending actions…

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 ago by Roger Montero.

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 ww.wp.xz.cn – 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>

y el resto de datos que pide son los de la pasarela o bizum hay que solicitarlo aparte?

?wc-api=WC_Gateway_redsys

En Woocommerce aparece como pagado con Redsys y en canales aparece como Tipo de pago Bozum

Si, la notificacion HTTP va a nuestra url y yono he configurado Bizum porque ni siquiera sabia que se podia en el Lite y el cliente no lo habia activado en su movil tmpoco al ser una cuenta nueva (era del banco con el logotipo de Miro y ahora es de otro) por se un cambio reciente

Thank you for your answer @macmanx

I have resaved permalinks several times (as this is the usual troubleshooting) .

I have been troubleshotting this issue with Elementor Support and Astra support I have even change the builder from Elementor to Spectra and after all troubleshooting it seems is related with my permalinks structure.

I have a personalized estructure which is /blog/%category%/%postname% and it is working fine as spected. Everything is ok except for the author page.

I don´t want to roll back to a default permalink structure because /blog/%category%/%postname% is the structure I want for segmenting