Games to play.Claim Your Free 999 Pesos Bonus Today

Resolved

(@camjohns122)

Our product import and sync continually hangs at 89% and never completes and eventually errors out. All errors documented are for the service-runner action no other actions seem to fail. Copied below are the logs

` WordPress Environment
WordPress address (URL): https://halifaxstreet.com
Site address (URL): https://halifaxstreet.com
WC Version: 8.8.2
REST API Version: ? 8.8.2
Action Scheduler Version: ? 3.7.4
Log Directory Writable: ?
WP Version: 6.5.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en
External object cache: – Server Environment
Server Info: Apache
PHP Version: 8.1.27
PHP Post Max Size: 32 MB
PHP Time Limit: 1200
PHP Max Input Vars: 1000
cURL Version: 7.87.0
OpenSSL/1.1.1w
SUHOSIN Installed: –
MySQL Version: 10.6.16-MariaDB-cll-lve
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database
WC Database Version: 8.8.2
WC Database Prefix: wp_
Total Database Size: 73.14MB
Database Data Size: 48.38MB
Database Index Size: 24.76MB
wp_woocommerce_sessions: Data: 0.09MB + 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.05MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.17MB + Index: 0.19MB + 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.05MB + 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: 4.02MB + Index: 7.63MB + 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: 4.02MB + Index: 3.53MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_iwp_backup_status: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 11.16MB + Index: 1.22MB + Engine InnoDB
wp_postmeta: Data: 10.28MB + Index: 4.55MB + Engine InnoDB
wp_posts: Data: 5.41MB + Index: 0.33MB + Engine InnoDB
wp_post_smtp_logmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_post_smtp_logs: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wp_simple_history: Data: 1.02MB + Index: 0.44MB + Engine InnoDB
wp_simple_history_contexts: Data: 5.02MB + Index: 5.03MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.30MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.11MB + 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_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_operational_data: 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.13MB + Index: 0.13MB + 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_wmh_deleted_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wmh_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wmh_save_scan_content: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_wmh_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wmh_unused_media_post_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wmh_used_media_post_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wmh_whitelist_media_post_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_square_customers: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wsp_mails: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wsp_sessions_v2: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts
attachment: 272
custom_css: 2
et_body_layout: 2
et_footer_layout: 1
et_header_layout: 7
et_pb_layout: 22
et_template: 19
et_theme_builder: 1
nav_menu_item: 5
page: 7
post: 3
product: 185
product_variation: 487
revision: 104
shop_coupon: 3
shop_order: 104
shop_order_refund: 4
wp_block: 23
wp_global_styles: 1 Security
Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (14)
All-in-One WP Migration Unlimited Extension: by ServMask – 2.56
All-in-One WP Migration: by ServMask – 7.81
Facebook for WooCommerce: by Facebook – 3.1.15
Media Cleaner: by Jordy Meow – 6.7.3
Meta pixel for WordPress: by Facebook – 3.0.16
Post SMTP: by Post SMTP – 2.9.0
Simple History: by P?r Thernstr?m – 4.14.0
WooCommerce.com Update Manager: by Automattic – 1.0.2
WooCommerce Shipping & Tax: by WooCommerce – 2.5.4
WooCommerce Side Cart Premium: by XootiX – 1.2
WooCommerce Square: by WooCommerce – 4.6.1
WooCommerce: by Automattic – 8.8.2
WP File Manager: by mndpsingh287 – 7.2.6
WPMU DEV Dashboard: by WPMU DEV – 4.11.26 Inactive Plugins (7)
Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2
Google Listings and Ads: by WooCommerce – 2.6.7
Hummingbird Pro: by WPMU DEV – 3.7.4
Jetpack: by Automattic – 13.3.1
Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.26.8
Media Hygiene: by Media Hygiene – 2.0.0
Smush Pro: by WPMU DEV – 3.16.2 Must Use Plugins (1)
WordPress automation by Installatron: by – Settings
API Enabled: –
Force SSL: –
Currency: CAD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)
variation (variation)
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: – Logging
Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 74 MB WC Pages
Shop base: #8 - /shop/
Cart: #647 - /cart/
Checkout: #652 - /checkout/
My account: ? Page not set
Terms and conditions: #740 - /terms_refund_returns/ Theme
Name: Divi Child Theme
Version: 1.0.0
Author URL: https://www.elegantthemes.com
Child Theme: ?
Parent Theme Name: Divi
Parent Theme Version: 4.25.0
Parent Theme Author URL: https://www.elegantthemes.com
WooCommerce Support: ? Templates
Overrides: – Square
Environment: Production
Tokenization Enabled: –
Debug Mode: Off Admin
Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
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
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
product-pre-publish-modal
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: minified-js
new-product-management-experience
product-custom-fields
settings
async-product-editor-category-field
launch-your-store
Daily Cron: ? Next scheduled: 2024-04-21 14:29:26 -06:00
Options: ?
Notes: 178
Onboarding: completed Action Scheduler
Complete: 18,525
Oldest: 2024-03-20 13:40:06 -0600
Newest: 2024-04-20 13:06:05 -0600
Failed: 101
Oldest: 2024-04-19 23:08:57 -0600
Newest: 2024-04-20 11:51:29 -0600
In-progress: 1
Oldest: –
Newest: –
Pending: 6
Oldest: 2024-04-20 13:11:05 -0600
Newest: 2024-04-27 11:50:58 -0600 Status report information
Generated at: 2024-04-20 13:08:19 -06:00
`

Viewing 2 replies - 1 through 2 (of 2 total)

Thread Starter camjohns122
(@camjohns122)

11 months, 1 week ago

and all I receive is the most basic obscure error message that does not seem to indicate where to investigate

“action marked as failed after 300 seconds. Unknown error occurred. Check server, PHP and database error logs to diagnose cause.”
Plugin Support Shameem R. a11n
(@shameemreza)

11 months, 1 week ago
Hi @camjohns122

The issue seems to be related to server timeout. The process is expected to be completed within 300 seconds but takes longer.

Here are a few steps you might consider:
1. Increase the PHP Time Limit: Your PHP Time Limit is currently set to 1200 seconds. You might need to increase this limit to see if it helps the process complete. Additionally, consider increasing your PHP Post Max Size from 32 MB to 2 GB! You can edit your php.ini file or contact your hosting provider for assistance.
2. Check Server Logs: The error message suggests checking the server, PHP, and database error logs. These logs might contain more detailed information about what’s causing the issue. If you’re unsure how to access these logs, your hosting provider should be able to assist.
If this makes no difference, please enable debug mode in the Square setting and share a copy of any fatal error log found under WooCommerce → Status → Logs.

You could copy and paste your reply or share it via Mozilla Community Pastebin and share the link here. This will help us investigate further and provide you with a more accurate solution.

In the meantime, you can run a conflict test to help you identify the cause of the issue. More info: https://woocommerce.com/document/how-to-test-for-conflicts/

Please try these and let us know if they help or if you need further assistance.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Product Syncing Failure’ is closed to new replies.