Project:
| View Revisions: Issue #36001 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0036001: Connection leak after start the system having any servlet with "loaded-on-startup" for example: Analytics module installed | ||
| Revision | 2017-05-19 09:04 by caristu | ||
| Steps To Reproduce | In an environment with Analytics module installed: 1- Start tomcat Check on the pg_stat_activity that there is a line in state='idle in transaction' the query is: SELECT mo.action AS TYPE, (CASE mo.action WHEN 'X' THEN mo.ad_form_id WHEN 'P' THEN mo.ad_process_id WHEN 'R' THEN mo.ad_process_id WHEN 'S' THEN mo.ad_reference_id WHEN 'C' THEN mo.ad_callout_id ELSE null END) AS ID, m.name AS NAME, /*Name is only maintained for backwards compatibility, now REPORT_TITLE is automatically filled*/ COALESCE((CASE mo.action WHEN 'X' THEN f.ad_module_id WHEN 'P' THEN p.ad_module_id WHEN 'R' THEN p.ad_module_id WHEN 'S' THEN r.ad_module_id W Having Analytics installed this query is launched in the init method of the QueryRepositoryServlet servlet |
||
| Revision | 2017-05-19 08:46 by caristu | ||
| Steps To Reproduce | Start tomcat login to system Check on the pg_stat_activity that there is a line in state='idle in transaction' the query is: ELECT mo.action AS TYPE, (CASE mo.action WHEN 'X' THEN mo.ad_form_id WHEN 'P' THEN mo.ad_process_id WHEN 'R' THEN mo.ad_process_id WHEN 'S' THEN mo.ad_reference_id WHEN 'C' THEN mo.ad_callout_id ELSE null END) AS ID, m.name AS NAME, /*Name is only maintained for backwards compatibility, now REPORT_TITLE is automatically filled*/ COALESCE((CASE mo.action WHEN 'X' THEN f.ad_module_id WHEN 'P' THEN p.ad_module_id WHEN 'R' THEN p.ad_module_id WHEN 'S' THEN r.ad_module_id W |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |