Hi Pandula, What is your configured time period for session data cleanup task ? . Can you please reduce it and check. Please refer [1]
[1] https://docs.wso2.com/display/IS500/Enabling+Authentication+Session+Persistence On Mon, Oct 5, 2015 at 3:12 PM, Pandula Kariyawasam <pand...@wso2.com> wrote: > > Hi Team, > > We are experiencing the issue [1] during the long run test for OAuth on > IS510Alpha pack. > > This is a 3 node cluster setup and the DBs are on Oracle 12c. > - 3 IS Nodes > - Load Balanced via Nginx Plus 1.7 > - Registry Mounted > - Primary User store - Open LDAP > - DB -Oracle 12c > > The scenario we are focusing in the Long Run as follows, > - Super Tenant Admin generate Authorization Code Token for his own App > - Super Tenant User generate Authorization Code Token for his own App > - Tenant2 User generate Authorization Code Token for his own App > - Tenant2 User generate Authorization Code Token for Super Tenant User's > App > - Super Tenant User generate Authorization Code Token for Tenant2 User's > App > - Tenant1 Admin generate Authorization Code Token for Tenant2 User's App > - Super Tenant Admin generate Authorization Code Token for Tenant2 User's > App > - Tenant3 Admin generate Authorization Code Token for Tenant2 User's App > - Tenant3 Admin generate Authorization Code Token for Super Tenant User's > App > > The Jmeter script invokes these scenarios on 5 Threads, without a delay. > > > - The cause for this issue is the 'USER DBF' file in > 'C:\app\oracle\oradata\ora12c' location of Oracle installation, has reached > it's maximum limit. > - As a workaround we can set a new file using following Oracle Script > [2], with giving the maximum allowed size as 'MAXSIZE'. > - Still the script we used for longrun test make it grow up to 1GB > within 2 hours. > - We can give a larger 'MAXSIZE' but it won't be practical for larger > loads. > - Can you check the validity of things that written in to this file, > which cause it to grow so quickly? > - Is this the expected behavior? > > Related public JIRA [3] > > Highly appreciate your opinion and advices on this. > > Thanks, > Pandula > > > > [1] > > TID: [-1] [] [2015-10-05 11:48:19,909] ERROR > {org.wso2.carbon.identity.application.authentication.framework.store.SessionDataStore} > - Error while storing session data > java.sql.SQLException: ORA-01653: unable to extend table > IS510ID.IDN_AUTH_SESSION_STORE by 8192 in tablespace USERS > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897) > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361) > at > org.wso2.carbon.identity.application.authentication.framework.store.SessionDataStore.persistSessionData(SessionDataStore.java:345) > at > org.wso2.carbon.identity.application.authentication.framework.store.SessionDataPersistTask.run(SessionDataPersistTask.java:53) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > > > > [2] > > ALTER TABLESPACE users > ADD DATAFILE 'C:\app\oracle\oradata\ora12c\users02.dbf' SIZE 10M > AUTOEXTEND ON > NEXT 512K > MAXSIZE 1024M; > > > [3] https://wso2.org/jira/browse/IDENTITY-3736 > > > -- > > *Pandula Kariyawasam K.B.* > *Senior Software Engineer - QA* > Mobile: +94772314510 > > > > *WSO2 Inc.lean . enterprise . middlewear.http://www.wso2.com > <http://www.wso2.com>* > <http://www.wso2.com> > -- Hasintha Indrajee Software Engineer WSO2, Inc. Mobile:+94 771892453
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev