Project:
| View Revisions: Issue #36001 | [ 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-22 10:32 by alostale | ||
| Description | A transaction is not closed after restart tomcat when the instance has Analytics module installed. The problem occurs for any Servlet that is marked to be loaded on startup, at this point a DAL connection is now created out of a Servlet request, so standard DalThreadHandler is not closing it. |
||
| 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 09:04 by caristu | ||
| Description | A connection is not closed after restart tomcat and access to the application when the instance has Analytics module installed. | ||
| 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 |
||
| Revision | 2017-05-19 08:46 by caristu | ||
| Description | A connection is not closed after restart tomcat and access to the application. | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |