Database update freezes

Hi there,

In order to troubleshoot this further, please share a copy of your status report as found under **WooCommerce > Status**.

Thanks!

### WordPress Environment ###

WordPress address (URL): ...
Site address (URL): ...
WC Version: 4.4.1
REST API Version: ? 1.0.15
WC Blocks Version: ? 3.1.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.4.0
Log Directory Writable: ?
WP Version: 5.5
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2
PHP Version: 7.2.30
PHP Post Max Size: 128 MB
PHP Time Limit: 180
PHP Max Input Vars: 10000
cURL Version: 7.70.0
OpenSSL/1.0.2k-fips

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.12-MariaDB
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 4.4.1
WC Database Prefix: wpro_
Total Database Size: 532.56MB
Database Data Size: 480.67MB
Database Index Size: 51.89MB
wpro_woocommerce_sessions: Data: 369.93MB + Index: 10.98MB + Engine MyISAM
wpro_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpro_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_woocommerce_order_items: Data: 0.56MB + Index: 0.27MB + Engine MyISAM
wpro_woocommerce_order_itemmeta: Data: 5.97MB + Index: 1.86MB + Engine MyISAM
wpro_woocommerce_tax_rates: Data: 0.04MB + Index: 0.05MB + Engine MyISAM
wpro_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpro_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_actionscheduler_actions: Data: 0.16MB + Index: 0.14MB + Engine InnoDB
wpro_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_actionscheduler_logs: Data: 0.16MB + Index: 0.13MB + Engine InnoDB
wpro_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_cleantalk_sessions: Data: 2.02MB + Index: 0.00MB + Engine InnoDB
wpro_cleantalk_sfw: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_commentmeta: Data: 0.08MB + Index: 0.07MB + Engine MyISAM
wpro_comments: Data: 2.12MB + Index: 0.72MB + Engine MyISAM
wpro_couponwheel_wheels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_couponwheel_wheel_run_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpro_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_itsec_distributed_storage: Data: 7.02MB + Index: 0.02MB + Engine InnoDB
wpro_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpro_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpro_itsec_lockouts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpro_itsec_logs: Data: 15.02MB + Index: 1.61MB + Engine InnoDB
wpro_itsec_mutexes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_itsec_opaque_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_itsec_temp: Data: 0.47MB + Index: 0.72MB + Engine InnoDB
wpro_itsec_user_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_litespeed_img_optm: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpro_litespeed_optimizer: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpro_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_options: Data: 3.49MB + Index: 0.81MB + Engine MyISAM
wpro_postmeta: Data: 32.27MB + Index: 6.30MB + Engine MyISAM
wpro_posts: Data: 5.63MB + Index: 0.68MB + Engine MyISAM
wpro_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_redirection_404: Data: 13.52MB + Index: 14.11MB + Engine InnoDB
wpro_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpro_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpro_redirection_logs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpro_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_s2w_error_product_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_sbi_instagram_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_sib_model_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_sib_model_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpro_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_termmeta: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpro_terms: Data: 0.06MB + Index: 0.08MB + Engine MyISAM
wpro_term_relationships: Data: 0.19MB + Index: 0.41MB + Engine MyISAM
wpro_term_taxonomy: Data: 0.11MB + Index: 0.09MB + Engine MyISAM
wpro_usermeta: Data: 3.73MB + Index: 2.68MB + Engine MyISAM
wpro_users: Data: 0.25MB + Index: 0.29MB + Engine MyISAM
wpro_wcpdf_invoice_number: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpro_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wc_customer_lookup: Data: 0.17MB + Index: 0.13MB + Engine InnoDB
wpro_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_wc_order_coupon_lookup: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
wpro_wc_order_product_lookup: Data: 0.19MB + Index: 0.22MB + Engine InnoDB
wpro_wc_order_stats: Data: 0.16MB + Index: 0.16MB + Engine InnoDB
wpro_wc_order_tax_lookup: Data: 0.11MB + Index: 0.11MB + Engine InnoDB
wpro_wc_product_meta_lookup: Data: 0.04MB + Index: 0.06MB + Engine MyISAM
wpro_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpro_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpro_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wfblocks7: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
wpro_wfconfig: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpro_wfcrawlers: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpro_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wfhits: Data: 1.52MB + Index: 0.36MB + Engine InnoDB
wpro_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpro_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wflogins: Data: 3.52MB + Index: 1.75MB + Engine InnoDB
wpro_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpro_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wfsnipcache: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
wpro_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpro_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpro_yith_wcwl: Data: 2.40MB + Index: 1.14MB + Engine MyISAM
wpro_yith_wcwl_lists: Data: 3.57MB + Index: 3.28MB + Engine MyISAM
wpro_yoast_indexable: Data: 4.50MB + Index: 1.27MB + Engine InnoDB
wpro_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpro_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpro_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpro_yoast_seo_links: Data: 0.11MB + Index: 0.05MB + Engine InnoDB
wpro_yoast_seo_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 2622
blocks: 16
custom_css: 1
customize_changeset: 31
nav_menu_item: 41
oembed_cache: 8
page: 46
polylang_mo: 2
post: 230
postman_sent_mail: 250
product: 54
product_variation: 321
revision: 223
shop_coupon: 120
shop_order: 2723
shop_order_refund: 3
wof_lite_wheel: 1
woo_discount: 1
wpcf7_contact_form: 8

