· 4 years ago · Jun 03, 2021, 05:04 AM
12021-06-03_11:51:54.533 [main] INFO c.s.c.c.DbMigrationManager [] - Trying to migrate the database schema if needed
22021-06-03_11:51:54.916 [main] INFO c.g.flyway.core.command.DbMigrate [] - Current version of schema "public": 00066
32021-06-03_11:51:54.917 [main] INFO c.g.flyway.core.command.DbMigrate [] - Migrating schema "public" to version 00067
42021-06-03_11:51:57.512 [main] ERROR c.g.flyway.core.command.DbMigrate [] - Migration of schema "public" to version 00067 failed! Changes successfully rolled back.
52021-06-03_11:51:59.004 [main] ERROR o.s.web.context.ContextLoader [] - Context initialization failed
6org.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: CREATE TABLE soc_inform_tech_request
7(
8 id BIGSERIAL PRIMARY KEY,
9 uuid VARCHAR(64) NOT NULL,
10 conversation_id VARCHAR(255) DEFAULT NULL,
11 status VARCHAR(24) NOT NULL,
12 adapter_status VARCHAR(64) DEFAULT NULL,
13 gd_message_id BIGINT REFERENCES gd_message (id),
14 service_code VARCHAR(255) DEFAULT NULL,
15 create_timestamp TIMESTAMP DEFAULT NOW(),
16 start_ping_timestamp TIMESTAMP DEFAULT NULL,
17 last_try_ping_timestamp TIMESTAMP DEFAULT NULL,
18 next_try_ping_timestamp TIMESTAMP DEFAULT NULL,
19 attempts INT DEFAULT 0,
20 max_attempts INT DEFAULT 100 NOT NULL,
21 response TEXT DEFAULT NULL,
22 err_msg TEXT DEFAULT NULL,
23 comment TEXT DEFAULT NULL
24)
25 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:527) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
26 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
27 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
28 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
29 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
30 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
31 at org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:733) ~[spring-context-3.1.2.RELEASE.jar:3.1.2.RELEASE]
32 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:454) ~[spring-context-3.1.2.RELEASE.jar:3.1.2.RELEASE]
33 at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383) ~[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
34 at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) ~[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
35 at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) [spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
36 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) [catalina.jar:6.0.44]
37 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) [catalina.jar:6.0.44]
38 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:802) [catalina.jar:6.0.44]
39 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) [catalina.jar:6.0.44]
40 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) [catalina.jar:6.0.44]
41 at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:944) [catalina.jar:6.0.44]
42 at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:779) [catalina.jar:6.0.44]
43 at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:505) [catalina.jar:6.0.44]
44 at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1322) [catalina.jar:6.0.44]
45 at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:325) [catalina.jar:6.0.44]
46 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) [catalina.jar:6.0.44]
47 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1068) [catalina.jar:6.0.44]
48 at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) [catalina.jar:6.0.44]
49 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1060) [catalina.jar:6.0.44]
50 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) [catalina.jar:6.0.44]
51 at org.apache.catalina.core.StandardService.start(StandardService.java:525) [catalina.jar:6.0.44]
52 at org.apache.catalina.core.StandardServer.start(StandardServer.java:759) [catalina.jar:6.0.44]
53 at org.apache.catalina.startup.Catalina.start(Catalina.java:595) [catalina.jar:6.0.44]
54 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_211]
55 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_211]
56 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]
57 at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]
58 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) [bootstrap.jar:6.0.44]
59 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) [bootstrap.jar:6.0.44]
60Caused 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: CREATE TABLE soc_inform_tech_request
61(
62 id BIGSERIAL PRIMARY KEY,
63 uuid VARCHAR(64) NOT NULL,
64 conversation_id VARCHAR(255) DEFAULT NULL,
65 status VARCHAR(24) NOT NULL,
66 adapter_status VARCHAR(64) DEFAULT NULL,
67 gd_message_id BIGINT REFERENCES gd_message (id),
68 service_code VARCHAR(255) DEFAULT NULL,
69 create_timestamp TIMESTAMP DEFAULT NOW(),
70 start_ping_timestamp TIMESTAMP DEFAULT NULL,
71 last_try_ping_timestamp TIMESTAMP DEFAULT NULL,
72 next_try_ping_timestamp TIMESTAMP DEFAULT NULL,
73 attempts INT DEFAULT 0,
74 max_attempts INT DEFAULT 100 NOT NULL,
75 response TEXT DEFAULT NULL,
76 err_msg TEXT DEFAULT NULL,
77 comment TEXT DEFAULT NULL
78)
79 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
80 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
81 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
82 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
83 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
84 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
85 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
86 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:284) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
87 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
88 at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:420) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
89 at org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:277) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
90 at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.detectPersistenceExceptionTranslators(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
91 at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.<init>(PersistenceExceptionTranslationInterceptor.java:79) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
92 at org.springframework.dao.annotation.PersistenceExceptionTranslationAdvisor.<init>(PersistenceExceptionTranslationAdvisor.java:70) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
93 at org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor.setBeanFactory(PersistenceExceptionTranslationPostProcessor.java:103) ~[spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE]
94 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1475) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
95 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1443) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
96 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
97 ... 34 common frames omitted
98Caused by: com.googlecode.flyway.core.command.FlywaySqlScriptException: Error executing statement at line 1: CREATE TABLE soc_inform_tech_request
99(
100 id BIGSERIAL PRIMARY KEY,
101 uuid VARCHAR(64) NOT NULL,
102 conversation_id VARCHAR(255) DEFAULT NULL,
103 status VARCHAR(24) NOT NULL,
104 adapter_status VARCHAR(64) DEFAULT NULL,
105 gd_message_id BIGINT REFERENCES gd_message (id),
106 service_code VARCHAR(255) DEFAULT NULL,
107 create_timestamp TIMESTAMP DEFAULT NOW(),
108 start_ping_timestamp TIMESTAMP DEFAULT NULL,
109 last_try_ping_timestamp TIMESTAMP DEFAULT NULL,
110 next_try_ping_timestamp TIMESTAMP DEFAULT NULL,
111 attempts INT DEFAULT 0,
112 max_attempts INT DEFAULT 100 NOT NULL,
113 response TEXT DEFAULT NULL,
114 err_msg TEXT DEFAULT NULL,
115 comment TEXT DEFAULT NULL
116)
117 at com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:92) ~[flyway-core-2.3.1.jar:na]
118 at com.googlecode.flyway.core.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:72) ~[flyway-core-2.3.1.jar:na]
119 at com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:243) ~[flyway-core-2.3.1.jar:na]
120 at com.googlecode.flyway.core.command.DbMigrate$2.doInTransaction(DbMigrate.java:241) ~[flyway-core-2.3.1.jar:na]
121 at com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[flyway-core-2.3.1.jar:na]
122 at com.googlecode.flyway.core.command.DbMigrate.applyMigration(DbMigrate.java:241) ~[flyway-core-2.3.1.jar:na]
123 at com.googlecode.flyway.core.command.DbMigrate.access$700(DbMigrate.java:44) ~[flyway-core-2.3.1.jar:na]
124 at com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:186) ~[flyway-core-2.3.1.jar:na]
125 at com.googlecode.flyway.core.command.DbMigrate$1.doInTransaction(DbMigrate.java:135) ~[flyway-core-2.3.1.jar:na]
126 at com.googlecode.flyway.core.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) ~[flyway-core-2.3.1.jar:na]
127 at com.googlecode.flyway.core.command.DbMigrate.migrate(DbMigrate.java:135) ~[flyway-core-2.3.1.jar:na]
128 at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:872) ~[flyway-core-2.3.1.jar:na]
129 at com.googlecode.flyway.core.Flyway$1.execute(Flyway.java:819) ~[flyway-core-2.3.1.jar:na]
130 at com.googlecode.flyway.core.Flyway.execute(Flyway.java:1200) ~[flyway-core-2.3.1.jar:na]
131 at com.googlecode.flyway.core.Flyway.migrate(Flyway.java:819) ~[flyway-core-2.3.1.jar:na]
132 at com.sc.cpgu.configuration.DbMigrationManager.manageMigrations(DbMigrationManager.java:32) ~[cpgu-model-1.0-SNAPSHOT.jar:na]
133 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_211]
134 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_211]
135 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]
136 at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]
137 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1581) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
138 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1522) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
139 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452) ~[spring-beans-3.1.3.RELEASE.jar:3.1.3.RELEASE]
140 ... 51 common frames omitted
141Caused by: org.postgresql.util.PSQLException: ERROR: relation "soc_inform_tech_request" already exists
142 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) ~[postgresql-9.1-901-1.jdbc4.jar:na]
143 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql-9.1-901-1.jdbc4.jar:na]
144 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.1-901-1.jdbc4.jar:na]
145 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[postgresql-9.1-901-1.jdbc4.jar:na]
146 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) ~[postgresql-9.1-901-1.jdbc4.jar:na]
147 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) ~[postgresql-9.1-901-1.jdbc4.jar:na]
148 at com.googlecode.flyway.core.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:230) ~[flyway-core-2.3.1.jar:na]
149 at com.googlecode.flyway.core.dbsupport.SqlScript.execute(SqlScript.java:90) ~[flyway-core-2.3.1.jar:na]
150 ... 73 common frames omitted
151