Re: [Treebase-devel] 8ball TreeBASE Down

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

This sounds like the database is down. Or it is up but has been down  
temporarily and so the connection handles in the pool have gotten  
stale. You can take care of the latter by restarting the application  
server (Tomcat, I presume).

	-hilmar

On Sep 11, 2009, at 9:21 AM, William Piel wrote:

>
> TreeBASE (http://8ball.sdsc.edu:6666/) seems to be down. Is this a  
> broken application service for SDSC staff to fix?
>
> Below is the result of a simple author search.
>
> bp
>
>
> Could not open Hibernate Session for transaction; nested exception  
> is org.hibernate.exception.GenericJDBCException: Cannot open  
> connection
>
> org.springframework.transaction.CannotCreateTransactionException:  
> Could not open Hibernate Session for transaction; nested exception  
> is org.hibernate.exception.GenericJDBCException: Cannot open  
> connection Caused by: org.hibernate.exception.GenericJDBCException:  
> Cannot open connection at  
> org 
> .hibernate 
> .exception 
> .SQLStateConverter 
> .handledNonSpecificException(SQLStateConverter.java:103) at  
> org 
> .hibernate 
> .exception.SQLStateConverter.convert(SQLStateConverter.java:91) at  
> org 
> .hibernate 
> .exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)  
> at  
> org 
> .hibernate 
> .exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)  
> at  
> org 
> .hibernate 
> .jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)  
> at  
> org 
> .hibernate 
> .jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) at  
> org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119) at  
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java: 
> 57) at  
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java: 
> 1326) at  
> org 
> .springframework 
> .orm 
> .hibernate3 
> .HibernateTransactionManager 
> .doBegin(HibernateTransactionManager.java:510) at  
> org 
> .springframework 
> .transaction 
> .support 
> .AbstractPlatformTransactionManager 
> .getTransaction(AbstractPlatformTransactionManager.java:350) at  
> org 
> .springframework 
> .transaction 
> .interceptor 
> .TransactionAspectSupport 
> .createTransactionIfNecessary(TransactionAspectSupport.java:262) at  
> org 
> .springframework 
> .transaction 
> .interceptor 
> .TransactionInterceptor.invoke(TransactionInterceptor.java:101) at  
> org 
> .springframework 
> .aop 
> .framework 
> .ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java: 
> 171) at  
> org 
> .springframework 
> .aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java: 
> 204) at $Proxy83.getStudyService(Unknown Source) at  
> org 
> .cipres 
> .treebase 
> .web 
> .controllers 
> .StudySearchController.doSearch(StudySearchController.java:276) at  
> org 
> .cipres 
> .treebase 
> .web 
> .controllers 
> .StudySearchController.onSubmit(StudySearchController.java:163) at  
> org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission 
> (SimpleFormController.java:267) at org.springframework.web.servlet.mvc.CancellableFormController.processFormSubmission 
> (CancellableFormController.java:140) at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal 
> (AbstractFormController.java:265) at org.springframework.web.servlet.mvc.AbstractController.handleRequest 
> (AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle 
> (SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch 
> (DispatcherServlet.java:858) at org.springframework.web.servlet.DispatcherServlet.doService 
> (DispatcherServlet.java:792) at org.springframework.web.servlet.FrameworkServlet.processRequest 
> (FrameworkServlet.java:476) at org.springframework.web.servlet.FrameworkServlet.doPost 
> (FrameworkServlet.java:441) at  
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at  
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 269) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at  
> org 
> .displaytag 
> .filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java: 
> 125) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 215) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at  
> org 
> .springframework 
> .orm 
> .hibernate3 
> .support 
> .OpenSessionInViewFilter 
> .doFilterInternal(OpenSessionInViewFilter.java:198) at  
> org 
> .springframework 
> .web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 
> 75) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 215) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at  
> com 
> .opensymphony 
> .module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at  
> com 
> .opensymphony 
> .module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 215) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:264) at  
> org 
> .acegisecurity 
> .intercept 
> .web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java: 
> 107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter 
> (FilterSecurityInterceptor.java:72) at  
> org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity 
> .ui 
> .ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java: 
> 110) at org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity 
> .wrapper 
> .SecurityContextHolderAwareRequestFilter 
> .doFilter(SecurityContextHolderAwareRequestFilter.java:81) at  
> org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity 
> .ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java: 
> 217) at org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity 
> .context 
> .HttpSessionContextIntegrationFilter 
> .doFilter(HttpSessionContextIntegrationFilter.java:191) at  
> org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java: 
> 148) at  
> org 
> .acegisecurity 
> .util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 215) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at  
> org 
> .apache 
> .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 
> 213) at  
> org 
> .apache 
> .catalina.core.StandardContextValve.invoke(StandardContextValve.java: 
> 174) at  
> org 
> .apache 
> .catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
> at  
> org 
> .apache 
> .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)  
> at  
> org 
> .apache 
> .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
> 108) at  
> org 
> .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
> 174) at  
> org 
> .apache.coyote.http11.Http11Processor.process(Http11Processor.java: 
> 874) at org.apache.coyote.http11.Http11BaseProtocol 
> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 
> 665) at  
> org 
> .apache 
> .tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java: 
> 528) at  
> org 
> .apache 
> .tomcat 
> .util 
> .net 
> .LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java: 
> 81) at org.apache.tomcat.util.threads.ThreadPool 
> $ControlRunnable.run(ThreadPool.java:689) at  
> java.lang.Thread.run(Thread.java:595) Caused by:  
> java.sql.SQLException: Connections could not be acquired from the  
> underlying database! at  
> com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at  
> com 
> .mchange 
> .v2 
> .c3p0 
> .impl 
> .C3P0PooledConnectionPool 
> .checkoutPooledConnection(C3P0PooledConnectionPool.java:529) 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: 
> 423) ... 65 more Caused by:  
> com.mchange.v2.resourcepool.CannotAcquireResourceException: A  
> ResourcePool could not acquire a resource from its primary factory  
> or source. at  
> com 
> .mchange 
> .v2 
> .resourcepool 
> .BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319) 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) ... 68  
> more « Back
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008  
> 30-Day
> trial. Simplify your report design, integration and deployment - and  
> focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july_______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel

-- 
===========================================================
: Hilmar Lapp  -:-  Durham, NC  -:- hlapp at duke dot edu :
===========================================================