[Building Sakai] DB connections timeout after some time in 2.9.2

[David Wafula Wanyonyi]

Hello all,

We are about to upgrade  from 2.8.0 to 2.9.2  in about 3 weeks. In our QA running 2.9.2, we have noticed  that DB connections are timing out after some time, freezing the whole Sakai...here is an extract from the logs:

2013-06-20 10:04:37,199  WARN http-bio-8080-exec-129 org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = SAKAI_REALM.REALM_KEY and  SAKAI_REALM.REALM_ID IN (?,?,?) and FUNCTION_KEY in (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = ?)  and (ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and USER_ID = ?  and REALM_KEY in (select REALM_KEY from SAKAI_REALM where  SAKAI_REALM.REALM_ID IN (?,?,?)))  or ROLE_KEY in (1) ) /announcement/channel/!site/motd /site/!site !site.helper annc.read  /announcement/channel/!site/motd /site/!site !site.helper
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
....


The DB is MySQL 5.5.15 Connecting direct to DB just works fine, implying this just happening on the Sakai side.

We are running Java 1.7.0_07 on Solaris 5.11
Any areas we should be looking at ?

David Wafula,
Team Leader, Software Development,
eLearning Support and Innovation Unit,
University of Witwatersrand, Johannesburg
Tel +27 11 717 7180
Website http://elearn.wits.ac.za
Private Bag 3, Wits, 2050, South Africa

<table width="100%" border="0" cellspacing="0" cellpadding="0" style="width:100%;"> 
<tr>
<td align="left" style="text-align:justify;"><font face="arial,sans-serif" size="1" color="#999999"><span style="font-size:11px;">This communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorised signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary. </span></font></td>
</tr>
</table
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130620/caee2865/attachment.html