Fatal Error

Hey, gentlemako, I’m another WooCommerce user.

What version of PHP are you using out of curiosity?

Also, are you able to post what line number that you experienced the memory error? The error message you posted appears to cut off right before specifying the line in the file caused the issue.

Hey Ian,

Our PHP version is 8.0.6

This fatal Error is always seems to be on line 2153

Regards,

Hi @gentlemako ,

CRITICAL Allowed memory size of 1073741824 bytes exhausted (tried to allocate 8388648 bytes) in /var/www/gg/wp-includes/class-wpdb.php on lin

This error indicates your memory limit being exhausted. To resolve this issue you would need to increase your WordPress memory limit.

Below are some methods to try if you would like to do this on your own, alternatively you could reach out to your host provider to do this for you:

Edit your wp-config.php file
Add this to the top, before the line that says, “Happy Blogging”:

define(‘WP_MEMORY_LIMIT’, ‘256M’);

Edit your PHP.ini file
If you have access to your PHP.ini file, change the line in PHP.ini
If your line shows 64M try 256M:

memory_limit = 256M ; Maximum amount of memory a script may consume (64MB)

Edit your .htaccess file
If you don’t have access to PHP.ini try adding this to an .htaccess file:

php_value memory_limit 256M

Please see the below documentation for more information:

https://woocommerce.com/document/increasing-the-wordpress-memory-limit/

Should the issue persist, please can you share the following, in order to get a better understanding of your site setup:

• System Status: which you can find via WooCommerce → Status. Select Get system report and then Copy for support.
• Fatal Error log: Share a copy of any fatal error log found under WooCommerce → Status → Logs.

Once you have these, please share them in your response here.

Hello there,

We’ve done that many times, as you can see the error show the memory limit, we have already 1G in memory and this issue still hapening.

Our dev went through all the database queries and could not find what caused this. We have debugged the server and database queries and cannot find the real cause.

We’ve also disabled all plugin and this error still presist.

Regards,

Hi @gentlemako ,

Thanks for providing additional clarity on this.

Would you please share the full stack trace of this exact error, as part of it appears to be missing?

Additionally, please share the System Status report as requested earlier, in order to have a better understanding of your sites environment.

We’ll be happy to take a closer look!

2023-01-23T00:28:17+00:00 CRITICAL Allowed memory size of 1073741824 bytes exhausted (tried to allocate 16777256 bytes) in /var/www/gg/wp-includes/class-wpdb.php on line 2153

2023-01-23T11:32:59+00:00 CRITICAL Allowed memory size of 1073741824 bytes exhausted (tried to allocate 8388648 bytes) in /var/www/gg/wp-includes/class-wpdb.php on line 2153

2023-01-23T20:57:55+00:00 CRITICAL Allowed memory size of 1073741824 bytes exhausted (tried to allocate 16777256 bytes) in /var/www/gg/wp-includes/class-wpdb.php on line 2153

