Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047432Retail ModulesWeb POSpublic2021-07-21 19:372021-07-23 14:00
Reporterlbressan 
Assigned Toadrianromero 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS10OS Version
Product VersionRR20Q1 
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
Summary0047432: Error when searching for clients with the latest version of Chrome
DescriptionVersion Openbravo 20q1
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 clients loaded

Attached the video https://drive.google.com/file/d/12TJeLoO4mGY2JlPYjCFNwRfB9BRlWSec/view [^]
Steps To ReproduceHave the following versions:
Version Openbravo 20q1
Version Chrome 92.0.4515.107
Windows

1) Open the terminal
2) Search a customer, put "Sofia" and search.
Proposed SolutionApply attached patch that creates an index in websql table for c_bpartner_location
Additional Information
TagsNo tags attached.
Relationships
related to defect 0047441 closed Retail Error when searching for products with the latest version of Chrome 
Attached Filesdiff FIX0047432-20Q2.2.diff (1,217) 2021-07-22 17:04
https://issues.openbravo.com/file_download.php?file_id=16035&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-07-21 19:37lbressanNew Issue
2021-07-21 19:37lbressanAssigned To => Retail
2021-07-21 19:37lbressanOBNetwork customer => No
2021-07-21 19:37lbressanSupport ticket => 26521
2021-07-21 19:37lbressanResolution time => 1595282400
2021-07-21 19:37lbressanTriggers an Emergency Pack => No
2021-07-21 19:52PracticsIssue Monitored: Practics
2021-07-22 11:38egoitzIssue cloned0047441
2021-07-22 11:38egoitzRelationship addedrelated to 0047441
2021-07-22 12:39adrianromeroFile Added: 47432.diff
2021-07-22 12:41adrianromeroProposed Solution updated
2021-07-22 17:04adrianromeroFile Added: FIX0047432-20Q2.2.diff
2021-07-23 10:58adrianromeroFile Deleted: 47432.diff
2021-07-23 11:16adrianromeroNote Added: 0130718
2021-07-23 11:27adrianromeroNote Added: 0130720
2021-07-23 11:44adrianromeroStatusnew => scheduled
2021-07-23 11:44adrianromeroAssigned ToRetail => adrianromero
2021-07-23 11:44adrianromeroStatusscheduled => resolved
2021-07-23 11:44adrianromeroResolutionopen => fixed
2021-07-23 11:44adrianromeroReview Assigned To => adrianromero
2021-07-23 11:44adrianromeroStatusresolved => closed
2021-07-23 11:44adrianromeroFixed in Version => RR20Q2.2
2021-07-23 14:00eugeniIssue Monitored: eugeni

Notes
(0130718)
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 [^]
(0130720)
adrianromero   
2021-07-23 11:27   
As a workaround Chrome can be downgraded to version 91.0.4472.77