Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037404Retail ModulesWeb POSpublic2017-11-28 11:072018-01-03 12:39
ReporterdaniOpenbravo 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q1 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037404: [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
TagsPerformance, SERQA
Relationships
depends on backport 0037420RR17Q4 closed marvintm [BUT Issue 3556] Delete in C_import_entry_archive query too long 
depends on backport 0037421RR17Q3.2 closed marvintm [BUT Issue 3556] Delete in C_import_entry_archive query too long 
Attached Filespng Selection_050.png (19,418) 2017-11-28 11:07
https://issues.openbravo.com/file_download.php?file_id=11332&type=bug
png

png Selection_051.png (45,253) 2017-11-28 11:08
https://issues.openbravo.com/file_download.php?file_id=11333&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2017-11-28 11:07daniOpenbravoNew Issue
2017-11-28 11:07daniOpenbravoAssigned To => Retail
2017-11-28 11:07daniOpenbravoFile Added: Selection_050.png
2017-11-28 11:07daniOpenbravoOBNetwork customer => Yes
2017-11-28 11:07daniOpenbravoResolution time => 1513638000
2017-11-28 11:07daniOpenbravoTriggers an Emergency Pack => No
2017-11-28 11:07daniOpenbravoTag Attached: SERQA
2017-11-28 11:08daniOpenbravoFile Added: Selection_051.png
2017-11-28 11:08daniOpenbravoIssue Monitored: daniOpenbravo
2017-11-30 10:17marvintmStatusnew => scheduled
2017-11-30 10:17marvintmAssigned ToRetail => marvintm
2017-11-30 10:18marvintmTag Attached: Performance
2017-11-30 10:18marvintmStatusscheduled => acknowledged
2017-11-30 10:19marvintmStatusacknowledged => scheduled
2017-12-03 00:21hgbotCheckin
2017-12-03 00:21hgbotNote Added: 0100908
2017-12-03 00:21hgbotStatusscheduled => resolved
2017-12-03 00:21hgbotResolutionopen => fixed
2017-12-03 00:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/21f7f8c56b57adbaedbb38a7d2f8fa321fc3bb7e [^]
2017-12-04 17:17migueldejuanaReview Assigned To => migueldejuana
2017-12-04 17:17migueldejuanaNote Added: 0100925
2017-12-04 17:17migueldejuanaStatusresolved => closed
2017-12-04 17:17migueldejuanaFixed in Version => RR18Q1
2018-01-03 12:39hudsonbotCheckin
2018-01-03 12:39hudsonbotNote Added: 0101512

Notes
(0100908)
hgbot   
2017-12-03 00:21   
Repository: erp/devel/pi
Changeset: 21f7f8c56b57adbaedbb38a7d2f8fa321fc3bb7e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Sun Dec 03 00:20:53 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/21f7f8c56b57adbaedbb38a7d2f8fa321fc3bb7e [^]

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

---
M src-db/database/model/tables/C_IMPORT_ENTRY_ARCHIVE.xml
---
(0100925)
migueldejuana   
2017-12-04 17:17   
Reviewed
(0101512)
hudsonbot   
2018-01-03 12:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c81e0d3cbab5 [^]
Maturity status: Test