Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0043390Retail ModulesLayaway orderpublic2020-03-02 17:512020-03-12 13:14
ReporterALopetegui 
Assigned Torqueralta 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in VersionRR20Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0043390: Void Layaway BGProcess bad performance
DescriptionAutomatic void of layaway BGProcess has bad performance query getting the layaway List.
Steps To ReproduceIn high volume environment run "Automatic void of layaway" BGProcess.

Here the query explain plan
https://explain.depesz.com/s/FJ8b [^]
Proposed SolutionThe launched query needs to be filtered also for ad_client_id in order to perform correctly the core index c_order_client_org_date_docno.

In the past there was a custom index of symmetric DS, only ad_org_id in c_order, but after symmetricDS unistall, the core index doesn't work properly if we dont' filter by ad_client_id.

Attached diff to filter also by ad_client_id, doing a subselect to get the id:

Here the new explain plan:
https://explain.depesz.com/s/3ybN [^]
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff VoidLayawaysBGProcess.diff (899) 2020-03-02 17:51
https://issues.openbravo.com/file_download.php?file_id=14119&type=bug
Issue History
Date ModifiedUsernameFieldChange
2020-03-02 17:51ALopeteguiNew Issue
2020-03-02 17:51ALopeteguiAssigned To => Retail
2020-03-02 17:51ALopeteguiFile Added: VoidLayawaysBGProcess.diff
2020-03-02 17:51ALopeteguiResolution time => 1581807600
2020-03-02 17:51ALopeteguiTriggers an Emergency Pack => No
2020-03-04 19:09marvintmResolution time1581807600 => 1585004400
2020-03-09 16:30rqueraltaAssigned ToRetail => rqueralta
2020-03-09 16:30rqueraltaStatusnew => scheduled
2020-03-09 22:03hgbotCheckin
2020-03-09 22:03hgbotNote Added: 0118432
2020-03-09 22:03hgbotStatusscheduled => resolved
2020-03-09 22:03hgbotResolutionopen => fixed
2020-03-09 22:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.autocancelreservation/rev/f6e7f24277354ad196efc79fa0eb903ef658e023 [^]
2020-03-12 12:46ALopeteguiIssue Monitored: ALopetegui
2020-03-12 13:14marvintmReview Assigned To => marvintm
2020-03-12 13:14marvintmStatusresolved => closed
2020-03-12 13:14marvintmFixed in Version => RR20Q2

Notes
(0118432)
hgbot   
2020-03-09 22:03   
Repository: erp/pmods/org.openbravo.retail.autocancelreservation
Changeset: f6e7f24277354ad196efc79fa0eb903ef658e023
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Mon Mar 09 17:02:59 2020 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.autocancelreservation/rev/f6e7f24277354ad196efc79fa0eb903ef658e023 [^]

Fixed BUG-43390: Void Layaway BGProcess bad performance

- Filter by ad_client_id, doing a subselect to get the id

---
M src/org/openbravo/retail/autocancelreservation/process/VoidLayawaysBGProcess.java
---