Some errors after migrations and use HPOS

  • Resolved Paul Vek

    (@paulvek)


    11 months ago

    I recently migrated to HPOS in my store that has customers and orders (I used this feature).
    After complete transfer and sing and activation of HPOS option, I removed the compatibility check. (I disabled)
    Complete migration and use of HPOS was done. But then errors were revealed in the log. They seem important.
    Anyway, what should be done now? There is no way back! It doesn’t seem like there is a malfunction of the site, but in any case those errors are there and there must be a reason. No need to worry? What should be done? I wanted to report the problem so that you can fix it. Thank you.

    [25-Apr-2024 00:30:06 UTC] ???? ?????? ???????????? ???? Cron ???? ????: action_scheduler_run_queue, ?? ???: could_not_set, ????? ???: ???? ?????? corn ??????? ????? ???., ????: {"schedule":"every_minute","args":["WP Cron"],"interval":60}
[25-Apr-2024 00:47:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_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\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->is_enqueued, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
[25-Apr-2024 00:47:48 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_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
[25-Apr-2024 05:34:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_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\DataStores\Orders\LegacyDataCleanup->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\LegacyDataCleanup->maybe_reset_state, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->is_enqueued, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->get_enqueued_processors, get_option
[25-Apr-2024 05:34:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_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
[25-Apr-2024 05:34:29 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = '1716615269' 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, wp_cache_set, WP_Object_Cache->set, WP_Object_Cache->_transient_set, update_option
Viewing 15 replies - 1 through 15 (of 19 total)
  • talexandru00

    (@talexandru00)

    same here. Found them after migrating to HPOS in woocoommerce. The errors were in error_log in the public_html

    [26-Apr-2024 19:11:51 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wpup_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

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello Paul Vek

    Thank you for contacting WooCommerce support.

    Could you please tell me for how long did you leave the “Enable compatibility mode” option checked? It is advisable to maintain compatibility mode for some time to ensure a seamless transition.

    More details about HPOS activation can be found here:
    https://woocommerce.com/document/high-performance-order-storage/#how-to-enable-high-performance-order-storage

    To help you further, I’d like to review your site’s System Status Report.
    You can find it via WooCommerce > Status.
    Select Get system report and then Copy for support.

    Once you’ve done that, you can paste the text in https://gist.github.com
    After that, you can paste the Gist link here in your reply.

    I look forward to your reply. ??

    Best regards.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello talexandru00

    Thank you for your message here.

    As per our support policy, I will suggest you create a new topic so I can assist you with your query separately.

    I appreciate your cooperation for this. ??

    Best regards.

    Thread Starter Paul Vek

    (@paulvek)

    Hello @doublezed2 thank you for your response

    I didn’t keep it active for long time maybe 6 hours. I had read the instructions you sent. But when I felt the process was complete and the high performance activation option was enabled I enabled it and disabled the compatibility option.

    I don’t think there is anything wrong with my method. I feel you should have considered a better mechanism for HPOS. After all this time, it is still a big challenge to transition to it.

    However, I got those errors but I’m still using the new feature, if there’s any problem, I’m afraid to go back to the previous state in case there’s a problem with the data.

    I went to take a look at that section, to my surprise I saw a few tables waiting to be synced. I had done it once. And I had kept the HPOS mode active, however, it seems that there are still things in the process waiting for the command to execute and synchronize. I don’t know, maybe this is not needed and there is no need for this work, and this is for the opposite mode, that is, instead of transferring to the orders table, it transfers from the orders table to the posts table.

    https://i.imgur.com/eWowHFu.png

    HPOS is a good feature, but even for me, who knows about WordPress development and has a hand in programming to some extent, this process is boring, uncertain, and daunting!

    Thread Starter Paul Vek

    (@paulvek)

    sorry I forgot to paste my gist link to my Previous answer. now I put this to the below line:

    https://gist.github.com/paulvek/4fd1b1698d8a7fd8728cce14b7004027

    Please read both my answers.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello Paul Vek

    Thank you for your reply.

    I understand you enabled the compatibility mode for about six hours.
    I suggest you activate the compatibility mode again and leave it enabled for a few days.
    This will make sure all the data is synced properly.

    Make sure to check WooCommerce → Status → Scheduled Actions for any failed or pending actions related to HPOS. Let me know if you see any.

    Further details about enabling HPOS can be found in this guide.

    I hope this helps.
    If you have any other questions, I am here for you. ??

    Best regards.

    Thread Starter Paul Vek

    (@paulvek)

    thanks @doublezed2

    I explained my concerns about reactivating it. Is there any problem if I reactivate it?
    Now I have kept HPOS and compatibility enabled again, right?
    How many days should this state be maintained and after how many days should I remove the compatibility check? (disable) and only HPOS remains active? And then it’s over?

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello Paul Vek

    Thank you for your reply.

    I understand your concerns about reactivating the compatibility mode again.

    I recommend leaving it enabled for a couple of days to ensure the sync process is complete.
    Once you enable the compatibility mode, check if there is a message showing Pending orders.
    Here is an example for your reference:

    I look forward to your response. ??

    Best regards.

    Thread Starter Paul Vek

    (@paulvek)

    here is features settings

    and scheduled items. (After a day of reactivating compatibility mode, they are still pending).

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello Paul Vek

    Thank you for your reply.

    It looks like a hook has been set to sync the orders table.
    Could you confirm if your site is active and visited frequently?

    Please note that these Hooks rely on WordPress’s built-in WP-Cron system.
    In short, WP-Cron triggers when someone visits your website.

    Let me know what is the latest status of these Hooks in your reply.
    I am here for you until this issue is resolved. ??

    Best regards.

    Thread Starter Paul Vek

    (@paulvek)

    Yes, Our site is active, has visitors and sales.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello Paul Vek

    Thank you for your reply.

    If the site is active and regularly visited then the Hooks should be triggered.
    However, since there are pending hooks and over 100 failed hooks, this suggests something is interfering with the default WooCommerce functionality.

    The best steps to diagnose this issue further will be by performing a Conflict Test.
    As you mentioned, this is a live site, I suggest you create a Staging site.
    You may ask your host if they provide a Staging site feature.
    You can also use a free plugin WP STAGING to create a staging site.

    Once you create a staging site, please disable all the plugins except WooCommerce and change the theme to Storefront. This will allow me to diagnose the issue in the default environment.

    Let me know if you have any questions. ??

    Best regards.

    Hello ?? We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

    @paulvek

    salam dost man . moshkel chetor hal shod ?

    Hey, @mohamadmoghadasi!

    Per WordPress forum guidelines, would you mind opening up a new thread for this so that we can keep things organized and offer more personalized support for you? We’ll be happy to help you out with this over there!

    Have a wonderful day!

Viewing 15 replies - 1 through 15 (of 19 total)
  • The topic ‘Some errors after migrations and use HPOS’ is closed to new replies.