0039755: It would be nice to have a method to use lock "FOR NO KEY UPDATE"

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0039755

Openbravo ERP

I. Performance

public

2018-12-04 15:26

2018-12-17 20:39

Reporter

Sandrahuguet

Assigned To

Sandrahuguet

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR19Q1

Merge Request Status

Review Assigned To

alostale

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0039755: It would be nice to have a method to use lock "FOR NO KEY UPDATE"

Description

It would be nice to have a method to use lock "FOR NO KEY UPDATE", because "FOR UPDATE" in PostgreSQL is too aggressive.

Steps To Reproduce

- In order to easily simulate the 2 transactions are processed at same time it is necessary to set a break-point just after execution of following code :

financialAccount.setCurrentBalance(financialAccount.getCurrentBalance().subtract(transaction.getDepositAmount()).add(transaction.getPaymentAmount()));

- Go to Payment In and create a payment:
  Organization: F&B España - Region Norte
  Received From: Alimentos y Supermercados, S.A
  Payment Method: Transferencia
  Deposit To: Cuenta de Banco - EUR
  Amount: 100
  In Add details - > Overpayment Action: Leave the credit to be used later
  Done and execution should be stopped in previous break-point

- Open "new incognito window" in Chrome and access
  Go to Payment In and create a new payment:
  Organization: F&B España - Region Norte
  Received From: Restaurantes Luna Llena, S.A.
  Payment Method: Transferencia
  Deposit To: Cuenta de Banco - EUR
  Amount: 200
  Click in add details, the popup does not open, save the header is locked

Proposed Solution

This is required for PostgreSQL as a workaround until a newer Hibernate version implements HHH-13135 [1].

[1] https://hibernate.atlassian.net/browse/HHH-13135 [^]

Additional Information

Tags

Performance

Relationships

depends on	backport	0039756	3.0PR18Q4.1	closed	Sandrahuguet	It would be nice to have a method to use lock "FOR NO KEY UPDATE"
depends on	backport	0039757	3.0PR18Q3.4	closed	Sandrahuguet	It would be nice to have a method to use lock "FOR NO KEY UPDATE"
blocks	defect	0039672		closed	Sandrahuguet	Improve contention problems in fin_financial_account