What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

halp how can I deal with ```Spryker\Zed\Oms\Business\Exception\LockException - Exception: State mach

U01G4K5E0J2
U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet
in Help

halp
how can I deal with

Spryker\Zed\Oms\Business\Exception\LockException - Exception: State machine trigger is locked. Propel exception: Failed to execute insert statement for Orm\Zed\Oms\Persistence\SpyOmsStateMachineLock. Error: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "spy_oms_state_machine_lock-identifier"

Comments

  • U01LKKBK97T
    U01LKKBK97T Posts: 287 🧑🏻‍🚀 - Cadet

    There is a table called spy_oms_state_machine_lock. The fact that there still is an entry should tell you, that some oms transition failed.
    Check table column spy_oms_transition_log.error_message for errors.
    Once you're sure that the error is fixed, you can delete the lock entry from spy_oms_state_machine_lock and go ahead.

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    and what if there is no error for item causing trouble?

  • U01LKKBK97T
    U01LKKBK97T Posts: 287 🧑🏻‍🚀 - Cadet

    Don't know. Might be that oms execution was interrupted somehow. Where does the error occur, locally?
    Lock entries are usually deleted after successful transition.

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    well, made a nasty workaround (one of those that make you want to wash your hands really well) and it seems that indeed there was an issue with transition but for some reason said issue was not logged in transition log and lock was not lifted and it prevented other timed events from executing

  • U01G4K5E0J2
    U01G4K5E0J2 Posts: 194 🧑🏻‍🚀 - Cadet

    but otherwise, yeah, great software

Categories