• Resolved yourebayexpert

    (@yourebayexpert)


    have been having problems for about 12 months now where my site keeps crashing
    hosting company says its because of MySql processes are not closing correctly and pile up

    have have searched the net for months and everything keeps pointing me back to the woocommerce admin plugin being the issue (i installed this over a year agao and also uninstalled it)

    when i look at my processes and I/O usage i can see it spikes at 17mins past the hour every hour and builds up until it crashes

    these are the errors im seeing on repeat

    Woocommerce – status -logs

    022-05-07T04:15:11+00:00 ERROR Error on orders updateEbatNs_ResponseError Object
    (
        [Ack:protected] => Failure
        [Errors:protected] => Array
            (
                [0] => ErrorType Object
                    (
                        [ShortMessage:protected] => 
                        [LongMessage:protected] => soap-fault: Expired IAF token.
                        [ErrorCode:protected] => 90002
                        [UserDisplayHint:protected] => 
                        [SeverityCode:protected] => Error
                        [ErrorParameters:protected] => 
                        [ErrorClassification:protected] => SystemError
                    )
    
                [1] => ErrorType Object
                    (
                        [ShortMessage:protected] => 
                        [LongMessage:protected] => IAF token supplied is expired.
                        [ErrorCode:protected] => 21917053
                        [UserDisplayHint:protected] => 
                        [SeverityCode:protected] => Error
                        [ErrorParameters:protected] => 
                        [ErrorClassification:protected] => SystemError

    woocommerce – scheduled actions – failed

    
    

    2022-06-06 01:16:30 +0000
    action created
    2022-06-06 01:17:33 +0000
    action started via Async Request
    2022-06-06 01:17:33 +0000
    unexpected shutdown: PHP fatal error Uncaught DivisionByZeroError: Division by zero in /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Admin/Overrides/OrderTraits.php:34 Stack trace: #0 /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Admin/API/Reports/Products/DataStore.php(412): Automattic\WooCommerce\Admin\Overrides\OrderRefund->get_item_shipping_amount() #1 /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Internal/Admin/Schedulers/OrdersScheduler.php(169): Automattic\WooCommerce\Admin\API\Reports\Products\DataStore::sync_order_products() #2 [internal function]: Automattic\WooCommerce\Internal\Admin\Schedulers\OrdersScheduler::import() #3 /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Admin/Schedulers/SchedulerTraits.php(267): call_user_func_array() #4 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(307): Automattic\WooCommerce\Internal\Admin\Schedulers\ImportScheduler::do_action_or_reschedule() #5 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #6 /home/aquariu2/public_html/wp-includes/plugin.php(524): WP_Hook->do_action() #7 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/actions/ActionScheduler_Action.php(22): do_action_ref_array() #8 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_QueueRunner.php(65): ActionScheduler_Action->execute() #9 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(162): ActionScheduler_Abstract_QueueRunner->process_action() #10 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner->do_batch() #11 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(307): ActionScheduler_QueueRunner->run() #12 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #13 /home/aquariu2/public_html/wp-includes/plugin.php(476): WP_Hook->do_action() #14 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AsyncRequest_QueueRunner.php(52): do_action() #15 /home/aquariu2/public_html/wp-content/plugins/back-in-stock-notifier-for-woocommerce/includes/library/wp-async-request.php(149): ActionScheduler_AsyncRequest_QueueRunner->handle() #16 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(307): WP_Async_Request->maybe_handle() #17 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #18 /home/aquariu2/public_html/wp-includes/plugin.php(476): WP_Hook->do_action() #19 /home/aquariu2/public_html/wp-admin/admin-ajax.php(202): do_action() #20 {main} thrown in /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Admin/Overrides/OrderTraits.php on line 34`
    `

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @yourebayexpert,

    Thanks for sharing this with us. As a first step, could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Cheers.

    Thread Starter yourebayexpert

    (@yourebayexpert)

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.aquariumfishonline.com.au
    Site address (URL): https://www.aquariumfishonline.com.au
    WC Version: 6.5.1
    REST API Version: ? 6.5.1
    WC Blocks Version: ? 7.8.0
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: –
    Language: en_AU
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 8.0.19
    PHP Post Max Size: 128 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 3000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d
    
    SUHOSIN Installed: –
    MySQL Version: 10.3.35-MariaDB
    Max Upload Size: 128 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.5.1
    WC Database Prefix: 52EEovxKqC_
    Total Database Size: 3322.56MB
    Database Data Size: 2720.50MB
    Database Index Size: 602.06MB
    52EEovxKqC_woocommerce_sessions: Data: 61.09MB + Index: 2.16MB + Engine InnoDB
    52EEovxKqC_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    52EEovxKqC_woocommerce_order_items: Data: 22.55MB + Index: 6.52MB + Engine InnoDB
    52EEovxKqC_woocommerce_order_itemmeta: Data: 385.94MB + Index: 134.27MB + Engine InnoDB
    52EEovxKqC_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    52EEovxKqC_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_woocommerce_payment_tokens: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_woocommerce_payment_tokenmeta: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
    52EEovxKqC_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_actionscheduler_actions: Data: 0.60MB + Index: 0.32MB + Engine MyISAM
    52EEovxKqC_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_actionscheduler_logs: Data: 5.53MB + Index: 3.77MB + Engine MyISAM
    52EEovxKqC_ac_segments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_admin_columns: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_aepc_logs: Data: 1.50MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_atum_order_itemmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_atum_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_atum_product_data: Data: 0.05MB + Index: 0.05MB + Engine MyISAM
    52EEovxKqC_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_barcode_v3_templates: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_blog_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_check_email_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_comments: Data: 74.59MB + Index: 40.09MB + Engine InnoDB
    52EEovxKqC_ebay_accounts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_ebay_auctions: Data: 27.52MB + Index: 0.33MB + Engine InnoDB
    52EEovxKqC_ebay_categories: Data: 1.52MB + Index: 0.56MB + Engine InnoDB
    52EEovxKqC_ebay_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_ebay_log: Data: 193.55MB + Index: 2.33MB + Engine InnoDB
    52EEovxKqC_ebay_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_ebay_orders: Data: 299.59MB + Index: 0.48MB + Engine InnoDB
    52EEovxKqC_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_ebay_profiles: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_ebay_shipping: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_ebay_sites: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_ebay_stocks_log: Data: 12.49MB + Index: 0.07MB + Engine MyISAM
    52EEovxKqC_ebay_store_categories: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_ebay_transactions: Data: 217.52MB + Index: 0.78MB + Engine InnoDB
    52EEovxKqC_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_fbv_attachment_folder: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_followup_coupons: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_followup_coupon_logs: Data: 1.71MB + Index: 0.69MB + Engine MyISAM
    52EEovxKqC_followup_customers: Data: 1.61MB + Index: 2.29MB + Engine MyISAM
    52EEovxKqC_followup_customer_carts: Data: 11.85MB + Index: 0.56MB + Engine MyISAM
    52EEovxKqC_followup_customer_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_followup_customer_orders: Data: 1.35MB + Index: 0.77MB + Engine MyISAM
    52EEovxKqC_followup_email_excludes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_followup_email_logs: Data: 3.95MB + Index: 1.15MB + Engine MyISAM
    52EEovxKqC_followup_email_orders: Data: 13.72MB + Index: 2.68MB + Engine MyISAM
    52EEovxKqC_followup_email_tracking: Data: 1.89MB + Index: 1.16MB + Engine MyISAM
    52EEovxKqC_followup_followup_history: Data: 8.85MB + Index: 1.47MB + Engine MyISAM
    52EEovxKqC_followup_order_categories: Data: 3.77MB + Index: 6.40MB + Engine MyISAM
    52EEovxKqC_followup_order_items: Data: 2.93MB + Index: 5.05MB + Engine MyISAM
    52EEovxKqC_followup_subscribers: Data: 0.08MB + Index: 0.08MB + Engine MyISAM
    52EEovxKqC_followup_subscribers_to_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_followup_subscriber_lists: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_litespeed_avatar: Data: 0.21MB + Index: 0.16MB + Engine MyISAM
    52EEovxKqC_litespeed_img_optm: Data: 0.10MB + Index: 0.05MB + Engine MyISAM
    52EEovxKqC_litespeed_img_optming: Data: 0.33MB + Index: 0.12MB + Engine MyISAM
    52EEovxKqC_litespeed_url: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_litespeed_url_file: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_mapping_to_external_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_newsletters: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_newsletter_templates: Data: 1.07MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_scheduled_tasks: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_mailpoet_scheduled_task_subscribers: Data: 0.65MB + Index: 0.58MB + Engine MyISAM
    52EEovxKqC_mailpoet_segments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_statistics_woocommerce_purchases: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_subscribers: Data: 0.98MB + Index: 0.93MB + Engine MyISAM
    52EEovxKqC_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_mailpoet_subscriber_segment: Data: 0.55MB + Index: 0.54MB + Engine MyISAM
    52EEovxKqC_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_ngg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_ngg_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_ngg_pictures: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_oliver_pos_bridge_event_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_openpos_price_book: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_openpos_price_book_products: Data: 0.37MB + Index: 0.09MB + Engine MyISAM
    52EEovxKqC_openpos_promotions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_openpos_promotion_products: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_options: Data: 10.38MB + Index: 1.25MB + Engine InnoDB
    52EEovxKqC_order_inventory: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxe_exports: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM
    52EEovxKqC_pmxe_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxi_images: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxi_imports: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxi_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_postmeta: Data: 1028.94MB + Index: 256.50MB + Engine InnoDB
    52EEovxKqC_posts: Data: 55.56MB + Index: 20.09MB + Engine InnoDB
    52EEovxKqC_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    52EEovxKqC_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_sitemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_sm_advanced_search_temp: Data: 0.19MB + Index: 0.23MB + Engine MyISAM
    52EEovxKqC_sm_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_termmeta: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    52EEovxKqC_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_term_relationships: Data: 1.52MB + Index: 0.39MB + Engine InnoDB
    52EEovxKqC_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_tm_taskmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_usermeta: Data: 85.61MB + Index: 65.16MB + Engine InnoDB
    52EEovxKqC_users: Data: 5.52MB + Index: 4.55MB + Engine InnoDB
    52EEovxKqC_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_wc_category_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_wc_customer_lookup: Data: 5.52MB + Index: 5.03MB + Engine InnoDB
    52EEovxKqC_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_wc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    52EEovxKqC_wc_order_coupon_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_wc_order_product_lookup: Data: 18.55MB + Index: 14.06MB + Engine InnoDB
    52EEovxKqC_wc_order_stats: Data: 7.52MB + Index: 5.55MB + Engine InnoDB
    52EEovxKqC_wc_order_tax_lookup: Data: 4.52MB + Index: 4.03MB + Engine InnoDB
    52EEovxKqC_wc_point_of_sale_sale_reports: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wc_pos_grid_tiles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_wc_product_meta_lookup: Data: 0.38MB + Index: 0.55MB + Engine InnoDB
    52EEovxKqC_wc_rate_limits: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_wc_reserved_stock: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    52EEovxKqC_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfconfig: Data: 0.40MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wffilemods: Data: 5.78MB + Index: 0.78MB + Engine MyISAM
    52EEovxKqC_wfhits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfissues: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_wfknownfilelist: Data: 3.22MB + Index: 0.34MB + Engine MyISAM
    52EEovxKqC_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wflogins: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    52EEovxKqC_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfpklist_template_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wfstatus: Data: 0.24MB + Index: 0.10MB + Engine MyISAM
    52EEovxKqC_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_woocommerce_bundled_itemmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    52EEovxKqC_woocommerce_pickup_locations_geodata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    52EEovxKqC_woocommerce_square_customers: Data: 0.32MB + Index: 0.21MB + Engine MyISAM
    52EEovxKqC_woo_square_integration_deleted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_woo_square_integration_logs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_woo_wallet_transactions: Data: 0.23MB + Index: 0.06MB + Engine InnoDB
    52EEovxKqC_woo_wallet_transaction_meta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
    52EEovxKqC_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_wpmailsmtp_tasks_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    52EEovxKqC_wpml_mails: Data: 105.12MB + Index: 0.09MB + Engine MyISAM
    52EEovxKqC_wt_iew_action_history: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_wt_iew_mapping_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    52EEovxKqC_yith_wcwl: Data: 0.47MB + Index: 0.13MB + Engine InnoDB
    52EEovxKqC_yith_wcwl_lists: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
    52EEovxKqC_yoast_indexable: Data: 15.71MB + Index: 3.65MB + Engine MyISAM
    52EEovxKqC_yoast_indexable_hierarchy: Data: 0.45MB + Index: 0.99MB + Engine MyISAM
    52EEovxKqC_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    52EEovxKqC_yoast_primary_term: Data: 0.15MB + Index: 0.16MB + Engine MyISAM
    52EEovxKqC_yoast_seo_links: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
    52EEovxKqC_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    _op_receipt: 5
    _op_register: 2
    acf-field: 4
    acf-field-group: 1
    attachment: 5104
    atum_purchase_order: 1
    atum_supplier: 1
    blocks: 9
    custom_css: 1
    cwginstocknotifier: 153
    display_type: 7
    featured_item: 8
    follow_up_email: 11
    global_product_addon: 1
    ign_voucher: 1
    itsec-dash-card: 12
    itsec-dashboard: 2
    jetpack_migration: 2
    jp_img_sitemap: 3
    jp_img_sitemap_index: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    mailpoet_page: 1
    nav_menu_item: 13
    oembed_cache: 11
    op_transaction: 19318
    op_z_report: 1059
    page: 59
    popup: 7
    popup_theme: 8
    pos_outlet: 1
    pos_receipt: 1
    pos_register: 2
    pos_session: 7
    pos_temp_order: 25
    post: 4
    product: 3286
    revision: 9
    seedprod: 1
    shipping_package: 1
    shipping_validation: 1
    shop_coupon: 12938
    shop_order: 58197
    shop_order_refund: 3719
    supplier: 1
    ux_template: 1
    was: 29
    wc_conditional_fee: 1
    wc_membership_plan: 1
    wc_pickup_location: 1
    wp_global_styles: 1
    wpcf7_contact_form: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (42) ###
    
    WooCommerce Barcode: by Rafael De Jongh – 1.0
    Admin Columns Pro - WooCommerce: by AdminColumns.com – 3.7.1
    Admin Columns Pro: by AdminColumns.com – 5.7.1
    Advanced Custom Fields: by Delicious Brains – 5.12.1
    Akismet Anti-Spam: by Automattic – 4.2.4
    Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 2.7
    Contact Form 7: by Takayuki Miyoshi – 5.5.6.1
    Customer Reviews for WooCommerce: by CusRev – 4.41
    Flexible Checkout Fields PRO: by WP Desk – 3.2.5
    Flexible Checkout Fields: by WP Desk – 3.2.2
    Health Check & Troubleshooting: by The www.remarpro.com community – 1.4.5
    Jetpack: by Automattic – 10.9.1
    LiteSpeed Cache: by LiteSpeed Technologies – 4.6
    Barcode Printing for WooCommerce & Contact Form 7 - (premium): by  – 3.4.2
    WooCommerce Shipment Tracking API Extension for ReadyToShip: by ReadyToShip – 0.5
    Temporary Login Without Password: by StoreApps – 1.7.2
    WooCommerce Tiered Price Table (Premium): by bycrik – 2.7.0
    WooCommerce Blocks: by Automattic – 7.8.0
    TeraWallet: by WCBeginner – 1.3.24
    Woocommerce Admin Product Search By Title Only: by Andrea Debernardi – 1.0
    WooCommerce Advanced Shipping: by Jeroen Sormani – 1.0.14
    WooCommerce Cost of Goods: by SkyVerge – 2.11.1
    Follow-Up Emails: by WooCommerce – 4.9.22 (update to version 4.9.24 is available)
    Openpos -  Force update pos stock: by [email protected] – 1.0
    OpenPos - POS Credit Checkout: by [email protected] – 1.2
    Woocommerce OpenPOS - Price for POS: by [email protected] – 1.2
    Promotion for OpenPOS - Best woocomerce point of sale: by [email protected] – 1.1
    Woocommerce - Openpos -  TeraWallet: by [email protected] – 1.3
    Woocommerce OpenPos: by [email protected] – 5.9.2
    WooCommerce Payments: by Automattic – 4.2.1
    WooCommerce PayPal Payments: by WooCommerce – 1.8.1
    WooCommerce Product Add-ons: by WooCommerce – 5.0.0
    WooCommerce Product Bundles: by WooCommerce – 6.15.3 (update to version 6.15.5 is available)
    WooCommerce Shipment Tracking: by WooCommerce – 1.7.0
    Woocommerce Smart Coupon integrate with Openpos: by [email protected] – 1.0
    WooCommerce Smart Coupons: by StoreApps – 5.4.0 (update to version 5.5.0 is available)
    WooCommerce: by Automattic – 6.5.1
    WooSidebars: by WooCommerce – 1.4.6
    WP Crontrol: by John Blackbourn & crontributors – 1.12.1
    WP-Lister Pro for eBay: by WP Lab – 3.2.10
    WP Mail SMTP: by WPForms – 3.4.0
    WPLab Custom Code Snippets: by WPLab – 1.0.1
    
    ### Inactive Plugins (8) ###
    
    CAPTCHA 4WP: by WP White Security – 7.0.6.1
    FileBird: by Ninja Team – 4.9.9.1
    NextGEN Gallery: by Imagely – 3.26
    QR & Barcode Generator Label Printing Premium - Woolabel: by Wooaddons – 1.2.9
    Smart Manager - WooCommerce Inventory Management, Bulk Edit & more...: by StoreApps – 6.1.1
    User Switching: by John Blackbourn & contributors – 1.5.8
    WPide: by XplodedThemes – 2.6
    Yoast SEO: by Team Yoast – 19.0
    
    ### Must Use Plugins (1) ###
    
    Health Check Troubleshooting Mode: by  – 1.7.2
    
    ### Settings ###
    
    API Enabled: ?
    Force SSL: –
    Currency: AUD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    celebration_bundle (celebration_bundle)
    composite (composite)
    external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    woosb (woosb)
    
    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: #5 - /shop/
    Cart: #6 - /cart/
    Checkout: #7 - /checkout/
    My account: #8 - /my-account/
    Terms and conditions: #33132 - /d-o-a-policy-live-fish/
    
    ### Theme ###
    
    Name: Flatsome Child
    Version: 3.0
    Author URL: 
    Child Theme: ?
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.15.5
    Parent Theme Author URL: https://www.uxthemes.com/
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/terms.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product-cat.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome-child/woocommerce/emails/admin-new-order.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    flatsome/woocommerce/content-product_cat.php
    
    ### Product Bundles ###
    
    Database Version: 6.15.3
    Loopback Test: ?
    Template Overrides: –
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ?
    Shop country code: AU
    WooCommerce currency supported: ?
    PayPal card processing available in country: ?
    Pay Later messaging available in country: ?
    Webhook status: –
    Vault enabled: ?
    Logging enabled: –
    Reference Transactions: –
    Used PayPal Checkout plugin: ?
    
    ### WooCommerce Payments ###
    
    Version: 4.2.1
    Connected to WPCOM: Yes
    Blog ID: 207785377
    Account ID: acct_1L7wIW2HTplUl1oM
    
    ### Action Scheduler ###
    
    Cancelled: 1
    Oldest: 2022-05-31 22:00:13 +1000
    Newest: 2022-05-31 22:00:13 +1000
    
    Complete: 2,487
    Oldest: 2022-06-05 09:06:47 +1000
    Newest: 2022-06-08 19:57:48 +1000
    
    Failed: 21
    Oldest: 2022-06-06 11:17:33 +1000
    Newest: 2022-06-08 09:29:44 +1000
    
    Pending: 71
    Oldest: 2022-06-09 19:22:54 +1000
    Newest: 2022-06-22 10:52:36 +1000
    
    ### Status report information ###
    
    Generated at: 2022-06-08 20:04:39 +10:00
    
    Mirko P.

    (@rainfallnixfig)

    Hi @yourebayexpert,

    Thanks for sending over the system status report.

    Looking at the logs I can see a reference to this plugin:

    Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 2.7

    Can you please temporarily deactivate the plugin and check if it stops the scheduled action every hour?

    One thing I’d recommend here is to install the Query Monitor plugin – it will allow you to monitor what is happening within WordPress and provides you with information about the database queries that are executed by each plugin and theme during the page load.

    Thread Starter yourebayexpert

    (@yourebayexpert)

    its not the back in stock notifier as i have only recently started using that plugin and this issues has been going on for months

    this is the error i found that occurred on the 17min past the hour

    2022-06-06 01:17:33 +0000
    unexpected shutdown: PHP fatal error Uncaught DivisionByZeroError: Division by zero in /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Admin/Overrides/OrderTraits.php:34 Stack trace: #0 /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Admin/API/Reports/Products/DataStore.php(412): Automattic\WooCommerce\Admin\Overrides\OrderRefund->get_item_shipping_amount() #1 /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Internal/Admin/Schedulers/OrdersScheduler.php(169): Automattic\WooCommerce\Admin\API\Reports\Products\DataStore::sync_order_products() #2 [internal function]: Automattic\WooCommerce\Internal\Admin\Schedulers\OrdersScheduler::import() #3 /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Admin/Schedulers/SchedulerTraits.php(267): call_user_func_array() #4 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(307): Automattic\WooCommerce\Internal\Admin\Schedulers\ImportScheduler::do_action_or_reschedule() #5 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #6 /home/aquariu2/public_html/wp-includes/plugin.php(524): WP_Hook->do_action() #7 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/actions/ActionScheduler_Action.php(22): do_action_ref_array() #8 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/abstracts/ActionScheduler_Abstract_QueueRunner.php(65): ActionScheduler_Action->execute() #9 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(162): ActionScheduler_Abstract_QueueRunner->process_action() #10 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner->do_batch() #11 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(307): ActionScheduler_QueueRunner->run() #12 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #13 /home/aquariu2/public_html/wp-includes/plugin.php(476): WP_Hook->do_action() #14 /home/aquariu2/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AsyncRequest_QueueRunner.php(52): do_action() #15 /home/aquariu2/public_html/wp-content/plugins/back-in-stock-notifier-for-woocommerce/includes/library/wp-async-request.php(149): ActionScheduler_AsyncRequest_QueueRunner->handle() #16 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(307): WP_Async_Request->maybe_handle() #17 /home/aquariu2/public_html/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters() #18 /home/aquariu2/public_html/wp-includes/plugin.php(476): WP_Hook->do_action() #19 /home/aquariu2/public_html/wp-admin/admin-ajax.php(202): do_action() #20 {main} thrown in /home/aquariu2/public_html/wp-content/plugins/woocommerce/src/Admin/Overrides/OrderTraits.php on line 34
    Plugin Support Rashed Ripon (a11n)

    (@rur165)

    Hello @yourebayexpert ,

    Thanks for sharing the error message.

    I am not exactly sure if this is related to PHP version but please create a ticket so that we can investigate further. You are using some of our revenue-sharing extensions so we will be able to troubleshoot closely in the ticket.

    Also, according to your system status report, WP-Cron is disabled. Are you using a cron service from your host?

    Please include the SSR and a link to this thread so that we can track the progress here and help you properly.

    Thank you.

    Thread Starter yourebayexpert

    (@yourebayexpert)

    i have turned woocommerce payments OFF and disabled woocommerce admin and now all of a sudden my site is running super fast in back end and no more issues
    ?

    Plugin Support Sol J. a11n

    (@solstudioim)

    Hi @yourebayexpert

    i have turned woocommerce payments OFF and disabled woocommerce admin and now all of a sudden my site is running super fast in back end and no more issues

    I am happy that it’s finally resolved.

    But that’s really odd. I believe WooCommerce Payments and or WooCommerce Admin shouldn’t be a problem here.

    If you’re interested to find the real culprit you can do a full conflict test.
    ?
    To do the conflict test:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce, and WooCommerce Payments
    • Repeat the action that is causing the problem

    If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

    I hope that helps!

    If you have any other questions, do not hesitate to let us know!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Problems with Cron Scheduals crashing site’ is closed to new replies.