Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0018107 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] I. Performance | major | always | 2011-07-28 08:15 | 2011-09-07 17:10 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 0c139e47fb21 | |||
| Projection | none | ETA | none | Target Version | 3.0MP4 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | 3.0MP1 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | Google Chrome | |||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0018107: several minutes the CPU to 100 % when the table "product_price" has got a big number of records | |||||||
| Description | if 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' | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0040532) alostale (viewer) 2011-08-29 11:17 |
Is this issue still present after this changset? https://code.openbravo.com/erp/devel/pi/rev/0c139e47fb2149f2f614c93a5304cf04e21d7a1b [^] |
|
(0040603) jonalegriaesarte (viewer) 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 (viewer) 2011-09-02 14:53 |
the fix works for me |
|
(0040808) malsasua (viewer) 2011-09-07 17:10 |
verified |
|
Notes |
|
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 | OBNetwork customer | => Yes |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |