Issue with the WooCommerce Schedule Action Hook

Hello @robertmurdock153!

For better assistance, please share your WooCommerce error logs and System Status on this thread so we can take a look at your configuration and check the issue further:

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.

Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

Hello,

Thanks for the replied.

System Status:
### WordPress Environment ###

WordPress address (URL): https://www.surveying.com
Site address (URL): https://www.surveying.com
WC Version: 6.5.1
REST API Version: ? 6.5.1
WC Blocks Version: ? 7.4.3
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 3 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: ?

### Server Environment ###

Server Info: Apache
PHP Version: 8.0.19
PHP Post Max Size: 100 MB
PHP Time Limit: 3600
PHP Max Input Vars: 10000
cURL Version: 7.74.0
OpenSSL/1.1.1n

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

### Database ###

WC Database Version: 6.5.1
WC Database Prefix: wp_
Total Database Size: 456.13MB
Database Data Size: 269.56MB
Database Index Size: 186.57MB
wp_woocommerce_sessions: Data: 0.11MB + 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.02MB + 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: 75.11MB + Index: 78.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: 58.09MB + Index: 38.11MB + Engine InnoDB
wp_c2c_config: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_entry: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
wp_gf_entry_meta: Data: 0.44MB + Index: 0.44MB + Engine InnoDB
wp_gf_entry_notes: Data: 0.16MB + Index: 0.06MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_icl_languages_translations: Data: 0.20MB + Index: 0.13MB + Engine InnoDB
wp_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_icl_mo_files_domains: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_strings: Data: 2.52MB + Index: 4.45MB + Engine InnoDB
wp_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_string_pages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_icl_string_positions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_string_translations: Data: 2.52MB + Index: 1.81MB + Engine InnoDB
wp_icl_string_urls: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icl_translate: Data: 9.52MB + Index: 1.52MB + Engine InnoDB
wp_icl_translate_job: Data: 0.27MB + Index: 0.08MB + Engine InnoDB
wp_icl_translations: Data: 2.52MB + Index: 8.06MB + Engine InnoDB
wp_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icl_translation_status: Data: 13.52MB + Index: 0.25MB + Engine InnoDB
wp_icwp_wpsf_at_logs: Data: 2.02MB + Index: 0.44MB + Engine InnoDB
wp_icwp_wpsf_at_meta: Data: 4.02MB + Index: 0.45MB + Engine InnoDB
wp_icwp_wpsf_botsignal: Data: 1.05MB + Index: 0.08MB + Engine InnoDB
wp_icwp_wpsf_events: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
wp_icwp_wpsf_ips: Data: 0.17MB + Index: 0.11MB + Engine InnoDB
wp_icwp_wpsf_ip_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icwp_wpsf_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icwp_wpsf_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icwp_wpsf_req_logs: Data: 10.02MB + Index: 2.41MB + Engine InnoDB
wp_icwp_wpsf_resultitems: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icwp_wpsf_resultitem_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icwp_wpsf_scanitems: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_icwp_wpsf_scanresults: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_icwp_wpsf_scans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_icwp_wpsf_sessions: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_icwp_wpsf_user_meta: Data: 0.17MB + Index: 0.05MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 13.19MB + Index: 0.22MB + Engine InnoDB
wp_postmeta: Data: 33.56MB + Index: 22.06MB + Engine InnoDB
wp_posts: Data: 9.52MB + Index: 6.03MB + Engine InnoDB
wp_redirection_404: Data: 6.02MB + Index: 0.95MB + Engine InnoDB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_responsive_menu_pro: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
wp_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wp_term_taxonomy: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_toolset_associations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_toolset_associations_old: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_toolset_connected_elements: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_toolset_post_guid_id: Data: 0.14MB + Index: 0.20MB + Engine InnoDB
wp_toolset_relationships: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_toolset_type_sets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_usermeta: Data: 8.52MB + Index: 10.03MB + Engine InnoDB
wp_users: Data: 0.34MB + Index: 0.28MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.13MB + Index: 0.06MB + 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.09MB + Index: 0.09MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.47MB + Index: 0.81MB + 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_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 7.52MB + Index: 4.92MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.36MB + Index: 0.53MB + 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.08MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf-field: 319
acf-field-group: 37
attachment: 15096
custom_css: 1
media-center: 180
nav_menu_item: 71
oembed_cache: 144
page: 114
post: 5
product: 3229
product_variation: 876
revision: 10
seco-catalog: 7
shop_order: 4
team: 23
um_directory: 1
um_form: 3
wc-customer-group: 3
wp-types-group: 2
wpsl_stores: 395

### Security ###

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

### Active Plugins (36) ###

