SAP Knowledge Base Article - Preview

2734530 - DB locks on the discounts table

Symptom

We are using hybris Commerce Suite and have the issue that there are locks on the discounts table when a lot of people try to use the same PromotionVoucher.

Observed are a lot of UPDATE statements like the one below:

UPDATE discounts SET hjmpTS = 30790 ,modifiedTS='2017-12-01 13:33:16.278' WHERE PK = 8797208084528

The PK is always the same, it’s the PromotionVoucher. Basically these statements just set the modifiedTS. Sometimes these statements get stuck and accumulate on the DB. Some other actions on the storefront are held up waiting to acquire the lock. This for example blocks all further checkouts involving the specific PromotionVoucher.


Read more...

Environment

Any hybris version.

Product

SAP Commerce 1811 ; SAP Hybris Commerce 1808 ; SAP Hybris Commerce 6.0 ; SAP Hybris Commerce 6.1 ; SAP Hybris Commerce 6.2 ; SAP Hybris Commerce 6.3 ; SAP Hybris Commerce 6.4 ; SAP Hybris Commerce 6.5 ; SAP Hybris Commerce 6.6 ; SAP Hybris Commerce 6.7

Keywords

  • time stamp
  • lock
  • locked
  • blocked session
  • query
  • checkout
  • discount
  • promotion
  • category
  • product
  • database
, KBA , CEC-COM-CPS , SAP Commerce , Problem

About this page

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

Search for additional results

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