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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0056549
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Multi UPC/EAN for Productmajoralways2024-09-25 12:302024-10-18 13:04
ReportermalsasuaView Statuspublic 
Assigned ToSABARINATH P 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0056549: after incremental refresh process, the first scan is slow

DescriptionWith big volume of data (40K products), after incremental refresh process is executed, the first scan is slow:
https://drive.google.com/file/d/1HtPo4wiPDht52Dt3tueyMlRRlQwKminp/view?usp=sharing [^]

This issue is caused because a search is triggered by the MultiUpc module, but the database is busy "Loading cache for Model." Until the database completes the cache loading process, the MultiUpc query is not executed.

The query is executed in this line:
https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/blob/master/web/org.openbravo.retail.multiupc/js/extendUPCSearch.js?ref_type=heads#L71 [^]

 
Steps To Reproduce. in environment with 40K products, install multiupc module
. execute incremental refresh
. scan a product
Proposed Solution. if the database is executing the cache loading process, then execute the product search as remote
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0170558)
hgbot (developer)
2024-10-18 09:02

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/26 [^]
(0170567)
hgbot (developer)
2024-10-18 13:04

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/merge_requests/26 [^]
(0170568)
hgbot (developer)
2024-10-18 13:04

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc [^]
Changeset: 6d8d373831477aeeebbfa23297e2dfafd3990c7f
Author: Sabarinath <s.palanisamy@external.orisha.com>
Date: 18-10-2024 14:15:16
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.multiupc/-/commit/6d8d373831477aeeebbfa23297e2dfafd3990c7f [^]

Fixed ISSUE-56549:Remote product search triggered when cache loading was in process.

---
M web/org.openbravo.retail.multiupc/js/extendUPCSearch.js
---

- Issue History
Date Modified Username Field Change
2024-09-25 12:30 malsasua New Issue
2024-09-25 12:30 malsasua Assigned To => Retail
2024-09-25 12:30 malsasua Triggers an Emergency Pack => No
2024-09-25 12:44 Practics Issue Monitored: Practics
2024-09-27 10:59 guillermogil Status new => acknowledged
2024-10-01 07:29 SABARINATH P Assigned To Retail => SABARINATH P
2024-10-01 07:29 SABARINATH P Status acknowledged => scheduled
2024-10-18 09:02 hgbot Note Added: 0170558
2024-10-18 13:04 hgbot Note Added: 0170567
2024-10-18 13:04 hgbot Resolution open => fixed
2024-10-18 13:04 hgbot Status scheduled => closed
2024-10-18 13:04 hgbot Note Added: 0170568


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker