Issue to Upgrade from 2.31 to 2.32

Mithilesh_Kumar_Thak · 23 May 2019 12:32

Dear Team,
While upgrading from 2.31 to 2.32 i am facing following issue
I also increased the shared memory size and increase max_locks_per_transaction up to 1024 and i am working on window

WARN 2019-05-23 17:56:44,876 Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.security.acl.AclService’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-service-acl-2.32.0.jar!/META-INF/dhis/beans.xml]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.schema.SchemaService’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-service-schema-2.32.0.jar!/META-INF/dhis/beans.xml]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.schema.PropertyIntrospectorService’: Unsatisfied dependency expressed through field ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-support-db-migration-2.32.0.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed

SQL State : 53200
Error Code : 0
Message : ERROR: out of shared memory
Hint: You might need to increase max_locks_per_transaction.
Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\apache-tomcat-7.0.86\bin\file:\C:\apache-tomcat-7.0.86\webapps\dhis232\WEB-INF\lib\dhis-support-db-migration-2.32.0.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
Line : 800
Statement : alter table userinfo alter column userinfoid type bigint
(AbstractApplicationContext.java [localhost-startStop-1])

ERROR 2019-05-23 17:56:44,884 Context initialization failed (ContextLoader.java [localhost-startStop-1])
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.security.acl.AclService’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-service-acl-2.32.0.jar!/META-INF/dhis/beans.xml]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.schema.SchemaService’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-service-schema-2.32.0.jar!/META-INF/dhis/beans.xml]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.schema.PropertyIntrospectorService’: Unsatisfied dependency expressed through field ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-support-db-migration-2.32.0.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed

SQL State : 53200
Error Code : 0
Message : ERROR: out of shared memory
Hint: You might need to increase max_locks_per_transaction.
Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\apache-tomcat-7.0.86\bin\file:\C:\apache-tomcat-7.0.86\webapps\dhis232\WEB-INF\lib\dhis-support-db-migration-2.32.0.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
Line : 800
Statement : alter table userinfo alter column userinfoid type bigint

    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1198)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1100)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5141)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5664)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:1017)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:993)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1127)
    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:2020)
    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:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.schema.SchemaService’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-service-schema-2.32.0.jar!/META-INF/dhis/beans.xml]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.schema.PropertyIntrospectorService’: Unsatisfied dependency expressed through field ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-support-db-migration-2.32.0.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed

SQL State : 53200
Error Code : 0
Message : ERROR: out of shared memory
Hint: You might need to increase max_locks_per_transaction.
Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\apache-tomcat-7.0.86\bin\file:\C:\apache-tomcat-7.0.86\webapps\dhis232\WEB-INF\lib\dhis-support-db-migration-2.32.0.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
Line : 800
Statement : alter table userinfo alter column userinfoid type bigint

    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1198)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1100)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
    at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
    ... 28 more

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.hisp.dhis.schema.PropertyIntrospectorService’: Unsatisfied dependency expressed through field ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-support-db-migration-2.32.0.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed

SQL State : 53200
Error Code : 0
Message : ERROR: out of shared memory
Hint: You might need to increase max_locks_per_transaction.
Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\apache-tomcat-7.0.86\bin\file:\C:\apache-tomcat-7.0.86\webapps\dhis232\WEB-INF\lib\dhis-support-db-migration-2.32.0.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
Line : 800
Statement : alter table userinfo alter column userinfoid type bigint

    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:586)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:364)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1269)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
    at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
    ... 42 more

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘flyway’ defined in URL [jar:file:/C:/apache-tomcat-7.0.86/webapps/dhis232/WEB-INF/lib/dhis-support-db-migration-2.32.0.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed

SQL State : 53200
Error Code : 0
Message : ERROR: out of shared memory
Hint: You might need to increase max_locks_per_transaction.
Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\apache-tomcat-7.0.86\bin\file:\C:\apache-tomcat-7.0.86\webapps\dhis232\WEB-INF\lib\dhis-support-db-migration-2.32.0.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
Line : 800
Statement : alter table userinfo alter column userinfoid type bigint

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1631)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:583)
    ... 56 more

Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed

SQL State : 53200
Error Code : 0
Message : ERROR: out of shared memory
** Hint: You might need to increase max_locks_per_transaction.**
Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\apache-tomcat-7.0.86\bin\file:\C:\apache-tomcat-7.0.86\webapps\dhis232\WEB-INF\lib\dhis-support-db-migration-2.32.0.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
Line : 800
Statement : alter table userinfo alter column userinfoid type bigint

    at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:370)
    at org.flywaydb.core.internal.command.DbMigrate.access$200(DbMigrate.java:54)
    at org.flywaydb.core.internal.command.DbMigrate$3.call(DbMigrate.java:284)
    at org.flywaydb.core.internal.jdbc.TransactionTemplate.execute(TransactionTemplate.java:74)
    at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:281)
    at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:246)
    at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:159)
    at org.flywaydb.core.internal.command.DbMigrate.access$000(DbMigrate.java:54)
    at org.flywaydb.core.internal.command.DbMigrate$1.call(DbMigrate.java:135)
    at org.flywaydb.core.internal.command.DbMigrate$1.call(DbMigrate.java:132)
    at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:71)
    at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:104)
    at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:155)
    at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:132)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:1288)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:1249)
    at org.flywaydb.core.Flyway.execute(Flyway.java:1604)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:1249)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1760)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1697)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1627)
    ... 68 more

Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed

