Support » Plugin: WooCommerce » BLOG DOWN: delete_transient_version spam = ‘Lost connection to MySQL server’

  • Resolved design_dolphin

    (@design_dolphin)


    Problem Summary:
    For some reason WooCommerce is spamming delete_transient_version in the cron cue whenever a WooCommerce product is viewed on the Products admin screen or the front end. It appears to be creating transients for every single Product on a webpage melting the database server. Even when there are only about 10-16 products on a web page for example, so it’s not like there are 90 products on a page or something. The amount of products viewed on the webpages is well within what the blog should and can normally handle.

    Questions
    Why does it do this?
    Can I turn this off?/ How do I fix this?

    Problem Occurs Since
    The problem appears to have started after having moved server, and/or about a month ago.

    Steps Taken
    It is something that more people are having an issue with. I have tried various solutions (like turning off plugins, checking cron, changing themes, checking code, etc.), but the only thing that seems to work is turning WooCommerce off, which isn’t really a solution. I’ve searched for this, but can’t really find any solutions (that I know how to implement). For example:
    a. https://wordpress.org/support/topic/wc_cache_helperdelete_version_transients-flooding-cron/
    b. https://wordpress.org/support/topic/import-process-too-slow-wc_cache_helperdelete_version_transients/

    It is also kind of reminds me of an issue I’ve had with JetPack where it spammed cron commands. That may or may not be related. That took a while to track down, with help of the JetPack team, and kept coming back. Mentioning it because WordPress team works on both plugins? Not saying they are related, but maybe something in the code is causing some kind of issue on certain configurations.

    System Status Report:

    
    ### WordPress Environment ###
    
    Home URL: https://herlook.fashion
    Site URL: https://herlook.fashion
    WC Version: 3.5.1
    Log Directory Writable: ✔
    WP Version: 4.9.8
    WP Multisite: –
    WP Memory Limit: 4 GB
    WP Debug Mode: –
    WP Cron: –
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.2.6
    PHP Post Max Size: 64 MB
    PHP Time Limit: 1800
    PHP Max Input Vars: 1000
    cURL Version: 7.54.0
    OpenSSL/1.0.2k
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.39-cll-lve
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.4.5
    WC Database Prefix: wp_
    Total Database Size: 40.82MB
    Database Data Size: 28.37MB
    Database Index Size: 12.45MB
    wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
    wp_auto_updates: Data: 0.00MB + Index: 0.00MB
    wp_commentmeta: Data: 0.00MB + Index: 0.00MB
    wp_comments: Data: 0.00MB + Index: 0.00MB
    wp_links: Data: 0.00MB + Index: 0.00MB
    wp_loginizer_logs: Data: 0.00MB + Index: 0.01MB
    wp_options: Data: 2.23MB + Index: 0.05MB
    wp_pinterest_automatic: Data: 0.02MB + Index: 0.00MB
    wp_pmxi_files: Data: 0.00MB + Index: 0.00MB
    wp_pmxi_history: Data: 0.68MB + Index: 0.30MB
    wp_pmxi_images: Data: 0.00MB + Index: 0.00MB
    wp_pmxi_imports: Data: 0.35MB + Index: 0.00MB
    wp_pmxi_posts: Data: 2.52MB + Index: 0.56MB
    wp_pmxi_templates: Data: 0.19MB + Index: 0.00MB
    wp_postmeta: Data: 14.73MB + Index: 4.90MB
    wp_posts: Data: 5.52MB + Index: 2.73MB
    wp_termmeta: Data: 0.02MB + Index: 0.02MB
    wp_terms: Data: 0.09MB + Index: 0.15MB
    wp_term_relationships: Data: 1.61MB + Index: 3.19MB
    wp_term_taxonomy: Data: 0.10MB + Index: 0.12MB
    wp_usermeta: Data: 0.01MB + Index: 0.02MB
    wp_users: Data: 0.00MB + Index: 0.01MB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
    
    ### Post Type Counts ###
    
    amazon_auto_links: 1
    attachment: 876
    ct_size_guide: 2
    custom_css: 7
    feedback: 1
    header_builder: 1
    jetpack_migration: 2
    ml-slider: 1
    nav_menu_item: 50
    oembed_cache: 21
    page: 12
    post: 4204
    product: 4593
    templatera: 7
    wpedpcampaign: 1
    wr_mapper: 1
    x-portfolio: 1
    znpb_template_mngr: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (17) ###
    
    ManageWP - Worker: by ManageWP – 4.6.3
    Advanced Cron Manager: by BracketSpace – 2.3.4
    All In One SEO Pack: by Michael Torbert – 2.9.1
    Breadcrumb NavXT: by John Havlik – 6.2.1
    Bulk Delete: by Sudar – 5.6.1
    Cookie Notice: by dFactory – 1.2.44
    Envato Market: by Envato – 2.0.1
    Featured Image From URL: by Marcel Jacques Machado – 1.9.7 – Not tested with the active version of WooCommerce
    Limit Login Attempts: by Johan Eenfeldt – 1.7.1
    SCFashionCollection Plugin: by design_dolphin – 1.4
    Under Construction: by WebFactory Ltd – 3.15
    Woocommerce Products Per Page: by Jeroen Sormani – 1.2.6 – Not tested with the active version of WooCommerce
    WooCommerce: by Automattic – 3.5.1
    WP All Import Pro: by Soflyy – 4.5.5
    WordPress Common Functions Plugin: by design_dolphin – 1.4
    WP Rocket: by WP Media – 3.1.4
    WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.0.5 – Not tested with the active version of WooCommerce
    
    ### 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)
    
    ### WC Pages ###
    
    Shop base: #375349 - /fashion-collection-for-her/
    Cart: ❌ Page not set
    Checkout: ❌ Page not set
    My account: ❌ Page not set
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Icelander Child
    Version: 1.0.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Icelander
    Parent Theme Version: 1.3.3
    Parent Theme Author URL: https://www.webmandesign.eu/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: icelander-child/woocommerce/single-product/price.php
    

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • This issue appears to be fixed. There are no longer error logs being spewed in PHP and the blog is no longer erroring out.

    Hypothesis
    During the blog move there may have been some disconnect between transient versions, causing some kind of blockage/backup. The reason could be something els of course.

    Solution
    Looked at, reviewed, and then deleted all transients using a plugin (although there may be other ways to delete all transients)

    Plugin used:
    https://wordpress.org/plugins/transients-manager/

    The problem is back. My blog is down again, or very slow, because as soon as I log in for example it spams these single transients and just floods the database.

    Why is this even being done for every single one, and not for example with one garbage collection command.

    I am seriously losing money and visitors because my blog is down so long, and can’t fix this or find a fix for this. :'(

    Plugin Author Gerhard Potgieter

    (@kloon)

    Hi, I see you already opened an issue regarding this https://github.com/woocommerce/woocommerce/issues/21803

    We are aware of the slowness affecting some sites that do not utilise object and persistent caching. There’s an open PR with a proposed fix already https://github.com/woocommerce/woocommerce/pull/21282

    We do however need some further testing of that proposed fix, once we have conducted enough testing we will include it in a future release. So far we have earmarked it for WooCommerce 3.6 but this might change in the future.

    Going to mark this as resolved since there’s an open issue and a proposed fix already.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘BLOG DOWN: delete_transient_version spam = ‘Lost connection to MySQL server’’ is closed to new replies.