Openbravo Issue Tracking System - Openbravo ERP
Customer name Bureau Veritas
License Edition Professional Edition
Subscription Type Concurrent users limitation
Subscription Start Date 27-03-2017
Subscription End Date 31-12-2021
Concurrent Global System Users 314
Concurrent Users Warning 314
Current concurrent users 240
Instance Number 1
Instance Purpose Production
Web Service Access Unlimited
WebPOS Terminals None
-------------------------------------------------------------------------
After running relatively well for 3 years, this production instance started suddenly in March to suffer from severe performance issues causing deadlocks and database disconnection. Looking into the application logs show that the issue may have happened a few times last December going unnoticed but starting March there have been disconnection events almost daily.
We have made several changes to mitigate these issues including and improve the situation without being able to identify the root cause or to completely solve the problem :
1. code review to follow the standard usage of DAL.
2. review the transaction handling.
3. use query.scroll instead of query.list in batch processes
4. add index on foreign keys of frequently used tables.
By doing this, we reduced the occurrence of the dead lock issue, but the database disconnection issue keep happening.
We find that it might be related to issue 0012683, but we haven't got a chance to try it on production instance.
Attachments are the jfr file and the server log when disconnection happening.
We hope we can have a discussion with your team to solve this problem.
disconnection.log.2021-06-10 (579,344) 2021-06-11 09:31https://issues.openbravo.com/file_download.php?file_id=15909&type=bug
16233950555293.png (72,048) 2021-06-11 09:32https://issues.openbravo.com/file_download.php?file_id=15910&type=bug