Hi,
We are having a problem using the Timer Service - the ejbTimer database cannot be created . When I try to ping the TimerPool, it fails, but we haven't made any changes to the pool or the datasource. It was working for a while, but then we began getting these messages. Has anyone else run into this? Is there a way I can recreate the ejbTimer database?
Here is are the error messages from server.log:
#|2007-06-08T15:48:54.548-0400|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=10;_ThreadName=main;Connection could not be allocated because: Failed to start database '/usr/local/glassfish/domains/domain1/lib/databases/ejbtimer', see the next exception for details.;_RequestID=1404096f-0e55-44fb-8f89-4e1d62fa721b;|RAR5117 : Failed to obtain/create connection. Reason : Connection could not be allocated because: Failed to start database '/usr/local/glassfish/domains/domain1/lib/databases/ejbtimer', see the next exception for details.|#]
[#|2007-06-08T15:48:54.549-0400|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=10;_ThreadName=main;Error in allocating a connection. Cause: Connection could not be allocated because: Failed to start database '/usr/local/glassfish/domains/domain1/lib/databases/ejbtimer', see the next exception for details.;_RequestID=1404096f-0e55-44fb-8f89-4e1d62fa721b;|RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not be allocated because: Failed to start database '/usr/local/glassfish/domains/domain1/lib/databases/ejbtimer', see the next exception for details.]|#]
[#|2007-06-08T15:48:54.551-0400|WARNING|sun-appserver9.1|javax.enterprise.resource.jdo.persistencemanager|_ThreadID=10;_ThreadName=main;_RequestID=1404096f-0e55-44fb-8f89-4e1d62fa721b;|JDO76520: Errors while obtaining information about the database. Got the following exception:
java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Failed to start database '/usr/local/glassfish/domains/domain1/lib/databases/ejbtimer', see the next exception for details.
at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:102)
at com.sun.jdo.spi.persistence.support.sqlstore.ejb.TransactionHelperImpl.getConnection(TransactionHelperImpl.java:199)
at com.sun.jdo.spi.persistence.support.sqlstore.ejb.EJBHelper.getConnection(EJBHelper.java:184)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory.getConnection(SQLPersistenceManagerFactory.java:910)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory.initializeSQLStoreManager(SQLPersistenceManagerFactory.java:875)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory.getFromPool(SQLPersistenceManagerFactory.java:804)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory.getPersistenceManager(SQLPersistenceManagerFactory.java:691)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerFactoryImpl.getPersistenceManager(PersistenceManagerFactoryImpl.java:867)
at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerFactoryImpl.getPersistenceManager(PersistenceManagerFactoryImpl.java:699)
at com.sun.ejb.containers.TimerBean_2100919770_ConcreteImpl.jdoGetPersistenceManager(TimerBean_2100919770_ConcreteImpl.java:1230)
at com.sun.ejb.containers.TimerBean_2100919770_ConcreteImpl.ejbSelectTimerIdsByContainerAndState(TimerBean_2100919770_ConcreteImpl.java:830)
at com.sun.ejb.containers.TimerBean.ejbHomeSelectActiveTimerIdsByContainer(TimerBean.java:579)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1055)
at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:163)
at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2846)
at com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:229)
at $Proxy20.selectActiveTimerIdsByContainer(Unknown Source)
at com.sun.ejb.containers.EJBTimerService.getTimerIds(EJBTimerService.java:1125)
at com.sun.ejb.containers.EJBTimerServiceWrapper.getTimers(EJBTimerServiceWrapper.java:191)
at edu.harvard.hmdc.vdcnet.harvest.HarvesterServiceBean.createHarvestTimer(HarvesterServiceBean.java:121)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1055)
at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:163)
at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2846)
at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3930)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:184)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:70)
at $Proxy85.createHarvestTimer(Unknown Source)
at edu.harvard.hmdc.vdcnet.util.VDCContextListener.contextInitialized(VDCContextListener.java:34)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4493)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:5150)
at com.sun.enterprise.web.WebModule.start(WebModule.java:308)
at com.sun.enterprise.web.LifecycleStarter.doRun(LifecycleStarter.java:45)
at com.sun.appserv.management.util.misc.RunnableBase.runSync(RunnableBase.java:283)
at com.sun.appserv.management.util.misc.RunnableBase._submit(RunnableBase.java:155)
at com.sun.appserv.management.util.misc.RunnableBase.submit(RunnableBase.java:171)
at com.sun.enterprise.web.VirtualServer.startChildren(VirtualServer.java:1566)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1218)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:938)
at com.sun.enterprise.web.LifecycleStarter.doRun(LifecycleStarter.java:45)
at com.sun.appserv.management.util.misc.RunnableBase.runSync(RunnableBase.java:283)
at com.sun.appserv.management.util.misc.RunnableBase._submit(RunnableBase.java:155)
at com.sun.appserv.management.util.misc.RunnableBase.submit(RunnableBase.java:171)
at com.sun.enterprise.web.EmbeddedWebContainer$WebEngine.startChildren(EmbeddedWebContainer.java:440)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1218)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:520)
at org.apache.catalina.startup.Embedded.start(Embedded.java:923)
at com.sun.enterprise.web.WebContainer.start(WebContainer.java:852)
at com.sun.enterprise.web.PEWebContainer.startInstance(PEWebContainer.java:750)
at com.sun.enterprise.web.PEWebContainerLifecycle.onStartup(PEWebContainerLifecycle.java:71)
at com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:332)
at com.sun.enterprise.server.ondemand.OnDemandServer.onStartup(OnDemandServer.java:112)
at com.sun.enterprise.server.PEMain.run(PEMain.java:381)
at com.sun.enterprise.server.PEMain.main(PEMain.java:308)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.server.PELaunch.main(PELaunch.java:274)
Thanks,
Ellen
[Message sent by forum member 'ekraffmiller' (ekraffmiller)]
http://forums.java.net/jive/thread.jspa?messageID=221303