WooCommerce database update in progress forever

Hi @superservo

Thanks for reaching out!

I understand that you’re unable to update WooCommerce database successfully.

Can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled, update manually by going to WooCommerce > Status > Tools > Update Database 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.

If this did not resolve the issue, please share your System Status Report, that will help us further troubleshoot.

You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

You could copy and paste your reply here or paste it via and send the link here.

Let us know how it goes!

Can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled, update manually by going to WooCommerce > Status > Tools > Update Database and see if this works?

have tried but not work. still WooCommerce database update in progress infinity never end

WordPress Environment

WordPress address (URL): 
Site address (URL): 
WC Version: 7.4.1
REST API Version: ✔</img> 7.4.1
WC Blocks Version: ✔</img> 9.4.4
Action Scheduler Version: ✔</img> 3.5.4
Log Directory Writable: ✔</img>
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ✔</img>
Language: en_US
External object cache: –

Server Environment

Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.85.0
OpenSSL/3.0.8

SUHOSIN Installed: –
MySQL Version: 5.7.39-42-log
Max Upload Size: 256 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: 6.4.0
WC Database Prefix: wprd_
Total Database Size: 3137.14MB
Database Data Size: 2833.93MB
Database Index Size: 303.21MB
wprd_woocommerce_sessions: Data: 28.55MB + Index: 0.38MB + Engine InnoDB
wprd_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wprd_woocommerce_order_items: Data: 10.52MB + Index: 3.52MB + Engine InnoDB
wprd_woocommerce_order_itemmeta: Data: 295.64MB + Index: 43.11MB + Engine InnoDB
wprd_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wprd_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wprd_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wprd_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
ahc_browsers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ahc_countries: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
ahc_hits: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
ahc_keywords: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ahc_recent_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ahc_refering_sites: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ahc_searching_visits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ahc_search_engines: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ahc_search_engine_crawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ahc_title_traffic: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
ahc_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ahc_visits_time: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_actionscheduler_actions: Data: 15.52MB + Index: 15.13MB + Engine InnoDB
wprd_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_actionscheduler_logs: Data: 9.52MB + Index: 6.03MB + Engine InnoDB
wprd_alm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_atum_product_data: Data: 0.20MB + Index: 0.23MB + Engine InnoDB
wprd_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_bilo_woo: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_comments: Data: 30.55MB + Index: 21.09MB + Engine InnoDB
wprd_email_log: Data: 1467.56MB + Index: 0.00MB + Engine InnoDB
wprd_ewwwio_images: Data: 23.55MB + Index: 16.13MB + Engine InnoDB
wprd_faq_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_itsec_bans: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_itsec_dashboard_events: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wprd_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_itsec_lockouts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wprd_itsec_logs: Data: 1.52MB + Index: 0.14MB + Engine InnoDB
wprd_itsec_mutexes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_itsec_opaque_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_itsec_temp: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wprd_itsec_user_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_loginizer_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_nextend2_image_storage: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wprd_nextend2_section_storage: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wprd_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_nextend2_smartslider3_sliders: Data: 0.27MB + Index: 0.03MB + Engine InnoDB
wprd_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_nextend2_smartslider3_slides: Data: 1.52MB + Index: 0.11MB + Engine InnoDB
wprd_ninja_table_items: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wprd_options: Data: 9.48MB + Index: 1.64MB + Engine InnoDB
wprd_postmeta: Data: 777.98MB + Index: 148.31MB + Engine InnoDB
wprd_posts: Data: 107.63MB + Index: 23.09MB + Engine InnoDB
wprd_product_catmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_sliders: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_sliders_bkp: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_slides: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_slides_bkp: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_stt2_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_term_relationships: Data: 2.52MB + Index: 1.52MB + Engine InnoDB
wprd_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_usermeta: Data: 8.52MB + Index: 6.03MB + Engine InnoDB
wprd_users: Data: 0.48MB + Index: 0.34MB + Engine InnoDB
wprd_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_wc_customer_lookup: Data: 0.30MB + Index: 0.16MB + Engine InnoDB
wprd_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_wc_order_coupon_lookup: Data: 1.52MB + Index: 0.66MB + Engine InnoDB
wprd_wc_order_product_lookup: Data: 3.52MB + Index: 1.89MB + Engine InnoDB
wprd_wc_order_stats: Data: 2.52MB + Index: 1.20MB + Engine InnoDB
wprd_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wprd_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_wc_product_meta_lookup: Data: 6.52MB + Index: 11.09MB + Engine InnoDB
wprd_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_woocommerce_bolt_checkout_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_woocommerce_whatsapp_notification: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wprd_wt_abandonment_coupon: Data: 25.52MB + Index: 0.00MB + Engine InnoDB
wprd_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_yith_wcwl_lists: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wprd_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wprd_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

