on 2021 Jul 13 6:10 AM
we are facing DB session locks during update cart (below query) we upgraded our platform from 6.2 to 2005 . This causes thread block issues and the hybris service becomes unresponsive .
)UPDATE carts SET hjmpTS = @P0 ,modifiedTS=@P1,p_calculated=@P2 WHERE PK = @P3 AND (sealed IS NULL OR sealed=Did anyone face this similar issue if so what is the cause?, how was it resolved?
Did you find solution for locking issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Our custom CommerceCartCalculationStrategy.calculateCart() method was based on old code which wasn't transactional. When there were issues during calculation, we were getting blocked threads. Adding calls to Transaction begin(), rollback() and commit() in our calculation flow resolved our issues. Please see DefaultCommerceCartCalculationStrategy.calculateCart() for a working example of adding these transactional methods.
User | Count |
---|---|
34 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.