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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018107
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performancemajoralways2011-07-28 08:152011-09-07 17:10
ReportermalsasuaView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision0c139e47fb21
ProjectionnoneETAnoneTarget Version3.0MP4
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product Version3.0MP1SCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018107: several minutes the CPU to 100 % when the table "product_price" has got a big number of records

Descriptionif you have got a big number of records in the table "product_price", if you edit in "form mode" a line of sales order window, the CPU is loaded to 100 % during several minutes
Steps To Reproduce. create 1500 products
. create 500 records in pricelist and pricelist_version tables
. create 1.000.000 records in product_price table
. create a new sales order.
. create a new line: when you enter to the line, to edit in "form mode", the CPU is loaded to 100%

the problem is generated by the next query:
select productbyp0_.M_Product_Price_Warehouse_V_ID as M1_447_, productbyp0_.AD_Client_ID as AD2_447_, productbyp0_.AD_Org_ID as AD3_447_, productbyp0_.Isactive as Isactive447_, productbyp0_.Updated as Updated447_, productbyp0_.Updatedby as Updatedby447_, productbyp0_.Created as Created447_, productbyp0_.Createdby as Createdby447_, productbyp0_.M_Product_ID as M9_447_, productbyp0_.M_Warehouse_ID as M10_447_, productbyp0_.M_Productprice_ID as M11_447_, productbyp0_.QTY_Available as QTY12_447_, productbyp0_.QTY_Onhand as QTY13_447_, productbyp0_.QTY_Reserved as QTY14_447_, productbyp0_.QTY_Ordered as QTY15_447_, productbyp0_.Pricelist as Pricelist447_, productbyp0_.Pricestd as Pricestd447_, productbyp0_.Pricelimit as Pricelimit447_
from M_Product_Price_Warehouse_v productbyp0_ where (productbyp0_.AD_Org_ID in ('0' , 'B2B18708B6924502B9ABE5B72ADECFE6' , 'C025B6163F3A4B6A94E031CCCA3C7A6B'))
and (productbyp0_.AD_Client_ID in ('0947E36909B941AAAB131AE9A7D19701' , '0')) and productbyp0_.Isactive='Y'
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00183133.0MP4 closedmarvintm Bad performance of the partner selector having arround 100.000 partners 

-  Notes
(0040532)
alostale (manager)
2011-08-29 11:17

Is this issue still present after this changset?

https://code.openbravo.com/erp/devel/pi/rev/0c139e47fb2149f2f614c93a5304cf04e21d7a1b [^]
(0040603)
jonalegriaesarte (reporter)
2011-08-31 11:34

Due to the load with other issues we were not able to research this one for MP3, are planning MP4 for it now.
(0040726)
malsasua (developer)
2011-09-02 14:53

the fix works for me
(0040808)
malsasua (developer)
2011-09-07 17:10

verified

- Issue History
Date Modified Username Field Change
2011-07-28 08:15 malsasua New Issue
2011-07-28 08:15 malsasua Assigned To => gorkaion
2011-07-28 08:15 malsasua Web browser => Google Chrome
2011-07-28 08:15 malsasua Modules => Core
2011-07-28 08:15 malsasua Resolution time => 1316383200
2011-07-28 13:06 gorkaion Assigned To gorkaion => alostale
2011-08-05 12:56 alostale Status new => scheduled
2011-08-29 11:17 alostale Note Added: 0040532
2011-08-29 11:17 alostale Status scheduled => feedback
2011-08-29 13:06 alostale Relationship added related to 0018313
2011-08-31 11:34 jonalegriaesarte Web browser Google Chrome => Google Chrome
2011-08-31 11:34 jonalegriaesarte Note Added: 0040603
2011-08-31 11:34 jonalegriaesarte Target Version 3.0MP3 => 3.0MP4
2011-09-02 14:53 malsasua Note Added: 0040726
2011-09-07 17:09 malsasua Status feedback => scheduled
2011-09-07 17:09 malsasua fix_in_branch => pi
2011-09-07 17:10 malsasua Status scheduled => resolved
2011-09-07 17:10 malsasua Fixed in SCM revision => https://code.openbravo.com/erp/devel/pi/rev/0c139e47fb2149f2f614c93a5304cf04e21d7a1b [^]
2011-09-07 17:10 malsasua Resolution open => fixed
2011-09-07 17:10 malsasua Note Added: 0040808
2011-09-07 17:10 malsasua Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker