Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029177
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Warehouse Pickingmajorhave not tried2015-03-06 15:362015-04-24 11:27
ReporteregoitzView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toumartirena
Support ticket34121
OBNetwork customerOBPS
Regression introduced in release
Summary

0029177: The sequence for picking list on ad_sequence table is locked while the picking list process is executed

DescriptionWhen 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.
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0029131 closededuardo_Argal Modules Bad performance and degradation on the execution on the generate picking list process 
related to defect 0027160 closededuardo_Argal Openbravo ERP C_Order_Post poor performance 

-  Notes
(0076740)
umartirena (viewer)
2015-04-24 11:27

 Issue resolved by this commits:

https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/e8a78f938850 [^]

https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/346fac4a867b [^]
(0076741)
umartirena (viewer)
2015-04-24 11:27

 Code Review + Testing OK

- 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 Support ticket => 34121
2015-03-06 15:36 egoitz OBNetwork customer => Yes
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker