Hooks in Action Scheduler keep getting stuck

  • Resolved laconicsky

    (@laconicsky)


    1 year, 5 months ago

    Hi,

    I have six regular Hooks that run in Action Scheduler. At least once a day one of them gets stuck (sometimes in “in-progress” and other times it just says “Action Scheduler migration in progress. The list of scheduled actions may be incomplete.” and “Maximum simultaneous queues already in progress (1 queue). No additional queues will begin processing until the current queues are complete.”

    If the hook gets stuck in in-progress I have to delete it and then deactivate and reactivate my main theme plug in.

    The author of the theme has troubleshooted for me but is unable to replicate this issues and can’t offer further support.

    I’ve searched this forum for similar issues but the troubleshooting steps have not worked for me.

    I have screenshots of Action Scheduler and have downloaded the system report from there.

    Please could you have a look and advise on next steps for me.

    View post on imgur.com

    Here is copy and paste form the Logs section of Action Scheduler:

    httpswoocommerce.comwp-jsonwccomobw-free-extensions3.0extensions.json-2023-05-19-e7d21491df58f28c5351a02c6e10b5ce.log

2023-05-19T15:34:17+00:00 ERROR Error getting data feed

2023-05-19T15:34:17+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:34:17+00:00 ERROR Error getting data feed

2023-05-19T15:34:17+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:34:17+00:00 ERROR Error getting data feed

2023-05-19T15:34:17+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:34:17+00:00 ERROR Error getting data feed

2023-05-19T15:34:17+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:36:07+00:00 ERROR Error getting data feed

2023-05-19T15:36:07+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:36:07+00:00 ERROR Error getting data feed

2023-05-19T15:36:07+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:36:07+00:00 ERROR Error getting data feed

2023-05-19T15:36:07+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:36:07+00:00 ERROR Error getting data feed

2023-05-19T15:36:07+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:36:17+00:00 ERROR Error getting data feed

2023-05-19T15:36:17+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:36:17+00:00 ERROR Error getting data feed

2023-05-19T15:36:17+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:37:55+00:00 ERROR Error getting data feed

2023-05-19T15:37:55+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:37:55+00:00 ERROR Error getting data feed

2023-05-19T15:37:55+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:38:05+00:00 ERROR Error getting data feed

2023-05-19T15:38:05+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

2023-05-19T15:38:05+00:00 ERROR Error getting data feed

2023-05-19T15:38:05+00:00 ERROR WP_Error Object

(

    [errors] => Array

        (

            [http_request_failed] => Array

                (

                    [0] => cURL error 6: Could not resolve host: woocommerce.com

                )

        )

    [error_data] => Array

        (

        )

    [additional_data:protected] => Array

        (

        )

)

    And this is the status report:

    ### WordPress Environment ###

WordPress address (URL): https://winejobs.uk

Site address (URL): https://winejobs.uk

WC Version: 7.7.2

REST API Version: ? 7.7.2

WC Blocks Version: ? 10.0.6

Action Scheduler Version: ? 3.6.0

Log Directory Writable: ?

WP Version: 6.2.2

WP Multisite: –

WP Memory Limit: 2 GB

WP Debug Mode: –

WP Cron: ?

Language: en_GB

External object cache: ?

### Server Environment ###

Server Info: LiteSpeed

PHP Version: 7.4.33

PHP Post Max Size: 2 GB

PHP Time Limit: 120

PHP Max Input Vars: 5000

cURL Version: 7.84.0

OpenSSL/1.1.1p

SUHOSIN Installed: –

MySQL Version: 5.5.5-10.6.12-MariaDB-cll-lve

Max Upload Size: 2 GB

Default Timezone is UTC: ?

fsockopen/cURL: ?

SoapClient: ?

DOMDocument: ?

GZip: ?

Multibyte String: ?

Remote Post: ?

Remote Get: ?

### Database ###

WC Database Version: 7.7.2

WC Database Prefix: wp_

Total Database Size: 64.72MB

Database Data Size: 42.18MB

Database Index Size: 22.54MB

wp_woocommerce_sessions: Data: 0.36MB + Index: 0.02MB + Engine InnoDB

wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB

wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB

wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB

wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_actionscheduler_actions: Data: 0.23MB + Index: 0.20MB + Engine InnoDB

wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_actionscheduler_logs: Data: 0.27MB + Index: 0.17MB + Engine InnoDB

wp_b2s_network_insights: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_b2s_posts: Data: 0.02MB + Index: 0.14MB + Engine InnoDB

wp_b2s_posts_drafts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_b2s_posts_favorites: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_b2s_posts_insights: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_b2s_posts_network_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_b2s_posts_sched_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_b2s_user: Data: 0.02MB + Index: 0.05MB + Engine InnoDB

wp_b2s_user_contact: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_b2s_user_network_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_comments: Data: 0.41MB + Index: 0.09MB + Engine InnoDB

wp_easywpsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_easywpsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_litespeed_img_optm: Data: 0.14MB + Index: 0.08MB + Engine InnoDB

wp_litespeed_img_optming: Data: 0.05MB + Index: 0.05MB + Engine InnoDB

wp_litespeed_url: Data: 0.08MB + Index: 0.08MB + Engine InnoDB

wp_litespeed_url_file: Data: 0.25MB + Index: 0.52MB + Engine InnoDB

wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_field_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB

wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_options: Data: 1.52MB + Index: 0.39MB + Engine InnoDB

wp_postmeta: Data: 11.52MB + Index: 4.03MB + Engine InnoDB

wp_posts: Data: 11.52MB + Index: 0.33MB + Engine InnoDB

wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_rank_math_analytics_gsc: Data: 8.52MB + Index: 13.80MB + Engine InnoDB

wp_rank_math_analytics_inspections: Data: 1.52MB + Index: 0.22MB + Engine InnoDB

wp_rank_math_analytics_keyword_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_rank_math_analytics_objects: Data: 0.22MB + Index: 0.09MB + Engine InnoDB

wp_rank_math_internal_links: Data: 1.52MB + Index: 0.19MB + Engine InnoDB

wp_rank_math_internal_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB

wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB

wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_term_relationships: Data: 0.14MB + Index: 0.09MB + Engine InnoDB

wp_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB

wp_to_buffer_log: Data: 0.36MB + Index: 0.09MB + Engine InnoDB

wp_usermeta: Data: 1.52MB + Index: 0.42MB + Engine InnoDB

wp_users: Data: 0.08MB + Index: 0.05MB + Engine InnoDB

wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB

wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB

wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB

wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB

wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB

wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wp_yoast_indexable: Data: 0.16MB + Index: 0.09MB + Engine InnoDB

wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB

wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wp_yoast_seo_links: Data: 0.05MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 452

custom_css: 2

customize_changeset: 1

emailoctopus_form: 5

hp_email: 6

hp_listing: 1011

hp_listing_attribute: 4

hp_listing_package: 5

hp_testimonial: 1

hp_vendor: 164

hp_vendor_attribute: 3

nav_menu_item: 56

nf_sub: 25

oembed_cache: 9

page: 14

post: 2

product: 5

rank_math_schema: 1

revision: 315

seedprod: 1

shop_coupon: 2

shop_order: 31

wp_global_styles: 2

wpforms: 1

### Security ###

Secure connection (HTTPS): ?

Hide errors from visitors: ?

### Active Plugins (24) ###

AddToAny Share Buttons: by AddToAny – 1.8.6

Cloudflare: by Cloudflare

Inc. – 4.12.0

Code Snippets: by Code Snippets Pro – 3.4.0

Easy WP SMTP: by Easy WP SMTP – 2.1.0

EmailOctopus: by EmailOctopus – 3.1.5

Site Kit by Google: by Google – 1.102.0

HivePress Favourites: by HivePress – 1.2.2

HivePress Geolocation: by HivePress – 1.3.7

HivePress Messages: by HivePress – 1.3.0

HivePress Paid Listings: by HivePress – 1.1.7

HivePress Search Alerts: by HivePress – 1.1.2

HivePress Tags: by HivePress – 1.0.3

HivePress: by HivePress – 1.7.1

Jetpack: by Automattic – 12.2

LiteSpeed Cache: by LiteSpeed Technologies – 5.4

Loco Translate: by Tim Whitlock – 2.6.4

Ninja Forms: by Saturday Drive – 3.6.24

Rank Math SEO PRO: by Rank Math – 3.0.37

Rank Math SEO: by Rank Math – 1.0.116

UpdraftPlus - Backup/Restore: by UpdraftPlus.Com

DavidAnderson – 1.23.4

WooCommerce Stripe Gateway: by WooCommerce – 7.4.1

WooCommerce PayPal Payments: by WooCommerce – 2.0.5

WooCommerce: by Automattic – 7.7.2

WP to Buffer: by WP Zinc – 3.8.6

### Inactive Plugins (2) ###

HivePress Memberships: by HivePress – 1.1.4

HivePress Testimonials: by HivePress – 1.0.1

### Dropin Plugins (1) ###

object-cache.php: object-cache.php

### Settings ###

API Enabled: ?

Force SSL: –

Currency: GBP (￡)

Currency Position: left

Thousand Separator: ,

Decimal Separator: .

Number of Decimals: 0

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: –

Enforce Approved Product Download Directories: ?

HPOS feature screen enabled: –

HPOS feature enabled: –

Order datastore: WC_Order_Data_Store_CPT

HPOS data sync enabled: –

### WC Pages ###

Shop base: #353 - /shop/

Basket: #354 - /basket/

Checkout: #355 - /checkout/

My account: #356 - /my-account/

Terms and conditions: ? Page not set

### Theme ###

Name: JobHive

Version: 1.0.5

Author URL: https://hivepress.io

Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build

personally we recommend using a child theme. See: How to create a child theme

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: –

### WooCommerce PayPal Payments ###

Onboarded: ?

Shop country code: GB

WooCommerce currency supported: ?

Advanced Card Processing available in country: ?

Pay Later messaging available in country: ?

Webhook status: –

Vault enabled: ?

Logging enabled: –

Reference Transactions: –

Used PayPal Checkout plugin: –

Tracking enabled: ?

### Admin ###

Enabled Features: activity-panels

analytics

coupons

customer-effort-score-tracks

import-products-task

experimental-fashion-sample-products

shipping-smart-defaults

shipping-setting-tour

homescreen

marketing

mobile-app-banner

navigation

onboarding

onboarding-tasks

remote-inbox-notifications

remote-free-extensions

payment-gateway-suggestions

shipping-label-banner

subscriptions

store-alerts

transient-notices

woo-mobile-welcome

wc-pay-promotion

wc-pay-welcome-page

Disabled Features: product-block-editor

minified-js

new-product-management-experience

product-variation-management

settings

Daily Cron: ? Next scheduled: 2023-05-18 16:37:41 +01:00

Options: ?

Notes: 110

Onboarding: completed

### Action Scheduler ###

Complete: 210

Oldest: 2023-05-08 16:55:50 +0100

Newest: 2023-06-08 10:56:42 +0100

Pending: 6

Oldest: 2023-06-08 13:48:06 +0100

Newest: 2023-06-09 08:16:07 +0100

Failed: 305

Oldest: 2022-10-09 00:04:03 +0100

Newest: 2023-05-23 09:38:52 +0100

### Status report information ###

Generated at: 2023-06-12 10:42:07 +01:00
    • This topic was modified 1 year, 5 months ago by laconicsky.
Viewing 16 replies (of 16 total)
  • Plugin Support Beauty of Code (woo-hc)

    (@beautyofcode)

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.

    Cheers!

Viewing 16 replies (of 16 total)
  • The topic ‘Hooks in Action Scheduler keep getting stuck’ is closed to new replies.