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