Gravity Forms: by Gravity Forms – 2.6.3
WPML Multilingual CMS: by OnTheGoSystems – 4.5.8
WPML SEO: by OnTheGoSystems – 2.0.1
Advanced Custom Fields Multilingual: by OnTheGoSystems – 1.10.3
Advanced Custom Fields PRO: by Delicious Brains – 5.12.2
Advanced Custom Fields: Table Field: by Johann Heyne – 1.3.14
AJAX Search for WooCommerce: by Damian Góra – 1.6.3
WP Engine Smart Plugin Manager: by WP Engine – 5.10.33
Classic Editor: by WordPress Contributors – 1.6.2
Controlled Admin Access: by WPRuby – 1.5.12
GDPR Cookie Consent: by WebToffee – 2.1.2
Custom Post Type Widgets: by thingsym – 1.5.1
Customer Group based taxes for WooCommerce: by Monster Infotech – 1.0.0
Enable Media Replace: by ShortPixel – 3.6.3
Export Store: by surveying – 1.0.0
Export Users: by surveying – 1.0.0
Gravity Forms Multilingual: by OnTheGoSystems – 1.6.3
Import Store: by spectralasers – 20160911
Import User: by surveying – 1.10.1
Redirection: by John Godley – 5.2.3
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Responsive Menu Pro: by ExpressTech – 3.1.31
Show Current Template: by JOTAKI Taisuke – 0.4.6
Toolset Types: by OnTheGoSystems – 3.4.15
Ultimate Member: by Ultimate Member – 2.4.0
Woocommerce Cross Sell Products Display: by Logicfire – 2.0.1
WooCommerce Multilingual & Multicurrency: by OnTheGoSystems – 5.0.1
WOOF – WooCommerce Products Filter: by realmag777 – 1.2.6.3
Woocommerce Products Per Page: by Jeroen Sormani – 1.2.6
WooCommerce: by Automattic – 6.5.1
Yoast SEO: by Team Yoast – 19.0
WP Mail SMTP: by WPForms – 3.4.0
Shield Security: by Shield Security – 15.0.13
WP Store Locator: by Tijmen Smit – 2.2.232
WPML Media: by OnTheGoSystems – 2.7.0
WPML String Translation: by OnTheGoSystems – 3.2.1

### Inactive Plugins (2) ###

Cart2cart: Magento to Woocommerce Plugin: by MagneticOne – 2.0.0
WooCommerce CyberSource Gateway: by SkyVerge – 2.1.2

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
object-cache.php: Memcached Redux

### Must Use Plugins (6) ###

Force Strong Passwords – WPE Edition: by Jason Cosper – 1.8.0
WPE ElasticPress Autosuggest Logger: by WP Engine – 1.0.0
WP Engine Cache Plugin: by WP Engine – 1.0.9
WP Engine Seamless Login Plugin: by WP Engine – 1.5.5
WP Engine Security Auditor: by wpengine – 1.0.10
WP Engine System: by WP Engine – 5.0.1

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
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: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #15 – /shop/
Cart: #7 – /cart/
Checkout: #9 – /checkout/
My account: #11 – /my-account/
Terms and conditions: ? Page ID is set
but the page does not exist

### Theme ###

Name: surveying
Version: 1.0.0
Author URL: https://underscores.me/
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 ###

