Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0038291
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] External Data Integrationmajoralways2018-04-06 14:422018-04-13 09:28
ReporterumartirenaView Statuspublic 
Assigned Tocaristu 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionb490bc5d7ca8
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toalostale
Regression introduced in release
Summary

0038291: 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
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0038289 closedalostale Openbravo ERP Log Clean Up Process takes too long to delete the records in AD_PROCESS_REQUEST window with Process Groups 

-  Notes
(0103714)
shuehner (administrator)
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 (developer)
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 (developer)
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 (manager)
2018-04-13 09:28

 reviewed + tested

- Issue History
Date Modified Username Field Change
2018-04-06 14:42 umartirena New Issue
2018-04-06 14:42 umartirena Assigned To => platform
2018-04-06 14:52 shuehner Resolution time => 1524780000
2018-04-06 14:52 shuehner Note Added: 0103714
2018-04-06 14:52 shuehner Description Updated View Revisions
2018-04-06 14:52 shuehner Tag Attached: Performance
2018-04-06 15:10 caristu Assigned To platform => caristu
2018-04-09 11:27 hgbot Checkin
2018-04-09 11:27 hgbot Note Added: 0103748
2018-04-09 11:27 hgbot Status new => resolved
2018-04-09 11:27 hgbot Resolution open => fixed
2018-04-09 11:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.externaldata.integration/rev/b490bc5d7ca89187d8353fee260b67cd5b010571 [^]
2018-04-09 11:27 hgbot Checkin
2018-04-09 11:27 hgbot Note Added: 0103749
2018-04-09 11:30 caristu Review Assigned To => alostale
2018-04-13 09:23 alostale Relationship added related to 0038289
2018-04-13 09:28 alostale Note Added: 0103869
2018-04-13 09:28 alostale Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker