Title: max_statement_time exceeded
Last modified: October 28, 2021

---

# max_statement_time exceeded

 *  Resolved [alexqbox](https://wordpress.org/support/users/alexqbox/)
 * (@alexqbox)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/)
 * Hello,
 * we have a strange issue in our development website. Almost every time when saving
   woocommerce belonging settings like products, mails, general setting the website
   is running into a timeout. We already enabled a log file. The Log shows the following:
 * > [22-Oct-2021 02:56:20 UTC] WordPress-Datenbank-Fehler Query execution was interrupted(
   > max_statement_time exceeded) für Abfrage DELETE FROM wp7r_wc_admin_note_actions
   > WHERE note_id = 6 von require(‘wp-blog-header.php’), require_once(‘wp-load.
   > php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘
   > init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\
   > Admin\Install::check_version, do_action(‘woocommerce_admin_updated’), WP_Hook-
   > >do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\RemoteInboxNotifications\
   > RemoteInboxNotificationsEngine::run_on_woocommerce_admin_updated, Automattic\
   > WooCommerce\Admin\RemoteInboxNotifications\RemoteInboxNotificationsEngine::
   > run, Automattic\WooCommerce\Admin\RemoteInboxNotifications\SpecRunner::run_spec,
   > WC_Data->save, WC_Data_Store->update, Automattic\WooCommerce\Admin\Notes\DataStore-
   > >update, Automattic\WooCommerce\Admin\Notes\DataStore->save_actions [22-Oct-
   > 2021 02:56:20 UTC] WordPress-Datenbank-Fehler Query execution was interrupted(
   > max_statement_time exceeded) für Abfrage ALTER TABLE wp7r_wc_admin_note_actions
   > CHANGE COLUMN `note_id` note_id BIGINT UNSIGNED NOT NULL von require(‘wp-blog-
   > header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘
   > wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters,
   > Automattic\WooCommerce\Admin\Install::check_version, Automattic\WooCommerce\
   > Admin\Install::install, Automattic\WooCommerce\Admin\Install::create_tables,
   > dbDelta [22-Oct-2021 02:56:20 UTC] WordPress-Datenbank-Fehler Query execution
   > was interrupted (max_statement_time exceeded) für Abfrage REPLACE INTO `wp7r_wc_admin_note_actions`(`
   > note_id`, `name`, `label`, `query`, `status`, `is_primary`, `actioned_text`,`
   > nonce_action`, `nonce_name`) VALUES (1, ‘wayflyer_q3_2021’, ‘Get funded’, ‘
   > [https://woocommerce.com/products/wayflyer/&#8217](https://woocommerce.com/products/wayflyer/&#8217);,‘
   > actioned’, 1, ”, NULL, NULL) von require(‘wp-blog-header.php’), require_once(‘
   > wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’),
   > do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\
   > Admin\Install::check_version, do_action(‘woocommerce_admin_updated’), WP_Hook-
   > >do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\RemoteInboxNotifications\
   > RemoteInboxNotificationsEngine::run_on_woocommerce_admin_updated, Automattic\
   > WooCommerce\Admin\RemoteInboxNotifications\RemoteInboxNotificationsEngine::
   > run, Automattic\WooCommerce\Admin\RemoteInboxNotifications\SpecRunner::run_spec,
   > WC_Data->save, WC_Data_Store->update, Automattic\WooCommerce\Admin\Notes\DataStore-
   > >update, Automattic\WooCommerce\Admin\Notes\DataStore->save_actions
 * It’s basically the same error code all the time. The main issue here is the **
   max_statement_time exceeded** but the value is with max_statement_time=300 already
   enough by the hoster. The hoster pointed out, that a command writing in the database
   table **wp7r_wc_admin_note_actions** takes way to long time and is running into
   the timeout.
 * We have no idea what could be the reason for that behavior. Do you have an idea
   and could help us with that? Why the script take too long to run the Query and
   ends up in a timeout?
 * Thanks, Alex

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

 *  Thread Starter [alexqbox](https://wordpress.org/support/users/alexqbox/)
 * (@alexqbox)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15014789)
 * The timeout appears when saving any options in the woocommerce settings but also
   by just navigating through the tabs with the following error screen: [https://ibb.co/4ZbCpYy](https://ibb.co/4ZbCpYy)
   Sometimes also just by loading products in the frontend. It’s a serious problem.
    -  This reply was modified 4 years, 5 months ago by [alexqbox](https://wordpress.org/support/users/alexqbox/).
 *  Plugin Support [Joash (a11n)](https://wordpress.org/support/users/joashrajin/)
 * (@joashrajin)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15014844)
 * Hi [@alexqbox](https://wordpress.org/support/users/alexqbox/) 👋
 * Thanks for sharing this with us. In order for us to get a better understanding
   of your Server Setup, 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.
 * Once we have that, we’ll be able to advise you further about this.
 *  Thread Starter [alexqbox](https://wordpress.org/support/users/alexqbox/)
 * (@alexqbox)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15014869)
 * Here we go [@joashrajin](https://wordpress.org/support/users/joashrajin/)
 *     ```
       ### WordPress Environment ###
   
       WordPress address (URL): https://hhomepage.com/evotecsolutions
       Site address (URL): https://hhomepage.com/evotecsolutions
       WC Version: 5.8.0
       REST API Version: ✔ 5.8.0
       WC Blocks Version: ✔ 5.9.1
       Action Scheduler Version: ✔ 3.3.0
       WC Admin Version: ✔ 2.7.2
       Log Directory Writable: ✔
       WP Version: 5.8.1
       WP Multisite: –
       WP Memory Limit: 4 GB
       WP Debug Mode: –
       WP Cron: ✔
       Language: de_DE
       External object cache: –
   
       ### Server Environment ###
   
       Server Info: LiteSpeed
       PHP Version: 7.4.24
       PHP Post Max Size: 1 GB
       PHP Time Limit: 300
       PHP Max Input Vars: 10000
       cURL Version: 7.71.0
       OpenSSL/1.1.1d
   
       SUHOSIN Installed: –
       MySQL Version: 10.3.31-MariaDB
       Max Upload Size: 1 GB
       Default Timezone is UTC: ✔
       fsockopen/cURL: ✔
       SoapClient: ✔
       DOMDocument: ✔
       GZip: ✔
       Multibyte String: ✔
       Remote Post: ✔
       Remote Get: ✔
   
       ### Database ###
   
       WC Database Version: 5.8.0
       WC Database Prefix: wp7r_
       Datenbank-Gesamtgröße: 5.90MB
       Datenbank-Datengröße: 5.11MB
       Datenbank-Indexgröße: 0.79MB
       wp7r_woocommerce_sessions: Daten: 0.03MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_api_keys: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_downloadable_product_permissions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_order_items: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_order_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_actionscheduler_actions: Daten: 0.02MB + Index: 0.03MB + Engine MyISAM
       wp7r_actionscheduler_claims: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_actionscheduler_groups: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_actionscheduler_logs: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_commentmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_comments: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_ewd_uwpm_email_links_clicked_events: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_ewd_uwpm_email_only_users: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_ewd_uwpm_email_open_events: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_ewd_uwpm_email_send_events: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_fusion_forms: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_fusion_form_entries: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_fusion_form_fields: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_fusion_form_submissions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_content_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_core_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_flags: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_languages: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_icl_languages_translations: Daten: 0.11MB + Index: 0.11MB + Engine MyISAM
       wp7r_icl_locale_map: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_message_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_node: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_reminders: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_strings: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_string_positions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_string_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_string_translations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_translate: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_translate_job: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_translations: Daten: 0.01MB + Index: 0.02MB + Engine MyISAM
       wp7r_icl_translation_batches: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_icl_translation_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_layerslider: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_layerslider_revisions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_links: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_litespeed_crawler: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_litespeed_crawler_blacklist: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_litespeed_url: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_litespeed_url_file: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailchimp_carts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailchimp_jobs: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailpoet_custom_fields: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailpoet_feature_flags: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailpoet_forms: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailpoet_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailpoet_newsletters: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailpoet_segments: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_mailpoet_settings: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailpoet_subscribers: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_mailpoet_user_agents: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mailpoet_user_flags: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mpp_category: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mpp_media: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_mpp_players: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_options: Daten: 4.00MB + Index: 0.11MB + Engine MyISAM
       wp7r_postmeta: Daten: 0.19MB + Index: 0.07MB + Engine MyISAM
       wp7r_posts: Daten: 0.41MB + Index: 0.02MB + Engine MyISAM
       wp7r_revslider_css: Daten: 0.09MB + Index: 0.01MB + Engine MyISAM
       wp7r_revslider_css_bkp: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_layer_animations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_layer_animations_bkp: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_navigations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_navigations_bkp: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_sliders: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_sliders_bkp: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_slides: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_slides_bkp: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_static_slides: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_revslider_static_slides_bkp: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_shortpixel_folders: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_shortpixel_meta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_termmeta: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_terms: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_term_relationships: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_term_taxonomy: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_usermeta: Daten: 0.04MB + Index: 0.01MB + Engine MyISAM
       wp7r_users: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_wc_admin_notes: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_admin_note_actions: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM
       wp7r_wc_category_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_customer_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_download_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_order_coupon_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_order_product_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_order_stats: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_order_tax_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_postfinancecheckout_attribute_options: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
       wp7r_wc_postfinancecheckout_completion_job: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp7r_wc_postfinancecheckout_method_config: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
       wp7r_wc_postfinancecheckout_refund_job: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp7r_wc_postfinancecheckout_token_info: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
       wp7r_wc_postfinancecheckout_transaction_info: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp7r_wc_postfinancecheckout_void_job: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
       wp7r_wc_product_meta_lookup: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_wc_reserved_stock: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wc_tax_rate_classes: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_wc_webhooks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_weu_user_notification: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_dhl_im_products: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_dhl_im_product_services: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_packaging: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_packagingmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_shipmentmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_shipments: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_shipment_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_shipment_items: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_shipment_labelmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_shipment_labels: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_shipping_provider: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_woocommerce_gzd_shipping_providermeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wpjf3_mr_access_keys: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wpjf3_mr_unrestricted_ips: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_wpmailsmtp_tasks_meta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_yith_wcbk_booking_notes: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_yith_wcbk_external_bookings: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_yith_wcbk_logs: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_yoast_indexable: Daten: 0.03MB + Index: 0.03MB + Engine MyISAM
       wp7r_yoast_indexable_hierarchy: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_yoast_migrations: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
       wp7r_yoast_primary_term: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_yoast_seo_links: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
       wp7r_yoast_seo_meta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
   
       ### Post Type Counts ###
   
       attachment: 46
       fusion_element: 1
       fusion_form: 1
       mailpoet_page: 1
       nav_menu_item: 18
       page: 11
       product: 2
       revision: 6
       shop_order: 4
       uwpm_mail_template: 1
       wc_booking: 1
       yith_booking: 1
   
       ### Security ###
   
       Secure connection (HTTPS): ✔
       Hide errors from visitors: ✔
   
       ### Active Plugins (20) ###
   
       WPML Multilingual CMS: von OnTheGoSystems – 4.4.12
       Avada by hhomepage Builder - Horizontal & Vertical Duo Button: von ArcticLune – 2.1.0
       All-in-One WP Migration Dropbox Extension: von ServMask – 3.64
       All-in-One WP Migration: von ServMask – 7.49
       Media Hovers: von Tean – 3.61
       Enable Media Replace: von ShortPixel – 3.6.1
       Avada by hhomepage Builder: von Avada by hhomepage – 3.5
       Avada by hhomepage Core: von Avada by hhomepage – 5.5
       Avada by hhomepage Custom Branding: von Avada by hhomepage – 1.2
       FWD Ultimate 3D Carousel: von FWD – 1.3
       Loco Translate: von Tim Whitlock – 2.5.5
       Mailchimp for WooCommerce: von Mailchimp – 2.5.3
       Ultimate WP Mail: von Etoile Web Design – 1.0.9
       WooCommerce PostFinance Checkout: von wallee AG – 1.7.0
       Direct Checkout for WooCommerce: von QuadLayers – 2.5.5
       Germanized für WooCommerce: von vendidero – 3.6.3
       WooCommerce: von Automattic – 5.8.0
       Yoast SEO: von Team Yoast – 17.4
       YITH Booking and Appointment for WooCommerce Premium: von YITH – 2.3.0
       YITH WooCommerce Featured Audio and Video Content Premium: von YITH – 1.3.12
   
       ### Inactive Plugins (5) ###
   
       LiteSpeed Cache: von LiteSpeed Technologies – 4.4.3
       Maintenance Redirect: von Peter Hardy-vanDoorn since 03/18; based on the original by Jack Finch – 1.7
       Media File Renamer (Pro): von Jordy Meow – 5.0.8
       ShortPixel Image Optimizer: von ShortPixel – 4.22.6
       WP Mail SMTP: von WPForms – 3.1.0
   
       ### Settings ###
   
       API Enabled: –
       Force SSL: –
       Currency: CHF (CHF)
       Currency Position: left_space
       Thousand Separator: '
       Decimal Separator: .
       Number of Decimals: 2
       Taxonomies: Product Types: booking (booking)
       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-Basis: #271 - /shop/
       Warenkorb: #272 - /warenkorb/
       Kasse: #273 - /kasse/
       Mein Konto: #274 - /mein-konto/
       Allgemeine Geschäftsbedingungen: #202 - /agb/
   
       ### Theme ###
   
       Name: Avada Child
       Version: 1.0.0
       Author URL: https://theme-fusion.com
       Child Theme: ✔
       Parent Theme Name: Avada
       Parent Theme Version: 7.5
       Parent Theme Author URL: https://themeforest.net/user/Avada%20by%20hhomepage
       WooCommerce Support: ✔
   
       ### Templates ###
   
       Overrides: Avada/woocommerce/cart/cart.php
       Avada/woocommerce/checkout/form-pay.php
       Avada/woocommerce/checkout/review-order.php
       Avada/woocommerce/checkout/thankyou.php
       Avada/woocommerce/loop/loop-start.php
       Avada/woocommerce/single-product/add-to-cart/variable.php
       Avada/woocommerce/single-product/short-description.php
       Avada/woocommerce/single-product/tabs/additional-information.php
       Avada/woocommerce/single-product/tabs/description.php
   
       ### Action Scheduler ###
   
       Ausstehend: 86
       Oldest: -0001-11-30 00:34:08 +0034
       Newest: 2021-10-25 14:32:33 +0200
   
       Abgebrochen: 1
       Oldest: -0001-11-30 00:34:08 +0034
       Newest: -0001-11-30 00:34:08 +0034
   
       ### Status report information ###
   
       Generated at: 2021-10-28 12:53:37 +02:00
       ```
   
    -  This reply was modified 4 years, 5 months ago by [alexqbox](https://wordpress.org/support/users/alexqbox/).
 *  Plugin Support [Joash (a11n)](https://wordpress.org/support/users/joashrajin/)
 * (@joashrajin)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15015195)
 * Thanks [@alexqbox](https://wordpress.org/support/users/alexqbox/) 😀
 * The server settings seem perfect, but it could be that there is some sort of 
   conflict.
 * Since this is a development website, could you please run some tests on it to
   see if there are any conflicts?
 * You can use the tests outlined here to figure this out: [https://docs.woocommerce.com/document/how-to-test-for-conflicts/](https://docs.woocommerce.com/document/how-to-test-for-conflicts/)
 * **Note**: An easy way to test for conflicts on your development site is by enabling
   [Storefront](https://woocommerce.com/storefront/) or Twenty Twenty-One as your
   theme, then disabling all plugins besides WooCommerce. Once you have that done,
   you can test again to see if these errors persist or not.
 * Let me know how it goes 👍
 *  Thread Starter [alexqbox](https://wordpress.org/support/users/alexqbox/)
 * (@alexqbox)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15017339)
 * Hi [@joashrajin](https://wordpress.org/support/users/joashrajin/),
 * so i did exactly that, i disabled every plugin except Woocommerce. I switched
   to the default theme twenty twenty one. The issues are still the same. I am just
   going to the woocommerce settings, switching tabs without saving anything –> 
   timeout. Also when opening products and switching between them –> timeout. Same
   behaviour if saving something. But if i save normal pages or theme settings e.
   g. all works fine.
 * I have no clue what is causing that behaviour as we are running other websites
   with woocommerce without any problem.
 * I just uploaded a video which you can find here, please have a look: [https://www.mediafire.com/file/g0evmqb6bcg2z3w/Bildschirmaufnahme+2021-10-29+um+10.40.08.mov/file](https://www.mediafire.com/file/g0evmqb6bcg2z3w/Bildschirmaufnahme+2021-10-29+um+10.40.08.mov/file)
 * Also a re-install of woocommerce doesn’t solve the problem. The issue persists.
   I really think it’s belonging to the one database table wp7r_wc_admin_note_actions
   wich seems corrupt.
 * Thanks for your help! Alex
 *  Plugin Support [Joash (a11n)](https://wordpress.org/support/users/joashrajin/)
 * (@joashrajin)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15018645)
 * Thank you very much for sharing that with us [@alexqbox](https://wordpress.org/support/users/alexqbox/)
   👍
 * Could you please try going to WooCommerce > Status > Tools > ‘Verify base database
   tables’, and try running that to see if all of the tables exist correctly on 
   your database: [https://d.pr/i/nQ5aH2](https://d.pr/i/nQ5aH2)
 * You can also try using the ‘Update Database’ button afterward to see if it helps.
 * If both of them do not work, then it’s likely that the database is corrupted 
   in some way. You’ll need to follow the advise shown [here](https://kinsta.com/knowledgebase/wordpress-repair-database/#how-to-repair-the-wordpress-database-in-phpmyadmin)
   to repair it or try creating a new staging/development site to see if that works
   correctly.
 * I hope this helps 👍
 *  Thread Starter [alexqbox](https://wordpress.org/support/users/alexqbox/)
 * (@alexqbox)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15018987)
 * Hi [@joashrajin](https://wordpress.org/support/users/joashrajin/),
 * thanks, i think i could fix it. Was running the Database verification which was
   fine. Was going to update the database afterwards as well, it was adding a hook
   to the planned actions. Then i saw like 90 old planned actions which never run
   and it was always the same hook as you can see here: [https://ibb.co/nBx7x4V](https://ibb.co/nBx7x4V)
   So i cleaned it up, deleted all old hooks and was running the new one hook from
   the database update. Also i was running the wordpress included database repair
   function which was fine and doesn’t show any errors.
 * Now i am clicking through the site and all seems fine. No timeouts so far. I 
   guess the issue appeared as the hooks in planned actions got stuck at some point.
   Every few minute the same hook was added and the database was overwhelmed obviously.
   That would explain the timeouts.
 * I still don’t know why the hooks stuck and could not run. If it happens again
   i will let you know.
 * Thank you for pointing me in the right direction. Appreciated.
 * Cheers Alex
 *  [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
 * (@rainfallnixfig)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15038237)
 * Hi [@alexqbox](https://wordpress.org/support/users/alexqbox/),
 * It sounds you’re all set for now! Great to hear that.
 * I’m going to set this thread as resolved. You can open a new topic whenever you
   feel you have some other questions or concerns.
 * Have a nice day!
 *  [Dan Miller Coding](https://wordpress.org/support/users/danmillercoding/)
 * (@danmillercoding)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15041505)
 * having issue with wayflyer_q3_2021
 * How did you fix it?
 *  [Abiola Ogodo](https://wordpress.org/support/users/oaoyadeyi/)
 * (@oaoyadeyi)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15042307)
 * [@danmillercoding](https://wordpress.org/support/users/danmillercoding/)
 * From how the user resolved their issue, their hooks were not running completely
   in **Dashboard ** -> **Tools **-> **Scheduled Action**. For that reason, they
   were experiencing timeouts. To resolve, they deleted those pending actions and
   didn’t experience the error further.
 * I also recommend going through this guide: [https://wordpress.org/support/article/common-wordpress-errors/#connection-timed-out](https://wordpress.org/support/article/common-wordpress-errors/#connection-timed-out)

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

The topic ‘max_statement_time exceeded’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [time-out](https://wordpress.org/support/topic-tag/time-out/)

 * 10 replies
 * 5 participants
 * Last reply from: [Abiola Ogodo](https://wordpress.org/support/users/oaoyadeyi/)
 * Last activity: [4 years, 5 months ago](https://wordpress.org/support/topic/max_statement_time-exceeded/#post-15042307)
 * Status: resolved