WC 3.4 Database Update Complete – and keeps on running!
-
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!
ErikThe page I need help with: [log in to see the link]
-
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:- https://github.com/woocommerce/woocommerce/blob/35bfb6bbdc1fa86d2930e7cde53dd024a9125d2e/includes/wc-update-functions.php#L1640
- https://github.com/woocommerce/woocommerce/blob/9e1b8245beae5e1c18484b53c8e97f5b0d1f25f3/includes/class-wc-install.php#L103
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)
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: https://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.
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.
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
- The topic ‘WC 3.4 Database Update Complete – and keeps on running!’ is closed to new replies.