OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

Forums 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 5 years, 4 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #37647

    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
    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)

The forum ‘OroPlatform – Installation/Technical Issues or Problems’ is closed to new topics and replies.

Back to top