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>
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev