Stuck on database update for days – “WooCommerce database update in progress”

  • Resolved elizabethhereandnowdigital

    (@elizabethhereandnowdigital)


    2 years, 8 months ago

    The message “WooCommerce database update in progress” has been showing for days.

    From the system report:
    WooCommerce version: 6.6.0
    WooCommerce database version: 6.4.0

    When I try to add a WooCommerce category I get the message:
    Could not insert term into the database.

    Full System Report:

    
### WordPress Environment ###

WC Version: 6.6.0
REST API Version: ? 6.6.0
WC Blocks Version: ? 7.6.0
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.30
PHP Post Max Size: 256 MB
PHP Time Limit: 300
PHP Max Input Vars: 4000
cURL Version: 7.83.1
OpenSSL/1.1.1o

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

### Database ###

WC Database Version: 6.4.0
WC Database Prefix: wpk3_
Total Database Size: 969.98MB
Database Data Size: 691.02MB
Database Index Size: 278.96MB
3_woocommerce_sessions: Data: 0.33MB + Index: 0.01MB + Engine MyISAM
3_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
3_woocommerce_order_items: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
3_woocommerce_order_itemmeta: Data: 0.31MB + Index: 0.27MB + Engine InnoDB
3_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
3_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_actionscheduler_actions: Data: 61.59MB + Index: 33.16MB + Engine InnoDB
3_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_actionscheduler_logs: Data: 475.98MB + Index: 240.47MB + Engine InnoDB
3_aioseo_notifications: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
3_aioseo_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_comments: Data: 0.31MB + Index: 0.28MB + Engine InnoDB
3_et_bloom_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_frm_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_frm_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_frm_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_frm_item_metas: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_mailchimp_jobs: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
3_mo_campaign_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_mo_campaign_logmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_mo_conversions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_mo_email_campaignmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_mo_email_campaigns: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_mo_optin_campaignmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_mo_optin_campaigns: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_options: Data: 2.50MB + Index: 0.17MB + Engine InnoDB
3_patchstack_event_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_patchstack_firewall_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_patchstack_logic: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_postmeta: Data: 137.52MB + Index: 2.03MB + Engine InnoDB
3_postmeta_new: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_posts: Data: 4.52MB + Index: 0.22MB + Engine InnoDB
3_posts.bak_20220114: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
3_rank_math_404_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
3_rank_math_analytics_ga: Data: 0.08MB + Index: 0.04MB + Engine MyISAM
3_rank_math_analytics_gsc: Data: 0.82MB + Index: 0.52MB + Engine MyISAM
3_rank_math_analytics_inspections: Data: 0.12MB + Index: 0.02MB + Engine MyISAM
3_rank_math_analytics_keyword_manager: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_rank_math_analytics_objects: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
3_rank_math_internal_links: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
3_rank_math_internal_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_usermeta: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
3_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
3_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_wcpdf_packing_slip_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
3_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
3_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
3_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
3_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
3_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
3_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_wpforms_entries: Data: 3.52MB + Index: 0.05MB + Engine InnoDB
3_wpforms_entry_fields: Data: 1.52MB + Index: 0.41MB + Engine InnoDB
3_wpforms_entry_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
3_wpforms_tasks_meta: Data: 0.07MB + Index: 0.00MB + Engine MyISAM
3_wpr_rucss_used_css: Data: 0.13MB + Index: 0.03MB + Engine MyISAM
3_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
3_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
3_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
3_yoast_primary_term: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
3_yoast_seo_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

attachment: 370
customize_changeset: 1
custom_css: 2
fl-builder-template: 11
fl-theme-layout: 2
frm_form_actions: 1
frm_styles: 1
nav_menu_item: 86
oembed_cache: 21
page: 46
popup: 1
popup_theme: 6
post: 18
product: 55
product_variation: 12
revision: 287
shop_coupon: 9
shop_order: 261
shop_order_refund: 2
wcs_ruleset: 1
wpforms: 3
wpm-testimonial: 1
wp_global_styles: 7

### Security ###

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

### Active Plugins (19) ###

ManageWP - Worker: by GoDaddy – 4.9.14
Beaver Builder Plugin (Pro Version): by The Beaver Builder Team – 2.5.4.3
Conditional Shipping for WooCommerce: by Lauri Karisola / WP Trio – 2.3.1
Duplicate Page: by mndpsingh287 – 4.4.8
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.4
Insert Headers and Footers: by WPBeginner – 1.6.2
Mailchimp for WooCommerce: by Mailchimp – 2.6.2
Really Simple SSL: by Really Simple Plugins – 5.3.2
reCaptcha for WooCommerce: by I Thirteen Web Solution – 2.34
Rank Math SEO PRO: by Rank Math – 3.0.14
Rank Math SEO: by Rank Math – 1.0.91
Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.31
WooCommerce First Data Payeezy Gateway: by SkyVerge – 4.9.0
WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.16.0
WooCommerce: by Automattic – 6.6.0
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.2.5

WP Rocket: by WP Media – 3.11.3
WPForms: by WPForms – 1.7.2.2
YITH WooCommerce Wishlist: by YITH – 3.9.0

### Inactive Plugins (5) ###

Akismet Anti-Spam: by Automattic – 4.2.4
Patchstack Security: by Patchstack – 2.1.19
Under Construction: by WebFactory Ltd – 3.93
WooCommerce Shipping & Tax: by WooCommerce – 1.26.0
WPForms Mailchimp: by WPForms – 2.1.1

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (1) ###

ManageWP - Worker Loader: by GoDaddy –

### 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)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

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: –

### WC Pages ###

Shop base: #1199 - /shop/
Cart: #1201 - /cart/
Checkout: #1203 - /checkout/
My account: #1205 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Beaver Builder Child Theme
Version: 1.0
Author URL: https://www.fastlinemedia.com
Child Theme: ?
Parent Theme Name: Beaver Builder Theme
Parent Theme Version: 1.7.11
Parent Theme Author URL: https://www.wpbeaverbuilder.com/?utm_medium=bb-pro&utm_source=bb-theme&utm_campaign=themes-admin-page
WooCommerce Support: ?

### Templates ###

Overrides: –

### Payeezy Gateway Credit Card ###

Environment: Production
Tokenization Enabled: 
Debug Mode: Off

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-06-18 21:09:10 -07:00
Options: ?
Notes: 57
Onboarding: completed

### Action Scheduler ###

Complete: 120
Oldest: 2022-05-27 11:06:58 -0700
Newest: 2022-06-08 11:00:08 -0700

Pending: 130,760
Oldest: -0001-11-29 16:07:02 -0752
Newest: 2022-06-17 14:25:58 -0700

Failed: 109
Oldest: 2022-04-22 14:53:36 -0700
Newest: 2022-04-25 19:15:41 -0700

### Status report information ###

Generated at: 2022-06-18 05:05:21 -07:00
Viewing 4 replies - 1 through 4 (of 4 total)

  • Hello,

    Regarding the error received, please take a look at this article.

    How to optimize and repair MySQL databases

    I that does not work, please provide us with the following information:

    — Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

    Thanks.

    • This reply was modified 2 years, 8 months ago by Igor H.
    Thread Starter elizabethhereandnowdigital

    (@elizabethhereandnowdigital)

    I ran repair and optimize for all tables in the site’s database as per the article.

    The same to problems persist:
    1. WooCommerce database update in progress notices doesn’t go away.
    2. Unable to add a WooCommerce category. Error message “Could not insert term taxonomy into the database.”

    If I filter under WooCommerce > Scheduled Actions for “woocommerce_run_update”
    there are these two tasks:

    woocommerce_run_update_callback:
    'update_callback' => 'wc_update_650_approved_download_directories'
    and
    'update_callback' => 'wc_update_651_approved_download_directories'

    If I run anyone manually, it’s spawns more of the same task.

    I can also see there are 130784 Pending scheduled actions in total.

    WC Error Log
    This is the error log for today, after I ran the database optimization and repair, tried and failed to add a WC category, and ran the scheduled update manually.

    2022-05-19T16:44:20+00:00 CRITICAL Uncaught WP_Rocket\Dependencies\League\Container\Exception\ContainerException: A service provider must be a fully qualified class name or instance of (\WP_Rocket\Dependencies\League\Container\ServiceProvider\ServiceProviderInterface) in /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Dependencies/League/Container/ServiceProvider/ServiceProviderAggregate.php:52
