OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums Forums OroCommerce I have a problem with message consumers

This topic contains 2 replies, has 2 voices, and was last updated by  Mauro Chojrin 1 month, 3 weeks ago.

The forum will run in the read-only mode starting from March 1. Please head to StackOverflow for support.

  • Creator
    Topic
  • #41013

    Mauro Chojrin
    Participant

    Hi:

    I’ve been getting a lot of emails from my app with critical errors related to Orphans being found and re-delivered.

    I read through similar threads (like this one and this one) and my conclusion is there must have been something wrong with my sql server while the message queue was being processed…

    I checked the mysql logs and all I can see is:

    .

    Looking at the message queue I see the problem is related to the resizing of a product image.

    What I can see is that the mysql error report was generated very close to the update time (like 1 minute after that).

    I mannually deleted the messages from the queue but I’d like to put a more permanent solution in place.

    I’m using OroCommerce 3.1.12

    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Author
    Replies
  • #41021
    Andrey Yatsenko
    Andrey Yatsenko
    Moderator

    You are the first one who reported this issue.

    DBAL queue is not supposed to work with a large amount of data. In general, we recommend switching to an Enterprise version, as soon as it’s hard to manage in CE.

    You can follow SO post as it’s basically an environment configuration issue and there is nothing to do with the app.
    Also, we can recommend using http://www.mysqlcalculator.com as a configuration generator to tune MySQL for better performance.

    #41034

    Mauro Chojrin
    Participant

    Got it. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

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

Yes No