Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038291ModulesExternal Data Integrationpublic2018-04-06 14:422018-04-13 09:28
Reporterumartirena 
Assigned Tocaristu 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toalostale
Support ticket
OBNetwork customer
Regression introduced in release
Summary0038291: Log Clean Up process doesn't finish deleting C_IMPORT_ENTRY_ARCHIVE table with big amount of data
DescriptionLog Clean Up process doesn't finish deleting C_IMPORT_ENTRY_ARCHIVE table with big amount of data. The problem happens when there are lot of records in OBEDL_REQUEST_LINE table that has a foreign key to C_IMPORT_ENTRY_ARCHIVE.

Same issue can happen with C_IMPORT_ENTRY_ID column. (In ImportEntryArchiveThread as it deletes from c_import_entry table triggering same seq-scan) -> Already visible with 500ms avg time of pgbadger for delete of c_import_entry probably coming from that (2nd indicator is very high number of seq-scans of obedl_request_line table)
Steps To Reproduce-
Proposed SolutionCREATE INDEX OBEDL_REQ_LINE_IEA_IDX
  ON public.obedl_request_line
  USING btree
  (c_import_entry_archive_id COLLATE pg_catalog."default")
  WHERE c_import_entry_archive_id is not null

  CREATE INDEX OBEDL_REQ_LINE_IE_IDX
  ON public.obedl_request_line
  USING btree
  (c_import_entry_id COLLATE pg_catalog."default")
  WHERE c_import_entry_id is not null
Additional Information
TagsPerformance
Relationships
related to defect 0038289 closed alostale Openbravo ERP Log Clean Up Process takes too long to delete the records in AD_PROCESS_REQUEST window with Process Groups 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-04-06 14:42umartirenaNew Issue
2018-04-06 14:42umartirenaAssigned To => platform
2018-04-06 14:52shuehnerResolution time => 1524780000
2018-04-06 14:52shuehnerNote Added: 0103714
2018-04-06 14:52shuehnerDescription Updatedbug_revision_view_page.php?rev_id=16959#r16959
2018-04-06 14:52shuehnerTag Attached: Performance
2018-04-06 15:10caristuAssigned Toplatform => caristu
2018-04-09 11:27hgbotCheckin
2018-04-09 11:27hgbotNote Added: 0103748
2018-04-09 11:27hgbotStatusnew => resolved
2018-04-09 11:27hgbotResolutionopen => fixed
2018-04-09 11:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.externaldata.integration/rev/b490bc5d7ca89187d8353fee260b67cd5b010571 [^]
2018-04-09 11:27hgbotCheckin
2018-04-09 11:27hgbotNote Added: 0103749
2018-04-09 11:30caristuReview Assigned To => alostale
2018-04-13 09:23alostaleRelationship addedrelated to 0038289
2018-04-13 09:28alostaleNote Added: 0103869
2018-04-13 09:28alostaleStatusresolved => closed

Notes
(0103714)
shuehner   
2018-04-06 14:52   
Adding obps flag as affecting two customers already. Note as trivial fix makes sense to put into 18Q2 + maybe even add backports as will affect every customer using edl module.
(0103748)
hgbot   
2018-04-09 11:27   
Repository: erp/pmods/org.openbravo.externaldata.integration
Changeset: b490bc5d7ca89187d8353fee260b67cd5b010571
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Apr 09 10:46:01 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.externaldata.integration/rev/b490bc5d7ca89187d8353fee260b67cd5b010571 [^]

fixes bug 38291: Log Clean Up can take too long deleting C_IMPORT_ENTRY_ARCHIVE

  Added two new partial indexes in OBEDL_REQUEST_LINE table for the C_IMPORT_ENTRY_ID and C_IMPORT_ENTRY_ARCHIVE_ID columns.

---
M src-db/database/model/tables/OBEDL_REQUEST_LINE.xml
---
(0103749)
hgbot   
2018-04-09 11:27   
Repository: erp/pmods/org.openbravo.externaldata.integration
Changeset: dda30fc5409afb1e0808e53ebf021aa06f86beef
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Apr 09 11:01:01 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.externaldata.integration/rev/dda30fc5409afb1e0808e53ebf021aa06f86beef [^]

related to bug 38291: Move dependency to 3.0PR17Q1

  Move core dependency to 3.0PR17Q1, as partial indexes are supported starting from that version[1].

  [1] https://issues.openbravo.com/view.php?id=32211 [^]

---
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0103869)
alostale   
2018-04-13 09:28   
reviewed + tested