Pagal khana drama wikipedia english,Real money pokies Australia app.Recharge Every day and Get Bonus up-to 50%!

Resolved

(@varchar19)

After updating to 5.4.1 we are seeing what appears to be a recurrence of this issue: https://github.com/woocommerce/woocommerce-admin/issues/3664

Unfortunately, however, this query is not just slow —?it’s endless. Each time someone views a WooCommerce admin page, this query is generated and will run forever, and the user will receive a timeout unless it is killed promptly:

SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, low_stock_amount_meta.meta_value AS low_stock_amount, MAX( product_lookup.date_created ) AS last_order_date FROM wp_posts  LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_id  LEFT JOIN wp_postmeta AS low_stock_amount_meta ON wp_posts.ID = low_stock_amount_meta.post_id AND low_stock_amount_meta.meta_key = '_low_stock_amount'  LEFT JOIN wp_wc_order_product_lookup product_lookup ON wp_posts.ID = CASE
				WHEN wp_posts.post_type = 'product' THEN product_lookup.product_id
				WHEN wp_posts.post_type = 'product_variation' THEN product_lookup.variation_id
			END WHERE 1=1  AND wp_posts.post_type IN ('product', 'product_variation') AND ((wp_posts.post_status = 'publish'))
			AND wc_product_meta_lookup.stock_quantity IS NOT NULL
			AND wc_product_meta_lookup.stock_status IN('instock','outofstock')
			AND (
				(
					low_stock_amount_meta.meta_value > ''
					AND wc_product_meta_lookup.stock_quantity <= CAST(low_stock_amount_meta.meta_value AS SIGNED)
				)
				OR (
					(
						low_stock_amount_meta.meta_value IS NULL OR low_stock_amount_meta.meta_value <= ''
					)
					AND wc_product_meta_lookup.stock_quantity <= 2
				)
			) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC, wp_posts.ID DESC LIMIT 0, 1

I’d be thrilled if there were a way to simply kill this query, disabling the low stock notification badge, until deeper analysis can be performed or a fix found.

Any thoughts or hope? This is rather crippling to our operations.

(Yes, this occurs with WooCommerce as the only active plugin. Yes, we’re good on RAM. Yes, we’ve tried what we can think of. ?? )

Viewing 9 replies - 1 through 9 (of 9 total)

Mirko P.

(@rainfallnixfig)

3 years, 4 months ago

Hi @varchar19,

In order to try to troubleshoot this issue and further check kindly provide us the following:

System Status: 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.
Error log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

I’d be thrilled if there were a way to simply kill this query, disabling the low stock notification badge, until deeper analysis can be performed or a fix found.

The Stock display format value under WooCommerce → Settings → Products → Inventory can be set to “Never show quantity remaining in stock” in order to hide the low stock quantity display in the front end.

Thanks.

Thread Starter

One Island

(@varchar19)

3 years, 4 months ago

Thanks for the response, @rainfallnixfig! The stock display in the frontend isn’t the problem, frustratingly. I know where the switch for that is. ?? If you refer to the example I gave above, it’s related to analytics in the built-in WooCommerce Admin bits and pieces. Once I disabled that —?not as simple as it could be —?things were passably functional.

Happily, there have been no fatal errors logged since the upgrade. There were several before related to a known password change issue, but no others in quite some time. Again, nothing since this problem surfaced.

For the system report, I’ve redacted the site name, as providing such deep information about it publicly isn’t wise, but everything else you want is below and I’m open to disclosing it in private message if proven necessary:


### WordPress Environment ###

WordPress address (URL): **
Site address (URL): **
WC Version: 5.4.1
REST API Version: ? 5.4.1
WC Blocks Version: ? 5.5.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.3.1
Log Directory Writable: ?
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: ?

### Server Environment ###

Server Info: nginx/1.14.2
PHP Version: 7.4.13
PHP Post Max Size: 2 GB
PHP Time Limit: 300
PHP Max Input Vars: 20000
cURL Version: 7.47.0
OpenSSL/1.0.2g

