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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0056538
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2024-09-24 12:522024-09-26 10:57
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in VersionPR24Q4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
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
Summary

0056538: 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...

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
caused by feature request 0056195 closedcberner New infrastructure for sending messages, using websockets 

-  Notes
(0169525)
hgbot (developer)
2024-09-24 13:01

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1356 [^]
(0169631)
hgbot (developer)
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 (developer)
2024-09-26 10:57

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1356 [^]

- Issue History
Date Modified Username Field Change
2024-09-24 12:52 alostale New Issue
2024-09-24 12:52 alostale Assigned To => Triage Platform Base
2024-09-24 12:52 alostale Modules => Core
2024-09-24 12:52 alostale Triggers an Emergency Pack => No
2024-09-24 12:54 alostale Relationship added caused by 0056195
2024-09-24 12:54 alostale Assigned To Triage Platform Base => alostale
2024-09-24 12:56 alostale Regression level => Pre packaging ( pi )
2024-09-24 12:56 alostale Regression date => 2024-09-16
2024-09-24 12:56 alostale Regression introduced in release => main
2024-09-24 12:56 alostale Regression introduced by commit => https://gitlab.com/openbravo/product/openbravo/-/commit/2125d7c307f7800604da50c51e89e27ef489697a [^]
2024-09-24 13:01 hgbot Note Added: 0169525
2024-09-26 10:57 hgbot Resolution open => fixed
2024-09-26 10:57 hgbot Status new => closed
2024-09-26 10:57 hgbot Fixed in Version => PR24Q4
2024-09-26 10:57 hgbot Note Added: 0169631
2024-09-26 10:57 hgbot Note Added: 0169632


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker