[Dev] Identity Server: Number of Connections

2014-07-07 Thread Daya Attapattu
I am trying to run 400 users (400 threads on jmeter) on identity server. IS fails with the following message: ERROR {org.wso2.carbon.registry.core.dataaccess.TransactionManager} - Failed to start new registry transaction. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:

Re: [Dev] Identity Server: Number of Connections

2014-07-07 Thread Prasad Tissera
In master-datasources.xml (wso2is-5.0.0/repository/conf/datasources) you can increase the database connection pool size by increasing maxActive50/maxActive property. datasource nameWSO2_CARBON_DB/name descriptionThe datasource used for registry and user manager/description

Re: [Dev] Identity Server: Number of Connections

2014-07-07 Thread Prasad Tissera
Hi Daya, Yes, I also don't think there is a linear relationship between numbers of users and max active connections. I thought it was 50 when trying with 400 users. In this case, issue should be something else. May be not closing the connection properly. I'm not aware of the values used in

Re: [Dev] Identity Server: Number of Connections

2014-07-07 Thread Daya Attapattu
I think the message is coming from mysql side: http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html - Daya On Mon, Jul 7, 2014 at 12:34 PM, Prasad Tissera pras...@wso2.com wrote: Hi Daya, Yes, I also don't think there is a linear relationship between numbers of users and max