`
### WordPress Environment ###

WordPress address (URL): https://www.********.com
Site address (URL): https://www.********.com
WC Version: 7.3.0
REST API Version: ?</img> 7.3.0
WC Blocks Version: ?</img> 9.1.5
Action Scheduler Version: ?</img> 3.5.3
Log Directory Writable: ?</img>
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?</img>
Language: en_US
External object cache: ?</img>

### 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: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

### Database ###

WC Database Version: 7.3.0
WC Database Prefix: wp_
Total Database Size: 1354.22MB
Database Data Size: 1123.21MB
Database Index Size: 231.01MB
wp_woocommerce_sessions: Data: 2.97MB + Index: 0.03MB + 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: 7.48MB + Index: 3.01MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 90.33MB + Index: 37.81MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.16MB + Index: 0.14MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.23MB + Index: 0.30MB + 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: 2.52MB + Index: 1.83MB + 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: 0.95MB + Engine InnoDB
wp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_atum_logs: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
wp_atum_logs_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_atum_logs_cache_var: Data: 2.52MB + Index: 1.89MB + Engine InnoDB
wp_atum_order_itemmeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_atum_order_items: Data: 0.20MB + Index: 0.06MB + Engine InnoDB
wp_atum_product_data: Data: 0.52MB + Index: 0.25MB + Engine InnoDB
wp_barcode_gen2_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_gen2_codes_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_gen2_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_gen2_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_gen2_files: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
wp_barcode_gen2_shortcodes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_gen2_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_gen2_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_gen2_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_scanner_interface: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_scanner_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_scanner_logs: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_barcode_scanner_posts: Data: 9.52MB + Index: 1.52MB + Engine InnoDB
wp_barcode_scanner_posts_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_scanner_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_v3_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 2.97MB + Index: 1.79MB + Engine MyISAM
wp_comments: Data: 62.93MB + Index: 26.25MB + Engine MyISAM
wp_cr_local_forms: Data: 3.52MB + Index: 0.09MB + Engine InnoDB
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 5.11MB + Index: 0.22MB + Engine MyISAM
wp_postmeta: Data: 801.92MB + Index: 100.17MB + Engine MyISAM
wp_posts: Data: 26.91MB + Index: 7.02MB + Engine MyISAM
wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_redirection_items: Data: 0.27MB + Index: 0.25MB + Engine InnoDB
wp_redirection_logs: Data: 18.55MB + Index: 4.55MB + Engine InnoDB
wp_shareasale_wc_tracker_datafeeds: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_social_users: Data: 0.05MB + Index: 0.06MB + Engine MyISAM
wp_taxjar_record_queue: Data: 4.52MB + Index: 1.52MB + Engine InnoDB
wp_termmeta: Data: 0.08MB + Index: 0.05MB + Engine MyISAM
wp_terms: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
wp_term_relationships: Data: 0.68MB + Index: 1.30MB + Engine MyISAM
wp_term_taxonomy: Data: 0.08MB + Index: 0.02MB + 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: 7.66MB + Index: 2.65MB + Engine MyISAM
wp_users: Data: 0.46MB + Index: 0.35MB + Engine MyISAM
wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_packing_slip_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.88MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.25MB + Index: 0.27MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 7.52MB + Index: 6.06MB + Engine InnoDB
wp_wc_order_stats: Data: 5.52MB + Index: 4.55MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.19MB + Index: 0.14MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.47MB + Index: 0.67MB + 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_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 15.55MB + Index: 11.09MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 1.52MB + Index: 1.20MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_yoast_seo_links: Data: 25.29MB + Index: 2.91MB + Engine MyISAM
wp_yoast_seo_meta: Data: 4.00MB + Index: 4.03MB + Engine MyISAM

### Post Type Counts ###

amn_exact-metrics: 1
attachment: 5536
atum_po_delivery: 68
atum_purchase_order: 324
atum_supplier: 15
blocks: 330
chch-pfc: 1
chch-pop-up: 1
custom_css: 2
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: 210
oembed_cache: 7
page: 21
post: 320
postman_sent_mail: 6
product: 512
product_variation: 3053
revision: 17
scheduled-action: 13875
shop_coupon: 4211
shop_order: 37828
shop_order_refund: 6004
wc_stamps_label: 6
wcpa_pt_forms: 2
wcps: 1
woocarousel: 3
wpcr3_review: 1
wpforms: 1
xlwcty_thankyou: 1
yith-wcbm-badge: 1
ywar_reviews: 132

### Security ###

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

### Active Plugins (43) ###

Pixel Manager for WooCommerce (Premium): by SweetCode – 1.29.1
ATUM Action Logs: by Stock Management Labs? – 1.3.3
ATUM Purchase Orders PRO: by Stock Management Labs? – 1.0.8
ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.9.26.2
Autoptimize: by Frank Goossens (futtta) – 3.1.4
Barcode Generator - create barcodes for products, orders, emails - (basic): by UkrSolution – 2.0.0
Barcode Scanner with Inventory & Order Manager - (mobile): by UkrSolution – 1.3.0
Barcode Scanner with Inventory & Order Manager - (premium): by  – 1.3.0
Better Font Awesome: by Mickey Kay – 2.0.3
Classic Editor: by WordPress Contributors – 1.6.2
Cloudflare: by Cloudflare
Inc. – 4.6.0

Code Snippets: by Code Snippets Pro – 3.1.1
Customer Reviews for WooCommerce: by CusRev – 5.3.5
Disable Bloat for WordPress & WooCommerce: by Disable Bloat – 3.0.3
Docket Cache: by Nawawi Jamili – 22.07.02
Nextend Social Login: by Nextendweb – 3.1.5
Perfmatters: by forgemedia – 2.0.2
Barcode Printing for WooCommerce & Contact Form 7 - (basic): by UkrSolution – 3.4.4
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.7
Separate product colors pages link: by Taha Lamari – 0.0.2
ShareASale WooCommerce Tracker: by ShareASale.com
Inc. – 1.5.3

TaxJar - Sales Tax Automation for WooCommerce: by TaxJar – 4.1.5
WooCommerce Thank You Page - NextMove: by XLPlugins – 1.15.1
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.22.24

White Label CMS: by www.videousermanuals.com – 2.5
Woocommerce Custom Product Addons: by Acowebs – 4.2.1
Product Feed PRO for WooCommerce: by AdTribes.io – 12.0.4
WooCommerce All in One Currency Converter: by Dev49.net – 2.12.1
WooCommerce Email Customizer: by cxThemes – 3.33
WooCommerce PayPal Payments: by WooCommerce – 2.0.1
WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 3.0.1
WooCommerce - ShipStation Integration: by WooCommerce – 4.3.2
WooCommerce: by Automattic – 7.3.0
Yoast SEO: by Team Yoast – 18.9
WP Mail SMTP: by WPForms – 3.2.1
WP Rollback: by GiveWP.com – 1.7.3
WP Super Cache: by Automattic – 1.9.2

### Inactive Plugins (3) ###

Add to cart AJAX modal: by Taha Lamari – 0.0.1
ImgO: by Taha Lamari – 0.0.1
WooCommerce - StampscomEndicia Integration: by Stamps.comEndicia – 2.0.0

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
object-cache.php: Docket Cache Drop-in

### Settings ###

API Enabled: ?</img>
Force SSL: ?</img>
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: –
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT

### 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: ?</img>
Parent Theme Name: Flatsome
Parent Theme Version: 3.16.5
Parent Theme Author URL: https://uxthemes.com
WooCommerce Support: ?</img>

### 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 version 3.7.0 is out of date. The core version is 7.3.0
/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/rating.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: ?</img>
					
					
						Learn how to update

### WooCommerce PayPal Payments ###

Onboarded: ?</img>
Shop country code: US
WooCommerce currency supported: ?</img>
Advanced Card Processing available in country: ?</img>
Pay Later messaging available in country: ?</img>
Webhook status: –
Vault enabled: ?</img>
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: ?</img>
Tracking enabled: –

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
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
settings

Daily Cron: ?</img> Next scheduled: 2023-01-24 22:06:14 -08:00
Options: ?</img>
Notes: 3
Onboarding: completed

### Action Scheduler ###

Complete: 13,137
Oldest: 2022-12-24 11:08:53 -0800
Newest: 2023-01-24 10:46:29 -0800

Pending: 71
Oldest: 2023-01-24 10:44:21 -0800
Newest: 2023-01-30 14:09:58 -0800

Canceled: 633
Oldest: 2023-01-08 02:02:00 -0800
Newest: 2023-01-24 16:00:07 -0800

In-progress: 1
Oldest: –
Newest: –

Failed: 33
Oldest: -0001-11-29 16:07:02 -0752
Newest: 2022-11-08 11:54:19 -0800


### Status report information ###

Generated at: 2023-01-24 10:46:58 -08:00
`

