Project:
| View Revisions: Issue #58060 | [ Back to Issue ] | ||
| Summary | 0058060: websocket infra: DB transaction remains open | ||
| Revision | 2025-02-24 14:28 by alostale | ||
| 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
|
||
| Revision | 2025-02-24 14:27 by alostale | ||
| 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
|
||
| Copyright © 2000 - 2009 MantisBT Group |
 |