Error: SQL memory overload

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.

Reach us now!!

BSS Commerce is a full-service ecommerce agency with 14+ years of experience, supporting 75,000+ customers worldwide. As an Adobe Commerce Solution Bronze Partner and Select Magento Extensions Builder, we deliver trusted end-to-end solutions.

Our core strength is Magento, with 150+ extensions designed to enhance store performance and drive growth. With deep expertise from years of working on Magento websites, we deliver scalable, high-impact solutions backed by strong client trust.

Discover our extensions: https://bsscommerce.com/magento-2-extensions.html 

Our Magento B2B Extension by BSS Commerce is a flagship, widely used global solution, providing an all-in-one system for pricing, account management, and efficient B2B workflows.

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