### Security ###

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

### Active Plugins (28) ###

Polylang Pro: by WP SYNTEX – 2.7.4
AfterShip - WooCommerce Tracking: by AfterShip – 1.9.26 – Installed version not tested with active version of WooCommerce 4.4.1
iThemes Security: by iThemes – 7.8.0
Classic Editor: by WordPress Contributors – 1.6
Anti-Spam by CleanTalk: by СleanTalk  – 5.144
Contact Form 7: by Takayuki Miyoshi – 5.2.1
301 Redirects: by WebFactory Ltd – 2.51
Widget for Social Page Feeds: by Milap Patel – 6.1
Flexible Shipping: by WP Desk – 3.11.3
Nextend Social Login: by Nextendweb – 3.0.24
Omise Payment Gateway: by Omise and contributors – 4.1 – Installed version not tested with active version of WooCommerce 4.4.1
Polylang comments merging: by Frédéric Demarle – 0.3-dev – Installed version not tested with active version of WooCommerce 4.4.1
Polylang for WooCommerce: by WP SYNTEX – 1.4.4 – Installed version not tested with active version of WooCommerce 4.4.1
Post SMTP: by Yehuda Hassine – 2.0.15
Really Simple SSL: by Really Simple Plugins – 3.3.4
Redirection: by John Godley – 4.8
Simple YouTube Responsive: by Eirudo – 2.3
Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 1.0.55 – Installed version not tested with active version of WooCommerce 4.4.1
Variation Swatches for WooCommerce: by Emran Ahmed – 1.0.85 – Installed version not tested with active version of WooCommerce 4.4.1
WooCommerce Coupon Restrictions: by WooCommerce – 1.8.0 – Installed version not tested with active version of WooCommerce 4.4.1
WooCommerce Multi Currency Premium: by VillaTheme – 2.1.9.4 – Installed version not tested with active version of WooCommerce 4.4.1
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.6.0
WooCommerce Photo Reviews Premium: by VillaTheme – 1.1.4.6 – Installed version not tested with active version of WooCommerce 4.4.1
WooCommerce: by Automattic – 4.4.1
WooSidebars: by WooCommerce – 1.4.5
Yoast SEO: by Team Yoast – 14.8
Smush: by WPMU DEV – 3.6.3
YITH WooCommerce Wishlist: by YITH – 3.0.13

### Inactive Plugins (4) ###

Newsletter, SMTP, Email marketing and Subscribe forms by Sendinblue: by Sendinblue – 3.0.6
Shortcode in Menus: by Gagan Deep Singh – 3.5
Smash Balloon Instagram Feed: by Smash Balloon – 2.4.6
WP Fastest Cache: by Emre Vona – 0.9.0.9

### Settings ###

API Enabled: –
Force SSL: –
Currency: THB (?)
Currency Position: right_space
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #71 - /shop/
Cart: #70 - /cart/
Checkout: #69 - /checkout/
My account: #68 - /my-account/
Terms and conditions: #3 - /privacy-policy/

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.12.2
Parent Theme Author URL: https://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.php
flatsome/woocommerce/content-product_cat.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
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

### WC Pages Translations ###

Shop base: ?
Cart: ?
Checkout: ?
My account: ?

### Action Scheduler ###

Complete: 530
Oldest: 2020-07-25 15:28:29 +0700
Newest: 2020-08-25 14:48:58 +0700

• This reply was modified 4 years, 7 months ago by karamba.
• This reply was modified 4 years, 7 months ago by Yui.

Still “updating”…
Disabling / enabling plugin doesn’t help.

Hi @karamba

Sounds like a problem from aggressive caching or it may be caused by a theme or plugin conflict. Here we support the WooCommerce plugin to ensure it’s working as expected.

As a starting point and to ensure that’s the case, we’ll recommend you to try switching back to a default theme like Twenty Twenty and disabling all plugins except for WooCommerce to see if this resolves the problem.

If this fixes the issue, then re-enable each plugin one at a time, then the theme, until you find the one that’s causing the conflict.

Here is a link that better outlines that process:

https://docs.woocommerce.com/document/woocommerce-self-service-guide/#section-4

We haven’t heard back from you in a while, so I’m going to go ahead and mark this thread as resolved. If you have any other questions please feel free to start a new thread.