Support » Plugin: WooCommerce » Critical Error about running out of Memory

  • Resolved EliteGent

    (@gentlemako)


    Hello there,

    We have noticed that our Woo-commerce is running out of memory every time lately, we currently can’t open/edit/update any product page, we receive the error ” There has been a critical error on this website. Please check your site admin email inbox for instructions.” on the error log status we see the “CRITICAL Allowed memory size of 536870912 bytes exhausted (tried to allocate 8388648 bytes) in /var/www/gg/wp-includes/wp-db.php on line 2128”

    Previously we increased from 258 MB to 528 MB, the issue have been fixed temporarily for a few days until we published some new products, and then the issue started appearing again.

    Now we upgraded from 528mb to 1G and we are sure there is a problem with Woocommerce somehow since we have deactivated all plugins and the issue still persists.

    Please advise.

    Thank you.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Support Juan G. (woo-hc)

    (@judagutor)

    Hi @gentlemako!

    To know more about your setup and further check into this case, kindly provide us your System Status; you can find it via WooCommerce > Status. Select ‘Get system report’ and then ‘Copy for support’. Once you do this, paste in here your response.

    Thanks!

    Thread Starter EliteGent

    (@gentlemako)

    
    ### WordPress Environment ###
    
    WordPress address (URL): XXXX
    Site address (URL): XXXXX
    WC Version: 6.3.0
    REST API Version: ✔ 6.3.0
    WC Blocks Version: ✔ 6.9.0
    Action Scheduler Version: ✔ 3.4.0
    WC Admin Version: ✔ 3.2.1
    Log Directory Writable: ✔
    WP Version: ❌ 5.9 - There is a newer version of WordPress available (5.9.1)
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: nginx/1.21.0
    PHP Version: 8.0.6
    PHP Post Max Size: 40 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.64.0
    OpenSSL/1.1.1d
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.34-log
    Max Upload Size: 20 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.3.0
    WC Database Prefix: wp_
    Total Database Size: 760.24MB
    Database Data Size: 597.19MB
    Database Index Size: 163.05MB
    wp_woocommerce_sessions: Data: 70.95MB + Index: 2.37MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 5.25MB + Index: 2.13MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 58.34MB + Index: 26.42MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    sib_model_contact: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 3.02MB + Index: 3.73MB + 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: 2.52MB + Index: 2.03MB + Engine InnoDB
    wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 2.12MB + Index: 1.29MB + Engine MyISAM
    wp_comments: Data: 37.32MB + Index: 15.09MB + Engine MyISAM
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_options: Data: 8.17MB + Index: 0.40MB + Engine MyISAM
    wp_postmeta: Data: 327.70MB + Index: 71.12MB + Engine MyISAM
    wp_posts: Data: 13.30MB + Index: 3.47MB + Engine MyISAM
    wp_termmeta: Data: 0.07MB + Index: 0.05MB + Engine MyISAM
    wp_terms: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_term_relationships: Data: 0.34MB + Index: 0.64MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.06MB + Index: 0.01MB + Engine MyISAM
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_usermeta: Data: 10.62MB + Index: 4.67MB + Engine MyISAM
    wp_users: Data: 0.56MB + Index: 0.62MB + Engine MyISAM
    wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 2.52MB + Index: 1.80MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 4.52MB + Index: 5.03MB + Engine InnoDB
    wp_wc_order_stats: Data: 3.52MB + Index: 2.39MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.22MB + Index: 0.17MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.17MB + Index: 0.17MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.38MB + Index: 0.55MB + 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
    
    ### Post Type Counts ###
    
    amn_exact-metrics: 1
    attachment: 4686
    blocks: 210
    chch-pfc: 1
    chch-pop-up: 1
    custom_css: 2
    customize_changeset: 5
    display_type: 7
    elementor_library: 4
    featured_item: 8
    follow_up_email: 11
    jetpack_migration: 2
    mc4wp-form: 2
    ml-slider: 2
    nav_menu_item: 148
    oembed_cache: 7
    page: 21
    post: 9
    postman_sent_mail: 6
    product: 459
    product_variation: 2627
    revision: 53
    shop_coupon: 562
    shop_order: 27520
    shop_order_refund: 4231
    wc_stamps_label: 6
    wcpa_pt_forms: 2
    wcps: 1
    woocarousel: 3
    wpcf7_contact_form: 1
    wpcr3_review: 1
    wpforms: 1
    xlwcty_thankyou: 1
    yith-wcbm-badge: 1
    ywar_reviews: 132
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (34) ###
    
    ATUM Inventory Management for WooCommerce: by Stock Management Labs™ – 1.9.11.1
    Autoptimize: by Frank Goossens (futtta) – 2.9.5.1
    Better Font Awesome: by Mickey Kay – 2.0.1
    Classic Editor: by WordPress Contributors – 1.6.2
    Cloudflare: by Cloudflare
    Inc. – 4.6.0
    
    Code Snippets: by Code Snippets Pro – 2.14.3
    Customer Reviews for WooCommerce: by CusRev – 4.38
    Disable WooCommerce Bloat: by ospiotr – 2.6.5
    Nextend Social Login: by Nextendweb – 3.0.27
    Perfmatters: by forgemedia – 1.8.5
    WooCommerce Product Review to Google Merchant XML: by Taha Lamari – 0.0.1
    Read More Without Refresh: by George Gkouvousis – 3.1
    CM Commerce for WooCommerce: by Campaign Monitor – 1.6.6
    Redirection: by John Godley – 5.2.3
    Richpanel for WooCommerce: by Richpanel – 2.3.2
    Separate product colors pages link: by Taha Lamari – 0.0.2
    TaxJar - Sales Tax Automation for WooCommerce: by TaxJar – 4.1.1
    WooCommerce Thank You Page - NextMove: by XLPlugins – 1.15.1
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.22.4
    
    White Label CMS: by www.videousermanuals.com – 2.2.9
    Woocommerce Custom Product Addons: by Acowebs – 3.8.0
    Product Feed PRO for WooCommerce: by AdTribes.io – 11.3.6
    WooCommerce All in One Currency Converter: by Dev49.net – 2.12.1
    WooCommerce Email Customizer: by cxThemes – 3.33
    WooCommerce PayPal Payments: by WooCommerce – 1.7.0
    WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.13.0
    WooCommerce - ShipStation Integration: by WooCommerce – 4.1.48
    WooCommerce: by Automattic – 6.3.0
    WooCommerce Pixel Manager (Premium): by SweetCode – 1.14.2
    Yoast SEO: by Team Yoast – 16.9
    WP Mail SMTP: by WPForms – 3.2.1
    WP Super Cache: by Automattic – 1.7.7
    
    ### Inactive Plugins (4) ###
    
    Add to cart AJAX modal: by Taha Lamari – 0.0.1
    Contact Form 7: by Takayuki Miyoshi – 5.3.2
    ImgO: by Taha Lamari – 0.0.1
    WooCommerce - StampscomEndicia Integration: by Stamps.comEndicia – 2.0.0
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### 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)
    woosb (woosb)
    
    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: #260 - /store/
    Cart: #261 - /cart/
    Checkout: #262 - /checkout/
    My account: #263 - /my-account/
    Terms and conditions: #3960 - /terms-conditions/
    
    ### Theme ###
    
    Name: Flatsome Child
    Version: 3.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.15.3
    Parent Theme Author URL: http://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
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/admin-cancelled-order.php version 3.7.0 is out of date. The core version is 4.1.0
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/admin-failed-order.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/admin-new-order.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/customer-completed-order.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/customer-invoice.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/customer-new-account.php version 3.7.0 is out of date. The core version is 6.0.0
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/customer-note.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/customer-on-hold-order.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/customer-processing-order.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/customer-refunded-order.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/customer-reset-password.php version 3.7.0 is out of date. The core version is 4.0.0
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/email-addresses.php version 3.5.4 is out of date. The core version is 5.6.0
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/email-customer-details.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/email-downloads.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/email-footer.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/email-header.php version 2.4.0 is out of date. The core version is 4.0.0
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/email-order-details.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/email-order-items.php
    /var/www/gg/wp-content/plugins/woocommerce-email-control/templates/emails/deluxe/email-styles.php version 3.3.0 is out of date. The core version is 4.0.0
    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
    
    Outdated Templates: ❌
    					
    					
    						Learn how to update
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ✔
    Shop country code: US
    WooCommerce currency supported: ✔
    PayPal card processing available in country: ✔
    Pay Later messaging available in country: ✔
    Webhook status: ✔
    Vault enabled: ✔
    Logging enabled: –
    Reference Transactions: –
    Used PayPal Checkout plugin: ✔
    
    ### Action Scheduler ###
    
    Canceled: 2
    Oldest: 2022-02-12 16:06:21 -0800
    Newest: 2022-02-21 16:05:55 -0800
    
    Complete: 8,915
    Oldest: 2022-02-06 10:36:06 -0800
    Newest: 2022-03-09 10:30:10 -0800
    
    Failed: 1
    Oldest: 2022-03-08 17:06:58 -0800
    Newest: 2022-03-08 17:06:58 -0800
    
    Pending: 3
    Oldest: 2022-03-09 10:44:08 -0800
    Newest: 2022-03-09 16:00:04 -0800
    
    ### Status report information ###
    
    Generated at: 2022-03-09 10:32:03 -08:00
    
    Igor H

    (@ihereira)

    Hello,

    When checking the system status report, please notice:

    WP Version: ❌ 5.9 – There is a newer version of WordPress

    You will want to update your WordPress version first, here there is an article that explains how you can do it.

    Then you can use debug mode to find the issue.

    Debugging in WordPress

    If that does not work, you can perform a conflict test:

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

    For more information: You can find a more detailed explanation on how to do a conflict test here.

    Let us know how it goes.

    Thread Starter EliteGent

    (@gentlemako)

    We have tried all that, the issue is still there, most likely it’s from Woocommerce itself.

    Margaret S. woo-hc

    (@margaretwporg)

    Hi @gentlemako

    Thanks for letting us know that you’ve updated WordPress and have also performed a complete conflict test.

    Your system status shows that the current memory allocation is more than sufficient.
    WP Memory Limit: 1 GB

    1. It seems certain processes are running in the background that are drawing a huge chunk of the memory. Can you please have you host check that?

    2. Also, I see there are outdated templates in your Flatsome child theme. This is one area that needs corrected.
    Please refer to our documentation on how to update outdated templates: https://woocommerce.com/document/fix-outdated-templates-woocommerce/

    Margaret S. woo-hc

    (@margaretwporg)

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above info was helpful.

    If you have further questions, please feel free to open a new topic.

    Thread Starter EliteGent

    (@gentlemako)

    Hello there,

    This issue has not been resolved, all the info you guys gave me didn’t do anything. The only thing we know and highly to be true is this must be coming from Woocommerce Itself.

    Margaret S. woo-hc

    (@margaretwporg)

    Hi @gentlemako

    Thanks for responding! We will be glad to help you further.

    We understand the frustrating situation and the resultant belief that the problem must be coming from WooCommerce itself.

    So that we can move ahead with the troubleshooting, may I ask if you’ve performed steps 1 & 2 suggested in our previous interaction?

    We’ll look forward to hearing from you and will be happy to assist further.

    Cheers!

    Thread Starter EliteGent

    (@gentlemako)

    Hello Margaret,

    We have done step 2 already nothing happened, I’m still waiting for my dev to see what happened in the background when the Issue happen.

    Igor H

    (@ihereira)

    Hello,

    So sorry to hear about this situation.

    As mentioned previously please be sure to contact your host. Also, for us to check further, please provide the following information:

    * Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if any).

    Let us know, thanks.

    Margaret S. woo-hc

    (@margaretwporg)

    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 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Critical Error about running out of Memory’ is closed to new replies.