[
http://mifosforge.jira.com/browse/MIFOS-4950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Van Mittal-Henkle resolved MIFOS-4950.
--------------------------------------
Resolution: Fixed
resolution was verified by performance test runs with 100 concurent users
viewing clients with question group data.
For Mifos 2.0.2, database connection timeouts were observed consistent with
what GK saw.
For Mifos 2.0.3 (with the fix), no errors were observed.
> View Client/Group/Center screen would not open when multiple users are logged
> in
> --------------------------------------------------------------------------------
>
> Key: MIFOS-4950
> URL: http://mifosforge.jira.com/browse/MIFOS-4950
> Project: mifos
> Issue Type: Bug
> Reporter: Udai Gupta
> Assignee: Van Mittal-Henkle
> Priority: Critical
> Attachments: hibernateManagedDBPool.txt, IMG_15042011_131753.png
>
>
> Mifos 2.0.2 with about 100 concurrent users it throws errors and View
> Customer screen times out (doesn't load).
> The exceptions were related to
> {code}
> Caused by: java.sql.SQLException: An attempt by a client to checkout a
> Connection has timed out.
> at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
> at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
> at
> com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
> at
> org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
> ... 14 more
> Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out
> while waiting to acquire a resource from
> com.mchange.v2.resourcepool.BasicResourcePool@1bdb52c8 -- timeout at
> awaitAvailable()
> at
> com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317)
> at
> com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
> at
> com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
> at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
> {code}
> We increased the max connections in my.cnf to 200 from 50,
> max_connection_pool(local.properties) to 200 from 20, after this connection
> timeout error was gone but View Customer Screen were still being stuck (or
> taking forever to load) or throw error.
> {code}
> java.lang.NullPointerException
> at
> org.mifos.framework.util.helpers.SessionUtils.getFlow(SessionUtils.java:249)
> at
> org.mifos.framework.util.helpers.SessionUtils.setCollectionAttribute(SessionUtils.java:229)
> at
> org.mifos.customers.client.struts.action.ClientCustAction.setQuestionGroupInstances(ClientCustAction.java:517)
> at
> org.mifos.customers.client.struts.action.ClientCustAction.setQuestionGroupInstances(ClientCustAction.java:506)
> {code}
> Looking at the processes of MySQL using MySQL Admin it was found that lot's
> of queries were just waiting. (screenshot attached)
> There are two major factors which could causing this issue.
> - Dataset had > 10000000 responses in question_group_response table, we
> tested with something like 1800000 responses.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