SUHOSIN Installed: –
MySQL Version: 5.7.25-0ubuntu0.16.04.2
Max Upload Size: 2 GB
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: 5.4.1
WC Database Prefix: wp_
Total Database Size: 5378.37MB
Database Data Size: 3781.51MB
Database Index Size: 1596.86MB
wp_woocommerce_sessions: Data: 10.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: 9.52MB + Index: 2.52MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 107.64MB + Index: 101.27MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + 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: 52.11MB + Index: 28.11MB + 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: 19.06MB + Index: 15.03MB + Engine InnoDB
wp_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aepc_logs: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_failed_logins: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_login_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_login_lockdown: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_permanent_block: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 7.52MB + Index: 9.03MB + Engine InnoDB
wp_comments: Data: 135.69MB + Index: 72.19MB + Engine InnoDB
wp_duplicator_packages: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 20.23MB + Index: 2.27MB + Engine InnoDB
wp_pimwick_gift_card: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_pimwick_gift_card_activity: Data: 0.17MB + Index: 0.05MB + Engine InnoDB
wp_postmeta: Data: 2584.84MB + Index: 830.61MB + Engine InnoDB
wp_posts: Data: 195.73MB + Index: 87.75MB + Engine InnoDB
wp_ps_exclude: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ps_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ps_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ps_product_sku: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_relevanssi: Data: 31.31MB + Index: 38.72MB + Engine InnoDB
wp_relevanssi_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_relevanssi_stopwords: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_snippets: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_stockmanager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.20MB + Index: 0.30MB + Engine InnoDB
wp_terms: Data: 0.41MB + Index: 0.52MB + Engine InnoDB
wp_term_relationships: Data: 160.75MB + Index: 70.61MB + Engine InnoDB
wp_term_taxonomy: Data: 0.52MB + Index: 0.56MB + Engine InnoDB
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: 76.53MB + Index: 52.92MB + Engine InnoDB
wp_users: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
wp_wcpt_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wcsc_error_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wcsc_logs: Data: 0.25MB + Index: 0.22MB + 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: 1.52MB + Index: 0.33MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.38MB + Index: 0.47MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 4.52MB + Index: 5.05MB + Engine InnoDB
wp_wc_order_stats: Data: 12.52MB + Index: 13.53MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.20MB + Index: 0.17MB + Engine InnoDB
wp_wc_point_of_sale_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_point_of_sale_sale_reports: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_poin_of_sale_tabs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_poin_of_sale_tabs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 5.52MB + Index: 9.09MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.20MB + 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_wfBlockedIPLog: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfConfig: Data: 2.28MB + Index: 0.00MB + Engine InnoDB
wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfFileMods: Data: 8.52MB + Index: 0.00MB + Engine InnoDB
wp_wfHits: Data: 1.02MB + Index: 0.23MB + Engine InnoDB
wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfKnownFileList: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
wp_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfLogins: Data: 1.02MB + Index: 0.16MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfNotifications: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfStatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wp_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woof_query_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmelon_advbedit_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wp_wc_poin_of_sale_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wsal_metadata: Data: 78.61MB + Index: 131.50MB + Engine InnoDB
wp_wsal_occurrences: Data: 4.52MB + Index: 6.00MB + Engine InnoDB
wp_wsal_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_indexable: Data: 226.88MB + Index: 111.25MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 3.28MB + Index: 3.94MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_yoast_prominent_words: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.50MB + Index: 0.27MB + Engine InnoDB
wp_yoast_seo_meta: Data: 6.52MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amn_exact-metrics: 1
attachment: 281740
faq: 7
mts_notification_bar: 3
nav_menu_item: 67
oembed_cache: 30
op_transaction: 1
page: 50
popup: 2
popup_theme: 6
post: 4
pos_temp_register_or: 8
product: 1963
product_variation: 75007
revision: 2077
rp_shop_giftcard: 33
shop_coupon: 11732
shop_order: 116177
shop_order_refund: 1842
sidebar: 1
soliloquy: 12
sp_wps_shortcodes: 1
wc_product_table: 2
woocarousel: 3
woocarouselpro: 12
woo_discount: 1
wpforms: 1
wpl_wcslider: 1
yith_wcps_type: 1
_op_register: 1

### Security ###

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

### Active Plugins (39) ###

Query Monitor: by John Blackbourn – 3.7.1
WP Activity Log for Yoast SEO: by WP White Security – 1.1.0
CDN Enabler: by KeyCDN – 2.0.3
Child Theme Wizard: by Jay Versluis – 1.4
Code Snippets: by Code Snippets Pro – 2.14.1
Customer Reviews for WooCommerce: by CusRev – 4.18
Disable WooCommerce Bloat: by ospiotr – 2.4.10
GAinWP Google Analytics Integration for WordPress: by IntelligenceWP – 5.4.6
Pixel Caffeine: by AdEspresso – 2.3.3
Product Filter for WooCommerce: by 7VX LLC
USA CA – 7.2.7

PW WooCommerce Gift Cards Pro: by Pimwick
LLC – 1.283

Quick and Easy FAQs: by Inspiry Themes – 1.3.4
Redis Object Cache: by Till Krüss – 2.0.18
Relevanssi: by Mikko Saari – 4.13.2
Simple Custom CSS: by John Regan
Danny Van Kooten – 4.0.4

Simple Sales Tax: by TaxCloud – 6.3.7
Social Icons Widget & Block by WPZOOM: by WPZOOM – 4.1.3
WC Hide Shipping Methods: by Rynaldo Stoltz – 1.4
WooCommerce Blocks: by Automattic – 5.5.0
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.17
Woocommerce Variations Table - Grid: by Spyros Vlachopoulos – 1.3.10
WooCommerce Advanced Bulk Edit: by George Iron – 4.5
WooCommerce Cart Stock Reducer: by James Golovich – 3.40
Clear Cart & Sessions for WooCommerce: by Puri.io – 1.4.8
WooCommerce Stripe Gateway: by WooCommerce – 5.2.3
WooCommerce Product SKU Generator: by SkyVerge – 2.4.5
WooCommerce Shipping & Tax: by WooCommerce – 1.25.15
WooCommerce - ShipStation Integration: by WooCommerce – 4.1.42
WooCommerce Table Rate Shipping: by Bolder Elements – 4.2
WooCommerce: by Automattic – 5.4.1
WooSidebars: by WooCommerce – 1.4.5
Wordfence Security: by Wordfence – 7.5.4
Yoast SEO Premium: by Team Yoast – 15.4
WP Activity Log for WooCommerce: by WP White Security – 1.2.2
WP Mail SMTP: by WPForms – 2.9.0
WP Notification Bars: by MyThemeShop – 1.0.5
WP Rocket: by WP Media – 3.9.0.5
WP Activity Log (Premium): by WP White Security – 4.3.0
WPForms Lite: by WPForms – 1.6.7.3

### Inactive Plugins (27) ###

Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.2.6
Advanced Cron Manager: by BracketSpace – 2.4.1
Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.9
Duplicator: by Snap Creek – 1.4.2
Facebook for WooCommerce: by Facebook – 2.6.1
Jetpack: by Automattic – 9.9
Multiple Domain Mapping on single site: by Matthias Wagner - FALKEmedia – 1.0.5
Popup Maker: by Popup Maker – 1.16.2
Really Simple SSL: by Really Simple Plugins – 5.0.2
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Related Products for WooCommerce: by Vagelis P. – 3.3.3
Springbot WooCommerce Integration: by Springbot – 0.0.15
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.56

WooCommerce Admin: by WooCommerce – 2.4.1
WooCommerce Advanced Bulk Edit: by George Iron – 4.4.4-beta1
WooCommerce Conversion Tracking: by weDevs – 2.0.8
Woocommerce Product Recent Variations: by Arghya Dutta – 1.0.0
WooCommerce Product Table PRO: by WC Product Table – 2.1.0
Woocommerce Variations Table - Grid: by Spyros Vlachopoulos – 1.3.11
Woo Discount Rules: by Flycart – 2.3.7
Woo Product Category Discount Pro: by WooExtend – 3.12
WP-Cron Status Checker: by Webhead LLC – 1.2.2
WP Activity Log: by WP White Security – 4.3.1
WP Crontrol: by John Blackbourn & crontributors – 1.10.0
YITH WooCommerce Compare: by YITH – 2.5.2
YITH WooCommerce Product Slider Carousel: by YITH – 1.0.54
Yoast SEO: by Team Yoast – 16.6.1

### Dropin Plugins (3) ###

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

