I have a problem with message consumers

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:

Shell

[Note] InnoDB: page_cleaner: 1000ms intended loop took 4011ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)

1	[Note] InnoDB: page_cleaner: 1000ms intended loop took 4011ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)

.

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.

Topic

[Andrey YatsenkoModerator]

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.

[Mauro ChojrinParticipant]

Got it. Thanks!

[Author]

Replies