Hi @gentlemako

As per the error logs, these are incomplete since we cannot fully verify what plugin are causing this conflict on your site.

Pending: 71

Checking on your site’s System Status Report, there are a lot of pending tasks. Please try to run them manually by going to WooCommerce > Status > Scheduled Actions > Pending.

Then, please try to switch to the default Storefront theme and only WooCommerce plugin is enabled and see if this works?

If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

Let us know how it goes!

Hello there,

We have done all the instructions provided, deactivated all plugins, and left only Woocomerce. The problem is still persisting, we have upgraded memory to 2GB, and it’s still there.

Please advise.

• This reply was modified 1 year, 9 months ago by EliteGent.

Hi @gentlemako

I understand that increasing your memory size to 2 GB did not resolve the issue here.

Can you please share the updated fatal error logs on your site?

Hello there,

After looking into this for almost a year, I found this thread on Github about the problem with Action-Scheduler having thousands of comments and crashing the wp-dashboard.

We had to run the hook mentioned on the thread to clean all the comments instead of waiting 6 months to do so automatically, in the meantime, we’re just waiting to see if the issue still presist.

Regards

• This reply was modified 1 year, 9 months ago by EliteGent.

Hi @gentlemako ,

Thanks for providing an update!

Please do let us know how this goes.

Cheers!

Hello there,

The issue still persists, and now we see the errors way more than before, as I confirmed before we have deactivated all plugins and this is still happening, please advise.

Any updates, this issue is costing us a lot of money by slowing down the website and sometimes even server shut down please advise.

After long hours of troubleshooting the only error we could find for this in the same line the fatal error is happening is the following.

mysqli_query(?$mysql =?class mysqli { public $affected_rows = -1; public $client_info = ‘mysqlnd 8.0.6’; public $client_version = 80006; public $connect_errno = 0; public $connect_error = NULL; public $errno = 0; public $error = ”; public $error_list = []; public $field_count = 3; public $host_info = ‘mysql via TCP/IP’; public $info = NULL; public $insert_id = 0; public $server_info = ‘5.7.34’; public $server_version = 50734; public $sqlstate = ‘00000’; public $protocol_version = 10; public $thread_id = 1264; public $warning_count = 0 },?$query =?‘SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (389146,395066,395124,395178,397794,397847,398352,398411,398480,417042,420269,420500,420615,420728,420796,421130,421203,421318,421468,421552,422022,422169,422265,422360,422492) ORDER BY meta_id ASC’?)

Please advise.

Hi!
Have you ever tried to switch back to PHP 7.4?
I had the same problem with my staging site trying to get it to work with PHP 8.1 – but not with product or comment updates. Our site generally exceeded the memory limit with 8.1.
After switching back to 7.4. there was no problem.
I tried to figure out which plugin causes this – but couldn’t find it.
Maybe it’s worth trying.