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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0054937
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Openbravo Business APImajoralways2024-03-13 11:322024-04-17 11:31
ReportermalsasuaView Statuspublic 
Assigned Tocaristu 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0054937: EDL error using ReadOnly database with Business API events

Descriptionwhen EDL is configured to use the ReadOnly db:
Openbravo.properties: bbdd.readonly.url=xxxx

in the flow Send Business API Event, if the synchronization between the primary and the replica nodes is slow, an error is raised (attached the whole error trace):
ERROR org.openbravo.externaldata.integration.process.AsynchronousProcessor - Unexpected error processing item
org.openbravo.base.exception.OBException: Could not export data for record with ID A6FACEAC7AA61347420F98C6BB9A96BF
        at org.openbravo.api.edl.ApiEventItemProcessor.lambda$exportItem$0(ApiEventItemProcessor.java:85) ~[classes/:?]

Executing again, the EDL works

The problem is the ticket was processed but it was not synced yet to the replica db node
Steps To Reproduce. in local env, duplicate the db:
 -> create database miDB2 template miDB;
. configure Openbravo.properties to use a readOnly:
bbdd.readonly.url=jdbc:postgresql://localhost:5432 [^]
bbdd.readonly.sid=miDB2
bbdd.readonly.user=tad
bbdd.readonly.password=tad

. configure to use Send Business API - RETAPCO_OrderCreation

. in POS -> complete a ticket
. in BO -> go to EDL -> edl record was created in error
TagsNo tags attached.
Attached Fileslog file icon stackTrace.log [^] (5,062 bytes) 2024-03-13 11:32
png file icon codeError.png [^] (50,108 bytes) 2024-03-13 11:33

- Relationships Relation Graph ] Dependency Graph ]
related to backport 0055135 closedadrianromero EDL error using ReadOnly database with Business API events 
related to backport 0055217 closedadrianromero EDL error using ReadOnly database with Business API events 

-  Notes
(0162130)
hgbot (developer)
2024-03-14 08:35

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/243 [^]
(0162884)
hgbot (developer)
2024-04-05 12:51

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/243 [^]
(0162885)
hgbot (developer)
2024-04-05 12:51

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: 8415e224774f1c20b10d889501093a056f15b5e4
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 05-04-2024 10:51:54
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/8415e224774f1c20b10d889501093a056f15b5e4 [^]

fixes BUG-54937: do not use RO pool for single record events

---
M src-test/org/openbravo/api/edl/ApiEventItemProcessorTest.java
M src/org/openbravo/api/edl/ApiEventItemProcessor.java
---

- Issue History
Date Modified Username Field Change
2024-03-13 11:32 malsasua New Issue
2024-03-13 11:32 malsasua Assigned To => Triage Platform Base
2024-03-13 11:32 malsasua Modules => Core
2024-03-13 11:32 malsasua Triggers an Emergency Pack => No
2024-03-13 11:32 malsasua File Added: stackTrace.log
2024-03-13 11:33 malsasua File Added: codeError.png
2024-03-13 11:34 malsasua Description Updated View Revisions
2024-03-13 11:37 caristu Project Openbravo ERP => Modules
2024-03-13 11:39 caristu Assigned To Triage Platform Base => Triage Platform Conn
2024-03-13 11:39 caristu Category A. Platform => Openbravo Business API
2024-03-13 11:41 malsasua Summary EDL error using ReadOnly database => EDL error using ReadOnly database with Business API events
2024-03-14 08:35 hgbot Note Added: 0162130
2024-03-18 10:06 adrianromero Assigned To Triage Platform Conn => caristu
2024-04-05 12:51 hgbot Note Added: 0162884
2024-04-05 12:51 hgbot Resolution open => fixed
2024-04-05 12:51 hgbot Status new => closed
2024-04-05 12:51 hgbot Note Added: 0162885
2024-04-09 09:37 adrianromero Issue cloned 0055135
2024-04-09 09:37 adrianromero Relationship added related to 0055135
2024-04-17 11:31 adrianromero Issue cloned 0055217
2024-04-17 11:31 adrianromero Relationship added related to 0055217


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker