Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0047432 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | critical | always | 2021-07-21 19:37 | 2021-07-23 14:00 | |||
Reporter | lbressan | View Status | public | |||||
Assigned To | adrianromero | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | RR20Q2.2 | |||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Windows | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | RR20Q1 | SCM revision | ||||||
Review Assigned To | adrianromero | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0047432: Error when searching for clients with the latest version of Chrome | |||||||
Description | Version 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 Reproduce | Have 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 Solution | Apply attached patch that creates an index in websql table for c_bpartner_location | |||||||
Tags | No tags attached. | |||||||
Attached Files | FIX0047432-20Q2.2.diff [^] (1,217 bytes) 2021-07-22 17:04 [Show Content] | |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
Notes | |
(0130718) adrianromero (manager) 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 (manager) 2021-07-23 11:27 |
As a workaround Chrome can be downgraded to version 91.0.4472.77 |
Issue History | |||
Date Modified | Username | Field | Change |
2021-07-21 19:37 | lbressan | New Issue | |
2021-07-21 19:37 | lbressan | Assigned To | => Retail |
2021-07-21 19:37 | lbressan | Resolution time | => 1595282400 |
2021-07-21 19:37 | lbressan | Triggers an Emergency Pack | => No |
2021-07-21 19:52 | Practics | Issue Monitored: Practics | |
2021-07-22 11:38 | egoitz | Issue cloned | 0047441 |
2021-07-22 11:38 | egoitz | Relationship added | related to 0047441 |
2021-07-22 12:39 | adrianromero | File Added: 47432.diff | |
2021-07-22 12:41 | adrianromero | Proposed Solution updated | |
2021-07-22 17:04 | adrianromero | File Added: FIX0047432-20Q2.2.diff | |
2021-07-23 10:58 | adrianromero | File Deleted: 47432.diff | |
2021-07-23 11:16 | adrianromero | Note Added: 0130718 | |
2021-07-23 11:27 | adrianromero | Note Added: 0130720 | |
2021-07-23 11:44 | adrianromero | Status | new => scheduled |
2021-07-23 11:44 | adrianromero | Assigned To | Retail => adrianromero |
2021-07-23 11:44 | adrianromero | Status | scheduled => resolved |
2021-07-23 11:44 | adrianromero | Resolution | open => fixed |
2021-07-23 11:44 | adrianromero | Review Assigned To | => adrianromero |
2021-07-23 11:44 | adrianromero | Status | resolved => closed |
2021-07-23 11:44 | adrianromero | Fixed in Version | => RR20Q2.2 |
2021-07-23 14:00 | eugeni | Issue Monitored: eugeni |
Copyright © 2000 - 2009 MantisBT Group |