Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047441Retail ModulesWeb POSpublic2021-07-22 11:382021-08-05 18:18
Reporteregoitz 
Assigned ToRetail 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS10OS Version
Product VersionRR20Q2 
Target VersionFixed in VersionRR20Q2.2 
Merge Request Status
Review Assigned Toadrianromero
OBNetwork customerNo
Support ticket26521
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0047441: Error when searching for products with the latest version of Chrome
DescriptionVersion Openbravo 20q2
Version Chrome 92.0.4515.107
Windows

It remains loading and if I do any refresh the pos is frozen.
To be able to reproduce it, it is necessary to have many products loaded

Attached the video
Steps To ReproduceHave the following versions:
Version Openbravo 20q1
Version Chrome 92.0.4515.107
Windows

1) Open the terminal
2) Search a product

After that error, they scanned a product, and the product is not added.

Proposed SolutionApply attached patch
Additional Information
TagsNo tags attached.
Relationships
related to defect 0047432 closed adrianromero Error when searching for clients with the latest version of Chrome 
related to defect 0045760 closed ranjith_qualiantech_com [21Q1] With MultiUPC, on product SEARCH, operator '%' does not work properly 
related to defect 0045268 closed prakashmurugesan88 On Product SEARCH, operator '%' has stopped working 
Attached Filesdiff FIX0047441-20Q2.2.diff (1,327) 2021-07-23 11:09
https://issues.openbravo.com/file_download.php?file_id=16040&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-07-22 11:38egoitzNew Issue
2021-07-22 11:38egoitzAssigned To => Retail
2021-07-22 11:38egoitzOBNetwork customer => No
2021-07-22 11:38egoitzSupport ticket => 26521
2021-07-22 11:38egoitzResolution time => 1595282400
2021-07-22 11:38egoitzTriggers an Emergency Pack => No
2021-07-22 11:38egoitzIssue generated from0047432
2021-07-22 11:38egoitzRelationship addedrelated to 0047432
2021-07-22 12:06PracticsIssue Monitored: Practics
2021-07-23 11:09adrianromeroFile Added: FIX0047441-20Q2.2.diff
2021-07-23 11:09adrianromeroProposed Solution updated
2021-07-23 11:16adrianromeroNote Added: 0130719
2021-07-23 11:27adrianromeroNote Added: 0130721
2021-07-23 11:45adrianromeroStatusnew => scheduled
2021-07-23 11:45adrianromeroStatusscheduled => resolved
2021-07-23 11:45adrianromeroResolutionopen => fixed
2021-07-23 11:45adrianromeroReview Assigned To => adrianromero
2021-07-23 11:45adrianromeroStatusresolved => closed
2021-07-23 11:45adrianromeroFixed in Version => RR20Q2.2
2021-07-23 14:01eugeniIssue Monitored: eugeni
2021-08-05 18:17adrianromeroRelationship addedrelated to 0045760
2021-08-05 18:18adrianromeroRelationship addedrelated to 0045268

Notes
(0130719)
adrianromero   
2021-07-23 11:16   
This issue affects to Openbrav version 20Q2.2 and previous versions in combination with Chrome 92.0.4515.107 and later versions

Later Openbravo versions are not affected because master data queries use IndexDB instead of WebSQL.

Chrome 92.0.4515.107 adds the SQLite option SQLITE_OMIT_AUTOMATIC_INDEX.This option makes that SQL queries with joins on non indexed columns perform very poorly as automatic indexes on those columns are not created, so explicit indexes must be created as done in the attached patch.

https://chromium.googlesource.com/chromium/src/+/5d1cbc8576cd32833b785e00ec4b39ebf25a6773%5E%21/#F0 [^]
(0130721)
adrianromero   
2021-07-23 11:27   
As a workaround Chrome can be downgraded to version 91.0.4472.77