Databse Error Commands Out Of Sync

  • My online store is experiencing the same problem. Latest Woocommerce with HPOS, Payment Plugins for Stripe WooCommerce, LiteSpeed Cache, Yoast SEO, WP Mail SMTP. I’ve been pulling my hair out trying to find the cause yet so far without any luck. Enable compatibility mode was checked, 1 week later it was unchecked. But every time it is unchecked, the orders add up and are pending sync. What is stopping this from happening automatically? It seems as though every time “woocommerce_hpos_legacy_data_cleanup_in_progress” is in the queue, the database error commands out of sync message is displayed.

    [03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM ****_options WHERE option_name = ‘woocommerce_hpos_legacy_data_cleanup_in_progress’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->is_flag_set, get_option

    [03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT umeta_id FROM _usermeta WHERE meta_key = ‘_yoast_notifications’ AND user_id = 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast_Notification_Center->update_storage, array_walk, Yoast_Notification_Center->store_notifications_for_user, update_user_option, update_user_meta, update_metadata

    [03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM ****_usermeta made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast_Notification_Center->update_storage, array_walk, Yoast_Notification_Center->store_notifications_for_user, update_user_option, update_user_meta, update_metadata, add_metadata

    [03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM ****_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock

    [03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM ****_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock

    [03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query INSERT INTO ****_options (option_name, option_value, autoload) VALUES (‘action_scheduler_lock_async-request-runner’, ‘665e234646eec6.65761982|1717445506’, ‘no’) made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set

    [03-Jun-2024 20:10:46 UTC] WordPress database error Commands out of sync; you can’t run this command now for query UPDATE ****_options SET option_value = ‘1720037446’ WHERE option_name = ‘_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option

Viewing 1 replies (of 1 total)
  • Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hello ?? @bamsyamann,

    Thank you for reaching out.

    I understand you are facing issues with your database commands being out of Sync. This is indeed unusual.

    As a first step to troubleshoot the issue, I recommend the following steps:

    1. Try deactivating all your plugins except WooCommerce and see if the issue persists. If it doesn’t, reactivate each plugin one by one until you find the one causing the conflict. Please be sure to create a full site backup before performing this.
    2. Contact your hosting provider and ask them to check if there are any server error logs or issues with your server or MySQL configuration.

    Let us know how this goes.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.