cancel
Showing results for 
Search instead for 
Did you mean: 

DB session lock during Update cart

1,007

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?

View Entire Topic
former_member772115
Discoverer
0 Kudos

Did you find solution for locking issue?

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.