acoplw_badges: 2
attachment: 117400
br_labels: 1
contactform: 1
customize_changeset: 15
mc4wp-form: 1
nav_menu_item: 28
ninja-table: 1
page: 24
porto_builder: 1
post: 9
product: 25139
product_variation: 35
revision: 828
shop_coupon: 2
shop_order: 26302
shop_order_refund: 1229

Security

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

Active Plugins (17)

WooCommerce Advanced Product Labels: by BeRocket – 1.2.4.1
iThemes Security: by iThemes – 8.1.4
Bukubank Woocommerce: by Bukubank.com – 1.0.5
Classic Editor: by WordPress Contributors – 1.6.2
Contact Form 7: by Takayuki Miyoshi – 5.7.4
Disable Comments: by WPDeveloper – 2.4.3
Dynamic Featured Image: by Ankit Pokhrel – 3.7.0
Email Log: by Sudar – 2.4.8
Smart Slider 3 Pro: by Nextend – 3.5.1.14
Plugin Ongkos Kirim: by Tonjoo Studio – 3.8.8
Porto Theme - Functionality: by P-Themes – 2.8.0
Checkout Field Editor for WooCommerce: by ThemeHigh – 1.8.1
WooCommerce Extended Coupon Features FREE: by Soft79 – 3.2.9
WooCommerce: by Automattic – 7.4.1
WooSidebars: by WooCommerce – 1.4.6
WP Rocket: by WP Media – 3.0.5.1
Smart Coupons for WooCommerce Pro: by WebToffee – 1.3.5

Inactive Plugins (18)

Acowebs Product Labels For Woocommerce: by Acowebs – 1.4.8
Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.3
AgenWebsite Auto Confirm: by AgenWebsite – 1.0.6
Autoptimize: by Frank Goossens (futtta) – 3.1.5
CMP - Coming Soon & Maintenance Plugin: by NiteoThemes – 4.1.7
Embed Plus YouTube WordPress Plugin: by Embed Plus YouTube Plugin Team – 14.1.4.1
Loginizer: by Softaculous – 1.7.7
Password Protected: by WPExperts – 2.6.2
Smart Coupons For WooCommerce Coupons: by WebToffee – 1.4.5
TokoPress - Marketica VC & Shortcodes: by TokoPress – 3.0.2
WooCommerce Frontend Submission: by XtensionPress – 1.1
WooCommerce Indonesia Bank: by AgenWebsite – 1.0.10
WooCommerce Kode Pembayaran ( Full Version ): by AgenWebsite – 1.1.11
WooCommerce Konfirmasi Pembayaran: by AgenWebsite – 1.1.4
WooCommerce Volume Discount Coupons: by itthinx – 1.6.0
WooCommerce WhatsApp Notification: by Whacommerce – 1.0.9
YITH Essential Kit for WooCommerce #1: by YITH – 2.17.0
YITH WooCommerce PDF Invoice and Shipping List: by YITH – 1.2.32

Dropin Plugins (1)

advanced-cache.php: advanced-cache.php

Settings

API Enabled: ✔</img>
Force SSL: –
Currency: IDR (Rp)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
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: –
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: #5 - /shop/
Cart: ❌</img> Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: #7 - /checkout/
My account: #8 - /my-account/
Terms and conditions: ❌</img> Page not set

Theme

Name: Porto
Version: 6.8.0
Author URL: 
Child Theme: ❌</img> – 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: ✔</img>

Templates