SQL State : 53200
Error Code : 0
Message : ERROR: out of shared memory
Hint: You might need to increase max_locks_per_transaction.
Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\apache-tomcat-7.0.86\bin\file:\C:\apache-tomcat-7.0.86\webapps\dhis232\WEB-INF\lib\dhis-support-db-migration-2.32.0.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
Line : 800
Statement : alter table userinfo alter column userinfoid type bigint

    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:249)
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:202)
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:125)
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:77)
    at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:367)
    ... 92 more

Caused by: org.postgresql.util.PSQLException: ERROR: out of shared memory
Hint: You might need to increase max_locks_per_transaction.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:235)
at org.flywaydb.core.internal.sqlscript.StandardSqlStatement.execute(StandardSqlStatement.java:42)
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:189)
… 95 more
May 23, 2019 5:56:44 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: One or more listeners failed to start. Full details will be found in the appropriate container log file
May 23, 2019 5:56:44 PM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/dhis232] startup failed due to previous errors

INFO 2019-05-23 17:56:45,066 De-registering jdbc driver: org.postgresql.Driver@57c95dca (StartupListener.java [localhost-startStop-1])
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive C:\apache-tomcat-7.0.86\webapps\dhis232.war has finished in 494,656 ms
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\apache-tomcat-7.0.86\webapps\docs
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\apache-tomcat-7.0.86\webapps\docs has finished in 71 ms
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\apache-tomcat-7.0.86\webapps\examples
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\apache-tomcat-7.0.86\webapps\examples has finished in 262 ms
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\apache-tomcat-7.0.86\webapps\host-manager
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\apache-tomcat-7.0.86\webapps\host-manager has finished in 220 ms
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\apache-tomcat-7.0.86\webapps\manager
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\apache-tomcat-7.0.86\webapps\manager has finished in 63 ms
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\apache-tomcat-7.0.86\webapps\ROOT
May 23, 2019 5:56:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\apache-tomcat-7.0.86\webapps\ROOT has finished in 51 ms
May 23, 2019 5:56:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-apr-8090”]
May 23, 2019 5:56:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-apr-8009”]
May 23, 2019 5:56:45 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 495442 ms

Please help

Thanks and Regards

Mithilesh Kumar Thakur

Ameen · 24 May 2019 13:04

@Mithilesh_Kumar_Thak Just to confirm, did you restart the postgresql server after you made the config changes in postgres.conf ? Only then the changes will take effect.

Mithilesh_Kumar_Thak · 24 May 2019 16:31

Dear @Ameen yes i restart the PostgreSQL and also restart the server and PC but still facing the issue.
After that i run the SQL script manually and restart the server now its working.

thanks

Ameen · 24 May 2019 17:27

Running scripts manually can lead to unintended consequences. Certainly not to be done in production instances.
The 2.32 upgrade is a major database upgrade which takes about 7-10 minutes on a db of size similar to demo dbs.
We need to set the max_locks_per_transaction to atleast 100 in postgres.conf and restart the postgres server for the change to take effect and then deploy 2.32war.

To confirm whether a conf change has taken effect, after pg server restart you can execute

select setting,pending_restart from pg_settings where name= 'max_locks_per_transaction';

The setting column should be the new setting value you changed to (100 in this case), and pending_restart column should have a value of false.

Mithilesh_Kumar_Thak · 25 May 2019 03:57

Dear @Ameen,
Yes i run the script select setting,pending_restart from pg_settings where name= 'max_locks_per_transaction'; and i also set the limit up to 1024 but i still facing same so i run the sql-script manually

thanks for your kind information.

Ameen · 25 May 2019 12:48

Hi @Mithilesh_Kumar_Thak Which specific script did you execute manually? Just curious. Thanks!

christos · 1 April 2020 20:45

Hey there @Ameen, I am installing the server on my macbook today and faced the same issue.

I have installed all the required software and followed the instructions on how to install it from here.

Dear @Mithilesh_Kumar_Thak how did you solve the issue?

@Ameen any ideas why this might be coming up on a fresh setup? Thanks!

Mithilesh_Kumar_Thak · 2 April 2020 02:04

Dear christos,

I resolved the issues what issue actually you got plese give details

christos · 2 April 2020 06:31

The problem I had was that:

after installing all the dependencies the server need in order to run and
after building the server by running the script in /dhis2-core/dhis-2 by executing ./build.sh
I would then navigate in the dhis2-core/dhis-2/dhis-web/dhis-web-portal where I would then run
mvn jetty:run-war

There I would get the same errors as you described.
I figured out that to solve the error I had to follow the instruction on the PostgreSQL performance tuning. The issue is now solved.

Thanks @Mithilesh_Kumar_Thak for the willingness to help.

Issue to Upgrade from 2.31 to 2.32

Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V2_32_10__Use_bigint_for_id_columns.sql failed

Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException: Migration V2_32_10__Use_bigint_for_id_columns.sql failed

Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed

Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Migration V2_32_10__Use_bigint_for_id_columns.sql failed