· 5 years ago · Aug 12, 2020, 01:16 PM
12020-08-12 16:09:27.122 ERROR 2352 --- [ main] o.f.core.internal.command.DbMigrate : Migration of schema "lingvo_Aleksey_Matveyev" to version 1 - init scheme failed! Changes successfully rolled back.
22020-08-12 16:09:27.164 WARN 2352 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
3Migration V1__init_scheme.sql failed
4------------------------------------
5SQL State : 3F000
6Error Code : 0
7Message : ERROR: no schema has been selected to create in
8 Position: 28
9Location : db/migration/V1__init_scheme.sql (C:\Users\Aleksey.Matveyev\IdeaProjects\lingvo\lingvo-backend\target\classes\db\migration\V1__init_scheme.sql)
10Line : 1
11Statement : create table if not exists task
12(
13 id uuid not null
14 constraint task_pkey primary key,
15 created_date timestamp not null,
16 created_by text not null
17)
18
192020-08-12 16:09:27.165 INFO 2352 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'applicationTaskExecutor'
202020-08-12 16:09:27.166 INFO 2352 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
212020-08-12 16:09:27.204 INFO 2352 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
222020-08-12 16:09:27.206 INFO 2352 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
232020-08-12 16:09:27.215 INFO 2352 --- [ main] ConditionEvaluationReportLoggingListener :
24
25Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
262020-08-12 16:09:27.223 ERROR 2352 --- [ main] o.s.boot.SpringApplication : Application run failed
27
28org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
29Migration V1__init_scheme.sql failed
30------------------------------------
31SQL State : 3F000
32Error Code : 0
33Message : ERROR: no schema has been selected to create in
34 Position: 28
35Location : db/migration/V1__init_scheme.sql (C:\Users\Aleksey.Matveyev\IdeaProjects\lingvo\lingvo-backend\target\classes\db\migration\V1__init_scheme.sql)
36Line : 1
37Statement : create table if not exists task
38(
39 id uuid not null
40 constraint task_pkey primary key,
41 created_date timestamp not null,
42 created_by text not null
43)
44
45 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
46 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
47 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
48 at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
49 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
50 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
51 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
52 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
53 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
54 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:895) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
55 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
56 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.2.6.RELEASE.jar:5.2.6.RELEASE]
57 at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
58 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
59 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
60 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
61 at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
62 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
63 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.3.0.RELEASE.jar:2.3.0.RELEASE]
64 at ru.gpn.common.Application.main(Application.java:18) ~[classes/:na]
65Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
66Migration V1__init_scheme.sql failed
67------------------------------------
68SQL State : 3F000
69Error Code : 0
70Message : ERROR: no schema has been selected to create in
71 Position: 28
72Location : db/migration/V1__init_scheme.sql (C:\Users\Aleksey.Matveyev\IdeaProjects\lingvo\lingvo-backend\target\classes\db\migration\V1__init_scheme.sql)
73Line : 1
74Statement : create table if not exists task
75(
76 id uuid not null
77 constraint task_pkey primary key,
78 created_date timestamp not null,
79 created_by text not null
80)
81
82 at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:369) ~[flyway-core-6.4.1.jar:na]
83 at org.flywaydb.core.internal.command.DbMigrate.access$200(DbMigrate.java:54) ~[flyway-core-6.4.1.jar:na]
84 at org.flywaydb.core.internal.command.DbMigrate$3.call(DbMigrate.java:282) ~[flyway-core-6.4.1.jar:na]
85 at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:66) ~[flyway-core-6.4.1.jar:na]
86 at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:279) ~[flyway-core-6.4.1.jar:na]
87 at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:244) ~[flyway-core-6.4.1.jar:na]
88 at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:54) ~[flyway-core-6.4.1.jar:na]
89 at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:162) ~[flyway-core-6.4.1.jar:na]
90 at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:159) ~[flyway-core-6.4.1.jar:na]
91 at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:71) ~[flyway-core-6.4.1.jar:na]
92 at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) ~[flyway-core-6.4.1.jar:na]
93 at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:140) ~[flyway-core-6.4.1.jar:na]
94 at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:159) ~[flyway-core-6.4.1.jar:na]
95 at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:137) ~[flyway-core-6.4.1.jar:na]
96 at org.flywaydb.core.Flyway$1.execute(Flyway.java:199) ~[flyway-core-6.4.1.jar:na]
97 at org.flywaydb.core.Flyway$1.execute(Flyway.java:159) ~[flyway-core-6.4.1.jar:na]
98 at org.flywaydb.core.Flyway.execute(Flyway.java:530) ~[flyway-core-6.4.1.jar:na]
99 at org.flywaydb.core.Flyway.migrate(Flyway.java:159) ~[flyway-core-6.4.1.jar:na]
100 at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:65) ~[spring-boot-autoconfigure-2.3.0.RELEASE.jar:2.3.0.RELEASE]
101 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
102 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792) ~[spring-beans-5.2.6.RELEASE.jar:5.2.6.RELEASE]
103 ... 19 common frames omitted
104Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
105Migration V1__init_scheme.sql failed
106------------------------------------
107SQL State : 3F000
108Error Code : 0
109Message : ERROR: no schema has been selected to create in
110 Position: 28
111Location : db/migration/V1__init_scheme.sql (C:\Users\Aleksey.Matveyev\IdeaProjects\lingvo\lingvo-backend\target\classes\db\migration\V1__init_scheme.sql)
112Line : 1
113Statement : create table if not exists task
114(
115 id uuid not null
116 constraint task_pkey primary key,
117 created_date timestamp not null,
118 created_by text not null
119)
120
121 at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:274) ~[flyway-core-6.4.1.jar:na]
122 at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:220) ~[flyway-core-6.4.1.jar:na]
123 at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:127) ~[flyway-core-6.4.1.jar:na]
124 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:88) ~[flyway-core-6.4.1.jar:na]
125 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.access$000(SqlMigrationExecutor.java:33) ~[flyway-core-6.4.1.jar:na]
126 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor$1.call(SqlMigrationExecutor.java:77) ~[flyway-core-6.4.1.jar:na]
127 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor$1.call(SqlMigrationExecutor.java:74) ~[flyway-core-6.4.1.jar:na]
128 at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:28) ~[flyway-core-6.4.1.jar:na]
129 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:74) ~[flyway-core-6.4.1.jar:na]
130 at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:366) ~[flyway-core-6.4.1.jar:na]
131 ... 39 common frames omitted
132Caused by: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
133 Position: 28
134 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2533) ~[postgresql-42.2.12.jar:42.2.12]
135 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2268) ~[postgresql-42.2.12.jar:42.2.12]
136 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:313) ~[postgresql-42.2.12.jar:42.2.12]
137 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) ~[postgresql-42.2.12.jar:42.2.12]
138 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) ~[postgresql-42.2.12.jar:42.2.12]
139 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310) ~[postgresql-42.2.12.jar:42.2.12]
140 at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296) ~[postgresql-42.2.12.jar:42.2.12]
141 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273) ~[postgresql-42.2.12.jar:42.2.12]
142 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268) ~[postgresql-42.2.12.jar:42.2.12]
143 at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95) ~[HikariCP-3.4.5.jar:na]
144 at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-3.4.5.jar:na]
145 at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:244) ~[flyway-core-6.4.1.jar:na]
146 at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111) ~[flyway-core-6.4.1.jar:na]
147 at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:208) ~[flyway-core-6.4.1.jar:na]
148 ... 47 common frames omitted
149
150Disconnected from the target VM, address: '127.0.0.1:55213', transport: 'socket'
151
152Process finished with exit code 1