Overrides: porto/woocommerce/archive-product.php
porto/woocommerce/cart/cart-empty.php
porto/woocommerce/cart/cart-shipping.php
porto/woocommerce/cart/cart-totals.php
porto/woocommerce/cart/cart.php
porto/woocommerce/cart/cross-sells.php
porto/woocommerce/cart/mini-cart.php
porto/woocommerce/cart/proceed-to-checkout-button.php
porto/woocommerce/cart/shipping-calculator.php
porto/woocommerce/checkout/form-billing.php
porto/woocommerce/checkout/form-checkout.php
porto/woocommerce/checkout/form-coupon.php
porto/woocommerce/checkout/form-login.php
porto/woocommerce/checkout/form-pay.php
porto/woocommerce/checkout/form-shipping.php
porto/woocommerce/checkout/payment-method.php
porto/woocommerce/checkout/payment.php
porto/woocommerce/checkout/review-order.php
porto/woocommerce/checkout/thankyou.php
porto/woocommerce/content-product-cat.php
porto/woocommerce/content-product.php
porto/woocommerce/content-single-product.php
porto/woocommerce/content-widget-product.php
porto/woocommerce/global/form-login.php
porto/woocommerce/global/quantity-input.php
porto/woocommerce/global/wrapper-start.php
porto/woocommerce/loop/add-to-cart.php
porto/woocommerce/loop/loop-end.php
porto/woocommerce/loop/loop-start.php
porto/woocommerce/loop/no-products-found.php
porto/woocommerce/loop/orderby.php
porto/woocommerce/loop/pagination.php
porto/woocommerce/loop/rating.php
porto/woocommerce/loop/sale-flash.php
porto/woocommerce/myaccount/dashboard.php
porto/woocommerce/myaccount/downloads.php
porto/woocommerce/myaccount/form-add-payment-method.php
porto/woocommerce/myaccount/form-edit-account.php
porto/woocommerce/myaccount/form-edit-address.php
porto/woocommerce/myaccount/form-login.php
porto/woocommerce/myaccount/form-lost-password.php
porto/woocommerce/myaccount/form-reset-password.php
porto/woocommerce/myaccount/lost-password-confirmation.php
porto/woocommerce/myaccount/my-account.php
porto/woocommerce/myaccount/my-address.php
porto/woocommerce/myaccount/my-downloads.php
porto/woocommerce/myaccount/my-orders.php
porto/woocommerce/myaccount/navigation.php
porto/woocommerce/myaccount/orders.php
porto/woocommerce/myaccount/payment-methods.php
porto/woocommerce/myaccount/view-order.php
porto/woocommerce/order/form-tracking.php
porto/woocommerce/order/order-details-customer.php
porto/woocommerce/order/order-details.php
porto/woocommerce/order/order-downloads.php
porto/woocommerce/order/tracking.php
porto/woocommerce/single-product/add-to-cart/simple.php
porto/woocommerce/single-product/add-to-cart/variable.php
porto/woocommerce/single-product/meta.php
porto/woocommerce/single-product/product-attributes.php
porto/woocommerce/single-product/product-image.php
porto/woocommerce/single-product/product-thumbnails.php
porto/woocommerce/single-product/rating.php
porto/woocommerce/single-product/related.php
porto/woocommerce/single-product/review-meta.php
porto/woocommerce/single-product/review-rating.php
porto/woocommerce/single-product/review.php
porto/woocommerce/single-product/sale-flash.php
porto/woocommerce/single-product/short-description.php
porto/woocommerce/single-product/tabs/tabs.php
porto/woocommerce/single-product/title.php
porto/woocommerce/single-product/up-sells.php
porto/woocommerce/single-product-reviews.php

Admin

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

Daily Cron: ✔</img> Next scheduled: 2022-05-29 02:52:49 +07:00
Options: ✔</img>
Notes: 16
Onboarding: completed

Action Scheduler

Complete: 26,423
Oldest: 2021-07-14 05:41:43 +0000
Newest: 2023-03-07 06:46:51 +0000

Pending: 213
Oldest: 2023-03-06 05:41:28 +0000
Newest: 2023-03-07 07:27:57 +0000

Failed: 2
Oldest: 2021-12-02 10:25:40 +0000
Newest: 2022-03-13 14:34:55 +0000

Canceled: 15,514
Oldest: -0001-11-30 00:00:00 +0000
Newest: -0001-11-30 00:00:00 +0000

Status report information

Generated at: 2023-03-07 13:50:03 +07:00
`

latest fatal error

2023-03-07T06:45:53+00:00 WARNING Synchronization of approved product download directories is already in progress.
2023-03-07T06:46:26+00:00 WARNING Synchronization of approved product download directories is already in progress.