Support » Plugin: WooCommerce » WC 3.4 Database Update Complete – and keeps on running!

  • Resolved FUNNEL24

    (@cleverpixel)


    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 RK

    (@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)

    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

    (@mikejolley)

    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

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.