kidsinthekitchennz

Given that people with various themes are all suffering the same issue, and that it doesn’t work even with all other plugins disabled, I’m pretty sure this is a Woocommerce issue.

I had particularly bad symptoms because something was overriding my max execution time setting, which meant the rogue processes never exited. I’ve fixed that.

• This reply was modified 3 years, 1 month ago by kidsinthekitchennz.

I have got my site working by using Widget Disable plugin to disable Woocommerce widgets from the dashboard.

I disabled all plugins except Woocommerce, this makes no difference. I haven’t tried theme to default but I don’t think its relevant – can test this on staging once I get it up to date from prod.

Now I can log on fine and view the dashboard. So the issue is specific to the statistics widget I think.

• This reply was modified 3 years, 1 month ago by kidsinthekitchennz.
• This reply was modified 3 years, 1 month ago by kidsinthekitchennz.

Same issue in this topic : https://www.ads-software.com/support/topic/cant-open-wp-dashboard-after-update-to-wc-5-7-1/

I am using HTTP2 in Nginx.

• This reply was modified 3 years, 1 month ago by kidsinthekitchennz.
• This reply was modified 3 years, 1 month ago by kidsinthekitchennz.

I have exactly the same problem.

The Woocommerce update seemed to be OK after application (both 5.7 and then 5.7.1) and was applied to Prod server. As a security update, we updated a little quicker than normal.

Yesterday, somewhere between 9am and 11am NZ time, PHP CPU usage suddenly spikes according to my monitoring (NGINX Amplify). About that time, I had to log in again, and the wp-admin page would never complete logon, just process forever. However, if I went to the main site URL, the logon had worked, and I was able to get in to the site. Things kept getting sluggish as I was working, and I noticed several FPM-PHP processes using all the CPU.

Like the other person, I tried rolling back Woocommerce to 5.6.1 but that did not seem to help.

I enabled slow queries log in PHP FPM and I can see that the slow query is entirely made of calls to dashboard statistics:

`script_filename = /srv/websites/kidsinthekitchen.nz/wp-admin/index.php
[0x00007f99156168a0] __construct() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php:321
[0x00007f9915616510] next_day_start() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php:337
[0x00007f99156162e0] next_week_start() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php:478
[0x00007f9915616260] call_user_func() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/TimeInterval.php:478
[0x00007f9915616190] iterate() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/DataStore.php:635
[0x00007f9915616030] update_interval_boundary_dates() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/Orders/Stats/DataStore.php:409
[0x00007f9915615e40] get_data() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/includes/class-wc-data-store.php:207
[0x00007f9915615d90] __call() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/Revenue/Query.php:64
[0x00007f9915615c90] get_data() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/Revenue/Stats/Controller.php:73
[0x00007f99156157b0] get_items() /srv/websites/kidsinthekitchen.nz/wp-includes/rest-api/class-wp-rest-server.php:1140
[0x00007f99156156d0] respond_to_request() /srv/websites/kidsinthekitchen.nz/wp-includes/rest-api/class-wp-rest-server.php:987
[0x00007f99156155e0] dispatch() /srv/websites/kidsinthekitchen.nz/wp-includes/rest-api.php:495
[0x00007f9915615570] rest_do_request() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/PerformanceIndicators/Controller.php:383
[0x00007f99156153b0] get_stats_data() /srv/websites/kidsinthekitchen.nz/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Reports/PerformanceIndicators/Controller.php:420`

If I disable the Woocommerce plugin, the dashboard and logon work perfectly, but then obviously my webstore is very lacking in product.

### WordPress Environment ###

WordPress address (URL): https://kidsinthekitchen.nz
Site address (URL): https://kidsinthekitchen.nz
WC Version: 5.7.1
REST API Version: ? 5.7.1
WC Blocks Version: ? 5.9.1
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.6.5
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: ?
WP Cron: ?
Language: en_NZ
External object cache: ?

### Server Environment ###

