Scheduled sales behaving wrong

Hi,

I have a store with 50,000 products. We increased our server for a sales event to a HUGE machine (64gb RAM, 16core) so hardware-power wasn’t an issue.

We scheduled sale prices for 15,000 products. When the day changed and the cron function ran, the products were looking like sales (with red price and strikethrought) BUT the price that was shown was the regular one.
I checked the products and the sale prices were indeed added and the dates were accurate, but some prices were changing while others were not.

If I entered a product and saved it (without making any changes) the price will be shown correctly.

I re-run the cron several times without any positive results. I re-imported and some product prices changed, while others didn’t. After a while they started to change until all of them did, but the behavior was completely strange.

Redis was disabled and all kinds of cache were flushed several times, so it wasn’t a cache thing.

Is there any explanation for this? We will need to change prices again (when the sale ends) and I’m afraid it won’t work as expected again.

Thanks!