• Resolved camjohns122

    (@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)

    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)

    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.