We have lunched our website with 3 servers as load balancing. We are facing a big issue with stock quantity as seems something caching the stocks and affecting the customer as he can ask items that are become 0 stocks, I am attaching a sample of stock history for one of the items and marked the issue with yellow & Red.
For example:
1- Product "P1" has 4 stocks.
2- Customer1 session connected to server1, and asked for 1 item. Stock is 3 now.
3- Custoemr2 session connected to server2, asked for 1 item, stock is become 3 as still caching the quantity 4!.
In addition, I have implemented the distributed caching to be SQL as attached.
We are using F5 loadbalancer with source address persistence profile
Our nopcommerce version is 4.40.2
Is there any clue why this happened?
