SAP Knowledge Base Article - Preview

3640093 - Database Deadlocks and Blockings in Cart and Cartentries Table using Telco Occ

Symptom

Many org.springframework.dao.DeadlockLoserDataAccessException exceptions and database lock/contention observed during cart calculation operation in following database modifications:

  • UPDATE carts SET hjmpTS = ? ,modifiedTS=?,p_calculated=? WHERE PK = ? AND (sealed IS NULL OR sealed='***')

  • UPDATE cartentries SET hjmpTS = ? ,modifiedTS=?,p_discountvaluesinternal=?,p_price=?,p_totalprice=? WHERE PK = ? AND (sealed IS NULL OR sealed='***')

While checking the stacktrace responsible for triggering the modifications above, similar code as below is observed:

at de.hybris.platform.b2ctelcoocc.controllers.TmaCartsController.getCarts(TmaCartsController.java:186)
at de.hybris.platform.b2ctelcofacades.order.impl.DefaultTmaCartFacade.getCartsForCustomer(DefaultTmaCartFacade.java:295)
at de.hybris.platform.commerceservices.order.impl.DefaultCommerceCartService.recalculateCart(DefaultCommerceCartService.java:186)
at de.hybris.platform.commerceservices.order.impl.DefaultCommerceCartCalculationStrategy.recalculateCart(DefaultCommerceCartCalculationStrategy.java:147)
at de.hybris.platform.commerceservices.order.impDefaultCommerceCartCalculationStrategy.beforeCalculate(DefaultCommerceCartCalculationStrategy.java:202)
at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.save(DefaultModelService.java:630)
at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAll(DefaultModelService.java:683)
at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAllInternal(DefaultModelService.java:703)
at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.performPersistenceOperations(DefaultModelService.java:709)
at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.persistWrappers(DefaultModelService.java:1126)
at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.doJaloPersistence(DefaultModelService.java:732)
at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveViaJalo(DefaultModelService.java:1182)
at de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister.persist(ResolvingModelPersister.java:47)
at de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister.saveOthers(ResolvingModelPersister.java:62)
at de.hybris.platform.servicelayer.internal.model.impl.wrapper.ModelWrapper.save(ModelWrapper.java:364)
at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.save(ItemModelConverter.java:875)


Read more...

Environment

SAP Commerce Cloud

Product

SAP Commerce Cloud all versions

Keywords

contention, locking, hybris, occ, telco, ccv2, tea , KBA , CEC-YIC-TEA , SAP Commerce Cloud Telco-Accelerator , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.