codesearch-github/codesearch — Issue #26: stale MySql Database Connections are not refreshed
Author: marmichael
Created: 2012-02-14 09:23:24+00:00
State: open
Labels: Code issue

Searching for any term after 10 hours idle time produce this error in the log File:

08:20:41,165 DEBUG SubversionPlugin:108 - Retrieving and checking file: Example-ServiceProvider/trunk/WebContent/WEB-INF/classes/org/opensaml/ws/message/BaseMessageContext.java
08:20:41,233 ERROR SearcherServiceImpl:163 - Could not access database:
org.codesearch.commons.database.DatabaseAccessException: Could not close the stream used to retrieve the content of the binary-index field
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
08:20:41,233 DEBUG SearcherServiceImpl:169 - detected mime is: text/x-java-source
08:20:41,234 DEBUG SearcherServiceImpl:220 - Finished retrieving file content for file: Example-ServiceProvider/trunk/WebContent/WEB-INF/classes/org/opensaml/ws/message/BaseMessageContext.java @ BE-Microsites

search interface still works, search result and file displayed properly (without code highlighting of course)