Hi Ellen,
Something might have gone wrong with the embedded derby database used by
timer service
(/usr/local/glassfish/domains/domain1/lib/databases/ejbtimer). You will
have nested exception in the log (just below this exception) that will
give you more details about what actually went wrong. Please correct the
issue and everything should be fine.
Regards,
Mitesh
glassfish_at_javadesktop.org wrote:
> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>