### 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)
pw gift card (pw-gift-card)
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: #3852 - /store/
Cart: #5 - /cart/
Checkout: #6 - /checkout/
My account: #7 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Storefront
Version: (update to version 0 is available)
Author URL: 
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 2.9.0 – 3.7.0 is available
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 83,479
Oldest: 2021-06-07 18:34:53 -0700
Newest: 2021-07-08 18:33:41 -0700

Failed: 2
Oldest: –
Newest: –

Pending: 9
Oldest: -0001-11-29 16:07:02 -0752
Newest: 2021-07-14 20:44:55 -0700

### Status report information ###

Generated at: 2021-07-08 18:35:08 -07:00

Mirko P.

(@rainfallnixfig)

3 years, 4 months ago

Hi again,

Thanks for your System Status report and for the additional comments.

With the recent WooCommerce update, there might have been changes in the core plugin such that one or more of your active plugins might be incompatible, using deprecated functions, running conflicting commands, etc.

A conflict test might help narrow down to the specific cause, if that’s the case. So, I would definitely recommend performing a conflict test to see if something comes up following this guide:

https://docs.woocommerce.com/document/how-to-test-for-conflicts/

Also, you could check with your host if caching is enabled server-side and temporarily disable it to see if it makes some difference. Drop-in plugins can’t be managed from the WordPress admin, so you should manage and deactivate them on your server.

Thanks.

This reply was modified 3 years, 4 months ago by Mirko P..

Thread Starter

One Island

(@varchar19)

3 years, 4 months ago

From my original post: “Yes, this occurs with WooCommerce as the only active plugin.”

This includes drop-in plugins.

If it helps, here’s a status report from a copy of the site running on a different server, which has everything save WooCommerce disabled.

It exhibits the same problem.

This is happening in a core WooCommerce module, as I called out above. The SQL is there to see. Please tell me how to reach someone who can help troubleshoot this specific endless query.


### WordPress Environment ###

WordPress address (URL): https://dev2.otbdiscs.com
Site address (URL): https://dev2.otbdiscs.com
WC Version: 5.4.1
REST API Version: ? 5.4.1
WC Blocks Version: ? 5.1.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.3.1
Log Directory Writable: ?
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: nginx/1.14.2
PHP Version: 7.4.13
PHP Post Max Size: 2 GB
PHP Time Limit: 300
PHP Max Input Vars: 20000
cURL Version: 7.47.0
OpenSSL/1.0.2g

SUHOSIN Installed: –
MySQL Version: 5.7.25-0ubuntu0.16.04.2
Max Upload Size: 2 GB
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: 5.4.1
WC Database Prefix: wp_
Total Database Size: 5321.86MB
Database Data Size: 3742.15MB
Database Index Size: 1579.71MB
wp_woocommerce_sessions: Data: 0.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: 9.52MB + Index: 2.52MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 107.64MB + Index: 101.27MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + 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: 53.09MB + Index: 27.11MB + 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: 19.05MB + Index: 15.03MB + Engine InnoDB
wp_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aepc_logs: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_failed_logins: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_login_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_login_lockdown: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_permanent_block: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 7.52MB + Index: 9.03MB + Engine InnoDB
wp_comments: Data: 135.69MB + Index: 72.19MB + Engine InnoDB
wp_duplicator_packages: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 20.22MB + Index: 2.27MB + Engine InnoDB
wp_pimwick_gift_card: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_pimwick_gift_card_activity: Data: 0.17MB + Index: 0.05MB + Engine InnoDB
wp_postmeta: Data: 2584.84MB + Index: 830.61MB + Engine InnoDB
wp_posts: Data: 195.73MB + Index: 87.75MB + Engine InnoDB
wp_ps_exclude: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ps_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ps_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ps_product_sku: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_relevanssi: Data: 25.56MB + Index: 42.67MB + Engine InnoDB
wp_relevanssi_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_relevanssi_stopwords: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_snippets: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_stockmanager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.20MB + Index: 0.30MB + Engine InnoDB
wp_terms: Data: 0.41MB + Index: 0.52MB + Engine InnoDB
wp_term_relationships: Data: 160.75MB + Index: 70.61MB + Engine InnoDB
wp_term_taxonomy: Data: 0.52MB + Index: 0.56MB + Engine InnoDB
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: 76.53MB + Index: 52.92MB + Engine InnoDB
wp_users: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
wp_wcpt_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wcsc_error_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wcsc_logs: Data: 0.25MB + Index: 0.22MB + 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: 1.52MB + Index: 0.33MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.38MB + Index: 0.47MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 4.52MB + Index: 5.05MB + Engine InnoDB
wp_wc_order_stats: Data: 12.52MB + Index: 13.53MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.20MB + Index: 0.17MB + Engine InnoDB
wp_wc_point_of_sale_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_point_of_sale_sale_reports: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_poin_of_sale_tabs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_poin_of_sale_tabs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 5.52MB + Index: 9.09MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.22MB + 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_wfBlockedIPLog: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfConfig: Data: 2.28MB + Index: 0.00MB + Engine InnoDB
wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfFileMods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfHits: Data: 1.02MB + Index: 0.22MB + Engine InnoDB
wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfKnownFileList: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
wp_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfLogins: Data: 1.02MB + Index: 0.16MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfNotifications: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfStatus: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
wp_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woof_query_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmelon_advbedit_temp: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wp_wc_poin_of_sale_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wsal_metadata: Data: 62.59MB + Index: 104.44MB + Engine InnoDB
wp_wsal_occurrences: Data: 4.52MB + Index: 6.00MB + Engine InnoDB
wp_wsal_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_indexable: Data: 226.78MB + Index: 118.19MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 3.28MB + Index: 3.94MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_yoast_prominent_words: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.47MB + Index: 0.25MB + Engine InnoDB
wp_yoast_seo_meta: Data: 6.52MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amn_exact-metrics: 1
attachment: 278080
faq: 7
mts_notification_bar: 3
nav_menu_item: 67
oembed_cache: 30
op_transaction: 1
page: 50
popup: 2
popup_theme: 6
post: 2
pos_temp_register_or: 8
product: 1942
product_variation: 73941
revision: 2046
rp_shop_giftcard: 33
shop_coupon: 11524
shop_order: 114036
shop_order_refund: 1814
sidebar: 1
soliloquy: 12
sp_wps_shortcodes: 1
wc_product_table: 2
woocarousel: 3
woocarouselpro: 12
woo_discount: 1
wpforms: 1
wpl_wcslider: 1
yith_wcps_type: 1
_op_register: 1

### Security ###

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

### Active Plugins (1) ###

WooCommerce: by Automattic – 5.4.1

### Inactive Plugins (64) ###

Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.2.6
Advanced Cron Manager: by BracketSpace – 2.4.1
Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.9
CDN Enabler: by KeyCDN – 2.0.3
Child Theme Wizard: by Jay Versluis – 1.4
Clear Cart & Sessions for WooCommerce: by Puri.io – 1.4.8
Code Snippets: by Code Snippets Pro – 2.14.1
Customer Reviews for WooCommerce: by CusRev – 4.18
Duplicator: by Snap Creek – 1.4.1
Facebook for WooCommerce: by Facebook – 2.6.1
GAinWP Google Analytics Integration for WordPress: by IntelligenceWP – 5.4.6
Jetpack: by Automattic – 9.9
Multiple Domain Mapping on single site: by Matthias Wagner - FALKEmedia – 1.0.5
Pixel Caffeine: by AdEspresso – 2.3.3
Popup Maker: by Popup Maker – 1.16.2
Product Filter for WooCommerce: by 7VX LLC
USA CA – 7.2.7

PW WooCommerce Gift Cards Pro: by Pimwick
LLC – 1.283

Query Monitor: by John Blackbourn – 3.7.1
Quick and Easy FAQs: by Inspiry Themes – 1.3.4
Really Simple SSL: by Really Simple Plugins – 5.0.2
Redis Object Cache: by Till Krüss – 2.0.18
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Related Products for WooCommerce: by Vagelis P. – 3.3.3
Relevanssi: by Mikko Saari – 4.13.2
Simple Custom CSS: by John Regan
Danny Van Kooten – 4.0.4

