Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037421Retail ModulesWeb POSpublic2017-11-28 11:072017-12-22 08:40
ReporterdaniOpenbravo 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR17Q3.2Fixed in VersionRR17Q3.2 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037421: [BUT Issue 3556] Delete in C_import_entry_archive query too long
DescriptionThe following executed query took more than 10 hours in BUT production environment (see attached images of Munin and pg_badger):

DELETE FROM C_Import_Entry_Archive WHERE Created & lt; now () - 30;
Steps To Reproduce1) Analyze previous query.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0037404 closed marvintm [BUT Issue 3556] Delete in C_import_entry_archive query too long 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-11-30 10:19marvintmTypedefect => backport
2017-11-30 10:19marvintmTarget Version => RR17Q3.2
2017-12-19 18:46hgbotCheckin
2017-12-19 18:46hgbotNote Added: 0101146
2017-12-19 18:46hgbotStatusscheduled => resolved
2017-12-19 18:46hgbotResolutionopen => fixed
2017-12-19 18:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q3.2/rev/bf6ee649ccd8fb77fef355015295c14490544dbf [^]
2017-12-22 08:40migueldejuanaReview Assigned To => migueldejuana
2017-12-22 08:40migueldejuanaNote Added: 0101195
2017-12-22 08:40migueldejuanaStatusresolved => closed
2017-12-22 08:40migueldejuanaFixed in Version => RR17Q3.2

Notes
(0101146)
hgbot   
2017-12-19 18:46   
Repository: erp/backports/3.0PR17Q3.2
Changeset: bf6ee649ccd8fb77fef355015295c14490544dbf
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Dec 19 18:46:23 2017 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR17Q3.2/rev/bf6ee649ccd8fb77fef355015295c14490544dbf [^]

Fixed issue 37421. Added index to improve performance of C_IMPORT_ENTRY_ARCHIVE deletion.

---
M src-db/database/model/tables/C_IMPORT_ENTRY_ARCHIVE.xml
---
(0101195)
migueldejuana   
2017-12-22 08:40   
Reviewed