Re: Apache Lenya 2.02 with Cocoon 2.1 and Tomcat 6.0

Tue, 31 Mar 2009 07:21:09 -0700 

It seem that Cocoon does not launch because of the following error:

 Couldn't clean volatile data: Table not found in statement [SELECT
 TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE IS_VOLATILE = ?]
 [See nested exception: java.sql.SQLException: Table not found in
 statement [SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE
 IS_VOLATILE = ?]]]

It might be that your database configuration is incorrect?

Regards,

Jeroen


Andrew Mullaney wrote:

Hi guys,
I have strictly followed the instruction on http://lenya.apache.org/docu20/installation20/install20.html for the set up with lenya.
When I start my tomcat server, I get the following error when checking http://localhost:8080/lenya/ : 



  Initialization Problem

Message: null

Description: No details available.

Sender: org.apache.cocoon.servlet.CocoonServlet

Source: Cocoon Servlet

cause

Failure occured during job recovery.

request-uri

/lenya/

Apache Cocoon 2.1.11 <http://cocoon.apache.org/>
I have rooted through the TOMCAT_HOME_DIR\ webapps\lenya\WEB-INF\logs, to uncover the following stack trace with cocoon:
2009-03-31 13:45:18,500 [main] ERROR core.manager - Caught an exception trying to initialize the component handler.
org.apache.avalon.framework.configuration.ConfigurationException: cannot create a quartz scheduler
at org.apache.cocoon.components.cron.QuartzJobScheduler.initialize(QuartzJobScheduler.java:309)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:297)
at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:108)
at org.apache.avalon.excalibur.component.ExcaliburComponentManager.initialize(ExcaliburComponentManager.java:524)
at org.apache.cocoon.components.CocoonComponentManager.initialize(CocoonComponentManager.java:583)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244) 

                at org.apache.cocoon.Cocoon.initialize(Cocoon.java:345)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
at org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1429)
at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:499)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:992)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4371)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 

                at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table not found in statement [SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE IS_VOLATILE = ?] [See nested exception: java.sql.SQLException: Table not found in statement [SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE IS_VOLATILE = ?]]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)
at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)
at org.quartz.impl.DirectSchedulerFactory.createScheduler(DirectSchedulerFactory.java:325)
at org.quartz.impl.DirectSchedulerFactory.createScheduler(DirectSchedulerFactory.java:269)
at org.apache.cocoon.components.cron.QuartzJobScheduler.initialize(QuartzJobScheduler.java:305) 

                ... 36 more

2009-03-31 13:45:18,515 [main] ERROR access - Exception reloading
org.apache.avalon.framework.configuration.ConfigurationException: cannot create a quartz scheduler
at org.apache.cocoon.components.cron.QuartzJobScheduler.initialize(QuartzJobScheduler.java:309)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:297)
at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:108)
at org.apache.avalon.excalibur.component.ExcaliburComponentManager.initialize(ExcaliburComponentManager.java:524)
at org.apache.cocoon.components.CocoonComponentManager.initialize(CocoonComponentManager.java:583)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244) 

                at org.apache.cocoon.Cocoon.initialize(Cocoon.java:345)
at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244)
at org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1429)
at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:499)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:992)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4371)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 

                at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table not found in statement [SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE IS_VOLATILE = ?] [See nested exception: java.sql.SQLException: Table not found in statement [SELECT TRIGGER_NAME, TRIGGER_GROUP FROM QRTZ_TRIGGERS WHERE IS_VOLATILE = ?]]]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493)
at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)
at org.quartz.impl.DirectSchedulerFactory.createScheduler(DirectSchedulerFactory.java:325)
at org.quartz.impl.DirectSchedulerFactory.createScheduler(DirectSchedulerFactory.java:269)
at org.apache.cocoon.components.cron.QuartzJobScheduler.initialize(QuartzJobScheduler.java:305) 

                ... 36 more
Does anyone know what this is? I have been hammering at this for ages and have exhausted all options!! Any help would be greatly appreciated! 


Thanks,


Andrew



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to