guestAT

Untitled

Sep 28th, 2020
843
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2020-09-28_16:27:54.517 [main] INFO  c.g.flyway.core.command.DbMigrate [] - Current version of schema "public": 00760
  2. 2020-09-28_16:27:54.521 [main] INFO  c.g.flyway.core.command.DbMigrate [] - Migrating schema "public" to version 00761
  3. 2020-09-28_16:27:54.562 [main] ERROR c.g.flyway.core.command.DbMigrate [] - Migration of schema "public" to version 00761 failed! Changes successfully rolled back.
  4. 2020-09-28_16:27:54.621 [main] ERROR o.s.web.context.ContextLoader [] - Context initialization failed
  5. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor#0': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbMigrationManager' defined in URL [jar:file:/opt/tomcat6/webapps/cpgu/WEB-INF/lib/cpgu-model-1.0-SNAPSHOT.jar!/META-INF/spring/cpgu-model-app-context.xml]: Invocation of init method failed; nested exception is com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 1: ALTER TABLE cpgu_payment
  6.     ADD COLUMN pre_check_required BOOLEAN DEFAULT FALSE
  7.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:527) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  8.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  9.         at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  10.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  11.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  12.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  13.  
  14.         at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:733) ~[spring-context-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  15.         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:454) ~[spring-context-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  16.         at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383) ~[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  17.         at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) ~[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  18.         at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) [spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  19.         at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) [catalina.jar:6.0.44]
  20.         at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) [catalina.jar:6.0.44]
  21.         at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) [catalina.jar:6.0.44]
  22.         at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) [catalina.jar:6.0.44]
  23.         at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) [catalina.jar:6.0.44]
  24.         at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:944) [catalina.jar:6.0.44]
  25.         at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:779) [catalina.jar:6.0.44]
  26.         at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:505) [catalina.jar:6.0.44]
  27.         at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1322) [catalina.jar:6.0.44]
  28.         at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:325) [catalina.jar:6.0.44]
  29.         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) [catalina.jar:6.0.44]
  30.         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) [catalina.jar:6.0.44]
  31.         at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) [catalina.jar:6.0.44]
  32.         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) [catalina.jar:6.0.44]
  33.         at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) [catalina.jar:6.0.44]
  34.         at org.apache.catalina.core.StandardService.start(StandardService.java:525) [catalina.jar:6.0.44]
  35.         at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) [catalina.jar:6.0.44]
  36.         at org.apache.catalina.startup.Catalina.start(Catalina.java:595) [catalina.jar:6.0.44]
  37.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172]
  38.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172]
  39.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172]
  40.         at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172]
  41.         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) [bootstrap.jar:6.0.44]
  42.         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) [bootstrap.jar:6.0.44]
  43. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbMigrationManager' defined in URL [jar:file:/opt/tomcat6/webapps/cpgu/WEB-INF/lib/cpgu-model-1.0-SNAPSHOT.jar!/META-INF/spring/cpgu-model-app-context.xml]: Invocation of init method failed; nested exception is com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 1: ALTER TABLE cpgu_payment
  44.     ADD COLUMN pre_check_required BOOLEAN DEFAULT FALSE
  45.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  46.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  47.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  48.         at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  49.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  50.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  51.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  52.  
  53.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:284) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  54.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  55.  
  56.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:420) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  57.         at org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:277) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  58.         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.detectPersistenceExceptionTranslators(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  59.         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.<init>(PersistenceExceptionTranslationInterceptor.java:79) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  60.         at org.springframework.dao.annotation.PersistenceExceptionTranslationAdvisor.<init>(PersistenceExceptionTranslationAdvisor.java:70) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  61.         at org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor.setBeanFactory(PersistenceExceptionTranslationPostProcessor.java:103) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
  62.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1475) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  63.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1443) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  64.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  65.         ... 34 common frames omitted
  66. Caused by: com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 1: ALTER TABLE cpgu_payment
  67.     ADD COLUMN pre_check_required BOOLEAN DEFAULT FALSE
  68.         at com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:92) ~[flyway-core-2.3.1.jar:na]
  69.         at com.googlecode.flyway.core.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:72) ~[flyway-core-2.3.1.jar:na]
  70.         at com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:243) ~[flyway-core-2.3.1.jar:na]
  71.         at com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:241) ~[flyway-core-2.3.1.jar:na]
  72.         at com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[flyway-core-2.3.1.jar:na]
  73.         at com.googlecode.flyway.core.command.DbMigrate.applyMigration(DbMigrate.java:241) ~[flyway-core-2.3.1.jar:na]
  74.         at com.googlecode.flyway.core.command.DbMigrate.access$700(DbMigrate.java:44) ~[flyway-core-2.3.1.jar:na]
  75.         at com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:186) ~[flyway-core-2.3.1.jar:na]
  76.         at com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:135) ~[flyway-core-2.3.1.jar:na]
  77.         at com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[flyway-core-2.3.1.jar:na]
  78.         at com.googlecode.flyway.core.command.DbMigrate.migrate(DbMigrate.java:135) ~[flyway-core-2.3.1.jar:na]
  79.         at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:872) ~[flyway-core-2.3.1.jar:na]
  80.         at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:819) ~[flyway-core-2.3.1.jar:na]
  81.         at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1200) ~[flyway-core-2.3.1.jar:na]
  82.         at com.googlecode.flyway.core.Flyway.migrate(Flyway.java:819) ~[flyway-core-2.3.1.jar:na]
  83.         at com.sc.cpgu.configuration.DbMigrationManager.manageMigrations(DbMigrationManager.java:32) ~[cpgu-model-1.0-SNAPSHOT.jar:na]
  84.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172]
  85.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172]
  86.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172]
  87.         at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172]
  88.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1581) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  89.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1522) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  90.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
  91.         ... 51 common frames omitted
  92. Caused by: org.postgresql.util.PSQLException: ERROR: column "pre_check_required" of relation "cpgu_payment" already exists
  93.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  94.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  95.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  96.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  97.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  98.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) ~[postgresql-9.1-901-1.jdbc4.jar:na]
  99.         at com.googlecode.flyway.core.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:230) ~[flyway-core-2.3.1.jar:na]
  100.         at com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:90) ~[flyway-core-2.3.1.jar:na]
  101.         ... 73 common frames omitted
RAW Paste Data