Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0030516 | Openbravo ERP | 04. Warehouse management | public | 2015-08-07 12:10 | 2015-08-20 23:16 |
|
| Reporter | alostale | |
| Assigned To | AtulOpenbravo | |
| 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 | |
| Review Assigned To | vmromanos |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | Production - Confirmed Stable |
| Regression date | 2015-02-15 |
| Regression introduced in release | 3.0PR15Q2 |
| Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/b4be2e4511445d578fc7f8a2175c3a6114e52583 [^] |
| Triggers an Emergency Pack | No |
|
| Summary | 0030516: Potential full c_orderline scan in M_Reservation_trg |
| Description | Trigger on M_Reservation table does a count on all order lines without any filtering.
If this code is executed in an environment with a decent amount of orders, it can take ages to complete.
|
| Steps To Reproduce | I have not reproduced it, but just read the code in M_RESERVATION_TRG.xml :
https://code.openbravo.com/erp/devel/pi/rev/b4be2e4511445d578fc7f8a2175c3a6114e52583#l1.28 [^]
select count (*) into v_count from c_orderline;
it looks like some missing debug code forgotten to remove as it is never used |
| Proposed Solution | |
| Additional Information | |
| Tags | Performance |
| Relationships | | depends on | backport | 0030528 | 3.0PR15Q3 | closed | AtulOpenbravo | Potential full c_orderline scan in M_Reservation_trg | | depends on | backport | 0030529 | 3.0PR15Q2.4 | closed | AtulOpenbravo | Potential full c_orderline scan in M_Reservation_trg | | caused by | defect | 0029063 | | closed | umartirena | M_Reservation_Post fails in Oracle |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-08-07 12:10 | alostale | New Issue | |
| 2015-08-07 12:10 | alostale | Assigned To | => Triage Finance |
| 2015-08-07 12:10 | alostale | Modules | => Core |
| 2015-08-07 12:10 | alostale | Regression level | => Production - Confirmed Stable |
| 2015-08-07 12:10 | alostale | Regression date | => 2015-02-15 |
| 2015-08-07 12:10 | alostale | Regression introduced in release | => 3.0PR15Q2 |
| 2015-08-07 12:10 | alostale | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/b4be2e4511445d578fc7f8a2175c3a6114e52583 [^] |
| 2015-08-07 12:10 | alostale | Triggers an Emergency Pack | => No |
| 2015-08-07 12:10 | alostale | Tag Attached: Performance | |
| 2015-08-07 12:10 | alostale | Relationship added | caused by 0029063 |
| 2015-08-07 12:12 | alostale | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=9178#r9178 |
| 2015-08-10 06:50 | AtulOpenbravo | Assigned To | Triage Finance => AtulOpenbravo |
| 2015-08-10 06:51 | AtulOpenbravo | Status | new => scheduled |
| 2015-08-10 09:13 | hgbot | Checkin | |
| 2015-08-10 09:13 | hgbot | Note Added: 0079271 | |
| 2015-08-10 09:13 | hgbot | Status | scheduled => resolved |
| 2015-08-10 09:13 | hgbot | Resolution | open => fixed |
| 2015-08-10 09:13 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/17b020a23cb9d5a9aacf9828773a303356276751 [^] |
| 2015-08-10 09:14 | vmromanos | Review Assigned To | => vmromanos |
| 2015-08-10 09:14 | vmromanos | Status | resolved => closed |
| 2015-08-20 23:16 | hudsonbot | Checkin | |
| 2015-08-20 23:16 | hudsonbot | Note Added: 0079536 | |