user103431

Hi @joostvandevijver,

I’ve taken this to your service desk as suggested.

Thanks!

Hi @eastofwest,

Sorry for the long delay. I had another attempt at updating, this time putting the site into maintenance mode manually prior to the install.

Observations:
– After install the site worked for a minute, then stopped as before
– No PHP errors generated, just an eventual timeouts for any requests
– SHOW PROCESSLIST in MySQL revealed no blocked queries

This time around the site began to function again on its own after a few minutes, I was then able to take the site out of manual maintenance mode. So far everything appears to be working fine.

Hi @eastofwest,

Thanks for the response! Firstly the details: the update did finish and I was able to navigate around admin for possibly a minute. During that time I cleared the Autoptimize cache and was attempting to clear CDN cache when the site stopped responding. After this point any attempt to load a page on the site, admin and frontend simply stalled until the webserver timed out the request (there was never a PHP error of any kind).

Logging into cPanel and restoring the plugins/woocommerce folder was able to get the frontend of the site back online, however a database restore was required to get the admin area back.

Below is the requested system report, thanks!

### WordPress Environment ###

WordPress address (URL): https://<omitted>
Site address (URL): https://<omitted>
WC Version: 5.6.1
REST API Version: ? 5.6.1
WC Blocks Version: ? 5.5.1
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.5.2
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_AU
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 8.0.10
PHP Post Max Size: 64 MB
PHP Time Limit: 300
PHP Max Input Vars: 3000
cURL Version: 7.71.0
OpenSSL/1.1.1d

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

### Database ###

WC Database Version: 5.6.1
WC Database Prefix: wp_
Total Database Size: 92.65MB
Database Data Size: 64.52MB
Database Index Size: 28.13MB
wp_woocommerce_sessions: Data: 0.43MB + Index: 0.02MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.81MB + Index: 0.50MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 6.34MB + Index: 4.21MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.39MB + Index: 0.17MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 0.26MB + Index: 0.20MB + Engine MyISAM
wp_adtribes_my_conversions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_comments: Data: 1.43MB + Index: 0.57MB + Engine MyISAM
wp_commercekit_searches: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commercekit_waitlist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commercekit_wishlist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commercekit_wishlist_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_e_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_e_submissions_actions_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_e_submissions_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailchimp_carts: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
wp_mailchimp_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 4.41MB + Index: 0.14MB + Engine MyISAM
wp_postmeta: Data: 23.40MB + Index: 7.94MB + Engine MyISAM
wp_posts: Data: 5.40MB + Index: 0.48MB + Engine MyISAM
wp_redirection_404: Data: 0.77MB + Index: 0.13MB + Engine MyISAM
wp_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_redirection_items: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_redirection_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_usermeta: Data: 15.45MB + Index: 10.68MB + Engine MyISAM
wp_users: Data: 0.73MB + Index: 0.53MB + Engine MyISAM
wp_wcpdf_invoice_number: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.65MB + Index: 0.53MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_bundle_lookup: Data: 0.13MB + Index: 0.13MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.65MB + Index: 0.49MB + Engine MyISAM
wp_wc_order_stats: Data: 0.35MB + Index: 0.21MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.21MB + Index: 0.26MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_bundled_itemmeta: Data: 0.06MB + Index: 0.05MB + Engine MyISAM
wp_woocommerce_bundled_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yoast_indexable: Data: 2.47MB + Index: 0.63MB + Engine MyISAM
wp_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_primary_term: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine MyISAM
wp_yoast_seo_links: Data: 0.02MB + Index: 0.01MB + Engine MyISAM

### Post Type Counts ###

attachment: 156
b2bwhs_custom_field: 9
b2bwhs_custom_role: 2
b2bwhs_group: 1
custom_css: 2
elementor_library: 26
elementor_snippet: 2
mc4wp-form: 1
nav_menu_item: 22
page: 26
post: 27
product: 79
revision: 1314
shop_coupon: 4
shop_order: 4684
shop_order_refund: 1
wp_block: 1

### Security ###

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

### Active Plugins (25) ###

ManageWP - Worker: by GoDaddy – 4.9.10
AddressFinder: by Abletech – 1.4.6
Afterpay Gateway for WooCommerce: by Afterpay – 3.2.2
Autoptimize: by Frank Goossens (futtta) – 2.9.2
B2B & Wholesale Suite: by WebWizards – 1.2.8
CommerceGurus Commercekit: by CommerceGurus – 1.3.0
Elementor Pro: by Elementor.com – 3.4.1
Elementor: by Elementor.com – 3.4.4
hCaptcha for Forms and More: by hCaptcha – 1.12.0
Jetpack: by Automattic – 10.1
Kirki Customizer Framework: by David Vongries – 3.1.9
Mailchimp for WooCommerce: by Mailchimp – 2.5.3
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.6
Redirection: by John Godley – 5.1.3
Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.28
WooCommerce Stripe Gateway: by WooCommerce – 5.5.0
Starshipit Addon: by Starshipit – 0.2.3
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.9.3
WooCommerce Product Bundles: by SomewhereWarm – 6.10.3
WooCommerce: by Automattic – 5.6.1 (update to version 5.7.1 is available)
Yoast SEO Premium: by Team Yoast – 17.2
Yoast SEO: by Team Yoast – 17.2
WP Mail SMTP: by WPForms – 3.0.3
WP Maintenance Mode: by Designmodo – 2.4.1
Yoast SEO: WooCommerce: by Team Yoast – 14.4

### Inactive Plugins (2) ###

WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3
WooCommerce PayPal Payments: by WooCommerce – 1.5.1

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

ManageWP - Worker Loader: by GoDaddy –

### Settings ###

API Enabled: ?
Force SSL: –
Currency: AUD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: bundle (bundle)
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: –

### WC Pages ###

Shop base: #6 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #795 - /terms-and-conditions/

### Theme ###

Name: Shoptimizer Child Theme
Version: 1.2.1
Author URL: 
Child Theme: ?
Parent Theme Name: Shoptimizer
Parent Theme Version: 2.4.5
Parent Theme Author URL: https://www.commercegurus.com/
WooCommerce Support: ?

### Templates ###

Overrides: shoptimizer-child-theme/woocommerce/checkout/form-checkout.php
shoptimizer-child-theme/woocommerce/emails/admin-cancelled-order.php
shoptimizer-child-theme/woocommerce/emails/admin-failed-order.php
shoptimizer-child-theme/woocommerce/emails/admin-new-order.php
shoptimizer-child-theme/woocommerce/emails/customer-completed-order.php
shoptimizer-child-theme/woocommerce/emails/customer-invoice.php
shoptimizer-child-theme/woocommerce/emails/customer-new-account.php
shoptimizer-child-theme/woocommerce/emails/customer-note.php
shoptimizer-child-theme/woocommerce/emails/customer-on-hold-order.php
shoptimizer-child-theme/woocommerce/emails/customer-processing-order.php
shoptimizer-child-theme/woocommerce/emails/customer-refunded-order.php
shoptimizer-child-theme/woocommerce/emails/customer-reset-password.php
shoptimizer-child-theme/woocommerce/emails/email-addresses.php
shoptimizer-child-theme/woocommerce/emails/email-customer-details.php
shoptimizer-child-theme/woocommerce/emails/email-downloads.php
shoptimizer-child-theme/woocommerce/emails/email-footer.php
shoptimizer-child-theme/woocommerce/emails/email-header.php
shoptimizer-child-theme/woocommerce/emails/email-order-details.php
shoptimizer-child-theme/woocommerce/emails/email-order-items.php
shoptimizer-child-theme/woocommerce/emails/email-styles.php
shoptimizer-child-theme/woocommerce/myaccount/dashboard.php

### Product Bundles ###

Database Version: 6.10.3
Loopback Test: ?
Template Overrides: –

### Action Scheduler ###

Cancelled: 3
Oldest: 2021-09-01 02:09:57 +0000
Newest: 2021-09-22 10:18:37 +0000

Complete: 1,590
Oldest: 2021-09-13 05:12:01 +0000
Newest: 2021-09-24 08:37:58 +0000

### Status report information ###

Generated at: 2021-09-24 22:26:39 +10:00