Error with WooCommerce HPOS

  • Resolved wpsmartbr

    (@wpsmartbr)


    10 months, 3 weeks ago

    We have been experiencing the above error message when attempting to activate Woocommerce HPOS in our site. After sync completed the option disable.

    Error Log:

    2024-05-06T22:10:56+00:00Erro PostsToOrdersMigrationController: when executing SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED: Transaction characteristics can't be changed while a transaction is in progress Contexto adicional{ "error": "Transaction characteristics can't be changed while a transaction is in progress" }

    We would appreciate any guidance on how to troubleshoot and resolve this issue. Specifically, we would like to understand:

    1. The root cause of this error and its implications for WooCommerce HPOS.
    2. Any potential configuration settings or code adjustments that could mitigate or resolve this error.

    If possible, please provide detailed instructions or suggestions for resolving this error. Thank you very much in advance.

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello wpsmartbr,

    Thank you for reaching out to Woo support!

    Just to confirm, are you currently following the steps provided in this guide?

    I would love to know how you can determine that the Sync has been successfully completed.

    Following our guidelines, I kindly suggest keeping the “Enable compatibility mode” option checked for a couple of days. This will help ensure that there are no pending actions.

    Lastly, would you mind sharing screenshots of the HPOS page and the Scheduled Actions page?
    Scheduled Actions are available at WooCommerce → Status → Scheduled Actions.

    Looking forward to your response. ??

    Best regards!

    Thread Starter wpsmartbr

    (@wpsmartbr)

    Hi Zubair, 

    Thanks for your reply. Yes, we are following all the steps in the guide. The sync completed but the High-performance order storage option keeps grayed out and disabled with no explanation?or apparent?error except that only one in the posts-to-orders-migration log.?Find below the screenshot links. Note that pending task refer to future subscriptions we have, but are up to date. If you tell me the specific name of the action you are looking for, I can send you more details about it. We are very grateful for your help and looking forward for more information to resolve this issue.

    https://drive.google.com/file/d/1MlSNqsOqzEj0dGE-KMncAswhncoYRop_/view

    https://drive.google.com/file/d/16W0plpzOPllH5hVcPi9UBURsFpjvvpkD/view?usp=sharing

    Hi @wpsmartbr,

    Thanks for sharing further details on this.

    Just want to confirm, are you able to manually run the scheduled actions from your end? If it’s possible, please try manually running the scheduled actions and then visit?WooCommerce ? Status ? Tools?and run the?Verify base database tables?tool.

    Let us know if that reports any problems or if it fixes any problem.

    Hi! 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.

    Thread Starter wpsmartbr

    (@wpsmartbr)

    Hi guys,

    Sorry for the delay in responding, we need some time to get permission to carry out these tests directly on the production server. So we did the database check that you recommended and also ran a database repair and nothing worked.

    After some attempts, we noticed that through the WordPress administration, the number of orders to be synchronized (17k) did not match the number of orders existing in the store (105k+). Then the idea of ??doing it through the WP CLI came up and it worked, the CLI synchronized all orders (105k) and we were finally able to activate HPOS.

    Maybe it would be worth taking a look to see if there is a problem with Woocommerce. Thanks a lot for your help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error with WooCommerce HPOS’ is closed to new replies.