Overrides: surveying/woocommerce/archive-product.php
surveying/woocommerce/cart/cart-empty.php
surveying/woocommerce/checkout/cart-errors.php
surveying/woocommerce/checkout/form-billing.php
surveying/woocommerce/checkout/form-checkout.php
surveying/woocommerce/checkout/form-coupon.php
surveying/woocommerce/checkout/form-login.php
surveying/woocommerce/checkout/form-pay.php version 3.4.0 is out of date. The core version is 5.2.0
surveying/woocommerce/checkout/form-shipping.php
surveying/woocommerce/checkout/order-receipt.php
surveying/woocommerce/checkout/payment-method.php
surveying/woocommerce/checkout/payment.php
surveying/woocommerce/checkout/review-order.php version 3.8.0 is out of date. The core version is 5.2.0
surveying/woocommerce/checkout/terms.php
surveying/woocommerce/checkout/thankyou.php
surveying/woocommerce/content-product.php
surveying/woocommerce/loop/add-to-cart.php
surveying/woocommerce/loop/orderby.php
surveying/woocommerce/myaccount/dashboard.php version 2.6.0 is out of date. The core version is 4.4.0
surveying/woocommerce/myaccount/downloads.php
surveying/woocommerce/myaccount/form-add-payment-method.php version 3.4.0 is out of date. The core version is 4.3.0
surveying/woocommerce/myaccount/form-edit-account.php
surveying/woocommerce/myaccount/form-edit-address.php
surveying/woocommerce/myaccount/form-login.php version 3.6.0 is out of date. The core version is 4.1.0
surveying/woocommerce/myaccount/form-lost-password.php
surveying/woocommerce/myaccount/form-reset-password.php
surveying/woocommerce/myaccount/lost-password-confirmation.php
surveying/woocommerce/myaccount/my-account.php
surveying/woocommerce/myaccount/my-address.php
surveying/woocommerce/myaccount/my-downloads.php
surveying/woocommerce/myaccount/my-orders.php
surveying/woocommerce/myaccount/navigation.php
surveying/woocommerce/myaccount/orders.php
surveying/woocommerce/myaccount/payment-methods.php
surveying/woocommerce/myaccount/view-order.php
surveying/woocommerce/single-product/add-to-cart/external.php
surveying/woocommerce/single-product/add-to-cart/grouped.php version 4.0.0 is out of date. The core version is 4.8.0
surveying/woocommerce/single-product/add-to-cart/simple.php
surveying/woocommerce/single-product/add-to-cart/variable.php version 3.5.5 is out of date. The core version is 6.1.0
surveying/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
surveying/woocommerce/single-product/add-to-cart/variation.php
surveying/woocommerce/single-product/meta.php
surveying/woocommerce/single-product/photoswipe.php
surveying/woocommerce/single-product/price.php
surveying/woocommerce/single-product/product-attributes.php
surveying/woocommerce/single-product/product-image.php
surveying/woocommerce/single-product/product-thumbnails.php
surveying/woocommerce/single-product/rating.php
surveying/woocommerce/single-product/related.php
surveying/woocommerce/single-product/review-meta.php
surveying/woocommerce/single-product/review-rating.php
surveying/woocommerce/single-product/review.php
surveying/woocommerce/single-product/sale-flash.php
surveying/woocommerce/single-product/share.php
surveying/woocommerce/single-product/short-description.php
surveying/woocommerce/single-product/stock.php
surveying/woocommerce/single-product/tabs/additional-information.php
surveying/woocommerce/single-product/tabs/description.php
surveying/woocommerce/single-product/tabs/tabs.php
surveying/woocommerce/single-product/title.php
surveying/woocommerce/single-product/up-sells.php
surveying/woocommerce/single-product.php
surveying/woocommerce/taxonomy-product_cat.php version 1.6.4 is out of date. The core version is 4.7.0
surveying/woocommerce/taxonomy-product_tag.php version 1.6.4 is out of date. The core version is 4.7.0

Outdated Templates: ?

Learn how to update

### Action Scheduler ###

Complete: 261,317
Oldest: 2022-05-09 16:19:44 +0000
Newest: 2022-06-09 04:55:21 +0000

Failed: 1
Oldest: 2022-04-13 09:00:45 +0000
Newest: 2022-04-13 09:00:45 +0000

Pending: 1
Oldest: 2022-06-09 04:55:22 +0000
Newest: 2022-06-09 04:55:22 +0000

### Status report information ###

Generated at: 2022-06-08 22:55:22 -06:00

=======================
Error Log:

Yes, error is found but it’s not related to the woocommerce. https://nimb.ws/5itbpK

Thanks

Hi @robertmurdock153

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

As a first step can I have you update the outdated templates? I see that your theme overrides many WooCommerce templates and some overrides are outdated. Please refer to our documentation on how to update outdated templates: https://woocommerce.com/document/fix-outdated-templates-woocommerce/

Hello,

Sure. I will update it ASAP and let you know.
However, can you look into the actual issue?

Let me know your feedback on it.

Thanks

Hello,

The actions you mention are related to this feature introduced in WooCommerce 6.3: https://developer.woocommerce.com/2022/02/02/new-product-filtering-by-attributes-rolling-out-in-woocommerce-6-3/

I recommend that you read the whole announcement, but the gist of it is that the scheduled actions are filling the new product attributes lookup table in batches of 10 – this can take a while in sites with a large number of products, but the recurring actions are expected and shouldn’t be a concern.

If you would like it to finish faster, you can find a solution in the link above.

Please let us know if we can be of any further assistance.

Yes, it’s help me!!.

Can we Abort it? Is it create any issue if we keep it abort? https://nimb.ws/hM1ZSq

Thanks

Hello,

If it aborts it means it could be interrupted or not completed, please allow some time for it to run properly, also the article shared by Paulo earlier explains a way to increase the batch size (is not recommended but it is a possibility).

Let us know if there are any questions.

Hello,

It looks like Regenerate progress number 550(https://nimb.ws/v72Zys) and it’s not reduce but on the schedule action is increasing the number of the count multiple(https://nimb.ws/ml9ONE).

Please guide!!

Thanks

Hi there,

What you see here is the total of all hooks in their complete, failed and pending statuses.

Does it cause any particular annoyance if you regenerate product lookup tables in batch following the article shared above and leave it in the background until the process is completed?

The time it takes to complete the task depends on your available resources and database, so you should contact your host if you have any concerns about this and try to find out if the process could be expedited.

Cheers.

We’ve not heard back from you in a while, so I’m marking this thread closed. Hopefully, the above info was helpful.

If you have other questions, please feel free to open a new topic.