[JS1-540] Continuously increasing number of Oracle sessions

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.5
• Component/s: Database
• Environment: Windows/Linux, Tomcat4.1/Tomcat5.0
• Assignee: Unassigned
• Reporter: Vesa
• Created: 17/Feb/05 22:00
• Updated: 04/Apr/05 16:52

Description

If the user keeps the browser open until the session expires and after that (he or anyone else) goes to login page (gets anonymous user profile) a new Oracle session is created in database and the previously used one stays inactive forever. This happens every time someone's session expires and a new user logs in until we get 'ORA-00020: maximum number of processes (150) exceeded' and Jetspeed crushes.
In addition to this a new database session is also created every eight hours counting from the startup of Tomcat.