Project:
| View Revisions: Issue #43440 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0043440: [Performance] With an certain code in evenhandlers it is possible to leave non reusable connections in the pool | ||
| Revision | 2020-03-13 11:04 by caristu | ||
| Steps To Reproduce | - In tomcat conf in server.xml file un comment line: <Executor name="tomcatThreadPool" namePrefix="catalina-exec-" maxThreads="150" minSpareThreads="4"/> and put maxThreads="5" - In an environment with retail apply the attached patch - Log in the system with a user and go to User -> User roles and activate and deactivate some user roles - Open, refresh and close windows - Log out and log in with another user - Do the same - Wait more than two minutes - Go to the database and execute 'select * from pg_stat_activity order by xact_start;' - There are connections with state_change older than 2 minutes that the pool should have closed (because of the default db.pool.minEvictableIdleTimeMillis=120000 configuration in Openbravo.properties) |
||
| Revision | 2020-03-05 19:22 by ioritzCia | ||
| Steps To Reproduce | - In tomcat conf in server.xml file un comment line: <Executor name="tomcatThreadPool" namePrefix="catalina-exec-" maxThreads="150" minSpareThreads="4"/> and put maxThreads="5" - In an environment with retail apply the attached patch - Log in the system with a user and go to User -> User roles and activate and deactivate some user roles - Open, refresh and close windows - Log out and log in with another user - Do the same - Wait more than two minutes - Go to the database and execute 'select * from pg_stat_activity order by xact_start;' - There are connections with state_change older than 2 minutes that the pool should have closed |
||
| Revision | 2020-03-05 19:17 by ioritzCia | ||
| Steps To Reproduce | - In an environment with retail apply the attached patch - Log in the system with a user and go to User -> User roles and activate and deactivate some user roles - Open, refresh and close windows - Log out and log in with another user - Do the same - Wait more than two minutes - Go to the database and execute 'select * from pg_stat_activity order by xact_start;' - There are connections with state_change older than 2 minutes that the pool should have closed |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |