Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0055217 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Modules] Openbravo Business API | major | always | 2024-04-17 11:31 | 2024-04-17 12:10 | |||
| Reporter | adrianromero | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | ||||||||
| Regression introduced in release | ||||||||
| Summary | 0055217: EDL error using ReadOnly database with Business API events | |||||||
| Description | when 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0163324) hgbot (developer) 2024-04-17 11:37 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/258 [^] |
|
(0163327) hgbot (developer) 2024-04-17 12:10 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^] Changeset: 2095c041ffae02076e17889c498a9eb72e3e4576 Author: Carlos Aristu <carlos.aristu@openbravo.com> Date: 17-04-2024 11:35:35 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/2095c041ffae02076e17889c498a9eb72e3e4576 [^] Fixes ISSUE-55217: 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 --- |
|
(0163328) hgbot (developer) 2024-04-17 12:10 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/258 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2024-04-17 11:31 | adrianromero | New Issue | |
| 2024-04-17 11:31 | adrianromero | Assigned To | => adrianromero |
| 2024-04-17 11:31 | adrianromero | Issue generated from | 0054937 |
| 2024-04-17 11:31 | adrianromero | Relationship added | related to 0054937 |
| 2024-04-17 11:37 | hgbot | Note Added: 0163324 | |
| 2024-04-17 12:10 | hgbot | Resolution | open => fixed |
| 2024-04-17 12:10 | hgbot | Status | new => closed |
| 2024-04-17 12:10 | hgbot | Note Added: 0163327 | |
| 2024-04-17 12:10 | hgbot | Note Added: 0163328 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |