dhis2-users team mailing list archive

[Gautam Morey <gautam@xxxxxxxxxxx>]

Hi,

Due to a out-of-memory crash, we are trying to get our hosted instance back
on track using the same dhis.conf and other configuration that was working
before the crash. However, we are against the wall with the following error
not allowing tomcat to deploy the war.  The longer version of the output
log is placed at https://pastebin.com/kwF7Lj0b

The final termination error is pasted below.

* INFO  2018-07-09 14:32:49,364 Executing startup routine [2 of 15,
runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java
[localhost-s
tartStop-1])
* WARN  2018-07-09 14:32:49,369 SQL Warning Code: 0, SQLState: 00000
(SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,369 parse S_3: ROLLBACK
(SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,369 SQL Warning Code: 0, SQLState: 00000
(SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 StartTransactionCommand
(SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000
(SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 bind <unnamed> to S_3
(SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000
(SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 ProcessUtility (SqlExceptionHelper.java
[localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000
(SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 CommitTransactionCommand
(SqlExceptionHelper.java [localhost-startStop-1])
* ERROR 2018-07-09 14:32:49,372 org.hibernate.WrongClassException: Object
[id=678182] was not of the specified subclass
[org.hisp.dhis.period.PeriodType] : Discriminator: BiWeekly
        at org.hibernate.loader.Loader.getInstanceClass(Loader.java:1816)
        at
org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627)
        at org.hibernate.loader.Loader.getRow(Loader.java:1556)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:740)
        at org.hibernate.loader.Loader.processResultSet(Loader.java:985)
        at org.hibernate.loader.Loader.doQuery(Loader.java:943)
        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
        at org.hibernate.loader.Loader.doList(Loader.java:2615)
        at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2460)
        at org.hibernate.loader.Loader.list(Loader.java:2422)
        at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
        at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1896)
        at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:366)
        at
org.hisp.dhis.period.hibernate.HibernatePeriodStore.getAllPeriodTypes(HibernatePeriodStore.java:228)
        at
org.hisp.dhis.period.PeriodTypePopulator.executeInTransaction(PeriodTypePopulator.java:66)
        at
org.hisp.dhis.system.startup.TransactionContextStartupRoutine$1.doInTransaction(TransactionContextStartupRoutine.java:57)
        at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
        at
org.hisp.dhis.system.startup.TransactionContextStartupRoutine.execute(TransactionContextStartupRoutine.java:52)
        at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:113)
        at
org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:70)
        at
org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
        at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
        at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
        at
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
        at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
:
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
        at
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
        at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:748)
 (StartupListener.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:49,422 De-registering jdbc driver:
org.postgresql.Driver@25a564f1 (StartupListener.java
[localhost-startStop-1])

What could we be doing wrong? We have tried to also use the db by making a
clean setup but the problem persists. Is there any corruption with the db?
Thanks in advance.

- Gautam