WC 3.4 Database Update Complete – and keeps on running!

Resolved Erik
(@cleverpixel)

5 years, 11 months ago

So I upgraded to 3.4 and the database update took about 6 hours to complete today, during which time we had a bunch of problems. No big deal, I thought, since 45 minutes ago it said, “WooCommerce data update complete…”

But then a few minutes later everything bogged down again. Memory usage spiked. So I check the wc_db_updates-xxx.log and see it updating again with this every 5 minutes or so:

2018-05-24T18:30:58+00:00 INFO Running wc_update_340_states callback

Any help on how I can force it to stop would be greatly appreciated!

Thanks!
Erik

The page I need help with: [log in to see the link]

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

Plugin Support

(@riaanknoetze)

Hi there,

Looking at the code for wc_update_340_states, it seems that this is the first function to run after the updater is initiated with the code available at:

I’m wondering whether your WooCommerce Database version isn’t getting set, which in turn, keeps firing the update sequence. To check for that, would you mind sending through a copy of your system status report (as found under WooCommerce > System Status)

Thread Starter

Erik

(@cleverpixel)

5 years, 11 months ago

Thank you for the response! I really do appreciate the help on this one.

Since my first post, the host tried a couple things.

First, he disabled memcached citing that it was looping through the update queries endlessly. I don’t know about that one.

Then he tried disabling WP Cron and setting it to run manually every 30 mins via cPanel. The result is the site runs great for about 15 minutes and then bogs down to where loading the Orders or processing a transaction becomes a problem. As expected, I’m seeing wc_update_340_states in the logs every half hour now.

Status Report below:


### WordPress Environment ###

Home URL: https://www.bandelettes.com
Site URL: https://www.bandelettes.com
WC Version: 3.4.0
Log Directory Writable: ✔
WP Version: 4.9.6
WP Multisite: –
WP Memory Limit: 640 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: ❌ 7.0.30 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 32 MB
PHP Time Limit: 45
PHP Max Input Vars: 1000
cURL Version: 7.59.0
OpenSSL/1.0.2k

SUHOSIN Installed: –
MySQL Version: 5.6.36
Max Upload Size: 24 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 3.4.0
WC Database Prefix: wp_
Total Database Size: 1182.14MB
Database Data Size: 724.26MB
Database Index Size: 457.88MB
wp_woocommerce_sessions: Data: 1.68MB + Index: 0.05MB
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_order_items: Data: 10.66MB + Index: 6.85MB
wp_woocommerce_order_itemmeta: Data: 183.67MB + Index: 91.22MB
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB
wp_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB
wp_comments: Data: 145.69MB + Index: 94.34MB
wp_eg_grids: Data: 0.05MB + Index: 0.02MB
wp_eg_item_elements: Data: 0.02MB + Index: 0.02MB
wp_eg_item_skins: Data: 1.52MB + Index: 0.03MB
wp_eg_navigation_skins: Data: 0.06MB + Index: 0.02MB
wp_EWD_OTP_Customers: Data: 0.02MB + Index: 0.00MB
wp_EWD_OTP_Custom_Fields: Data: 0.02MB + Index: 0.00MB
wp_EWD_OTP_Fields_Meta: Data: 0.02MB + Index: 0.00MB
wp_EWD_OTP_Orders: Data: 0.02MB + Index: 0.00MB
wp_EWD_OTP_Order_Statuses: Data: 0.02MB + Index: 0.00MB
wp_EWD_OTP_Sales_Reps: Data: 0.02MB + Index: 0.00MB
wp_fatal_error_logs: Data: 0.02MB + Index: 0.02MB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB
wp_gf_entry: Data: 1.52MB + Index: 0.16MB
wp_gf_entry_meta: Data: 2.52MB + Index: 2.13MB
wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB
wp_gf_form: Data: 0.02MB + Index: 0.00MB
wp_gf_form_meta: Data: 0.08MB + Index: 0.00MB
wp_gf_form_view: Data: 0.44MB + Index: 0.30MB
wp_imagify_files: Data: 0.02MB + Index: 0.08MB
wp_imagify_folders: Data: 0.02MB + Index: 0.03MB
wp_links: Data: 0.02MB + Index: 0.02MB
wp_options: Data: 5.47MB + Index: 0.13MB
wp_pmxe_exports: Data: 0.05MB + Index: 0.00MB
wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB
wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB
wp_pmxi_imports: Data: 0.23MB + Index: 0.00MB
wp_pmxi_posts: Data: 0.14MB + Index: 0.00MB
wp_pmxi_templates: Data: 0.14MB + Index: 0.00MB
wp_postmeta: Data: 291.86MB + Index: 209.50MB
wp_posts: Data: 27.55MB + Index: 12.06MB
wp_rg_form: Data: 0.02MB + Index: 0.00MB
wp_rg_form_meta: Data: 0.08MB + Index: 0.00MB
wp_rg_form_view: Data: 0.44MB + Index: 0.30MB
wp_rg_incomplete_submissions: Data: 0.00MB + Index: 0.00MB
wp_rg_lead: Data: 1.52MB + Index: 0.14MB
wp_rg_lead_detail: Data: 2.52MB + Index: 2.41MB
wp_rg_lead_detail_long: Data: 0.13MB + Index: 0.00MB
wp_rg_lead_meta: Data: 0.02MB + Index: 0.05MB
wp_rg_lead_notes: Data: 0.02MB + Index: 0.03MB
wp_strong_views: Data: 0.02MB + Index: 0.00MB
wp_termmeta: Data: 0.02MB + Index: 0.03MB
wp_terms: Data: 0.02MB + Index: 0.03MB
wp_term_relationships: Data: 0.06MB + Index: 0.05MB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB
wp_usermeta: Data: 42.58MB + Index: 35.13MB
wp_users: Data: 2.52MB + Index: 2.48MB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
wp_woochimp_scheduled_events: Data: 0.02MB + Index: 0.00MB
wp_yoast_seo_links: Data: 0.05MB + Index: 0.01MB
wp_yoast_seo_meta: Data: 0.02MB + Index: 0.02MB

