I am receiving the following stack trace error on my edex log (below). Any thoughts what may be causing it or how to resolve it?
[ingestCronRoute ] [bean200 ] [bean[ref:WarningToHazardTransformer method: checkForNewTextproducts] ] [ 10133]
Exchange
---------------------------------------------------------------------------------------------------------------------------------------
Exchange[
Id ID-wxserver-42472-1485069846607-86-64
ExchangePattern InOnly
Headers {breadcrumbId=ID-wxserver-42472-1485069846607-86-63, calendar=null, CamelRedelivered=false, CamelRedeliveryCounter=0, fireTime=Sun Jan 22 07:29:25 GMT 2017, jobDetail=JobDetail 'DEFAULT.quartz-endpoint261': jobClass: 'org.apache.camel.component.quartz.CamelJob isStateful: false isVolatile: false isDurable: false requestsRecovers: false, jobInstance=org.apache.camel.component.quartz.CamelJob@37690b7a, jobRunTime=-1, mergedJobDataMap=org.quartz.JobDataMap@27c12a43, nextFireTime=Sun Jan 22 07:29:30 GMT 2017, previousFireTime=Sun Jan 22 07:29:20 GMT 2017, refireCount=0, result=null, scheduledFireTime=Sun Jan 22 07:29:25 GMT 2017, scheduler=org.quartz.impl.StdScheduler@7a863452, trigger=Trigger 'HydroTextProductMonitor.checkForNewData/': triggerClass: 'org.quartz.CronTrigger isVolatile: false calendar: 'null' misfireInstruction: 0 nextFireTime: Sun Jan 22 07:29:30 GMT 2017, triggerGroup=HydroTextProductMonitor, triggerName=checkForNewData/}
BodyType String
Body
]
Stacktrace
---------------------------------------------------------------------------------------------------------------------------------------
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:544) ~[spring-orm-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at com.raytheon.uf.edex.database.dao.CoreDao.executeHQLQuery(CoreDao.java:711) ~[com.raytheon.uf.edex.database.jar:na]
at com.raytheon.uf.edex.hazards.interop.WarningToHazardTransformer.checkForNewTextproducts(WarningToHazardTransformer.java:271) ~[com.raytheon.uf.edex.hazards.interop.jar:na]
at com.raytheon.uf.edex.hazards.interop.WarningToHazardTransformer$$FastClassBySpringCGLIB$$f0beeae8.invoke(<generated>) ~[com.raytheon.uf.edex.hazards.interop.jar:na]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) ~[spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
at com.raytheon.uf.edex.hazards.interop.WarningToHazardTransformer$$EnhancerBySpringCGLIB$$f01185d2.checkForNewTextproducts(<generated>) ~[com.raytheon.uf.edex.hazards.interop.jar:na]
at sun.reflect.GeneratedMethodAccessor225.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_77]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_77]
at org.apache.camel.component.bean.MethodInfo.invoke(MethodInfo.java:408) ~[camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.component.bean.MethodInfo$1.doProceed(MethodInfo.java:279) ~[camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.component.bean.MethodInfo$1.proceed(MethodInfo.java:252) ~[camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.component.bean.BeanProcessor.process(BeanProcessor.java:177) ~[camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109) [camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.component.bean.BeanProcessor.process(BeanProcessor.java:68) ~[camel-core-2.16.2.jar:2.16.2]
at com.raytheon.uf.edex.esb.camel.MessageProducer$2.process(MessageProducer.java:432) ~[com.raytheon.uf.edex.esb.camel.jar:na]
at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:91) ~[camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:460) ~[camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190) [camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:190) [camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.processor.loadbalancer.QueueLoadBalancer.process(QueueLoadBalancer.java:44) [camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109) [camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.processor.loadbalancer.LoadBalancerSupport.process(LoadBalancerSupport.java:97) [camel-core-2.16.2.jar:2.16.2]
at org.apache.camel.component.quartz.QuartzEndpoint.onJobExecute(QuartzEndpoint.java:146) [camel-quartz-2.16.2.jar:2.16.2]
at com.raytheon.uf.edex.esb.camel.cluster.quartz.ClusteredQuartzEndpoint.onJobExecute(ClusteredQuartzEndpoint.java:74) [com.raytheon.uf.edex.esb.camel.jar:na]
at org.apache.camel.component.quartz.CamelJob.execute(CamelJob.java:63) [camel-quartz-2.16.2.jar:2.16.2]
at org.quartz.core.JobRunShell.run(JobRunShell.java:223) [quartz-1.8.6.jar:na]
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) [quartz-1.8.6.jar:na]
Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1351) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:502) ~[spring-orm-4.2.4.RELEASE.jar:4.2.4.RELEASE]
... 36 common frames omitted
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118) ~[mchange-commons-java-0.2.3.4.jar:na]
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:689) ~[c3p0-0.9.2.1.jar:0.9.2.1]
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) ~[c3p0-0.9.2.1.jar:0.9.2.1]
at org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:84) ~[hibernate-c3p0-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:301) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214) ~[hibernate-core-4.2.15.Final.jar:4.2.15.Final]
... 41 common frames omitted
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:1418) ~[c3p0-0.9.2.1.jar:0.9.2.1]
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:606) ~[c3p0-0.9.2.1.jar:0.9.2.1]
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:526) ~[c3p0-0.9.2.1.jar:0.9.2.1]
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:755) ~[c3p0-0.9.2.1.jar:0.9.2.1]
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:682) ~[c3p0-0.9.2.1.jar:0.9.2.1]
... 45 common frames omitted
ERROR 2017-01-22 07:29:35,163 1537 [DefaultQuartzScheduler_Worker-7] QuartzEndpoint: Error processing exchange. Exchange[ID-wxserver-42472-1485069846607-86-64][Message: ]. Caused by: [org.quartz.JobExecutionException - org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection]
