• Resolved babobo

    (@babobo)


    All my wc_facebook_regenerate_feed fails and returns a time out. I have a Woocommerce store with 3000+ products and 3000+ variations.

Viewing 11 replies - 1 through 11 (of 11 total)
  • hi @babobo ,

    We have a snippet that should help with this. I’d recommend you use the free?Code Snippets plugin?to install and activate this snippet. By default, this snippet is set to regenerate the feed once per 24 hours, though you can modify that if you like.
    https://github.com/skyverge/wc-plugins-snippets/blob/master/facebook-for-woocommerce/change-feed-file-generation-interval.php

    I hope this points you in the right direction.

    Thread Starter babobo

    (@babobo)

    Hi @kosiew , thank you for your attention.

    I tried to use this snippet, but the problem is that it doesn’t work when the regenerate fails. When the time out occurs, another regenerate feed is created in the scheduler, even with the 24 hours interval.

    Is this the correct behavior? Or did I do something wrong?

    AJ a11n

    (@amandasjackson)

    Hi @babobo

    Could you please share a copy of your site’s 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.

    Thread Starter babobo

    (@babobo)

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://papelariarainha.com.br
    Site address (URL): https://papelariarainha.com.br
    WC Version: 4.8.0
    REST API Version: ? 4.8.0
    WC Blocks Version: ? 3.8.1
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 1.8.2 inativa
    Log Directory Writable: ?
    WP Version: 5.6
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: pt_BR
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.13
    PHP Post Max Size: 260 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 3000
    cURL Version: 7.74.0
    OpenSSL/1.1.1i
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.23-23
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 4.8.0
    WC Database Prefix: wp_
    Tamanho total do banco de dados: 87.45MB
    Tamanho dos dados do banco de dados: 69.56MB
    Tamanho do índice do banco de dado: 17.89MB
    wp_woocommerce_sessions: Dados: 3.09MB + índex: 0.12MB + mecanismo MyISAM
    wp_woocommerce_api_keys: Dados: 0.00MB + índex: 0.01MB + mecanismo MyISAM
    wp_woocommerce_attribute_taxonomies: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_downloadable_product_permissions: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_order_items: Dados: 0.03MB + índex: 0.02MB + mecanismo MyISAM
    wp_woocommerce_order_itemmeta: Dados: 0.28MB + índex: 0.17MB + mecanismo MyISAM
    wp_woocommerce_tax_rates: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_tax_rate_locations: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_shipping_zones: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_shipping_zone_locations: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_shipping_zone_methods: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_payment_tokens: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_payment_tokenmeta: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_woocommerce_log: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_actionscheduler_actions: Dados: 2.01MB + índex: 0.74MB + mecanismo MyISAM
    wp_actionscheduler_claims: Dados: 0.01MB + índex: 0.03MB + mecanismo MyISAM
    wp_actionscheduler_groups: Dados: 0.00MB + índex: 0.01MB + mecanismo MyISAM
    wp_actionscheduler_logs: Dados: 1.41MB + índex: 1.02MB + mecanismo MyISAM
    wp_cartflows_ca_cart_abandonment: Dados: 0.24MB + índex: 0.02MB + mecanismo MyISAM
    wp_cartflows_ca_email_history: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_cartflows_ca_email_templates: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_cartflows_ca_email_templates_meta: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_check_email_log: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_cielo_api_jrossetto: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_cielo_webservice_check: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_cod_espec_titulo: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB
    wp_cod_mun: Dados: 0.27MB + índex: 0.14MB + mecanismo InnoDB
    wp_commentmeta: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_comments: Dados: 0.08MB + índex: 0.03MB + mecanismo MyISAM
    wp_correios_postcodes: Dados: 0.01MB + índex: 0.01MB + mecanismo MyISAM
    wp_links: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_mailchimp_carts: Dados: 0.07MB + índex: 0.00MB + mecanismo MyISAM
    wp_mailchimp_jobs: Dados: 0.15MB + índex: 0.01MB + mecanismo MyISAM
    wp_options: Dados: 13.12MB + índex: 1.47MB + mecanismo MyISAM
    wp_pmxi_hash: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_postmeta: Dados: 28.45MB + índex: 8.54MB + mecanismo MyISAM
    wp_posts: Dados: 4.95MB + índex: 1.75MB + mecanismo MyISAM
    wp_rank_math_404_logs: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB
    wp_rank_math_analytics_gsc: Dados: 0.28MB + índex: 0.45MB + mecanismo InnoDB
    wp_rank_math_analytics_objects: Dados: 1.52MB + índex: 0.28MB + mecanismo InnoDB
    wp_rank_math_internal_links: Dados: 0.16MB + índex: 0.06MB + mecanismo InnoDB
    wp_rank_math_internal_meta: Dados: 0.16MB + índex: 0.00MB + mecanismo InnoDB
    wp_rank_math_redirections: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB
    wp_rank_math_redirections_cache: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB
    wp_rank_math_sc_analytics: Dados: 0.06MB + índex: 0.02MB + mecanismo InnoDB
    wp_realmedialibrary_posts: Dados: 0.27MB + índex: 0.33MB + mecanismo InnoDB
    wp_termmeta: Dados: 0.07MB + índex: 0.06MB + mecanismo MyISAM
    wp_terms: Dados: 0.06MB + índex: 0.15MB + mecanismo MyISAM
    wp_term_relationships: Dados: 0.47MB + índex: 0.99MB + mecanismo MyISAM
    wp_term_taxonomy: Dados: 0.09MB + índex: 0.09MB + mecanismo MyISAM
    wp_tm_taskmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB
    wp_tm_tasks: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB
    wp_usermeta: Dados: 0.30MB + índex: 0.18MB + mecanismo MyISAM
    wp_users: Dados: 0.01MB + índex: 0.02MB + mecanismo MyISAM
    wp_wc_admin_notes: Dados: 0.01MB + índex: 0.00MB + mecanismo MyISAM
    wp_wc_admin_note_actions: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_wc_category_lookup: Dados: 0.01MB + índex: 0.01MB + mecanismo MyISAM
    wp_wc_customer_lookup: Dados: 0.00MB + índex: 0.01MB + mecanismo MyISAM
    wp_wc_download_log: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_wc_order_coupon_lookup: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_wc_order_product_lookup: Dados: 0.01MB + índex: 0.02MB + mecanismo MyISAM
    wp_wc_order_stats: Dados: 0.00MB + índex: 0.01MB + mecanismo MyISAM
    wp_wc_order_tax_lookup: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_wc_product_meta_lookup: Dados: 0.44MB + índex: 0.50MB + mecanismo MyISAM
    wp_wc_reserved_stock: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_wc_tax_rate_classes: Dados: 0.00MB + índex: 0.01MB + mecanismo MyISAM
    wp_wc_webhooks: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_wfblockediplog: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wfblocks7: Dados: 0.02MB + índex: 0.05MB + mecanismo InnoDB
    wp_wfconfig: Dados: 2.45MB + índex: 0.00MB + mecanismo InnoDB
    wp_wfcrawlers: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wffilechanges: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wffilemods: Dados: 5.52MB + índex: 0.00MB + mecanismo InnoDB
    wp_wfhits: Dados: 0.11MB + índex: 0.05MB + mecanismo InnoDB
    wp_wfhoover: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB
    wp_wfissues: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB
    wp_wfknownfilelist: Dados: 2.52MB + índex: 0.00MB + mecanismo InnoDB
    wp_wflivetraffichuman: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB
    wp_wflocs: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wflogins: Dados: 0.06MB + índex: 0.03MB + mecanismo InnoDB
    wp_wfls_2fa_secrets: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB
    wp_wfls_settings: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wfnotifications: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wfpendingissues: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB
    wp_wfpklist_template_data: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wfreversecache: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wfsnipcache: Dados: 0.02MB + índex: 0.05MB + mecanismo InnoDB
    wp_wfstatus: Dados: 0.13MB + índex: 0.09MB + mecanismo InnoDB
    wp_wftrafficrates: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wpforms_tasks_meta: Dados: 0.00MB + índex: 0.00MB + mecanismo MyISAM
    wp_wpgmza: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wpgmza_circles: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wpgmza_maps: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wpgmza_nominatim_geocode_cache: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wpgmza_polygon: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wpgmza_polylines: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_wpgmza_rectangles: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB
    wp_yith_wcwl: Dados: 0.01MB + índex: 0.01MB + mecanismo MyISAM
    wp_yith_wcwl_lists: Dados: 0.01MB + índex: 0.02MB + mecanismo MyISAM
    
    ### Post Type Counts ###
    
    attachment: 8471
    blocks: 2
    custom_css: 1
    customize_changeset: 7
    elementor_library: 2
    elementor-hf: 1
    mc4wp-form: 1
    nav_menu_item: 163
    oembed_cache: 4
    page: 137
    post: 6
    product: 3810
    product_variation: 2772
    revision: 646
    shop_coupon: 9
    shop_order: 72
    wpcf7_contact_form: 5
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (37) ###
    
    Query Monitor: por John Blackbourn – 3.6.5
    A-Z Listing: por Daniel Llewellyn – 3.1.2
    Contact Form 7: por Takayuki Miyoshi – 5.3.2
    Disable WooCommerce Bloat: por ospiotr – 2.4
    Enhanced E-commerce for Woocommerce store: por Tatvic – 2.3.6.1
    Facebook for WooCommerce: por Facebook – 2.2.0
    JivoChat: por JivoChat – 1.3.5.3
    Cielo Webservice API 3.0  - Jrossetto: por Juliano Rossetto – 2.2 – Vers?o instalada n?o testada com a vers?o ativa do WooCommerce 4.0
    Mailchimp para Woocommerce: por Mailchimp – 2.5.0
    Multiple Products to Cart for WooCommerce: por WebFix Lab – 3.0.3
    OT Flatsome Vertical Menu: por Thinhbg59 – 1.2.3
    Perfect Brands for WooCommerce: por QuadLayers – 1.8.5
    WooCommerce PDF Invoices, Packing Slips, Delivery Notes & Shipping Labels: por WebToffee – 2.7.3
    Product GTIN (EAN, UPC, ISBN) for WooCommerce: por Emanuela Castorina – 1.1.1
    reSmush.it Otimizador de Imagens: por reSmush.it – 0.3.11
    Rank Math SEO: por Rank Math – 1.0.55
    Shortcode in Menus: por Gagan Deep Singh – 3.5.1
    SiteOrigin Widgets Bundle: por SiteOrigin – 1.17.11
    UpdraftPlus - Backup/Restore: por UpdraftPlus.Com
    DavidAnderson – 1.16.43
    
    WebP Express: por Bj?rn Rosell – 0.19.0
    WooCommerce Cart Abandonment Recovery: por CartFlows Inc – 1.2.8
    Woo Title Limit: por Dima W. – 2.0.1
    WooCommerce Admin: por WooCommerce – 1.8.2
    Claudio Sanches - Correios for WooCommerce: por Claudio Sanches – 3.8.0 – Vers?o instalada n?o testada com a vers?o ativa do WooCommerce 4.0
    Brazilian Market on WooCommerce: por Claudio Sanches – 3.7.2 – Vers?o instalada n?o testada com a vers?o ativa do WooCommerce 4.0
    WooCommerce Shipping & Tax: por Automattic – 1.25.4
    WooCommerce: por Automattic – 4.8.0
    WooSidebars: por WooCommerce – 1.4.5
    Wordfence Security: por Wordfence – 7.4.14
    Asset CleanUp: Page Speed Booster: por Gabriel Livan – 1.3.7.2
    WP Google Maps: por WP Google Maps – 8.0.31
    WP Rocket | Redirect HTTP to HTTPS: por WP Rocket Support Team –
    WP Rocket | Redirect www to non-www: por WP Rocket Support Team –
    WP Rocket: por WP Media – 3.8.1
    Widget Disable: por required – 2.0.0
    WPS Hide Login: por WPServeur
    NicolasKulka
    wpformation – 1.6.1
    
    Adicionar aos meus desejos: por YITH – 3.0.17
    
    ### Inactive Plugins (8) ###
    
    All-in-One WP Migration: por ServMask – 7.32
    Better Search Replace: por Delicious Brains – 1.3.4
    Really Simple SSL: por Really Simple Plugins – 4.0.5
    Regenerate Thumbnails: por Alex Mills (Viper007Bond) – 3.1.4
    WooCommerce Correios - Cálculo de Frete na Página do Produto (CFPP): por Lucas Bustamante – 3.1.96 – Vers?o instalada n?o testada com a vers?o ativa do WooCommerce 4.0
    WP-Optimize - Clean, Compress, Cache: por David Anderson
    Ruhani Rabin
    Team Updraft – 3.1.6
    
    WP Crontrol: por John Blackbourn & crontributors – 1.9.0
    WP Server Stats: por Saumya Majumder
    Acnam Infotech – 1.6.9.1
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: BRL (R$)
    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 ###
    
    Base da loja: #4486 - /loja/
    Carrinho: #4485 - /carrinho/
    Finalizar compra: #4484 - /checkout/
    Minha conta: #4483 - /minha-conta/
    Termos e condi??es: ? Página n?o definida
    
    ### Theme ###
    
    Name: flatsome-child
    Version: 3.0
    Author URL: 
    Child Theme: ?
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.13.1
    Parent Theme Author URL: https://www.uxthemes.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/terms.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product-cat.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    flatsome/woocommerce/content-product_cat.php
    
    ### Action Scheduler ###
    
    Complete: 6.842
    Oldest: 2020-12-04 09:38:07 -0300
    Newest: 2021-01-04 09:28:43 -0300
    
    In-progress: 1
    Oldest: –
    Newest: –
    
    Pending: 3
    Oldest: 2021-01-04 09:34:13 -0300
    Newest: 2021-01-07 11:00:49 -0300
    
    
    Thread Starter babobo

    (@babobo)

    Hi @amandasjackson ,

    My biggest problem is that the failed scheduler actions don’t start from where it failed. When I force to Sync all products by pressing the “Sync products” button, it works. But when it depends on wc_facebook_regenerate_feed, it fails. My guess is that after the timeout, the action starts from the beginning.

    AJ a11n

    (@amandasjackson)

    Hi @babobo

    The site’s PHP memory_limit could be causing the time out.

    What the limit should be depends on how much else a site has going on. In a fresh install of WP, WC, and FBW, 128mb was good enough. Once you start adding other memory-intensive extensions (SEO packs, page builders, activity monitors, etc), that changes.

    We generally recommend a limit of at least 512mb to ensure that everything is covered, though extreme situations could demand more.

    Thread Starter babobo

    (@babobo)

    @amandasjackson

    My biggest problem is that Hostgator (host provider) limit my resources by:

    safe mode = Off
    memory_limit = 256M
    max_execution_time = 30
    max_input_time = 60
    post_max_size = 64M
    upload_max_filesize = 64M
    enable_dl = Off

    Why do the manual sync works and the action scheduler does not?
    Thank you for your answers! I hope I can solve this.

    AJ a11n

    (@amandasjackson)

    Hi @babobo

    > Why do the manual sync works and the action scheduler does not?

    Long story short, the action scheduler uses PHP memory (you can read more here: https://actionscheduler.org/)

    You will need to contact your hosting to increase the memory in this case.

    Thread Starter babobo

    (@babobo)

    Ok! I will try, thank you very much, and happy new year! ??

    AJ a11n

    (@amandasjackson)

    @babobo

    Please do let us know how that goes. I’ll leave the thread open for a bit longer incase you have any further questions.

    AJ a11n

    (@amandasjackson)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Action timed out after 300 seconds’ is closed to new replies.