API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 31st, 2020
229
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 48.89 KB | None | 0 0
raw download clone embed print report
  1.  
  2. 2020-03-31 16:58:49 Apache Commons Daemon procrun stdout initialized.
  3. * INFO 2020-03-31 16:59:16,742 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
  4. * INFO 2020-03-31 16:59:16,750 Environment variable DHIS2_HOME points to C:\DHIS2 (DefaultLocationManager.java [localhost-startStop-1])
  5. * INFO 2020-03-31 16:59:16,797 File C:\DHIS2\dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
  6. * INFO 2020-03-31 16:59:16,798 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
  7. * INFO 2020-03-31 16:59:16,803 File C:\DHIS2\dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
  8. * INFO 2020-03-31 16:59:16,803 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
  9. * INFO 2020-03-31 16:59:25,385 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
  10. * INFO 2020-03-31 16:59:25,386 Environment variable DHIS2_HOME points to C:\DHIS2 (DefaultLocationManager.java [localhost-startStop-1])
  11. * INFO 2020-03-31 16:59:25,418 File C:\DHIS2\dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
  12. * INFO 2020-03-31 16:59:25,419 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
  13. * INFO 2020-03-31 16:59:25,420 File C:\DHIS2\dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
  14. * INFO 2020-03-31 16:59:25,420 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
  15. * INFO 2020-03-31 16:59:32,355 Hibernate configuration loaded: dialect: 'org.hisp.dhis.hibernate.dialect.DhisPostgresDialect', region factory: 'org.hibernate.cache.ehcache.EhCacheRegionFactory', connection pool max size: 80 (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
  16. * WARN 2020-03-31 16:59:34,922 DB: column "capturecoordinates" of relation "program" already exists, skipping (SQL State: 42701 - Error Code: 0) (Slf4jLog.java [localhost-startStop-1])
  17. * ERROR 2020-03-31 16:59:55,177 Migration of schema "public" to version 2.32.10 - Use bigint for id columns failed! Changes successfully rolled back. (Slf4jLog.java [localhost-startStop-1])
  18. * WARN 2020-03-31 16:59:55,185 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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-acl-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-schema-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  19. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  20. --------------------------------------------------------
  21. SQL State : 53200
  22. Error Code : 0
  23. Message : ERROR: out of shared memory
  24. Hint: You might need to increase max_locks_per_transaction.
  25. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  26. Line : 725
  27. Statement : alter table smscommands alter column smscommandid type bigint
  28. (AbstractApplicationContext.java [localhost-startStop-1])
  29. * ERROR 2020-03-31 16:59:55,204 Context initialization failed (ContextLoader.java [localhost-startStop-1])
  30. org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.hisp.dhis.security.acl.AclService' defined in URL [jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-acl-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-schema-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  31. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  32. --------------------------------------------------------
  33. SQL State : 53200
  34. Error Code : 0
  35. Message : ERROR: out of shared memory
  36. Hint: You might need to increase max_locks_per_transaction.
  37. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  38. Line : 725
  39. Statement : alter table smscommands alter column smscommandid type bigint
  40.  
  41. at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
  42. at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
  43. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1198)
  44. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1100)
  45. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
  46. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
  47. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
  48. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  49. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
  50. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
  51. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
  52. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
  53. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
  54. at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
  55. at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
  56. at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
  57. at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
  58. at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
  59. at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
  60. at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
  61. at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
  62. at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
  63. at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:970)
  64. at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1841)
  65. at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  66. at java.util.concurrent.FutureTask.run(Unknown Source)
  67. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  68. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  69. at java.lang.Thread.run(Unknown Source)
  70. Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.hisp.dhis.schema.SchemaService' defined in URL [jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-schema-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  71. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  72. --------------------------------------------------------
  73. SQL State : 53200
  74. Error Code : 0
  75. Message : ERROR: out of shared memory
  76. Hint: You might need to increase max_locks_per_transaction.
  77. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  78. Line : 725
  79. Statement : alter table smscommands alter column smscommandid type bigint
  80.  
  81. at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
  82. at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
  83. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1198)
  84. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1100)
  85. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
  86. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
  87. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
  88. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  89. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
  90. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  91. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
  92. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
  93. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
  94. at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
  95. at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
  96. ... 28 more
  97. 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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  98. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  99. --------------------------------------------------------
  100. SQL State : 53200
  101. Error Code : 0
  102. Message : ERROR: out of shared memory
  103. Hint: You might need to increase max_locks_per_transaction.
  104. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  105. Line : 725
  106. Statement : alter table smscommands alter column smscommandid type bigint
  107.  
  108. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:586)
  109. at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
  110. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:364)
  111. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1269)
  112. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551)
  113. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
  114. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
  115. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  116. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
  117. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  118. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
  119. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
  120. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
  121. at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
  122. at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
  123. ... 42 more
  124. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in URL [jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  125. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  126. --------------------------------------------------------
  127. SQL State : 53200
  128. Error Code : 0
  129. Message : ERROR: out of shared memory
  130. Hint: You might need to increase max_locks_per_transaction.
  131. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  132. Line : 725
  133. Statement : alter table smscommands alter column smscommandid type bigint
  134.  
  135. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1631)
  136. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
  137. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
  138. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
  139. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  140. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
  141. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
  142. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297)
  143. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  144. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
  145. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
  146. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
  147. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:583)
  148. ... 56 more
  149. Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  150. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  151. --------------------------------------------------------
  152. SQL State : 53200
  153. Error Code : 0
  154. Message : ERROR: out of shared memory
  155. Hint: You might need to increase max_locks_per_transaction.
  156. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  157. Line : 725
  158. Statement : alter table smscommands alter column smscommandid type bigint
  159.  
  160. at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:369)
  161. at org.flywaydb.core.internal.command.DbMigrate.access$200(DbMigrate.java:54)
  162. at org.flywaydb.core.internal.command.DbMigrate$3.call(DbMigrate.java:282)
  163. at org.flywaydb.core.internal.jdbc.TransactionTemplate.execute(TransactionTemplate.java:74)
  164. at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:279)
  165. at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:244)
  166. at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:157)
  167. at org.flywaydb.core.internal.command.DbMigrate.access$000(DbMigrate.java:54)
  168. at org.flywaydb.core.internal.command.DbMigrate$1.call(DbMigrate.java:133)
  169. at org.flywaydb.core.internal.command.DbMigrate$1.call(DbMigrate.java:130)
  170. at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:71)
  171. at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:94)
  172. at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:139)
  173. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:130)
  174. at org.flywaydb.core.Flyway$1.execute(Flyway.java:189)
  175. at org.flywaydb.core.Flyway$1.execute(Flyway.java:149)
  176. at org.flywaydb.core.Flyway.execute(Flyway.java:511)
  177. at org.flywaydb.core.Flyway.migrate(Flyway.java:149)
  178. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  179. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  180. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  181. at java.lang.reflect.Method.invoke(Unknown Source)
  182. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1760)
  183. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1697)
  184. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1627)
  185. ... 68 more
  186. Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
  187. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  188. --------------------------------------------------------
  189. SQL State : 53200
  190. Error Code : 0
  191. Message : ERROR: out of shared memory
  192. Hint: You might need to increase max_locks_per_transaction.
  193. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  194. Line : 725
  195. Statement : alter table smscommands alter column smscommandid type bigint
  196.  
  197. at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:274)
  198. at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:220)
  199. at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:127)
  200. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:70)
  201. at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:366)
  202. ... 92 more
  203. Caused by: org.postgresql.util.PSQLException: ERROR: out of shared memory
  204. Hint: You might need to increase max_locks_per_transaction.
  205. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
  206. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
  207. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
  208. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
  209. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
  210. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
  211. at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
  212. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
  213. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
  214. at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
  215. at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:244)
  216. at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111)
  217. at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:208)
  218. ... 95 more
  219. * INFO 2020-03-31 16:59:55,271 De-registering jdbc driver: org.postgresql.Driver@31878980 (StartupListener.java [localhost-startStop-1])
  220.  
  221. 2020-03-31 17:13:06 Apache Commons Daemon procrun stdout initialized.
  222. * INFO 2020-03-31 17:13:32,560 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
  223. * INFO 2020-03-31 17:13:32,566 Environment variable DHIS2_HOME points to C:\DHIS2 (DefaultLocationManager.java [localhost-startStop-1])
  224. * INFO 2020-03-31 17:13:32,615 File C:\DHIS2\dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
  225. * INFO 2020-03-31 17:13:32,615 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
  226. * INFO 2020-03-31 17:13:32,615 File C:\DHIS2\dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
  227. * INFO 2020-03-31 17:13:32,615 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
  228. * INFO 2020-03-31 17:13:40,955 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
  229. * INFO 2020-03-31 17:13:40,956 Environment variable DHIS2_HOME points to C:\DHIS2 (DefaultLocationManager.java [localhost-startStop-1])
  230. * INFO 2020-03-31 17:13:40,993 File C:\DHIS2\dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
  231. * INFO 2020-03-31 17:13:40,993 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
  232. * INFO 2020-03-31 17:13:40,994 File C:\DHIS2\dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
  233. * INFO 2020-03-31 17:13:40,994 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
  234. * INFO 2020-03-31 17:13:48,267 Hibernate configuration loaded: dialect: 'org.hisp.dhis.hibernate.dialect.DhisPostgresDialect', region factory: 'org.hibernate.cache.ehcache.EhCacheRegionFactory', connection pool max size: 80 (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
  235. * WARN 2020-03-31 17:13:51,155 DB: column "capturecoordinates" of relation "program" already exists, skipping (SQL State: 42701 - Error Code: 0) (Slf4jLog.java [localhost-startStop-1])
  236. * ERROR 2020-03-31 17:14:11,994 Migration of schema "public" to version 2.32.10 - Use bigint for id columns failed! Changes successfully rolled back. (Slf4jLog.java [localhost-startStop-1])
  237. * WARN 2020-03-31 17:14:12,001 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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-acl-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-schema-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  238. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  239. --------------------------------------------------------
  240. SQL State : 53200
  241. Error Code : 0
  242. Message : ERROR: out of shared memory
  243. Hint: You might need to increase max_locks_per_transaction.
  244. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  245. Line : 725
  246. Statement : alter table smscommands alter column smscommandid type bigint
  247. (AbstractApplicationContext.java [localhost-startStop-1])
  248. * ERROR 2020-03-31 17:14:12,015 Context initialization failed (ContextLoader.java [localhost-startStop-1])
  249. org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.hisp.dhis.security.acl.AclService' defined in URL [jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-acl-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-schema-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  250. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  251. --------------------------------------------------------
  252. SQL State : 53200
  253. Error Code : 0
  254. Message : ERROR: out of shared memory
  255. Hint: You might need to increase max_locks_per_transaction.
  256. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  257. Line : 725
  258. Statement : alter table smscommands alter column smscommandid type bigint
  259.  
  260. at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
  261. at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
  262. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1198)
  263. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1100)
  264. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
  265. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
  266. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
  267. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  268. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
  269. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
  270. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
  271. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
  272. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
  273. at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443)
  274. at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325)
  275. at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
  276. at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
  277. at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
  278. at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
  279. at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
  280. at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
  281. at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
  282. at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:970)
  283. at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1841)
  284. at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  285. at java.util.concurrent.FutureTask.run(Unknown Source)
  286. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  287. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  288. at java.lang.Thread.run(Unknown Source)
  289. Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.hisp.dhis.schema.SchemaService' defined in URL [jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-service-schema-2.32.4.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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  290. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  291. --------------------------------------------------------
  292. SQL State : 53200
  293. Error Code : 0
  294. Message : ERROR: out of shared memory
  295. Hint: You might need to increase max_locks_per_transaction.
  296. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  297. Line : 725
  298. Statement : alter table smscommands alter column smscommandid type bigint
  299.  
  300. at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
  301. at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
  302. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1198)
  303. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1100)
  304. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
  305. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
  306. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
  307. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  308. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
  309. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  310. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
  311. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
  312. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
  313. at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
  314. at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
  315. ... 28 more
  316. 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:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  317. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  318. --------------------------------------------------------
  319. SQL State : 53200
  320. Error Code : 0
  321. Message : ERROR: out of shared memory
  322. Hint: You might need to increase max_locks_per_transaction.
  323. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  324. Line : 725
  325. Statement : alter table smscommands alter column smscommandid type bigint
  326.  
  327. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:586)
  328. at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
  329. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:364)
  330. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1269)
  331. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:551)
  332. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
  333. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
  334. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  335. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
  336. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  337. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
  338. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
  339. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
  340. at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
  341. at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
  342. ... 42 more
  343. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flyway' defined in URL [jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%208.5/webapps/dhis/WEB-INF/lib/dhis-support-db-migration-2.32.4.jar!/META-INF/dhis/beans.xml]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  344. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  345. --------------------------------------------------------
  346. SQL State : 53200
  347. Error Code : 0
  348. Message : ERROR: out of shared memory
  349. Hint: You might need to increase max_locks_per_transaction.
  350. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  351. Line : 725
  352. Statement : alter table smscommands alter column smscommandid type bigint
  353.  
  354. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1631)
  355. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
  356. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)
  357. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)
  358. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  359. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
  360. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
  361. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297)
  362. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
  363. at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
  364. at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1136)
  365. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1064)
  366. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:583)
  367. ... 56 more
  368. Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
  369. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  370. --------------------------------------------------------
  371. SQL State : 53200
  372. Error Code : 0
  373. Message : ERROR: out of shared memory
  374. Hint: You might need to increase max_locks_per_transaction.
  375. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  376. Line : 725
  377. Statement : alter table smscommands alter column smscommandid type bigint
  378.  
  379. at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:369)
  380. at org.flywaydb.core.internal.command.DbMigrate.access$200(DbMigrate.java:54)
  381. at org.flywaydb.core.internal.command.DbMigrate$3.call(DbMigrate.java:282)
  382. at org.flywaydb.core.internal.jdbc.TransactionTemplate.execute(TransactionTemplate.java:74)
  383. at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:279)
  384. at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:244)
  385. at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:157)
  386. at org.flywaydb.core.internal.command.DbMigrate.access$000(DbMigrate.java:54)
  387. at org.flywaydb.core.internal.command.DbMigrate$1.call(DbMigrate.java:133)
  388. at org.flywaydb.core.internal.command.DbMigrate$1.call(DbMigrate.java:130)
  389. at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:71)
  390. at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:94)
  391. at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:139)
  392. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:130)
  393. at org.flywaydb.core.Flyway$1.execute(Flyway.java:189)
  394. at org.flywaydb.core.Flyway$1.execute(Flyway.java:149)
  395. at org.flywaydb.core.Flyway.execute(Flyway.java:511)
  396. at org.flywaydb.core.Flyway.migrate(Flyway.java:149)
  397. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  398. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  399. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  400. at java.lang.reflect.Method.invoke(Unknown Source)
  401. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1760)
  402. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1697)
  403. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1627)
  404. ... 68 more
  405. Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
  406. Migration V2_32_10__Use_bigint_for_id_columns.sql failed
  407. --------------------------------------------------------
  408. SQL State : 53200
  409. Error Code : 0
  410. Message : ERROR: out of shared memory
  411. Hint: You might need to increase max_locks_per_transaction.
  412. Location : org/hisp/dhis/db/migration/2.32/V2_32_10__Use_bigint_for_id_columns.sql (C:\Program Files\Apache Software Foundation\Tomcat 8.5\file:\C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\dhis\WEB-INF\lib\dhis-support-db-migration-2.32.4.jar!\org\hisp\dhis\db\migration\2.32\V2_32_10__Use_bigint_for_id_columns.sql)
  413. Line : 725
  414. Statement : alter table smscommands alter column smscommandid type bigint
  415.  
  416. at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:274)
  417. at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:220)
  418. at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:127)
  419. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:70)
  420. at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:366)
  421. ... 92 more
  422. Caused by: org.postgresql.util.PSQLException: ERROR: out of shared memory
  423. Hint: You might need to increase max_locks_per_transaction.
  424. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
  425. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
  426. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
  427. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
  428. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
  429. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
  430. at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
  431. at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
  432. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
  433. at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
  434. at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:244)
  435. at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111)
  436. at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:208)
  437. ... 95 more
  438. * INFO 2020-03-31 17:14:12,075 De-registering jdbc driver: org.postgresql.Driver@556fe98c (StartupListener.java [localhost-startStop-1])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!