[
http://mifosforge.jira.com/browse/MIFOS-4950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukasz Chudy updated MIFOS-4950:
--------------------------------
Status: Ready for Showcase (was: Ready for Testing / Resolved)
> 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
> Labels: grameenkoota
> Fix For: Release 2.0.3, Release G - Iteration 6
>
> Attachments: hibernateManagedDBPool.txt, IMG_15042011_131753.png,
> secdep upgrade log
>
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://mifosforge.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Cloud Computing - Latest Buzzword or a Glimpse of the Future?
This paper surveys cloud computing today: What are the benefits?
Why are businesses embracing it? What are its payoffs and pitfalls?
http://www.accelacomm.com/jaw/sdnl/114/51425149/
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