Stack trace:
#0 /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Dependencies/League/Container/Container.php(146): WP_Rocket\Dependencies\League\Container\ServiceProvider\ServiceProviderAggregate->add('WP_Rocket\\Engin...')
#1 /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Plugin.php(224): WP_Rocket\Dependencies\League\Container\Container->addServiceProvider('WP_Rocket\\Engin...')
#2 /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Plugin.php(135): WP_Rocket\Plugin->init_common_subscribers()
#3 /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Plugin.php(114 in /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Dependencies/League/Container/ServiceProvider/ServiceProviderAggregate.php on line 52

2022-05-19T22:36:25+00:00 CRITICAL Uncaught TypeError: Argument 1 passed to WP_Rocket\Event_Management\Event_Manager::add_subscriber() must implement interface WP_Rocket\Event_Management\Subscriber_Interface, string given, called in /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Plugin.php on line 115 and defined in /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/classes/event-management/class-event-manager.php:33
Stack trace:
#0 /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Plugin.php(115): WP_Rocket\Event_Management\Event_Manager->add_subscriber('WP_Rocket\\Engin...')
#1 /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/main.php(50): WP_Rocket\Plugin->load()
#2 /home/<sitename>/public_html/wp-includes/class-wp-hook.php(307): rocket_init('')
#3 /home/<sitename>/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#4 /home/<sitename>/public_html/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#5 /home/katalys in /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/classes/event-management/class-event-manager.php on line 33

2022-05-19T22:36:25+00:00 CRITICAL Uncaught TypeError: Argument 1 passed to WP_Rocket\Event_Management\Event_Manager::add_subscriber() must implement interface WP_Rocket\Event_Management\Subscriber_Interface, string given, called in /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Plugin.php on line 115 and defined in /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/classes/event-management/class-event-manager.php:33
Stack trace:
#0 /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/Plugin.php(115): WP_Rocket\Event_Management\Event_Manager->add_subscriber('WP_Rocket\\Third...')
#1 /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/main.php(50): WP_Rocket\Plugin->load()
#2 /home/<sitename>/public_html/wp-includes/class-wp-hook.php(307): rocket_init('')
#3 /home/<sitename>/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters(NULL, Array)
#4 /home/<sitename>/public_html/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#5 /home/katalys in /home/<sitename>/public_html/wp-content/plugins/wp-rocket/inc/classes/event-management/class-event-manager.php on line 33

    Thank you for the assistance.

    Plugin Support Tamirat B. (a11n)

    (@tamirat22)

    Hello @elizabethhereandnowdigital!

    Thanks for the reply!

    This is the error log for today, after I ran the database optimization and repair, tried and failed to add a WC category, and ran the scheduled update manually.

    The error logs seem to be related to the WP-Rocket caching plugin.

    Could you please retry the steps while the plugin is disabled on a test site? If your host doesn’t offer a staging/testing option, we recommend WP Staging for quickly spinning up a new test site.

    If the above doesn’t address the issue, please run a full plugin/theme conflict test as described here.

    Finally, consult our guide here on configuring your caching plugins: https://woocommerce.com/document/configuring-caching-plugins

    Let us know how it turns out!

    Plugin Support Tamirat B. (a11n)

    (@tamirat22)

    Hello @elizabethhereandnowdigital!

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Stuck on database update for days – “WooCommerce database update in progress”’ is closed to new replies.