• Resolved Konstatninos

    (@skredlemon)


    Hi,

    I have been having a large number of reports delivered in my inbox from my monitoring about slow requests apparently made from – or related to – woocommerce. Would you kindly advise me what could be done in order to make these go away?

    path: /wp-json/wc-analytics/admin/notes?page=1&per_page=25&type=error%2Cupdate&status=unactioned&_locale=user
    # of slow requests: 114
    Average duration (sec.): 3.94
    Density: 0.83

    path: /wp-json/wc-analytics/admin/notes?page=1&per_page=25&status=unactioned&type%5B0%5D=info&type%5B1%5D=marketing&type%5B2%5D=survey&type%5B3%5D=warning&orderby=date&order=desc&_locale=user
    # of slow requests: 112
    Average duration (sec.): 3.9
    Density: 0.83

    path: /wp-json/wc-admin/options?options=woocommerce_ces_tracks_queue&_locale=user
    # of slow requests: 111
    Average duration (sec.): 3.8
    Density: 0.83

    path: /wp-json/wc-admin/options?options=woocommerce_task_list_hidden%2Cwoocommerce_extended_task_list_hidden%2Cwoocommerce_task_list_dismissed_tasks%2Cwoocommerce_task_list_complete%2Cwoocommerce_task_list_tracked_completed_tasks&_locale=user
    # of slow requests: 110
    Average duration (sec.): 3.85
    Density: 0.83

    path: /?wc-ajax=get_refreshed_fragments
    # of slow requests: 151
    Average duration (sec.): 2.5
    Density: 0.94

    Thanks!

    • This topic was modified 3 years, 3 months ago by Konstatninos.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Hi @skredlemon

    Thanks for sharing the error details. Could you please share a copy of your site’s System Status so we can get a better idea of where the time is being spent?

    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 Konstatninos

    (@skredlemon)

    Hi Margaret,

    Thank you for the prompt reply. Please find below the requested information. Thank you.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://padelove.gr
    Site address (URL): https://padelove.gr
    WC Version: 6.0.0
    REST API Version: ? 6.0.0
    WC Blocks Version: ? 6.3.3
    Action Scheduler Version: ? 3.3.0
    WC Admin Version: ? 2.9.4
    Log Directory Writable: ?
    WP Version: 5.8.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: ?
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.25
    PHP Post Max Size: 256 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 10000
    cURL Version: 7.79.1
    OpenSSL/1.1.1l
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.27
    Max Upload Size: 1 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.0.0
    WC Database Prefix: wppdlv_
    Total Database Size: 111.13MB
    Database Data Size: 95.77MB
    Database Index Size: 15.36MB
    wppdlv_woocommerce_sessions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wppdlv_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppdlv_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wppdlv_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppdlv_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_actionscheduler_actions: Data: 0.34MB + Index: 0.44MB + Engine InnoDB
    wppdlv_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_actionscheduler_logs: Data: 0.34MB + Index: 0.22MB + Engine InnoDB
    wppdlv_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_aws_cache: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wppdlv_aws_index: Data: 2.16MB + Index: 0.73MB + Engine InnoDB
    wppdlv_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wppdlv_eurobank_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_ewwwio_images: Data: 4.50MB + Index: 1.70MB + Engine InnoDB
    wppdlv_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_icl_languages_translations: Data: 0.20MB + Index: 0.17MB + Engine InnoDB
    wppdlv_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_icl_mo_files_domains: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_icl_string_pages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_icl_string_positions: Data: 0.30MB + Index: 0.08MB + Engine InnoDB
    wppdlv_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_string_translations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_icl_string_urls: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_strings: Data: 1.52MB + Index: 1.05MB + Engine InnoDB
    wppdlv_icl_translate: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_translate_job: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_icl_translation_status: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wppdlv_icl_translations: Data: 0.16MB + Index: 0.38MB + Engine InnoDB
    wppdlv_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_litespeed_img_optm: Data: 2.52MB + Index: 1.88MB + Engine InnoDB
    wppdlv_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppdlv_mailerlite_checkouts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_ml_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppdlv_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_nextend2_smartslider3_sliders: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
    wppdlv_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_nextend2_smartslider3_slides: Data: 0.16MB + Index: 0.11MB + Engine InnoDB
    wppdlv_options: Data: 26.28MB + Index: 0.22MB + Engine InnoDB
    wppdlv_postmeta: Data: 16.50MB + Index: 5.47MB + Engine InnoDB
    wppdlv_posts: Data: 10.05MB + Index: 0.50MB + Engine InnoDB
    wppdlv_seopress_significant_keywords: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wppdlv_term_relationships: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
    wppdlv_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_termmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    wppdlv_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_usermeta: Data: 0.23MB + Index: 0.06MB + Engine InnoDB
    wppdlv_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppdlv_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wppdlv_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppdlv_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppdlv_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_wc_product_meta_lookup: Data: 0.09MB + Index: 0.13MB + Engine InnoDB
    wppdlv_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_wfcm_file_events: Data: 17.52MB + Index: 0.00MB + Engine InnoDB
    wppdlv_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppdlv_wpr_rucss_resources: Data: 10.42MB + Index: 0.09MB + Engine InnoDB
    wppdlv_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppdlv_yoast_indexable: Data: 0.30MB + Index: 0.23MB + Engine InnoDB
    wppdlv_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
    wppdlv_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppdlv_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppdlv_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 1519
    br_filters_group: 1
    br_product_filter: 1
    cookielawinfo: 6
    custom_css: 2
    et_body_layout: 3
    et_footer_layout: 1
    et_header_layout: 5
    et_pb_layout: 15
    et_template: 16
    et_theme_builder: 1
    flamingo_contact: 13
    flamingo_inbound: 7
    nav_menu_item: 26
    page: 18
    popup: 5
    popup_theme: 8
    post: 8
    product: 302
    product_variation: 633
    pscw-size-chart: 6
    revision: 304
    seopress_404: 5
    shop_order: 17
    size-chart: 52
    wcpa_pt_forms: 1
    wpcf7_contact_form: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (43) ###
    
    WPML Multilingual CMS: by OnTheGoSystems – 4.4.12
    Advanced Woo Search: by ILLID – 2.42
    Contact Form 7 Connector: by ARI Soft – 1.1.13
    Booster Plus for WooCommerce: by Pluggabl LLC – 5.4.9
    CF7 Google Sheet Connector: by GSheetConnector – 4.9.1
    Change wp-admin login: by Nuno Morais Sarmento – 1.0.6
    Classic Widgets: by WordPress Contributors – 0.2
    Contact Form 7: by Takayuki Miyoshi – 5.5.3
    GDPR Cookie Consent: by WebToffee – 2.0.6
    Divi BodyCommerce: by Divi Engine – 6.5.2.1
    Divi Icons Pro: by b3multimedia – 1.4
    Divi Toolbox: by Divi Lover – 1.6.14
    Duplicate Page: by mndpsingh287 – 4.4.6
    Google Tag Manager for WordPress: by Thomas Geiger – 1.14.1
    Enable SVG, WebP, and ICO Upload: by ideasToCode – 1.0.1
    Facebook for WooCommerce: by Facebook – 2.6.7
    Flamingo: by Takayuki Miyoshi – 2.2.3
    Facebook for WordPress: by Facebook – 3.0.6
    Popup Maker - WooCommerce Pro: by WP Popup Maker – 1.0.1
    Popup Maker: by Popup Maker – 1.16.3
    PublishPress Future: by PublishPress – 2.7.0
    Product Size Chart for WooCommerce: by VillaTheme – 1.0.6
    Really Simple SSL: by Really Simple Plugins – 5.2.1
    Remove Uppercase Accents: by Giorgos Sarigiannidis – 1.1.1
    Security Headers: by Simon Waters – 1.1
    Smart Slider 3: by Nextend – 3.5.1.2
    Stop User Enumeration: by Fullworks – 1.4.0
    Supreme Modules Lite - Divi Theme, Extra Theme and Divi Builder: by Supreme Modules – 2.4.1
    Divi Supreme Pro: by Divi Supreme – 4.7.47
    Use Memcached: by Palasthotel  (in person: Edward Bock) – 1.0.4
    WooCommerce - MailerLite: by MailerLite – 1.5.7
    Eurobank WooCommerce Payment Gateway: by Papaki – 1.8.7
    Product Feed PRO for WooCommerce: by AdTribes.io – 11.0.3
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.5
    Booster for WooCommerce: by Pluggabl LLC – 5.4.9
    WooCommerce: by Automattic – 6.0.0
    Yoast SEO: by Team Yoast – 17.8
    WP Rocket: by WP Media – 3.10.5.1
    SEOPress PRO: by SEOPress – 5.3.0
    SEOPress: by SEOPress – 5.3.0
    WPML Media: by OnTheGoSystems – 2.6.5
    WPML String Translation: by OnTheGoSystems – 3.1.10
    WPML Translation Management: by OnTheGoSystems – 2.10.8
    
    ### Inactive Plugins (1) ###
    
    WooCommerce Multilingual: by OnTheGoSystems – 4.12.1
    
    ### Dropin Plugins (2) ###
    
    advanced-cache.php: advanced-cache.php
    object-cache.php: object-cache.php
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right
    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 ###
    
    Shop base: #2223 - /proionta/
    Cart: #34 - /cart/
    Checkout: #35 - /checkout/
    My account: #36 - /my-account/
    Terms and conditions: #2752 - /oroi-xrisis/
    
    ### Theme ###
    
    Name: RLPadelove
    Version: 1.0.0
    Author URL: https://redlemon.gr
    Child Theme: ?
    Parent Theme Name: Divi
    Parent Theme Version: 4.14.3
    Parent Theme Author URL: https://www.elegantthemes.com
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 1,142
    Oldest: 2021-11-23 14:19:01 +0200
    Newest: 2021-12-24 14:18:47 +0200
    
    Pending: 1
    Oldest: 2021-12-24 22:41:36 +0200
    Newest: 2021-12-24 22:41:36 +0200
    
    ### Status report information ###
    
    Generated at: 2021-12-24 14:19:05 +02:00
    
    Thread Starter Konstatninos

    (@skredlemon)

    I don’t know how or even if they are related, but I discovered four URLs which were refusing to render. They were throwing a critical error on the front page. After enabling the display errors option in php, we were able to discover the following errors also.

    Fatal error: Uncaught Exception: Invalid product. in /home/padelove/public_html/wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:167 Stack trace: 
    #0 /home/padelove/public_html/wp-content/plugins/woocommerce/includes/class-wc-data-store.php(159): WC_Product_Data_Store_CPT->read(Object(WC_Product)) 
    #1 /home/padelove/public_html/wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-product.php(137): WC_Data_Store->read(Object(WC_Product)) 
    #2 /home/padelove/public_html/wp-content/plugins/divi-bodycommerce/includes/modules/CrossSell/CrossSell.php(354): WC_Product->__construct(2925) 
    #3 /home/padelove/public_html/wp-content/themes/Divi/includes/builder/class-et-builder-element.php(3272): db_crosssell_code->render(Array, '', 'et_pb_db_crosss...', '', '', '', '', '') 
    #4 /home/padelove/public_html/wp-includes/shortcodes.php(356): ET_Builder_Element->_render(Array, '', 'et_pb_db_crosss...') 
    #5 [internal function]: do_shortcode_tag(Array) 
    #6 /home/padelove/public_html/wp-includes/shortco in /home/padelove/public_html/wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php on line 167
    There has been a critical error on this website.

    Please review and advise in addition to the last message. If they are not related however, please let me know and I’ll move it on its own thread.

    Thanks.

    Mirko P.

    (@rainfallnixfig)

    Hi @skredlemon,

    Thanks for sharing your system status.

    I can see your WordPress and WooCommerce versions are up to date. This issue may be caused by a conflict with your theme or with another plugin. The best way to determine this is to:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem

    If you’re not seeing the same behavior after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated.

    Reactivate the theme first and check again. Then, go on and reactivate your other plugins one by one, testing after each, until you find the one causing conflict.

    You can find a more detailed explanation on how to do a conflict test here: https://docs.woocommerce.com/document/how-to-test-for-conflicts/.

    Thanks.

    We haven’t heard back from you in a while, so I’m marking this thread as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Large number of slow requests’ is closed to new replies.