I can't really grasp why this would occur as price freezing goes via the product price freezer which always does a lookup to see if one exists prior to freezing a price.
Do you have any replication steps to reproduce this? Is there anything that could be affecting this? server infrastructure / custom code?
Cannot insert duplicate key row in object 'dbo.vendrFrozenPrice'
Hi,
Sorry for posting twice today.
We have another error in the log we could not get our head around. Is there any information on the exception below?
This is the exception:
Is this the right exception? It looks like the same stack trace from https://our.umbraco.com/packages/website-utilities/vendr/vendr-support/104214-deadlock-on-orderservicesaveorder-order-entity 🤔
I'm sorry, need some sleep I guess :D
I just edited my post!
Ok, so it doesn't tell me a great deal anyway, but ultimately it looks like it's trying to re-freeze a price for a product on an order (Read here for more info on price freezing https://vendr.net/docs/core/1-3-0/key-concepts/price-freezing/)
I can't really grasp why this would occur as price freezing goes via the product price freezer which always does a lookup to see if one exists prior to freezing a price.
Do you have any replication steps to reproduce this? Is there anything that could be affecting this? server infrastructure / custom code?
Matt
For completeness.
This problem was solved.
We had an issue with the product page which tried to save the order entity multiple times.
This was also the reason for this problem: https://our.umbraco.com/packages/website-utilities/vendr/vendr-support/104214-deadlock-on-orderservicesaveorder-order-entity#comment-325285
Thanks for coming back and confirming the issue. Hopefully it might help someone else in the future should they have the same problem.
Matt
is working on a reply...