Community mailing list archives

Re: Odoo Performance and concurrency locks

ePillars Systems LLC, Shawn Varghese
- 09/14/2015 15:32:46
Perhaps the issue I was referring to has been related to a concurrency with user login session. I am currently referring to a concurrency lock arising from the POS implementation in OpenERP 7. 

@Olivier Dony and OpnERP Master,
There are multiple POS machines which simultaneously validate orders or press validate in the gap of a few seconds. From what I have gathered from the logs, it seems that the lock arises when simultaneous transactions try to obtain a sequence number for the orders (which is a gapless sequence).

This causes a concurrency issue and the process is retried. But every now and then the random retry wait time that is generated is too short and hence does not give enough time for the lock to be released and eventually, the transaction just times out. It does not cause any issues in user experience, as the whole process takes place in the backend, but I wanted to tackle it before the issue escalates.

Increasing the wait time has produced visible improvements as the lock gets released before the retry, in most cases. But since it is not recommended, I will read through the suggestions mentioned here and try a different approach.