Openbravo Issue Tracking System - Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0029177 | Modules | Warehouse Picking | public | 2015-03-06 15:36 | 2015-04-24 11:27 |
|
| Reporter | egoitz | |
| Assigned To | eduardo_Argal | |
| Priority | immediate | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Regression date | |
| Regression introduced by commit | |
| Regression level | |
| Review Assigned To | umartirena |
| Support ticket | |
| OBNetwork customer | |
| Regression introduced in release | |
|
| Summary | 0029177: The sequence for picking list on ad_sequence table is locked while the picking list process is executed |
| Description | When starting tjhe picking list process a picking list document is created and when saving it the sequence for picking list on the ad_sequence table is locked.
That is locked until the process finish.
The same happens with the sequence for m_inout table becuase a shipment also is created on the begining of the processOrder method.
That is causing performance problems due to contention on the ad_sequence table. |
| Steps To Reproduce | -Execute the process for a order with thousends of lines.
See that the process takes long and that the sequence is locked until it finishes. |
| Proposed Solution | |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | defect | 0029131 | | closed | eduardo_Argal | Modules | Bad performance and degradation on the execution on the generate picking list process | | related to | defect | 0027160 | | closed | eduardo_Argal | Openbravo ERP | C_Order_Post poor performance |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-03-06 15:36 | egoitz | New Issue | |
| 2015-03-06 15:36 | egoitz | Assigned To | => naiaramartinez |
| 2015-03-06 15:36 | egoitz | Resolution time | => 1425855600 |
| 2015-03-06 15:36 | egoitz | Relationship added | related to 0029131 |
| 2015-03-06 15:36 | egoitz | Relationship added | related to 0027160 |
| 2015-03-06 15:39 | egoitz | Tag Attached: Performance | |
| 2015-03-06 15:39 | egoitz | Assigned To | naiaramartinez => eduardo_Argal |
| 2015-04-24 11:26 | umartirena | Status | new => scheduled |
| 2015-04-24 11:27 | umartirena | Note Added: 0076740 | |
| 2015-04-24 11:27 | umartirena | Status | scheduled => resolved |
| 2015-04-24 11:27 | umartirena | Resolution | open => fixed |
| 2015-04-24 11:27 | umartirena | Review Assigned To | => umartirena |
| 2015-04-24 11:27 | umartirena | Note Added: 0076741 | |
| 2015-04-24 11:27 | umartirena | Status | resolved => closed |