Error: SQL memory overload

Created by Rosa Truong, Modified on Mon, 31 Aug, 2020 at 8:17 PM by Rosa Truong

Issue:

We installed  Magento 2 Auto Cancel Order v1.0.4 on a Magento 2.3.3 and selected all payment methods and Payment Method Group All payments groups after 1 hour,.

Consider Cancelation after in past

Nothing happens. Cron is running well and also with "Apply Now" nothing happens.

The Show Log is empty

Also tested on a demo webshop Magento 2.3.4, also nothing happens there.

Why is this not working?


Solution:

After checking, we have found that the issue is caused due to the fact that the SQL memory overload, the collection is too big.

The site has many orders and there are some other parts adding data in the order table.
Our module calls collection-> create () then adding the attribute to filter.

Thus, it causes the issue overload of the SQL memory  https://dl.dropboxusercontent.com/s/9cpsxsd8bz4dt2x/Screenshot%20at%2011-41-29.png 

To fix this issue, we would like to give a solution to limit collection with the latest 50 orders per time to make the module work normally.

Could you please check and edit this file app/code/Bss/AutoCancelOrder/Helper/CancelOrderImplementation.php?

And then replace the changed file and flush the cache as well.


Please don't hesitate to contact us if you need any further support.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article