0058060: websocket infra: DB transaction remains open

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0058060

Openbravo ERP

A. Platform

public

2025-02-24 14:27

2025-02-28 12:07

Reporter

alostale

Assigned To

Triage Platform Base

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

PR25Q2

Merge Request Status

approved

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0058060: websocket infra: DB transaction remains open

Description

When websockets is enabled, a DB transaction is kept open forever not being returnd to the pool.

Steps To Reproduce

1. Activate Websockets: set "Enable Message Client Manager" preference to Y
2. Restart Tomcat
3. Check pg_stat_activity, there is a transaction that is created on Tomcat start and reused to check pending messages every 10s.

select xact_start, state_change, query from pg_stat_activity where state = 'idle in transaction';
          xact_start           |         state_change         |                                                                                                                                                                                                                                                                                                      
query                                                                                                                                                                                                                                                                                                      

-------------------------------+------------------------------+-------------------------------------------------------------------------
 
2025-02-24 14:09:39.901561+01 | 2025-02-24 14:26:19.80062+01 | select this_.C_Persisted_Message_ID as 
c_persis1_278_0_, this_.AD_Client_ID as ad_clien2_278_0_, this_.AD_Org_ID as ad_org_i3_278_0_, this_.Isactive 
as isactive4_278_0_, this_.Created as created5_278_0_, this_.Createdby as createdb6_278_0_, this_.Updated 
as updated7_278_0_, this_.Updatedby as updatedb8_278_0_, this_.Payload as payload9_278_0_, this_.Type 
as type10_278_0_, this_.Expirationdate as expirat11_278_0_, this_.Context as context12_278_0_ from C_Persisted_Message 
this_ where this_.Expirationdate>=$1 and this_.Created>$2 and this_.Isactive=$3 order by this_.Created 
asc limit $4

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

depends on	backport	0058102	PR25Q1	closed	Triage Platform Base	websocket infra: DB transaction remains open
depends on	backport	0058103	PR24Q4.2	closed	Triage Platform Base	websocket infra: DB transaction remains open
caused by	feature request	0056195		closed	cberner	New infrastructure for sending messages, using websockets