Title: Database Errors Last modified: July 16, 2025 --- # Database Errors * Resolved [khushbu91](https://wordpress.org/support/users/khushbu91/) * (@khushbu91) * [10 months, 4 weeks ago](https://wordpress.org/support/topic/database-errors-86/) * Hello Again, I am getting some database errors, not sure what is triggering these, but these pop up randomly ever since we migrated to current host. I am not that tech savvy, had hired a coder who couldn’t identify the issues, and said since these aren’t fatal shouldn’t worry much, but I have my reasons to be worried. Any help appreciated. -  Jul 16, 18:14:26WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpstg0_options WHERE option_name = ‘wc_pending_batch_processes’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\ WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\ WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\ BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController- >get_enqueued_processors, get_option - [[[[ Jul 16, 18:14:26WordPress database error Commands out of sync; you can’t run this command now for query SELECT a.action_id FROM wpstg0_actionscheduler_actions a WHERE 1=1 AND a.hook=’wc_schedule_pending_batch_processes’ AND a.status IN (‘in-progress’, ‘pending’) LIMIT 0, 1 made by shutdown_action_hook, do_action(‘ shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\ Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\ Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\ BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore- >query_actions - [[[[ Jul 16, 18:08:28WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpstg0_options WHERE option_name = ‘wc_pending_batch_processes’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\ WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\ WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\ BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController- >get_enqueued_processors, get_option - [[[[ Jul 16, 18:08:28WordPress database error Commands out of sync; you can’t run this command now for query SELECT a.action_id FROM wpstg0_actionscheduler_actions a WHERE 1=1 AND a.hook=’wc_schedule_pending_batch_processes’ AND a.status IN (‘in-progress’, ‘pending’) LIMIT 0, 1 made by shutdown_action_hook, do_action(‘ shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\ Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\ Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\ BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore- >query_actions - Mark as fixed | Ignore Jul 16, 18:08:08WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpstg0_options WHERE option_name = ‘wc_pending_batch_processes’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook- >apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController- >Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\ Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController- >get_enqueued_processors, get_option * System Status Report * ```wp-block-code ### WordPress Environment ###WordPress address (URL): [Redacted]Site address (URL): [Redacted]WC Version: 10.0.2Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.Action Scheduler Version: ✔ 3.9.2Log Directory Writable: ✔WP Version: 6.8.2WP Multisite: –WP Memory Limit: 1 GBWP Debug Mode: –WP Cron: –Language: en_USExternal object cache: ✔### Server Environment ###Server Info: LiteSpeedServer Architecture: Linux 4.18.0-553.34.1.lve.el8.x86_64 x86_64PHP Version: 8.1.32PHP Post Max Size: 8 MBPHP Time Limit: 30PHP Max Input Vars: 1000cURL Version: 8.13.0OpenSSL/1.1.1wSUHOSIN Installed: –MySQL Version: 10.11.13-MariaDB-cll-lveMax Upload Size: 5 MBDefault Timezone is UTC: ✔fsockopen/cURL: ✔SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.DOMDocument: ✔GZip: ✔Multibyte String: ✔Remote Post: ✔Remote Get: ✔### Database ###[REDACTED]### Post Type Counts ###astra-advanced-hook: 3attachment: 8752custom_css: 4custom_order_status: 6custom-css-js: 3display_type: 7elementor_library: 6footer: 6megamenu: 3nav_menu_item: 37ngg_gallery: 2ngg_pictures: 136nomos_mapper: 6oembed_cache: 6page: 21post: 1product: 2689product_variation: 3194revision: 18shop_coupon: 1shop_order: 2448wcpa_pt_forms: 16wp_global_styles: 3wp_navigation: 1ziss: 1### Security ###Secure connection (HTTPS): ✔Hide errors from visitors: ✔### Active Plugins (20) ###Advanced Database Cleaner: by Younes JFR. – 3.1.6Advanced Woo Search: by ILLID – 3.38Astra Pro: by Brainstorm Force – 4.11.4Blackhole for Bad Bots: by Jeff Starr – 3.7.4Click to Chat: by HoliThemes – 4.25CompressX: by WPvivid Team – 0.9.29Simple Custom CSS and JS: by SilkyPress.com – 3.50Custom Order Status for WooCommerce: by Tyche Softwares – 2.8.0Elementor Pro: by Elementor.com – 3.30.0Elementor: by Elementor.com – 3.30.2Error Log Monitor: by Janis Elsts – 1.7.11XML Sitemap Generator for Google: by Auctollo – 4.1.21Health Check & Troubleshooting: by The WordPress.org community – 1.7.1LiteSpeed Cache: by LiteSpeed Technologies – 7.2Side Cart WooCommerce: by XootiX – 2.6.8Advanced Shipment Tracking for WooCommerce: by zorem – 3.8.4WooCommerce Custom Product Addons Free: by Acowebs – 3.0.16Advanced Order Export For WooCommerce: by AlgolPlus – 4.0.3WooCommerce: by Automattic – 10.0.2WP STAGING WordPress Backup Plugin - Backup Duplicator & Migration: by WP-STAGINGWPStagingBackup – 4.2.0### Inactive Plugins (3) ###Temporary Login: by Elementor.com – 1.3.0WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 4.7.8Woo Store Vacation: by MyPreview – 1.9.6### Dropin Plugins () ###object-cache.php: LiteSpeed Cache - Object Cache (Drop-in)### Must Use Plugins (3) ###Elementor Safe Mode: by Elementor.com – 1.0.0Health Check Troubleshooting Mode: by – 1.9.2WP STAGING Optimizer: by WP STAGING – 1.6.0### Settings ###Legacy API Enabled: –Force SSL: –Currency: INR (₹)Currency Position: leftThousand Separator: ,Decimal Separator: .Number of Decimals: 2Taxonomies: 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)Connected to WooCommerce.com: –Enforce Approved Product Download Directories: –HPOS feature enabled: ✔Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStoreHPOS data sync enabled: ✔Enabled Features: analyticsmarketplaceorder_attributionsite_visibility_badgeremote_loggingemail_improvementsblueprintpoint_of_salecustom_order_tables### Logging ###Enabled: ✔Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2Retention period: 100 daysLevel threshold: –Log directory size: 17 MB### WC Pages ###Shop base: #5169 - /Cart: #5170 - /cart-2/ - Contains the woocommerce_cart shortcodeCheckout: #5171 - /checkout-2/ - Contains the woocommerce_checkout shortcodeMy account: #5167 - /my-account-2/ - Contains the [woocommerce_my_account] shortcodeTerms and conditions: ❌ Page not set### Theme ###Name: AstraVersion: 4.11.5 (update to version 4.11.6 is available)Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_themeChild Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child themeTheme type: Classic themeWooCommerce Support: ✔### Templates ###Overrides: –### Admin ###Enabled Features: activity-panelsanalyticsproduct-block-editorcouponscore-profilercustomize-storecustomer-effort-score-tracksimport-products-taskexperimental-fashion-sample-productsshipping-smart-defaultsshipping-setting-tourhomescreenmarketingmobile-app-banneronboardingonboarding-taskspattern-toolkit-full-composabilityproduct-custom-fieldsremote-inbox-notificationsremote-free-extensionspayment-gateway-suggestionsprintfulshipping-label-bannersubscriptionsstore-alertstransient-noticeswoo-mobile-welcomewc-pay-promotionwc-pay-welcome-pagelaunch-your-storeadd-to-cart-with-options-stepper-layoutDisabled Features: product-data-viewsexperimental-blocksexperimental-iapi-mini-cartexperimental-iapi-runtimecoming-soon-newsletter-templateminified-jsproduct-pre-publish-modalsettingsasync-product-editor-category-fieldproduct-editor-template-systemuse-wp-horizonDaily Cron: ✔ Next scheduled: 2025-07-16 15:21:43 +05:30Options: ✔Notes: 240Onboarding: completed### Action Scheduler ###Complete: 5,702Oldest: 2025-06-15 14:00:14 +0000Newest: 2025-07-16 13:17:06 +0000Failed: 72Oldest: 2024-11-10 02:55:57 +0000Newest: 2025-07-04 08:44:24 +0000Pending: 4Oldest: 2025-07-16 14:02:00 +0000Newest: 2025-07-17 11:07:57 +0000### Status report information ###Generated at: 2025-07-16 19:08:02 +05:30 ``` Viewing 14 replies - 1 through 14 (of 14 total) * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [10 months, 4 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18558356) * Hi there, * Thanks for sharing the error logs. The message **“Commands out of sync; you can’t run this command now”** typically comes from the database server (MySQL) when multiple queries are attempted in the wrong sequence or when a previous query hasn’t been properly completed before a new one starts. * Since this kind of error can be influenced by the server environment (such as PHP timeout settings, database connection handling, or caching layers), I would recommend reaching out to your **hosting provider** and asking: - If there are any **MySQL connection limits, timeouts, or caching configurations**( e.g., LiteSpeed optimizations) that could interfere with WooCommerce’s batch processing or scheduled actions. - If they could help you **increase the following PHP/server settings**: * `max_execution_time` → at least **300** * `post_max_size` → **32M** or higher * This should help reduce the likelihood of those database sync issues during WooCommerce’s background processes. * Let us know what they say. * Thread Starter [khushbu91](https://wordpress.org/support/users/khushbu91/) * (@khushbu91) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18559135) * Hello, They asked me to edit these via Cpanel PHP Ini settings, I have inserted the values shown above, will report if any errors occur in future. * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18559343) * Hi there! * Thanks for the update! * That sounds good — editing the PHP INI settings via cPanel is a valid approach. Hopefully, that helps stabilize things. Please do keep an eye on it and feel free to reach out if any errors pop up again. We’ll be here to help if you need further assistance! * Thread Starter [khushbu91](https://wordpress.org/support/users/khushbu91/) * (@khushbu91) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18560952) * Hello, Had 3 errors last night -  Jul 18, 10:00:06Cron reschedule event error for hook: aDBc_clean_scheduler, Error code: could_not_set, Error message: The cron event list could not be saved., Data: {“schedule”:”hourly”,”args”:[“Expired_Transients”],”interval”: 3600} - [[[[ Jul 18, 00:39:46WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpstg0_options WHERE option_name = ‘wc_pending_batch_processes’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\ WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\ WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\ BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController- >get_enqueued_processors, get_option - [[[[ Jul 18, 00:39:46WordPress database error Commands out of sync; you can’t run this command now for query SELECT a.action_id FROM wpstg0_actionscheduler_actions a WHERE 1=1 AND a.hook=’wc_schedule_pending_batch_processes’ AND a.status IN (‘in-progress’, ‘pending’) LIMIT 0, 1 made by shutdown_action_hook, do_action(‘ shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\ Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\ Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\ BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore- >query_actions * - This reply was modified 10 months, 3 weeks ago by [khushbu91](https://wordpress.org/support/users/khushbu91/). * [Mahfuzur Rahman](https://wordpress.org/support/users/mahfuzurwp/) * (@mahfuzurwp) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18561133) * Hi [@khushbu91](https://wordpress.org/support/users/khushbu91/), * Thanks for sharing the error logs. * The first message (Cron reschedule event error) indicates that WordPress had trouble saving a scheduled task—this can sometimes happen due to a temporary database lock or lack of server resources. * The other two errors are related to **database command sync issues** during shutdown, specifically when WooCommerce tries to process batch actions (like background tasks or pending batch processes). * Since they started appearing right after the move to a new host, they’re likely connected to the new server environment—possibly due to database configuration, cron handling, or permission settings. * We recommend reaching out to your hosting provider with these logs. They’ll be in the best position to check server-side settings and help resolve the underlying issue. * Thank you. * Thread Starter [khushbu91](https://wordpress.org/support/users/khushbu91/) * (@khushbu91) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18561224) * My Host has given these 2 links * [https://rankmath.com/kb/wordpress-database-error-commands-out-of-sync/](https://rankmath.com/kb/wordpress-database-error-commands-out-of-sync/) * [https://www.malcare.com/blog/wordpress-database-error-commands-out-of-sync/](https://www.malcare.com/blog/wordpress-database-error-commands-out-of-sync/) * I am not sure what to do now. * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18561252) * Hi there! * I understand your concern. The link your hosting provider shared relates to fixing the database command sync issue you’re experiencing. * Please follow the instructions in the two articles provided to help identify which plugin or setting might be causing the problem. Once you’ve found the culprit plugin, I recommend reaching out to that plugin’s support team for further assistance in resolving the issue. * Thread Starter [khushbu91](https://wordpress.org/support/users/khushbu91/) * (@khushbu91) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18562678) * I did not encounter any database errors today, didn’t change anything. But for some reason, my website has become painstakingly slow! * [Mahfuzur Rahman](https://wordpress.org/support/users/mahfuzurwp/) * (@mahfuzurwp) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18562780) * Hi [@khushbu91](https://wordpress.org/support/users/khushbu91/), * Thanks for reaching out! If your site suddenly feels slow and you haven’t made any recent changes, it’s a good idea to check what might be happening behind the scenes. * I recommend installing the **Query Monitor** plugin; it will help you see which database queries are taking the most time and if any specific plugin or theme component is causing delays. * You can also run your site through [Google PageSpeed Insights](https://pagespeed.web.dev/) to get suggestions on what might be slowing things down from a front-end perspective. * Let us know what you find! * Thread Starter [khushbu91](https://wordpress.org/support/users/khushbu91/) * (@khushbu91) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18562893) * I did raise a ticket, hosting company shared a video of them logging in to the admin panel and things running smoothly, while I struggle, I am not sure if my ISP or my IP is being filtered to make the site load slow? As I have changed 2 wifi spots but with the same ISP * Thread Starter [khushbu91](https://wordpress.org/support/users/khushbu91/) * (@khushbu91) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18562895) * Also the DB error is back -  Jul 20, 01:50:40WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpstg0_options WHERE option_name = ‘wc_pending_batch_processes’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\ WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\ WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\ BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController- >get_enqueued_processors, get_option - Mark as fixed | Ignore Jul 20, 01:50:40WordPress database error Commands out of sync; you can’t run this command now for query SELECT a.action_id FROM wpstg0_actionscheduler_actions a WHERE 1=1 AND a.hook=’wc_schedule_pending_batch_processes’ AND a.status IN (‘in-progress’, ‘pending’) LIMIT 0, 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\ WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\ WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\ BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions * [Mahfuzur Rahman](https://wordpress.org/support/users/mahfuzurwp/) * (@mahfuzurwp) * [10 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18563267) * Hi [@khushbu91](https://wordpress.org/support/users/khushbu91/), * Thanks for the detailed follow-up! * Since the original database errors have returned and the site still feels slow on your end — while loading fine for your host — it’s possible there are two issues at play: 1. **The database sync error** is still server-related and affects WooCommerce background processes. I’d recommend sharing the recurring log entries with your host again and specifically ask them to check the MySQL configuration, especially max_allowed_packet, caching layers, and persistent connections that could cause“ commands out of sync” issues. 2. **Performance differences by ISP** might point to a regional routing issue, firewall filtering, or DNS-level caching. You can try: 3. - Testing with a different device or mobile hotspot from a different provider. - Flushing your local DNS or switching to a public DNS (like Google DNS or Cloudflare DNS). - Using tools like [https://tools.pingdom.com](https://tools.pingdom.com) or [https://www.webpagetest.org](https://www.webpagetest.org) to benchmark performance from other locations. * Thank you. Let us know what you find out. * [LovingBro (woo-hc)](https://wordpress.org/support/users/lovingbro/) * (@lovingbro) * [10 months, 2 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18573518) * Hi [@khushbu91](https://wordpress.org/support/users/khushbu91/), we haven’t heard back from you in a while, so I’m going to mark this as resolved. If you have any further questions, please don’t hesitate to contact us here or start a new thread. * We’d appreciate it if you could take a few moments to review the WooCommerce plugin using the link here: [https://wordpress.org/support/plugin/woocommerce/reviews/#new-post](https://wordpress.org/support/plugin/woocommerce/reviews/#new-post%C2%A0). * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [6 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18719694) * Moderator note: * [@rodrigonc23](https://wordpress.org/support/users/rodrigonc23/) , if you need support then per the forum guidelines please start your own topic at [https://wordpress.org/support/plugin/woocommerce/#new-post](https://wordpress.org/support/plugin/woocommerce/#new-post) * [https://wordpress.org/support/forum-user-guide/faq/#i-have-the-same-problem-can-i-just-reply-to-someone-elses-post-with-me-too](https://wordpress.org/support/forum-user-guide/faq/#i-have-the-same-problem-can-i-just-reply-to-someone-elses-post-with-me-too) Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Database Errors’ 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/) * 14 replies * 6 participants * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * Last activity: [6 months, 3 weeks ago](https://wordpress.org/support/topic/database-errors-86/#post-18719694) * Status: resolved