Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0051930Openbravo ERPA. Platformpublic2023-03-21 14:412024-02-28 12:18
ivazquez 
AugustoMauch 
highmajorsometimes
closedno change required 
5
PR23Q4.1 
 
Core
No
0051930: IndexedDB data synchronization error
A record in the IndexedDB is too large(in this case we assume it is a corrupt Terminal Log), causing the following problem, preventing the till from loading and making it impossible to use.

Attached is JSON extracted from the MessageModel

Go to log in page: login page is not loaded
Error in the console:
Uncaught -> IDBRequest {result: undefined, error: DOMException: Failed to read large IndexedDB value, source: IDBIndex, transaction: IDBTransaction, readyState: 'done', ...}


Commands used to extract the pending information to be synchronized:

await OB.App.MessageModelController.findAll();

With this command, we obtain all the registers, which we copy, and paste into VCode and we see the giant problematic register, which we obtain its id and with the following command we eliminate it:

await OB.App.MessageModelController.delete('ID OF THE PROBLEMATIC RECORD');
No tags attached.
related to defect 0055014pi closed ander_flores Retail Modules IndexedDB data synchronization error - Extremely large Terminal Log caused by the module "Events for client" 
related to defect 0055016RR20Q3.4 closed Rajesh_18 Retail Modules IndexedDB data synchronization error - Extremely large Terminal Log caused by the function "updatePendingMultiOrders" 
? indexeddbentries.json (4,018,503) 2023-03-21 14:41
https://issues.openbravo.com/file_download.php?file_id=18286&type=bug
? indexeddbentries2.json (4,015,056) 2023-03-21 14:42
https://issues.openbravo.com/file_download.php?file_id=18287&type=bug
png Selección_932.png (52,370) 2023-03-21 16:42
https://issues.openbravo.com/file_download.php?file_id=18290&type=bug
png

png Selección_931.png (125,527) 2023-03-21 16:42
https://issues.openbravo.com/file_download.php?file_id=18291&type=bug
png

? bigTerminalLog.json (2,281,065) 2024-02-05 16:08
https://issues.openbravo.com/file_download.php?file_id=19438&type=bug
? terminalLogBlock.json (107,677) 2024-02-05 16:08
https://issues.openbravo.com/file_download.php?file_id=19439&type=bug
Issue History
2023-03-21 14:41ivazquezNew Issue
2023-03-21 14:41ivazquezAssigned To => Retail
2023-03-21 14:41ivazquezFile Added: indexeddbentries.json
2023-03-21 14:41ivazquezTriggers an Emergency Pack => No
2023-03-21 14:42ivazquezFile Added: indexeddbentries2.json
2023-03-21 14:42ivazquezFile Added: Selección_931.png
2023-03-21 14:43ivazquezFile Added: Selección_932.png
2023-03-21 16:32malsasuaProjectRetail Modules => Openbravo ERP
2023-03-21 16:32malsasuaModules => Core
2023-03-21 16:32malsasuaCategoryWeb POS => A. Platform
2023-03-21 16:32malsasuaversionRR20Q3.4 =>
2023-03-21 16:32malsasuaTarget VersionRR20Q3.4 =>
2023-03-21 16:34caristuAssigned ToRetail => Triage Platform Base
2023-03-21 16:37malsasuaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=25734#r25734
2023-03-21 16:40ivazquezFile Deleted: Selección_932.png
2023-03-21 16:40ivazquezFile Deleted: Selección_931.png
2023-03-21 16:42ivazquezFile Added: Selección_932.png
2023-03-21 16:42ivazquezFile Added: Selección_931.png
2023-03-21 18:25ivazquezSummaryIdexedDB data synchronization error => IndexedDB data synchronization error
2023-04-23 23:40AugustoMauchNote Added: 0148755
2023-04-23 23:40AugustoMauchAssigned ToTriage Platform Base => ivazquez
2023-04-23 23:40AugustoMauchStatusnew => feedback
2024-02-05 16:08ivazquezNote Added: 0160266
2024-02-05 16:08ivazquezFile Added: bigTerminalLog.json
2024-02-05 16:08ivazquezFile Added: terminalLogBlock.json
2024-02-05 16:09ivazquezStatusfeedback => new
2024-02-05 16:12ivazquezSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=27465#r27465
2024-02-05 16:12ivazquezAssigned Toivazquez => Retail
2024-02-05 16:15ivazquezAssigned ToRetail => AugustoMauch
2024-02-05 16:15ivazquezversion => PR23Q4.1
2024-02-28 12:18AugustoMauchNote Added: 0161370
2024-02-28 12:18AugustoMauchStatusnew => closed
2024-02-28 12:18AugustoMauchResolutionopen => no change required
2024-03-20 15:28ivazquezRelationship addedrelated to 0055014
2024-03-20 16:30ivazquezRelationship addedrelated to 0055016

Notes
(0148755)
AugustoMauch   
2023-04-23 23:40   
Ignacio,

I am sorry but the way it is reported this issue is not much actionable.

The way you describe the problem, for me the root cause is the bug that causes the corruption of the terminal log. Can you provide some steps to reproduce? The error stack trace could also help.
(0160266)
ivazquez   
2024-02-05 16:08   
Dear Augusto,

Unfortunately we do not know how to reproduce it, but this problem happens often not only in CarterCash but also in Maisadour and even in SMCP using the POS2, I will attach a giant terminal log that we extracted today from CCASH to unblock a till and another one from SMCP from last week, we must review it further to stop it from happening because it is a problem where the customer can not do more than notify us to unblock the till.

Regards,
Ignacio Vazquez
(0161370)
AugustoMauch   
2024-02-28 12:18   
This seems to be not an infra problem, but a problem related to how the infra is used / business logic bugs. Ignacio will report two separate issues that will target the specific problems described in the two attached log files