Simple Sales Tax: by TaxCloud – 6.3.7
Social Icons Widget & Block by WPZOOM: by WPZOOM – 4.1.3
Springbot WooCommerce Integration: by Springbot – 0.0.15
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.56

Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.17
WC Hide Shipping Methods: by Rynaldo Stoltz – 1.4
WooCommerce - ShipStation Integration: by WooCommerce – 4.1.42
WooCommerce Admin: by WooCommerce – 2.4.1
WooCommerce Advanced Bulk Edit: by George Iron – 4.4.4-beta1
WooCommerce Advanced Bulk Edit: by George Iron – 4.5
WooCommerce Blocks: by Automattic – 5.5.0
WooCommerce Cart Stock Reducer: by James Golovich – 3.40
WooCommerce Conversion Tracking: by weDevs – 2.0.8
Woocommerce Product Recent Variations: by Arghya Dutta – 1.0.0
WooCommerce Product SKU Generator: by SkyVerge – 2.4.5
WooCommerce Product Table PRO: by WC Product Table – 2.1.0
WooCommerce Shipping & Tax: by WooCommerce – 1.25.15 (update to version 1.25.16 is available)
WooCommerce Stripe Gateway: by WooCommerce – 5.2.3
WooCommerce Table Rate Shipping: by Bolder Elements – 4.2
Woocommerce Variations Table - Grid: by Spyros Vlachopoulos – 1.3.10
Woocommerce Variations Table - Grid: by Spyros Vlachopoulos – 1.3.11
Woo Discount Rules: by Flycart – 2.3.7
Woo Product Category Discount Pro: by WooExtend – 3.12
WooSidebars: by WooCommerce – 1.4.5
Wordfence Security: by Wordfence – 7.5.4
WP-Cron Status Checker: by Webhead LLC – 1.2.2
WP Activity Log: by WP White Security – 4.3.1
WP Activity Log (Premium): by WP White Security – 4.3.0
WP Activity Log for WooCommerce: by WP White Security – 1.2.2
WP Activity Log for Yoast SEO: by WP White Security – 1.1.0
WP Crontrol: by John Blackbourn & crontributors – 1.10.0
WPForms Lite: by WPForms – 1.6.7.3
WP Mail SMTP: by WPForms – 2.9.0
WP Notification Bars: by MyThemeShop – 1.0.5
WP Rocket: by WP Media – 3.9.0.5
YITH WooCommerce Compare: by YITH – 2.5.2
YITH WooCommerce Product Slider Carousel: by YITH – 1.0.54
Yoast SEO: by Team Yoast – 16.6.1
Yoast SEO Premium: by Team Yoast – 15.4

### 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)
pw gift card (pw-gift-card)
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: #3852 - /store/
Cart: #5 - /cart/
Checkout: #6 - /checkout/
My account: #7 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Storefront
Version: (update to version 0 is available)
Author URL: 
Child Theme: ?
Parent Theme Name: Storefront
Parent Theme Version: 3.7.0
Parent Theme Author URL: https://woocommerce.com/
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 74,360
Oldest: 2021-06-02 14:53:41 -0700
Newest: 2021-07-11 18:39:20 -0700

Failed: 2
Oldest: –
Newest: –

Pending: 1
Oldest: 2021-07-16 10:43:11 -0700
Newest: 2021-07-16 10:43:11 -0700

### Status report information ###

Generated at: 2021-07-11 18:42:59 -07:00

Thread Starter

One Island

(@varchar19)

3 years, 4 months ago

We certainly have found no solution currently other than disabling the WooCommerce Admin bits, which is really unfortunate as we rather liked having those metrics.

Definitely eager to see a full solution.

Thread Starter

One Island

(@varchar19)

3 years, 4 months ago

Still occurs on 5.5.1. Yes, the database is updated also.

jedkirby

(@jedkirby)

3 years, 4 months ago

I’ve opened an issue on the WooCommerce Admin repository for this as i’m also having this problem. The issue can be found here: https://github.com/woocommerce/woocommerce-admin/issues/7358.

Moderator

Yui

(@fierevere)

永子

3 years, 4 months ago

Please see Forum FAQ before replying “I have same issue”

Mirko P.

(@rainfallnixfig)

3 years, 4 months ago

Hi all,

Many thanks for your reports.

Since this is now being dealt with on Github with high priority I’ll go ahead and close the thread. Anyone can subscribe and follow the issue directly here:

https://github.com/woocommerce/woocommerce-admin/issues/7358

Feel free to open a new thread if you have any other issues with core WooCommerce.

Cheers!

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Endless query after upgrading from 4.x to 5.4.1’ is closed to new replies.