OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

Forums OroPlatform OroPlatform – Installation/Technical Issues or Problems multiple consumers -> Deadlock found when trying to get lock

This topic contains 1 reply, has 2 voices, and was last updated by Andrey Yatsenko Andrey Yatsenko 11 months, 3 weeks ago.

  • Creator
    Topic
  • #37647
    Ahmad Golzar
    Ahmad Golzar
    Participant

    Hello,

    ORO Platform version: 2.6.31

    When I have more than one instance of consumers running by supervisor:

    I get lots of these errors:

    An exception occurred while executing ‘DELETE FROM oro_message_queue WHERE id=:messageId LIMIT 1’ with params [\”2541\”]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /home/oropl/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115

    An error occurred while running command “‘oro:message-queue:consume’ –env=prod”. An exception occurred while executing ‘DELETE FROM oro_message_queue WHERE id=:messageId LIMIT 1’ with params [“2541”]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction {“exit_code”:0,”exception”:”[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0)

    When I change it to only one instance of consumer problem is resolved.

    Is this an issue?

    Thanks

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #37664
    Andrey Yatsenko
    Andrey Yatsenko
    Moderator

    Deadlock in MQ could be OK in some rear cases, the message should be redelivered with some delay and will be processed next time without locks.
    If you have deadlocks all the time, probably it’s a bug. In that case, please share a number of records, consumer working on and what messages are in progress.

    Thank you.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No