### Post Type Counts ###

acf: 1
attachment: 339
bis_masterlog: 6
custom_css: 1
customize_changeset: 7
et_pb_layout: 28
gs-logo-slider: 6
ign_voucher: 1
logoshowcase: 10
nav_menu_item: 29
nelioab_local_exp: 1
oembed_cache: 8
page: 25
popup: 6
popup_theme: 9
post: 24
press: 33
product: 16
product_variation: 174
revision: 289
shop_coupon: 214
shop_order: 71687
shop_order_refund: 208
wpm-testimonial: 459

### Security ###

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

### Active Plugins (42) ###

Gravity Forms: by rocketgenius – 2.3.2
Admin Menu Editor Pro: by Janis Elsts – 2.6.4
Advanced Custom Fields: by Elliot Condon – 4.4.12
Akismet Anti-Spam: by Automattic – 4.0.3
Autoptimize: by Frank Goossens (futtta) – 2.3.4
WooCommerce Back In Stock Notifier: by Fantastic Plugins – 10.2 – Not tested with the active version of WooCommerce
Bandelettes Ghoster: by Aspen Grove Studios – 2.1.7
Easy WP SMTP: by wpecommerce
alexanderfoxc – 1.3.6

Enhanced E-commerce for Woocommerce store: by Tatvic – 2.0.2 – Not tested with the active version of WooCommerce
Essential Grid: by ThemePunch – 2.1.6.2.2
Fatal Error Notify Pro: by Very Good Plugins – 1.2
Google Language Translator: by Rob Myrick – 5.0.48
Gravity Forms + Custom Post Types: by spivurno – 3.1.13
WooCommerce Gift Certificates Pro: by IgniteWoo.com – 3.5.39 – Not tested with the active version of WooCommerce
IgniteWoo Updater: by IgniteWoo.com – 2.1.11
Imagify: by WP Media – 1.7.1.3
Improved Variable Product Attributes for WooCommerce: by Mihajlovic Nenad – 4.2.1 – Not tested with the active version of WooCommerce
Instagram Feed: by Smash Balloon – 1.8.3
Metorik Helper: by Metorik – 0.15.0 – Not tested with the active version of WooCommerce
PayPal for WooCommerce: by Angell EYE – 1.4.9
Popup Maker: by WP Popup Maker – 1.7.21
WooCommerce Product Filter: by Mihajlovic Nenad – 6.5.6 – Not tested with the active version of WooCommerce
ReadyShipper WooCommerce API: by TrueShip
LLC – 1.0.5 – Not tested with the active version of WooCommerce

Server IP & Memory Usage Display: by Apasionados
Apasionados del Marketing – 2.1.0

SG Optimizer: by SiteGround – 4.0.6
Strong Testimonials: by Chris Dillon – 2.31.4
WooChimp: by RightPress – 2.2.4 – Not tested with the active version of WooCommerce
WooCommerce Checkout Field Editor: by WooCommerce – 1.5.12 – 1.5.13 is available – Not tested with the active version of WooCommerce
WooCommerce Conversion Tracking: by Tareq Hasan – 2.0 – Not tested with the active version of WooCommerce
WooCommerce Customer/Order CSV Export: by SkyVerge – 4.4.4 – 4.4.6 is available – Not tested with the active version of WooCommerce
WooCommerce Amazon Pay Gateway: by WooCommerce – 1.8.2 – 1.8.4 is available – Not tested with the active version of WooCommerce
WooCommerce Authorize.Net CIM Gateway: by SkyVerge – 2.10.0 – 2.10.1 is available – Not tested with the active version of WooCommerce
WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.5.0 – 3.5.2 is available – Not tested with the active version of WooCommerce
WooCommerce Sequential Order Numbers: by SkyVerge – 1.8.2 – Not tested with the active version of WooCommerce
WooCommerce Shipment Tracking: by WooCommerce – 1.6.10 – 1.6.11 is available – Not tested with the active version of WooCommerce
WooCommerce - ShipStation Integration: by WooCommerce – 4.1.19 – 4.1.22 is available – Not tested with the active version of WooCommerce
WooCommerce - Store Exporter Deluxe: by Visser Labs – 2.5.1 – Not tested with the active version of WooCommerce
WooCommerce Table Rate Shipping: by Bolder Elements – 4.1.1 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.4.0
Yoast SEO: by Team Yoast – 7.5.1
WP Logo Showcase Responsive Slider: by WP Online Support – 2.0
WP Rollback: by WordImpress – 1.5

### 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)
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)

### WC Pages ###

Shop base: #142806 - /shop-all-items/
Cart: #75337 - /cart/
Checkout: #75338 - /checkout/
My account: #75339 - /my-account/
Terms and conditions: ❌ Page not set

### Theme ###

Name: Bandelettes
Version: 1.0
Author URL: https://funnel24.com
Child Theme: ✔
Parent Theme Name: Divi
Parent Theme Version: 3.3.1
Parent Theme Author URL: http://www.elegantthemes.com
WooCommerce Support: ✔

### Templates ###

Overrides: bandelettes/woocommerce/cart/cart-totals.php
bandelettes/woocommerce/cart/proceed-to-checkout-button.php
bandelettes/woocommerce/cart/shipping-calculator.php
bandelettes/woocommerce/checkout/form-checkout.php
bandelettes/woocommerce/checkout/review-order.php
bandelettes/woocommerce/order/form-tracking.php
bandelettes/woocommerce/single-product/related.php
bandelettes/woocommerce/single-product/short-description.php

### Customer/Order CSV Export ###

Order Export Format: default
Customer Export Format: default
Automatically Export Orders: disabled
Automatically Export Customers: disabled

### Authorize.Net CIM ###

Environment: Production
Tokenization Enabled: 
Debug Mode: Off
Webhooks Enabled: ❌
						No signature key configured

### Templates ###

Debugging mode for Store Exporter Deluxe: ✔No Turn on Debugging mode
Extended logging mode for Store Exporter Deluxe: ✔No Turn on Logging mode
Scheduled Export to FTP: ✔
Scheduled Export to SFTP: ❌ The required SFTP functions are not available; ssh2_connect()
ssh2_auth_password()
ssh2_sftp(). Contact your hosting provider.

Plugin Author

Mike Jolley (a11n)

(@mikejolley)

5 years, 10 months ago

Looks like this may be timing out due to a large postmeta table.

Make this change: https://github.com/woocommerce/woocommerce/pull/20238

This will skip the update unless it’s ran using WP CLI manually.

Thread Starter

Erik

(@cleverpixel)

5 years, 10 months ago

Mike, thank you!

I actually got desperate and commented out the contents of that function so it would just finish. I’ve updated my file with this now – and it looks like it will be included in 3.4.1 so that’d be great.

Thanks again,

Erik

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

The topic ‘WC 3.4 Database Update Complete – and keeps on running!’ is closed to new replies.

Tags