dhis2-devs team mailing list archive

Thread
Date
Re: Ubuntu troubles

To: Knut Staring <knutst@xxxxxxxxx>
From: Jo Størset <storset@xxxxxxxxx>
Date: Fri, 9 Sep 2011 18:22:34 +0200
Cc: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAL=8=Nhv+s+3DJar=+fhO+UZaSULrCbtuo=+gj4wTkZ5wLVnRQ@mail.gmail.com>
Wild guess... hibernate.hbm2ddl.auto = update?

Jo

Den 9. sep. 2011 kl. 17.25 skrev Knut Staring:

> Hi everyone,
> 
> Trying to start DHIS2 on Ubuntu against an empty DHIS2 database, we get the following complaints about missing dhis2.systemsetting table. 
> 
> Any hints? 
> 
> Knut
> 
> ---------- Forwarded message ----------
> From: Jose Garcia Muñoz <josemp10@xxxxxxxxx>
> Date: 2011/9/9
> Subject: 
> To: knutst@xxxxxxxxx
> 
> 
> * INFO  17:19:50,505 Environment variable DHIS2_HOME points to /home/jose/dhis2/DHIS2_HOME (DefaultLocationManager.java [Thread-2])
> * WARN  17:20:19,569 SQL Error: 1146, SQLState: 42S02 (JDBCExceptionReporter.java [Thread-2])
> * ERROR 17:20:19,570 Table 'dhis2.systemsetting' doesn't exist (JDBCExceptionReporter.java [Thread-2])
> * ERROR 17:20:19,684 Context initialization failed (ContextLoader.java [Thread-2])
> org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.hisp.dhis.scheduling.SchedulingManager' defined in URL [jar:file:/usr/local/apache-tomcat-7.0.8/webapps/dhis/WEB-INF/lib/dhis-service-reporting-2.3.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
>     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
>     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
>     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
>     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
>     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
>     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
>     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
>     at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
>     at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
>     at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
>     at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
>     at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
>     at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
>     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
>     at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
>     at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
>     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:662)
> 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:2536)
>     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.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
>     at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGenericStore.java:159)
>     at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGenericStore.java:219)
>     at org.hisp.dhis.options.setting.DefaultSystemSettingManager.getSystemSetting(DefaultSystemSettingManager.java:106)
>     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:309)
>     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.invoke(TransactionInterceptor.java:110)
>     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
>     at $Proxy30.getSystemSetting(Unknown Source)
>     at org.hisp.dhis.scheduling.DefaultSchedulingManager.getRunnables(DefaultSchedulingManager.java:122)
>     at org.hisp.dhis.scheduling.DefaultSchedulingManager.scheduleTasks(DefaultSchedulingManager.java:77)
>     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:1544)
>     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1485)
>     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
>     ... 20 more
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dhis2.systemsetting' doesn't exist
>     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>     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:406)
>     at com.mysql.jdbc.Util.getInstance(Util.java:381)
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
>     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
>     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
>     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
>     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
>     at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
>     at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
>     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:2533)
>     ... 49 more
> 09-sep-2011 17:20:19 org.apache.catalina.core.StandardContext startInternal
> GRAVE: Error listenerStart
> 09-sep-2011 17:20:19 org.apache.catalina.core.StandardContext startInternal
> GRAVE: Falló en arranque del Contexto [/dhis] debido a errores previos
> 09-sep-2011 17:20:19 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
> GRAVE: La aplicación web [/dhis] registró el conductor JDBC [com.mysql.jdbc.Driver] pero falló al anular el registro mientras la aplicación web estaba parada. Para prevenir un fallo de memoria, se ha anulado el registro del conductor JDBC por la fuerza.
> 09-sep-2011 17:20:19 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
> GRAVE: La aplicación web [/dhis] parece haber arrancado un hilo llamado [MySQL Statement Cancellation Timer] pero no ha podido pararlo. Esto tiene todas las papeletas de convertirse en un fallo de memoria.
> 
> 
> 
> 
> -- 
> Knut Staring
> Department of Informatics
> University of Oslo
> http://hisp.uio.no
> +4722952249
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
Follow ups

Re: Ubuntu troubles
From: Morten Olav Hansen, 2011-09-10
References

Ubuntu troubles
From: Knut Staring, 2011-09-09