Project:
| View Revisions: Issue #54090 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0054090: connection leak on Tomcat start if a process is missfired | ||
| Revision | 2023-12-11 09:54 by alostale | ||
| Steps To Reproduce | 1. Configure the connection pool to use very few connections, ie. 4. (This step is not necessary but it make it easier to see the problem). 2. Schedule a process (ie. alert process) to run every 5 seconds. 3. Stop Tomcat and wait 5 secs. 4. Start Tomcat and wait 30 secs for quartz to start. - There will be a missfired instance of the scheduled process (OK) 5. Log in BO and perform some operations (ie. open a couple of windows and refresh grid some times). - ERROR: check pg_stat_activity, there is an idle connection whose state_change is at the time Tomcat was started and the query is INSERT INTO AD_Process_Run... Configuring the pool to log abandoned connections (db.pool.logAbandoned=true and db.pool.suspectTimeout=10), it will point to ProcessMonitor.triggerMisfired |
||
| Revision | 2023-12-11 09:38 by alostale | ||
| Steps To Reproduce | 1. Configure the connection pool to use very few connections, ie. 4. (This step is not necessary but it make it easier to see the problem). 2. Schedule a process (ie. alert process) to run every 5 seconds. 3. Stop Tomcat and wait 5 secs. 4. Start Tomcat and wait 30 secs for quartz to start. - There will be a missfired instance of the scheduled process (OK) 5. Log in BO and perform some operations (ie. open a couple of windows and refresh grid some times). - ERROR: check pg_stat_activity, there is an idle connection whose state_change is at the time Tomcat was started and the query is INSERT INTO AD_Process_Run... |
||
| Revision | 2023-12-11 09:36 by alostale | ||
| Steps To Reproduce | 1. Configure the connection pool to use very few connections, ie. 4. (This step is not necessary but it make it easier to see the problem). 2. Schedule a process (ie. alert process) to run every 5 seconds. 3. Stop Tomcat and wait 5 secs. 4. Start Tomcat - There will be a missfired instance of the scheduled process (OK) 5. Log in BO and perform some operations (ie. open a couple of windows and refresh grid some times). - ERROR: check pg_stat_activity, there is an idle connection whose state_change is at the time Tomcat was started and the query is INSERT INTO AD_Process_Run... |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |