Title: Database update freezes Last modified: August 25, 2020 --- # Database update freezes * Resolved [karamba](https://wordpress.org/support/users/karamba/) * (@karamba) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-update-freezes/) * Everything is complete but I still see **WooCommerce database update in progress** and I can not update any plugin, update stock and so on. * Screenshot [https://i.imgur.com/7PSUyIE.png](https://i.imgur.com/7PSUyIE.png) * What I should do? Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Support [Riaan K.](https://wordpress.org/support/users/riaanknoetze/) * (@riaanknoetze) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-update-freezes/#post-13310599) * Hi there, * In order to troubleshoot this further, please share a copy of your status report as found under **WooCommerce > Status**. * Thanks! * Thread Starter [karamba](https://wordpress.org/support/users/karamba/) * (@karamba) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-update-freezes/#post-13310619) * ``` ### 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: 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.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 5 years, 8 months ago by [karamba](https://wordpress.org/support/users/karamba/). - This reply was modified 5 years, 8 months ago by [Yui](https://wordpress.org/support/users/fierevere/). * Thread Starter [karamba](https://wordpress.org/support/users/karamba/) * (@karamba) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-update-freezes/#post-13320198) * Still “updating”… Disabling / enabling plugin doesn’t help. * Plugin Support [John Coy a11n](https://wordpress.org/support/users/johndcoy/) * (@johndcoy) * Automattic Happiness Engineer * [5 years, 8 months ago](https://wordpress.org/support/topic/database-update-freezes/#post-13409493) * Hi [@karamba](https://wordpress.org/support/users/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](https://docs.woocommerce.com/document/woocommerce-self-service-guide/#section-4) * [Missy a11n](https://wordpress.org/support/users/m155y5/) * (@m155y5) * Automattic Happiness Engineer * [5 years, 7 months ago](https://wordpress.org/support/topic/database-update-freezes/#post-13441632) * 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. Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Database update freezes’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) * 5 replies * 4 participants * Last reply from: [Missy a11n](https://wordpress.org/support/users/m155y5/) * Last activity: [5 years, 7 months ago](https://wordpress.org/support/topic/database-update-freezes/#post-13441632) * Status: resolved