WC 5.6.1: Promotion Engine deadlocks

[VijayaR]

My client has customized their "add to cart" flow in such a way that in their custom code for OrderItemAdd, after the items are added successfully to the order, before they show the cart, they invoke "OrderPrepare" command to prepare the order with promotional discounts.

We noticed that "OrderPrepare" command takes around 4 seconds to prepare an order around 10 items or so, one of the reasons could be is the fact that my client has a high number(a couple of hundreds) of active promotions(which are only price discounts, no shipping or tax discounts). And more over, the promotion engine deadlocks when more than one order(from different shoppers ofcourse) are being prepared.

Has any one seen this behaviour? I strongly believe this could be a bug in Promotion Engine. We plan to open a PMR, but I thought of getting some opinions from the forum. I would love to hear from any one who uses promotion engine for a reasonably high traffic site.

-thanks

[m***@ca.ibm.com]

I am sending this to a developer.

[VijayaR]

Thanks. Can provide trace/debug info as needed.

[m***@ca.ibm.com]

the developers say:
I think the recommendation for them is not to call OrderPrepare command to calculate the discount. They should use the OrderCalculate command to call promotion engine for the discount.

They need to see the Order trace and dead lock logs, and need to know which 5.6.1 fixpak you are using.

[VijayaR]

Yes, my client recently replaced "OrderPrepare" with "OrderCalculate", it made no difference.

They do not have any fixpack yet. Could you please check with the developer whether they suggest 5.6.1.2 Fix Pack?

[m***@ca.ibm.com]

The developer needs to see the logs

he says:

5.6.1.2 had some performance improvement, but regarding the deadlock, i need to see the log first...

[VijayaR]

Hello Frances,

I plan to provide the logs and deadlock snap shots shortly.

But meanwhile could you ask the developer whether it is common to have high number of active promotions(say around 200).

Also is there any email address I can send the logs to?

-thanks