Table wp_actionscheduler_actions can’t stop growing
-
Hi everyone!
I’m having some strange issue since I upgraded to version 4.0.1. My table wp_actionscheduler_actions can’t stop growing. There are more than a million records. Every second a new record is added, always with [“wc_admin_update_0251_db_version”] or [“wc_admin_update_0251_remove_unsnooze_action”] value in column args. What is wrong?
-
Hi there. It sounds like something is causing one of the WC Admin actions to get stuck in a loop. Do you have any fatal errors in your fatal error logs (WooCommerce > Status > Logs)?
Also can you post your system status report? You can find that by going to WooCommerce > Status in your dashboard, then clicking “Get system report,” then “Copy for support.”
Hi Austin.
Thanks for your response.
looking in Status > Logs, I have some messages like below:2020-04-14T14:22:54+00:00 CRITICAL Uncaught RuntimeException: Incapaz de reivindicar a??es. Erro no banco de dados. in /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:675 Stack trace: #0 /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(599): ActionScheduler_DBStore->claim_actions(90139, 25, NULL, Array, '') #1 /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(206): ActionScheduler_DBStore->stake_claim(25, NULL, Array, '') #2 /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_HybridStore->stake_claim(25) #3 /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/pack, em /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php, na linha 675 2020-04-14T16:20:04+00:00 CRITICAL Uncaught InvalidArgumentException: A??o 26 n?o identificada in /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php:495 Stack trace: #0 /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php(482): ActionScheduler_wpPostStore->get_date_gmt('26') #1 /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(274): ActionScheduler_wpPostStore->get_date('26') #2 /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(78): ActionScheduler_HybridStore->get_date('26') #3 /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionSchedule, em /home/222535.cloudwaysapps.com/wmwmqusqsy/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_wpPostStore.php, na linha 495
Status report is the following:
### WordPress Environment ### WordPress address (URL): https://www.hauseafins.com.br Site address (URL): https://www.hauseafins.com.br WC Version: 4.0.1 REST API Version: ? 1.0.7 WC Blocks Version: ? 2.5.14 Action Scheduler Version: ? 3.1.4 WC Admin Version: ? 1.0.3 Log Directory Writable: ? WP Version: 5.4 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: ? Language: pt_BR External object cache: – ### Server Environment ### Server Info: Apache/2.4.10 (Debian) PHP Version: 7.2.29-1+0~20200320.39+debian8~1.gbp513c2e PHP Post Max Size: 256 MB PHP Time Limit: 900 PHP Max Input Vars: 2500 cURL Version: 7.38.0 OpenSSL/1.0.1t SUHOSIN Installed: – MySQL Version: 5.5.5-10.2.31-MariaDB-10.2.31+maria~jessie-log Max Upload Size: 256 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 3.9.3 WC Database Prefix: wp_ Tamanho total do banco de dados: 861.97MB Tamanho dos dados do banco de dados: 706.56MB Tamanho do índice do banco de dado: 155.41MB wp_woocommerce_sessions: Dados: 29.06MB + índex: 1.02MB + mecanismo InnoDB wp_woocommerce_api_keys: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_woocommerce_attribute_taxonomies: Dados: 0.11MB + índex: 0.05MB + mecanismo InnoDB wp_woocommerce_downloadable_product_permissions: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB wp_woocommerce_order_items: Dados: 2.52MB + índex: 0.42MB + mecanismo InnoDB wp_woocommerce_order_itemmeta: Dados: 9.52MB + índex: 8.03MB + mecanismo InnoDB wp_woocommerce_tax_rates: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB wp_woocommerce_tax_rate_locations: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_woocommerce_shipping_zones: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_woocommerce_shipping_zone_locations: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_woocommerce_shipping_zone_methods: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_woocommerce_payment_tokens: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_woocommerce_payment_tokenmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_woocommerce_log: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB HA_hub2b_error_log: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_hub2b_order: Dados: 0.08MB + índex: 0.00MB + mecanismo InnoDB HA_hub2b_order_items: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_manufacturing_time: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_product: Dados: 2.52MB + índex: 0.00MB + mecanismo InnoDB HA_shipping_method_default_rates: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_skyhub_error_log: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_skyhub_order: Dados: 9.52MB + índex: 0.00MB + mecanismo InnoDB HA_skyhub_order_items: Dados: 1.52MB + índex: 0.00MB + mecanismo InnoDB HA_skyhub_send_product: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_skyhub_update_name: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_skyhub_update_price: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_skyhub_update_status: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB HA_skyhub_update_stock: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_actionscheduler_actions: Dados: 28.56MB + índex: 23.56MB + mecanismo InnoDB wp_actionscheduler_claims: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_actionscheduler_groups: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_actionscheduler_logs: Dados: 6.52MB + índex: 5.03MB + mecanismo InnoDB wp_blogmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_commentmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_comments: Dados: 7.52MB + índex: 8.09MB + mecanismo InnoDB wp_correios_postcodes: Dados: 0.05MB + índex: 0.02MB + mecanismo InnoDB wp_links: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_mailchimp_carts: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_mailchimp_jobs: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_options: Dados: 360.34MB + índex: 6.22MB + mecanismo InnoDB wp_postmeta: Dados: 184.72MB + índex: 78.25MB + mecanismo InnoDB wp_posts: Dados: 21.55MB + índex: 10.00MB + mecanismo InnoDB wp_revslider_css: Dados: 0.13MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_css_bkp: Dados: 0.13MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_layer_animations: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_layer_animations_bkp: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_navigations: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_navigations_bkp: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_sliders: Dados: 1.52MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_sliders_bkp: Dados: 1.50MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_slides: Dados: 6.52MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_slides_bkp: Dados: 9.52MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_static_slides: Dados: 0.05MB + índex: 0.00MB + mecanismo InnoDB wp_revslider_static_slides_bkp: Dados: 0.05MB + índex: 0.00MB + mecanismo InnoDB wp_sfa_abandoned_carts: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_termmeta: Dados: 2.25MB + índex: 3.03MB + mecanismo InnoDB wp_terms: Dados: 1.52MB + índex: 0.58MB + mecanismo InnoDB wp_term_relationships: Dados: 6.52MB + índex: 3.52MB + mecanismo InnoDB wp_term_taxonomy: Dados: 1.52MB + índex: 2.02MB + mecanismo InnoDB wp_tm_taskmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_tm_tasks: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_usermeta: Dados: 3.52MB + índex: 2.95MB + mecanismo InnoDB wp_users: Dados: 0.17MB + índex: 0.20MB + mecanismo InnoDB wp_wcmps_cf: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_wcmps_queue: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_wcmps_relationships: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_wc_admin_notes: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_wc_admin_note_actions: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_wc_category_lookup: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB wp_wc_customer_lookup: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_wc_download_log: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_wc_gpf_render_cache: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_wc_order_coupon_lookup: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_wc_order_product_lookup: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB wp_wc_order_stats: Dados: 0.02MB + índex: 0.05MB + mecanismo InnoDB wp_wc_order_tax_lookup: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB wp_wc_product_meta_lookup: Dados: 1.52MB + índex: 1.45MB + mecanismo InnoDB wp_wc_tax_rate_classes: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_wc_webhooks: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_woocommerce_gpf_google_taxonomy: Dados: 2.02MB + índex: 0.00MB + mecanismo InnoDB wp_woodmart_wishlists: Dados: 0.05MB + índex: 0.00MB + mecanismo InnoDB wp_woodmart_wishlist_products: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_yith_wcwl: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB wp_yith_wcwl_lists: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB wp_yoast_seo_links: Dados: 0.38MB + índex: 0.09MB + mecanismo InnoDB wp_yoast_seo_meta: Dados: 2.52MB + índex: 0.00MB + mecanismo InnoDB ### Post Type Counts ### attachment: 23569 br_minmax_limitation: 1 cms_block: 49 custom-css-js: 1 custom_css: 1 elementor_library: 11 es_template: 2 flamingo_contact: 1169 flamingo_inbound: 17 gfw_report: 1 mc4wp-form: 1 ml-slide: 15 ml-slider: 8 nav_menu_item: 48 oembed_cache: 234 page: 48 portfolio: 9 portfolio-item: 5 post: 52 product: 7510 product_variation: 85 shop_coupon: 2498 shop_order: 9009 shop_order_refund: 5 sptemplates: 3 sp_settings: 1 sp_template: 2 tablepress_table: 7 testimonials: 3 woocarousel: 1 woodmart_sidebar: 2 woodmart_slide: 22 woo_discount: 1 wpcf7_contact_form: 5 ywdpd_discount: 2 ywrac_cart: 126 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (38) ### Redux Framework: por Team Redux – 3.6.18 Smarthint - Smart Recommendations: por WooCommerce – 1.0.5 – N?o testado com a vers?o ativa do WooCommerce Admin Menu Editor: por Janis Elsts – 1.9.5 Advanced noCaptcha & invisible Captcha: por Shamim Hasan – 5.6 – N?o testado com a vers?o ativa do WooCommerce Breeze: por Cloudways – 1.1.5 Contact Form 7: por Takayuki Miyoshi – 5.1.7 VVAme chat: por Creame – 3.2.2 Custom Order Status for WooCommerce: por Tyche Softwares – 1.4.9 Duplicate Page: por mndpsingh287 – 4.2 Google Tag Manager for WordPress: por Thomas Geiger – 1.11.4 Elementor: por Elementor.com – 2.9.7 Facebook for WooCommerce: por Facebook – 1.10.2 Flamingo: por Takayuki Miyoshi – 2.1.1 Google Analytics Dashboard for WP (GADWP): por ExactMetrics – 6.0.2 Google XML Sitemaps: por Arne Brachhold – 4.1.0 WPBakery Page Builder: por Michael M - WPBakery.com – 6.1 Tradu??o (Loco): por Tim Whitlock – 2.3.2 Multiple Packages for WooCommerce: por Erica Dion – 1.1 – N?o testado com a vers?o ativa do WooCommerce My Custom Functions: por Space X-Chimp – 4.42 Post/Page specific custom CSS: por ?ukasz Nowicki – 0.2.0 Quantities and Units for WooCommerce: por Nicholas Verwymeren – 1.0.13 – N?o testado com a vers?o ativa do WooCommerce Slider Revolution: por ThemePunch – 6.1.8 Safe SVG: por Daryll Doyle – 1.9.8 ShortPixel Image Optimizer: por ShortPixel – 4.17.1 Page Builder da SiteOrigin: por SiteOrigin – 2.10.15 WooCommerce Dynamic Pricing & Discounts: por RightPress – 2.3.3 – N?o testado com a vers?o ativa do WooCommerce WC Simulador de Frete: por Fernando Acosta – 1.6.7 – N?o testado com a vers?o ativa do WooCommerce WooCommerce API Product Sync with Multiple Stores: por Obtain Infotech – 1.6.0 – N?o testado com a vers?o ativa do WooCommerce Claudio Sanches - Correios for WooCommerce: por Claudio Sanches – 3.8.0 – N?o testado com a vers?o ativa do WooCommerce Brazilian Market on WooCommerce: por Claudio Sanches – 3.7.2 – N?o testado com a vers?o ativa do WooCommerce Claudio Sanches - PagSeguro for WooCommerce: por Claudio Sanches – 2.14.0 – N?o testado com a vers?o ativa do WooCommerce WooCommerce Google Product Feed: por Ademti Software Ltd. – 7.7.0 – 8.1.0 está disponível – N?o testado com a vers?o ativa do WooCommerce WooCommerce Haus Custom Shipping Method: por Julio Cesar Machado – 1.0.0 – N?o testado com a vers?o ativa do WooCommerce WooCommerce: por Automattic – 4.0.1 Woodmart Core: por – 1.0.21 Yoast SEO: por Equipe da Yoast – 13.4.1 WP-Optimize - Clean, Compress, Cache: por David Anderson Ruhani Rabin Team Updraft – 3.0.19 WPB Product Slider for WooCommerce: por wpbean – 2.0.8.4 ### Inactive Plugins (14) ### Classic Editor: por WordPress Contributors – 1.5 Image optimization service by Optimole: por Optimole – 2.3.0 JWT Authentication for WP-API: por Enrique Chavez – 1.2.6 Mailchimp for WooCommerce: por Mailchimp – 2.3.6 Redis Object Cache: por Till Krüss – 1.5.7 Simulador de Parcelas - Taxas avan?adas: por Fernando Acosta – 1.0.1 – N?o testado com a vers?o ativa do WooCommerce SiteOrigin Widgets Bundle: por SiteOrigin – 1.16.0 User Role Editor: por Vladimir Garagulya – 4.53.1 WC Simulador de parcelas e descontos: por Fernando Acosta – 1.5.2 – N?o testado com a vers?o ativa do WooCommerce WooCommerce Multisite Product Sync: por Obtain Infotech – 1.5.0 – N?o testado com a vers?o ativa do WooCommerce WPC Frequently Bought Together for WooCommerce: por WPClever.net – 2.0.8 WP Mail SMTP: por WPForms – 1.9.0 YITH WooCommerce Compare: por YITH – 2.3.20 YITH WooCommerce Wishlist: por YITH – 3.0.9 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Settings ### API Enabled: ? Force SSL: – Currency: BRL (R$) Currency Position: left_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: ? ### WC Pages ### Base da loja: #4 - /loja/ Carrinho: #5 - /carrinho/ Finalizar compra: #6 - /finalizar-compra/ Minha conta: ? A página n?o contém shortcode. Termos e condi??es: ? Página n?o definida ### Theme ### Name: Woodmart Version: 4.5.2 Author URL: https://themeforest.net/user/xtemos Child Theme: ? – Recomendamos você utilizar um tema filho no caso de você estiver personalizando o WooCommerce em um tema ascendente. Veja como criar um tema filho WooCommerce Support: ? ### Templates ### Overrides: woodmart/woocommerce/archive-product.php woodmart/woocommerce/cart/cart-item-data.php woodmart/woocommerce/cart/cart.php woodmart/woocommerce/cart/cross-sells.php woodmart/woocommerce/cart/mini-cart.php woodmart/woocommerce/checkout/form-checkout.php woodmart/woocommerce/checkout/thankyou.php woodmart/woocommerce/content-product.php woodmart/woocommerce/content-product_cat.php woodmart/woocommerce/content-single-product.php woodmart/woocommerce/content-widget-product.php woodmart/woocommerce/global/breadcrumb.php woodmart/woocommerce/global/form-login.php woodmart/woocommerce/global/quantity-input.php vers?o 3.6.0 está desatualizado. A vers?o do core é 4.0.0 woodmart/woocommerce/loop/add-to-cart.php woodmart/woocommerce/loop/loop-end.php woodmart/woocommerce/loop/loop-start.php woodmart/woocommerce/loop/no-products-found.php woodmart/woocommerce/loop/orderby.php woodmart/woocommerce/loop/pagination.php woodmart/woocommerce/loop/sale-flash.php woodmart/woocommerce/myaccount/form-login.php woodmart/woocommerce/product-searchform.php woodmart/woocommerce/single-product/add-to-cart/grouped.php vers?o 3.4.0 está desatualizado. A vers?o do core é 4.0.0 woodmart/woocommerce/single-product/add-to-cart/variable.php woodmart/woocommerce/single-product/meta.php woodmart/woocommerce/single-product/product-image.php woodmart/woocommerce/single-product/product-thumbnails.php woodmart/woocommerce/single-product/rating.php woodmart/woocommerce/single-product/related.php woodmart/woocommerce/single-product/sale-flash.php woodmart/woocommerce/single-product/tabs/tabs.php woodmart/woocommerce/single-product/title.php woodmart/woocommerce/single-product/up-sells.php woodmart/woocommerce/single-product.php Outdated Templates: ? Aprenda como atualizar ### WooCommerce Google Product Feed fields ### Availability: Defaults to "in stock". Brand: Pre-populates from pa_marca taxonomy. Manufacturer Part Number (MPN): Pre-populates from sku taxonomy. Product Type: Pre-populates from product_cat taxonomy. Google Product Category: Global Trade Item Number (GTIN): Size system: ### WooCommerce Google Product Feed options ### Include variations in feed: Enabled Send item_group_id: No
Hi @mchadoo! Thanks for the additional information. I think you should contact our support team directly. You can do this by going to https://woocommerce.com/my-account/create-a-ticket/.
We haven’t heard back from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any further questions!
- The topic ‘Table wp_actionscheduler_actions can’t stop growing’ is closed to new replies.