Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010309Openbravo ERPA. Platformpublic2009-08-17 17:182009-09-18 00:00
Reporterplujan 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010309: Restarting Tomcat service does not clean the session_active field in ad_session
DescriptionIf I restart Tomcat service, all active sessions in ad_session table are kept as active, so license count will consider non active sessions until this rows were manually updated
Steps To ReproduceUse an OBPS site with 5 users limit.
Enter from 5 different browsers. All users can log in and work with the app.
Restart tomcat service.
Try to login again. A message saying all the licenses are in use is displayed and you cannot login.
Proposed Solution
Additional Information
TagsOBPS-Security
Relationships
related to defect 00268463.0PR14Q3 closed alostale Code running on tomcat start to search in remote tomcats is not needed anymore and can't work with Load Balanced Tomcats 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-17 17:18plujanNew Issue
2009-08-17 17:18plujanAssigned To => rafaroda
2009-08-17 17:18plujanTag Attached: OBPS-Security
2009-08-18 15:36rafarodaAssigned Torafaroda => alostale
2009-08-18 15:36rafarodaPrioritynormal => high
2009-08-18 15:36rafarodaStatusnew => scheduled
2009-08-18 18:13plujanversion => pi
2009-09-02 11:59alostaleNote Added: 0019408
2009-09-02 12:04hgbotCheckin
2009-09-02 12:04hgbotNote Added: 0019409
2009-09-02 12:04hgbotStatusscheduled => resolved
2009-09-02 12:04hgbotResolutionopen => fixed
2009-09-02 12:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d1e81c8176dbbd49a5b1faa890f4c0b2d29e76a9 [^]
2009-09-17 19:18psarobeStatusresolved => closed
2009-09-17 19:18psarobeNote Added: 0020154
2009-09-17 19:18psarobeFixed in Version => 2.50MP6
2009-09-18 00:00anonymoussf_bug_id0 => 2860999
2014-06-12 09:55alostaleRelationship addedrelated to 0026846

Notes
(0019408)
alostale   
2009-09-02 11:59   
In a normal shoutdown the active sessions in the context should be deactivated. This should only occur in abnormal shutdowns (for example killing the tomcat process).
(0019409)
hgbot   
2009-09-02 12:04   
Repository: erp/devel/pi
Changeset: d1e81c8176dbbd49a5b1faa890f4c0b2d29e76a9
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Sep 02 12:03:31 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d1e81c8176dbbd49a5b1faa890f4c0b2d29e76a9 [^]

fixed bug 0010309: Clean orphan sessions when starting context

    When tomcat is started orphan sessions (for example the ones that were in a context that was abnormally shut down) are deactivated.

---
M src-db/database/model/tables/AD_SESSION.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
M src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
M src/org/openbravo/erpCommon/security/SessionListener.java
M src/org/openbravo/erpCommon/security/SessionLogin.java
M src/org/openbravo/erpCommon/security/SessionLogin_data.xsql
A src/org/openbravo/erpCommon/security/SessionActive.java
---
(0020154)
psarobe   
2009-09-17 19:18   
Tested working fine