• Resolved jfnnolan

    (@jfnnolan)


    For information, I was struggling with “Connection Timeout” on editing posts in wp-admin. After days of trying various fixes I discovered that in Woocommerce (v6.4.1) I had 18 pending jobs in “Scheduled Actions” all called rocket_rucss_pending_jobs_cron and all rescheduling themselves ever minute (I also have 56k+ Completed Records). After deleting 17 of the jobs the website access is now normal, and there is only now 1 pending job. I do have WP Rocket plugin installed

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi @jfnnolan

    Thanks for sharing the details.

    It looks like you are experiencing this issue reported on GitHub:
    https://github.com/wp-media/wp-rocket/issues/4940

    This issue is currently being looked at by the developers. You can add your own comment and subscribe to the thread for updates. This will give the developers a good idea of the size and impact of the issue on users.

    In the meantime you can also get in touch with the WP Rocket team for an intermediate solution: https://wp-rocket.me/support/

    After deleting 17 of the jobs the website access is now normal, and there is only now 1 pending job.

    Thanks for troubleshooting proactively. If you need us to check deeper then please share with us the following:

    1. System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
    2. Fatal Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

    Thanks

    Thread Starter jfnnolan

    (@jfnnolan)

    It was this error that caused to to look in Action Scheduler – System Status also enclosed

    [02-May-2022 10:29:55 UTC] PHP Fatal error:  Uncaught InvalidArgumentException: Unidentified action 59455 in /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:797
    Stack trace:
    #0 /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueCleaner.php(127): ActionScheduler_DBStore->mark_failure('59455')
    #1 /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueCleaner.php(141): ActionScheduler_QueueCleaner->mark_failures(300)
    #2 /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_QueueRunner.php(102): ActionScheduler_QueueCleaner->clean(300)
    #3 /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(127): ActionScheduler_Abstract_QueueRunner->run_cleanup()
    #4 /home/g586962/public_html/wp-includes/class-wp-hook.php(307): ActionSch in /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 797
    [02-May-2022 10:29:55 UTC] PHP Fatal error:  Uncaught InvalidArgumentException: Unidentified action 59455 in /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:797
    Stack trace:
    #0 /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueCleaner.php(127): ActionScheduler_DBStore->mark_failure('59455')
    #1 /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueCleaner.php(141): ActionScheduler_QueueCleaner->mark_failures(300)
    #2 /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_QueueRunner.php(102): ActionScheduler_QueueCleaner->clean(300)
    #3 /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(127): ActionScheduler_Abstract_QueueRunner->run_cleanup()
    #4 /home/g586962/public_html/wp-includes/class-wp-hook.php(307): ActionSch in /home/g586962/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 797

    ### WordPress Environment ###

    WordPress address (URL): https://galwaycakery.ie
    Site address (URL): https://galwaycakery.ie
    WC Version: 6.4.1
    REST API Version: ? 6.4.1
    WC Blocks Version: ? 7.2.2
    Action Scheduler Version: ? 3.4.0
    WC Admin Version: ? 3.3.2
    Log Directory Writable: ?
    WP Version: 5.9.3
    WP Multisite: –
    WP Memory Limit: 368 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_GB
    External object cache: –

    ### Server Environment ###

    Server Info: LiteSpeed
    PHP Version: 7.2.34
    PHP Post Max Size: 128 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d

    SUHOSIN Installed: –
    MySQL Version: 5.7.37-cll-lve
    Max Upload Size: 128 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 6.4.1
    WC Database Prefix: wp_
    Total Database Size: 106.00MB
    Database Data Size: 90.56MB
    Database Index Size: 15.44MB
    wp_woocommerce_sessions: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_actions: Data: 21.92MB + Index: 6.31MB + Engine MyISAM
    wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_actionscheduler_logs: Data: 9.61MB + Index: 8.15MB + Engine MyISAM
    wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_duplicator_pro_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_duplicator_pro_packages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_mailchimp_jobs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_options: Data: 3.31MB + Index: 0.10MB + Engine MyISAM
    wp_postmeta: Data: 1.47MB + Index: 0.26MB + Engine MyISAM
    wp_posts: Data: 0.91MB + Index: 0.09MB + Engine MyISAM
    wp_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
    wp_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_slides: Data: 0.10MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_usermeta: Data: 0.12MB + Index: 0.02MB + Engine MyISAM
    wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_meta_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_revolut_customer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_revolut_orders: Data: 0.02MB + Index: 0.05MB + Engine MyISAM
    wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_circles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_maps: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_polygon: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_polylines: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpgmza_rectangles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpr_rucss_resources: Data: 8.73MB + Index: 0.05MB + Engine MyISAM
    wp_wpr_rucss_used_css: Data: 43.55MB + Index: 0.04MB + Engine MyISAM
    wp_yoast_indexable: Data: 0.43MB + Index: 0.10MB + Engine MyISAM
    wp_yoast_indexable_hierarchy: Data: 0.01MB + Index: 0.04MB + Engine MyISAM
    wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_yoast_primary_term: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_yoast_seo_links: Data: 0.12MB + Index: 0.04MB + Engine MyISAM

    ### Post Type Counts ###

    attachment: 358
    custom_css: 1
    mc4wp-form: 1
    nav_menu_item: 30
    page: 102
    post: 24
    product: 107
    revision: 25
    shop_order: 13
    shop_order_refund: 5
    wcpa_pt_forms: 19
    wpcf7_contact_form: 6

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (29) ###

    Akismet Anti-Spam: by Automattic – 4.2.3
    Bakery Options: by Milingona – 2.7
    Bakery Shortcodes: by Milingona – 2.7
    Classic Widgets: by WordPress Contributors – 0.3
    Honeypot for Contact Form 7: by Nocean – 2.1
    Contact Form 7: by Takayuki Miyoshi – 5.5.6
    Disable Gutenberg: by Jeff Starr – 2.6
    Duplicate Page: by mndpsingh287 – 4.4.8
    Font Awesome: by Font Awesome – 4.1.1
    Site Kit by Google: by Google – 1.73.0
    Insert Headers and Footers: by WPBeginner – 1.6.1
    Jetpack: by Automattic – 10.9
    WPBakery Page Builder: by Michael M – WPBakery.com – 6.9.0
    Mailchimp for WooCommerce: by Mailchimp – 2.6.2
    MC4WP: Mailchimp for WordPress: by ibericode – 4.8.7
    Image optimisation service by Optimole: by Optimole – 3.4.0
    PHP Compatibility Checker: by WP Engine – 1.5.2
    Revolut Gateway for WooCommerce: by Revolut – 3.1.6
    Slider Revolution: by ThemePunch – 6.5.21
    UpdraftPlus – Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.22.12

    Woocommerce Custom Product Addons: by Acowebs – 4.1.7
    WooCommerce Shipping & Tax: by WooCommerce – 1.25.27
    WooCommerce: by Automattic – 6.4.1
    Yoast SEO: by Team Yoast – 18.7
    WP File Manager: by mndpsingh287 – 7.1.5
    WP Rocket: by WP Media – 3.11.1
    WhatsApp Chat PRO: by QuadLayers – 2.5.7
    Social Chat: by QuadLayers – 5.0.3
    wptools: by Bill Minozzi – 3.23

    ### Inactive Plugins (5) ###

    One page checkout and layouts for Woocommerce: by BluePlugins – 3.0.2
    Really Simple SSL: by Really Simple Plugins – 5.3.1
    WooCommerce PayPal Payments: by WooCommerce – 1.8.0
    WP Google Maps: by WP Google Maps – 8.1.22
    WP Reset: by WebFactory Ltd – 1.95

    ### Dropin Plugins (1) ###

    advanced-cache.php: advanced-cache.php

    ### Settings ###

    API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left
    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 ###

    Shop base: #1132 – /shop/
    Basket: #1133 – /cart-2/
    Checkout: #1134 – /checkout-2/
    My account: #1135 – /my-account-2/
    Terms and conditions: ? Page not set

    ### Theme ###

    Name: Bakery Child
    Version: 2.7
    Author URL: https://themeforest.net/user/milingona_
    Child Theme: ?
    Parent Theme Name: Bakery
    Parent Theme Version: 2.7
    Parent Theme Author URL: https://themeforest.net/user/milingona_
    WooCommerce Support: ?

    ### Templates ###

    Archive Template: Your theme has a woocommerce.php file. You will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
    Overrides: bakery/woocommerce/content-product.php
    bakery/woocommerce/loop/add-to-cart.php
    bakery/woocommerce/loop/loop-end.php
    bakery/woocommerce/loop/loop-start.php
    bakery/woocommerce/loop/price.php
    bakery/woocommerce/loop/sale-flash.php
    bakery/woocommerce/single-product/related.php
    bakery/woocommerce/single-product/sale-flash.php
    bakery/woocommerce/single-product/up-sells.php
    bakery/woocommerce/content-product_cat.php

    ### Action Scheduler ###

    Canceled: 6
    Oldest: 2022-05-03 16:11:15 +0000
    Newest: 2022-05-03 16:11:15 +0000

    Complete: 57,596
    Oldest: 2022-04-05 15:44:36 +0000
    Newest: 2022-05-04 14:54:42 +0000

    Failed: 3
    Oldest: 2021-10-01 07:41:50 +0000
    Newest: 2021-10-01 07:44:01 +0000

    Pending: 1
    Oldest: 2022-05-04 14:55:42 +0000
    Newest: 2022-05-04 14:55:42 +0000

    ### Status report information ###

    Generated at: 2022-05-04 14:54:43 +00:00
    `

    Hi @jfnnolan

    Thanks for sharing the System Status Report and the error logs.

    PHP Version: 7.2.34

    As per our server recommendations, WooCommerce requires PHP 7.4 and above to run smoothly. You may want to upgrade your PHP to meet our server requirements.
    To update the PHP version please refer to this guide:
    https://woocommerce.com/document/update-php-wordpress/#section-10

    Do keep us informed whether that helped. Also, keep a watch on updates from Github.

    Thanks

    We haven’t heard back from you in a while, so I’m marking this thread closed – we’ll be here if and/or when you are ready to continue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Scheduled Actions’ is closed to new replies.