Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0056538Openbravo ERPA. Platformpublic2024-09-24 12:522024-09-26 10:57
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR24Q4 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelPre packaging ( pi )
Regression date2024-09-16
Regression introduced in releasemain
Regression introduced by commithttps://gitlab.com/openbravo/product/openbravo/-/commit/2125d7c307f7800604da50c51e89e27ef489697a [^]
Triggers an Emergency PackNo
Summary0056538: db transaction remains idle forever after Tomcat start
DescriptionAfter starting tomcat a transaction is kept idle forever.
Steps To Reproduce1. start tomcat
2. check db idle transactions: select query from pg_stat_activity where state ='idle in transaction'

 ERROR: there is an idle transaction that never closes:
        select n.node_id, n.parent_id, o.isready, ot.islegalentity...

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0056195 closed cberner New infrastructure for sending messages, using websockets 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-09-24 12:52alostaleNew Issue
2024-09-24 12:52alostaleAssigned To => Triage Platform Base
2024-09-24 12:52alostaleOBNetwork customer => No
2024-09-24 12:52alostaleModules => Core
2024-09-24 12:52alostaleTriggers an Emergency Pack => No
2024-09-24 12:54alostaleRelationship addedcaused by 0056195
2024-09-24 12:54alostaleAssigned ToTriage Platform Base => alostale
2024-09-24 12:56alostaleRegression level => Pre packaging ( pi )
2024-09-24 12:56alostaleRegression date => 2024-09-16
2024-09-24 12:56alostaleRegression introduced in release => main
2024-09-24 12:56alostaleRegression introduced by commit => https://gitlab.com/openbravo/product/openbravo/-/commit/2125d7c307f7800604da50c51e89e27ef489697a [^]
2024-09-24 13:01hgbotMerge Request Status => open
2024-09-24 13:01hgbotNote Added: 0169525
2024-09-25 12:37hgbotMerge Request Statusopen => approved
2024-09-26 10:57hgbotResolutionopen => fixed
2024-09-26 10:57hgbotStatusnew => closed
2024-09-26 10:57hgbotFixed in Version => PR24Q4
2024-09-26 10:57hgbotNote Added: 0169631
2024-09-26 10:57hgbotNote Added: 0169632

Notes
(0169525)
hgbot   
2024-09-24 13:01   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1356 [^]
(0169631)
hgbot   
2024-09-26 10:57   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: a1e03e5c5d9f9c5500de84559c9dc44d63b78b5b
Author: Asier Lostalé <a.lostale@orisha.com>
Date: 26-09-2024 08:57:20
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/a1e03e5c5d9f9c5500de84559c9dc44d63b78b5b [^]

fixed BUG-56538: DB transaction remains idle forever after Tomcat start

MessageClientContextListener is using DAL to start MessageClientManager, as it
is being run outside regular requests, we need to manually close DAL after using
it to prevent the DB to be leaked.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/messageclient/MessageClientContextListener.java
---
(0169632)
hgbot   
2024-09-26 10:57   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1356 [^]