[Building Sakai] Unkown lesson_builder_properties table in trunk

Daniel Merino daniel.merino at unavarra.es
Tue Jun 18 04:37:17 PDT 2013 

Hi everybody.

I'm trying to install latest trunk with autoddl turned on and tomcat 
launches an error in log related to a Lessons table named 
"lesson_builder_properties".

I can't find info about this table in google. Neither it is included in 
any SQL script of lessonbuilder/hbm/src/ddl/mysql

I paste Tomcat's log:

2013-06-18 13:30:15,718  WARN pool-2-thread-1 
org.hibernate.util.JDBCExceptionReporter - SQL Error: 1146, SQLState: 42S02
2013-06-18 13:30:15,718 ERROR pool-2-thread-1 
org.hibernate.util.JDBCExceptionReporter - Table 
'sakai29x_dev.lesson_builder_properties' doesn't exist
2013-06-18 13:30:15,727 ERROR pool-2-thread-1 
org.springframework.web.context.ContextLoader - Context initialization 
failed
org.springframework.beans.factory.BeanCreationException: Error creating 
bean with name 
'org.sakaiproject.lessonbuildertool.service.LessonBuilderAccessService' 
defined in ServletContext resource [/WEB-INF/applicationContext.xml]: 
Invocation of init method failed; nested exception is 
org.springframework.dao.InvalidDataAccessResourceUsageException: could 
not execute query; SQL [select this_.id as id64_0_, this_.attribute as 
attribute64_0_, this_.value as value64_0_ from lesson_builder_properties 
this_ where this_.attribute=?]; nested exception is 
org.hibernate.exception.SQLGrammarException: could not execute query
         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1482)
         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
         at 
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
         at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
         at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
         at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
         at 
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:626)
         at 
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
         at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
         at 
org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389)
         at 
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294)
         at 
org.sakaiproject.component.impl.ContextLoader.initWebApplicationContext(ContextLoader.java:64)
         at 
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
         at 
org.sakaiproject.util.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:56)
         at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4779)
         at 
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5273)
         at 
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
         at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
         at 
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
         at 
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
         at 
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:962)
         at 
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1603)
         at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
         at 
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
         at java.util.concurrent.FutureTask.run(FutureTask.java:138)
         at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
         at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
         at java.lang.Thread.run(Thread.java:619)
Caused by: 
org.springframework.dao.InvalidDataAccessResourceUsageException: could 
not execute query; SQL [select this_.id as id64_0_, this_.attribute as 
attribute64_0_, this_.value as value64_0_ from lesson_builder_properties 
this_ where this_.attribute=?]; nested exception is 
org.hibernate.exception.SQLGrammarException: could not execute query
         at 
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635)
         at 
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
         at 
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
         at 
org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
         at 
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046)
         at 
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039)
         at 
org.sakaiproject.lessonbuildertool.model.SimplePageToolDaoImpl.findProperty(SimplePageToolDaoImpl.java:280)
         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:597)
         at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
         at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
         at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
         at 
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
         at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
         at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
         at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
         at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
         at $Proxy44.findProperty(Unknown Source)
         at 
org.sakaiproject.lessonbuildertool.service.LessonBuilderAccessService.init(LessonBuilderAccessService.java:227)
         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:597)
         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1608)
         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1549)
         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1479)
         ... 28 more
Caused by: org.hibernate.exception.SQLGrammarException: could not 
execute query
         at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
         at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
         at org.hibernate.loader.Loader.doList(Loader.java:2545)
         at 
org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2319)
         at org.hibernate.loader.Loader.list(Loader.java:2268)
         at 
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
         at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
         at 
org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056)
         at 
org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1046)
         at 
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
         ... 53 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
Table 'sakai29x_dev.lesson_builder_properties' doesn't exist
         at 
sun.reflect.GeneratedConstructorAccessor59.newInstance(Unknown Source)
         at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
         at com.mysql.jdbc.Util.getInstance(Util.java:386)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
         at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
         at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310)
         at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
         at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
         at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
         at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
         at org.hibernate.loader.Loader.doQuery(Loader.java:802)
         at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
         at org.hibernate.loader.Loader.doList(Loader.java:2542)
         ... 61 more
18-jun-2013 13:30:15 org.apache.catalina.core.StandardContext startInternal
GRAVE: Error listenerStart
18-jun-2013 13:30:15 org.apache.catalina.core.StandardContext startInternal
GRAVE: Falló en arranque del Contexto [/lessonbuilder-tool] debido a 
errores previos
java.lang.Exception: traceback
         at 
org.sakaiproject.util.NoisierDefaultListableBeanFactory.destroySingletons(NoisierDefaultListableBeanFactory.java:94)
         at 
org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1090)
         at 
org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1064)
         at 
org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1010)
         at 
org.sakaiproject.component.impl.SpringCompMgr.close(SpringCompMgr.java:302)
         at 
org.sakaiproject.component.impl.SpringCompMgr.removeChildAc(SpringCompMgr.java:374)
         at 
org.sakaiproject.util.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:72)
         at 
org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4819)
         at 
org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5466)
         at 
org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:232)
         at 
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:160)
         at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
         at 
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
         at 
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
         at 
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:962)
         at 
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1603)
         at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
         at 
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
         at java.util.concurrent.FutureTask.run(FutureTask.java:138)
         at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
         at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
         at java.lang.Thread.run(Thread.java:619)

Please, could somebody help me?
Thanks.
-- 
Daniel Merino Echeverría
daniel.merino at unavarra.es
Gestor de teleformación - Centro Superior de Innovación Educativa.
Tfno: 948-168489 - Universidad Pública de Navarra.
--
Aquellos que pueden, hacen ciencia. Los que no pueden, cotorrean sobre 
su metodología. (Paul Samuelson)

More information about the sakai-dev mailing list