Server Info: nginx/1.18.0
PHP Version: 7.4.3
PHP Post Max Size: 32 MB
PHP Time Limit: 0
PHP Max Input Vars: 2000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.31-MariaDB-0ubuntu0.20.04.1
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.7.1
WC Database Prefix: wp_
Total Database Size: 356.31MB
Database Data Size: 176.68MB
Database Index Size: 179.63MB
wp_woocommerce_sessions: Data: 2.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 13.52MB + Index: 14.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 1.02MB + Index: 0.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: 1.02MB + Index: 0.42MB + Engine InnoDB
wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 4.52MB + Index: 3.28MB + Engine InnoDB
wp_csp3_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 5.39MB + Index: 1.11MB + Engine InnoDB
wp_postmeta: Data: 42.56MB + Index: 29.00MB + Engine InnoDB
wp_posts: Data: 14.50MB + Index: 4.50MB + Engine InnoDB
wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 2.50MB + Index: 3.02MB + Engine InnoDB
wp_users: Data: 0.11MB + Index: 0.08MB + 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: 0.27MB + Index: 0.20MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.89MB + Engine InnoDB
wp_wc_order_stats: Data: 0.30MB + Index: 0.30MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 1.39MB + Index: 0.75MB + 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_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wps_hit: Data: 1.52MB + Index: 2.19MB + Engine InnoDB
wp_wps_index: Data: 70.61MB + Index: 107.89MB + Engine InnoDB
wp_wps_key: Data: 0.45MB + Index: 0.36MB + Engine InnoDB
wp_wps_object_term: Data: 2.22MB + Index: 3.92MB + Engine InnoDB
wp_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_wps_query: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_wps_uri: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
wp_wps_user_agent: Data: 0.16MB + Index: 0.06MB + Engine InnoDB
wp_yoast_indexable: Data: 5.47MB + Index: 4.28MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 1.33MB + Index: 0.59MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amn_wpforms-lite: 1
attachment: 4938
blocks: 3
br_labels: 5
br_popups: 1
custom_css: 4
customize_changeset: 4
hrf_faq: 75
jetpack_migration: 2
jp_img_sitemap: 6
jp_img_sitemap_index: 2
jp_sitemap: 2
jp_sitemap_master: 2
laybuy_quote: 64
ml-slide: 5
ml-slider: 1
nav_menu_item: 42
oembed_cache: 4
page: 17
pf_contact: 38
post: 15
product: 105
product_variation: 1990
revision: 352
ris_gallery: 1
seedprod: 3
shop_coupon: 19
shop_order: 4061
shop_order_refund: 12
ufaq: 1
wapl: 4
wcps: 1
woo_faq: 2
wpforms: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (33) ###

Query Monitor: by John Blackbourn – 3.7.1
Addy's NZ Address Autocomplete for WooCommerce: by Addy Limited – 2.1.7
Afterpay Gateway for WooCommerce: by Afterpay – 3.2.2
BackUpWordPress: by XIBO Ltd – 3.11
Facebook for WooCommerce: by Facebook – 2.6.5
Flexible Shipping: by WP Desk – 4.8.3
Gmail SMTP: by naa986 – 1.2.2
Google Authenticator: by Ivan Kruchkoff – 0.53
HTML5 Responsive FAQ: by Ankit Agarwal
Priyanshu Mittal – 2.8.5

Hummingbird: by WPMU DEV – 3.1.0
Jetpack: by Automattic – 10.1
Laybuy Gateway for WooCommerce: by Laybuy – 5.3.4
Markup by Attribute for WooCommerce: by MarkTomlinson – 3.9.6
MetaSlider: by MetaSlider – 3.23.0
Product Input Fields for WooCommerce: by Tyche Softwares – 1.3.1
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.6.0
Woo Discount Rules: by Flycart – 2.3.8
WooCommerce Blocks: by Automattic – 5.9.1
WPC Product Bundles for WooCommerce (Premium): by WPClever – 5.9.2
Additional Variation Images Gallery for WooCommerce - Pro: by Emran Ahmed – 1.2.7
Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.2.7
Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 1.1.18
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.19
WooCommerce Stripe Gateway: by WooCommerce – 5.5.0
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.3
WooCommerce POS: by kilbot – 0.4.26
WooCommerce Product Search: by itthinx – 4.0.1
WooCommerce Shipping & Tax: by WooCommerce – 1.25.18
WooCommerce: by Automattic – 5.7.1
Yoast SEO: by Team Yoast – 17.2
WP Rollback: by impress.org – 1.7.1
WPForms Lite: by WPForms – 1.6.9

### Inactive Plugins (1) ###

WooCommerce Advanced Product Labels: by BeRocket – 3.2.4.4

### Dropin Plugins (3) ###

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class
object-cache.php: Hummingbird Redis Object Cache

### Settings ###

API Enabled: ?
Force SSL: –
Currency: NZD ($)
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: #8 - /
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My account: #11 - /my-account/
Terms and conditions: #608 - /terms-and-conditions/

### Theme ###

Name: Flatsome
Version: 3.14.3
Author URL: https://www.uxthemes.com/
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
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
/srv/websites/kidsinthekitchen.nz/wp-content/plugins/woo-variation-gallery/templates/product-images.php
/srv/websites/kidsinthekitchen.nz/wp-content/plugins/woo-variation-gallery/templates/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 ###

Cancelled: 2
Oldest: 2021-09-25 14:03:23 +1200
Newest: 2021-09-25 15:40:40 +1200

Complete: 2,283
Oldest: 2021-08-26 19:19:44 +1200
Newest: 2021-09-26 10:43:58 +1300

Failed: 1
Oldest: 2021-05-04 22:51:27 +1200
Newest: 2021-05-04 22:51:27 +1200

Pending: 9
Oldest: 2021-09-26 13:00:00 +1300
Newest: 2021-10-03 03:41:02 +1300

### Status report information ###

Generated at: 2021-09-26 10:50:54 +13:00

Seems fixed. Thanks!

I’ve tried click the link to fix but it doesn’t help.

It seems to have fixed itself.