0058103: websocket infra: DB transaction remains open

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