Hi Pandula, you can use following configurations in identity.xml to configure cleanup task frequency.
<PersistanceCleanUpTimeout>20160</PersistanceCleanUpTimeout> <PersistanceCleanUpPeriod>1140</PersistanceCleanUpPeriod> On Mon, Oct 5, 2015 at 5:19 PM, Hasintha Indrajee <hasin...@wso2.com> wrote: > 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 > > -- Hasintha Indrajee Software Engineer WSO2, Inc. Mobile:+94 771892453
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev