· 8 years ago · Nov 29, 2017, 05:56 PM
120:52:05.462 [INFO ] ontextBootstrapper:319 - Neither @ContextConfiguration nor @ContextHierarchy found for test class [ru.edu.portfolio.unit.remote.CertificateControllerTest], using SpringBootContextLoader
220:52:05.510 [INFO ] tractContextLoader:264 - Could not detect default resource locations for test class [ru.edu.portfolio.unit.remote.CertificateControllerTest]: no resource found for suffixes {-context.xml, Context.groovy}.
320:52:05.521 [INFO ] ContextLoaderUtils:81 - Could not detect default configuration classes for test class [ru.edu.portfolio.unit.remote.CertificateControllerTest]: CertificateControllerTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
420:52:06.388 [INFO ] ontextBootstrapper:206 - Found @SpringBootConfiguration ru.edu.portfolio.unit.remote.TestsConfiguration for test class ru.edu.portfolio.unit.remote.CertificateControllerTest
520:52:06.424 [INFO ] ontextBootstrapper:260 - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener, org.springframework.security.test.context.support.WithSecurityContextTestExecutionListener]
620:52:06.668 [INFO ] ontextBootstrapper:187 - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@6069db50, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@4efbca5a, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@1b7cc17c, org.springframework.test.context.support.DirtiesContextTestExecutionListener@59662a0b, org.springframework.test.context.transaction.TransactionalTestExecutionListener@77fbd92c, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@67c27493, org.springframework.security.test.context.support.WithSecurityContextTestExecutionListener@1a482e36, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@72967906, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@5b8dfcc1, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@2f9f7dcf, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@747ddf94, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@35e2d654, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@1bd4fdd]
7
8 . ____ _ __ _ _
9 /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
10( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
11 \\/ ___)| |_)| | | | | || (_| | ) ) ) )
12 ' |____| .__|_| |_|_| |_\__, | / / / /
13 =========|_|==============|___/=/_/_/_/
14 :: Spring Boot :: (v1.5.6.RELEASE)
15
1620:52:10.279 [INFO ] StartupInfoLogger:48 - Starting CertificateControllerTest on Max with PID 8117 (started by max in /home/max/IdeaProjects/portal)
1720:52:10.282 [INFO ] SpringApplication:593 - No active profile set, falling back to default profiles: default
1820:52:10.510 [INFO ] ApplicationContext:583 - Refreshing org.springframework.web.context.support.GenericWebApplicationContext@6e535154: startup date [Wed Nov 29 20:52:10 MSK 2017]; root of context hierarchy
1920:52:22.263 [INFO ] Version:30 - HV000001: Hibernate Validator 5.3.5.Final
2020:52:28.019 [INFO ] Slf4jLog:44 - Flyway 3.2.1 by Boxfuse
2120:52:28.626 [INFO ] Slf4jLog:44 - Database: jdbc:h2:mem:AZ (H2 1.4)
2220:52:28.828 [INFO ] Slf4jLog:44 - Validated 6 migrations (execution time 00:00.090s)
2320:52:28.876 [INFO ] Slf4jLog:44 - Creating Metadata table: "PUBLIC"."schema_version"
2420:52:28.940 [INFO ] Slf4jLog:44 - Current version of schema "PUBLIC": << Empty Schema >>
2520:52:28.941 [INFO ] Slf4jLog:44 - Migrating schema "PUBLIC" to version 1 - init
2620:52:29.061 [ERROR] Slf4jLog:52 - Migration of schema "PUBLIC" to version 1 failed! Please restore backups and roll back database and code!
2720:52:29.097 [WARN ] ApplicationContext:551 - 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.dbsupport.FlywaySqlScriptException:
28Migration V1__init.sql failed
29-----------------------------
30SQL State : 42001
31Error Code : 42001
32Message : СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
33 ID BIGINT NOT NULL,
34 BODY CHARACTER VARYING(3000),
35 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
36 MESSAGE_READ BOOLEAN,
37 SUBJECT CHARACTER VARYING(255),
38 RECEIVER_ID BIGINT NOT NULL,
39 SENDER_ID BIGINT NOT NULL
40) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
41Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
42 ID BIGINT NOT NULL,
43 BODY CHARACTER VARYING(3000),
44 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
45 MESSAGE_READ BOOLEAN,
46 SUBJECT CHARACTER VARYING(255),
47 RECEIVER_ID BIGINT NOT NULL,
48 SENDER_ID BIGINT NOT NULL
49) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
50CREATE TABLE IF NOT EXISTS message (
51 id BIGINT NOT NULL,
52 body CHARACTER VARYING(3000),
53 message_date TIMESTAMP WITHOUT TIME ZONE,
54 message_read BOOLEAN,
55 subject CHARACTER VARYING(255),
56 receiver_id BIGINT NOT NULL,
57 sender_id BIGINT NOT NULL
58) [42001-196]
59Location : db/migration/V1__init.sql (/home/max/IdeaProjects/portal/target/classes/db/migration/V1__init.sql)
60Line : 115
61Statement : CREATE TABLE IF NOT EXISTS message (
62 id BIGINT NOT NULL,
63 body CHARACTER VARYING(3000),
64 message_date TIMESTAMP WITHOUT TIME ZONE,
65 message_read BOOLEAN,
66 subject CHARACTER VARYING(255),
67 receiver_id BIGINT NOT NULL,
68 sender_id BIGINT NOT NULL
69)
70
7120:52:29.214 [ERROR] SpringApplication:771 - Application startup failed
72org.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.dbsupport.FlywaySqlScriptException:
73Migration V1__init.sql failed
74-----------------------------
75SQL State : 42001
76Error Code : 42001
77Message : СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
78 ID BIGINT NOT NULL,
79 BODY CHARACTER VARYING(3000),
80 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
81 MESSAGE_READ BOOLEAN,
82 SUBJECT CHARACTER VARYING(255),
83 RECEIVER_ID BIGINT NOT NULL,
84 SENDER_ID BIGINT NOT NULL
85) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
86Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
87 ID BIGINT NOT NULL,
88 BODY CHARACTER VARYING(3000),
89 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
90 MESSAGE_READ BOOLEAN,
91 SUBJECT CHARACTER VARYING(255),
92 RECEIVER_ID BIGINT NOT NULL,
93 SENDER_ID BIGINT NOT NULL
94) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
95CREATE TABLE IF NOT EXISTS message (
96 id BIGINT NOT NULL,
97 body CHARACTER VARYING(3000),
98 message_date TIMESTAMP WITHOUT TIME ZONE,
99 message_read BOOLEAN,
100 subject CHARACTER VARYING(255),
101 receiver_id BIGINT NOT NULL,
102 sender_id BIGINT NOT NULL
103) [42001-196]
104Location : db/migration/V1__init.sql (/home/max/IdeaProjects/portal/target/classes/db/migration/V1__init.sql)
105Line : 115
106Statement : CREATE TABLE IF NOT EXISTS message (
107 id BIGINT NOT NULL,
108 body CHARACTER VARYING(3000),
109 message_date TIMESTAMP WITHOUT TIME ZONE,
110 message_read BOOLEAN,
111 subject CHARACTER VARYING(255),
112 receiver_id BIGINT NOT NULL,
113 sender_id BIGINT NOT NULL
114)
115
116 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628)
117 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
118 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
119 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
120 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
121 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
122 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
123 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:296)
124 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
125 at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1078)
126 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:857)
127 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
128 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693)
129 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360)
130 at org.springframework.boot.SpringApplication.run(SpringApplication.java:303)
131 at org.springframework.boot.test.context.SpringBootContextLoader.loadContext(SpringBootContextLoader.java:120)
132 at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98)
133 at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116)
134 at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83)
135 at org.springframework.test.context.web.ServletTestExecutionListener.setUpRequestContextIfNecessary(ServletTestExecutionListener.java:189)
136 at org.springframework.test.context.web.ServletTestExecutionListener.prepareTestInstance(ServletTestExecutionListener.java:131)
137 at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230)
138 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228)
139 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287)
140 at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
141 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289)
142 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247)
143 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
144 at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
145 at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
146 at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
147 at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
148 at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
149 at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
150 at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
151 at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
152 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
153 at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
154 at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
155 at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
156 at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
157 at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
158Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
159Migration V1__init.sql failed
160-----------------------------
161SQL State : 42001
162Error Code : 42001
163Message : СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
164 ID BIGINT NOT NULL,
165 BODY CHARACTER VARYING(3000),
166 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
167 MESSAGE_READ BOOLEAN,
168 SUBJECT CHARACTER VARYING(255),
169 RECEIVER_ID BIGINT NOT NULL,
170 SENDER_ID BIGINT NOT NULL
171) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
172Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
173 ID BIGINT NOT NULL,
174 BODY CHARACTER VARYING(3000),
175 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
176 MESSAGE_READ BOOLEAN,
177 SUBJECT CHARACTER VARYING(255),
178 RECEIVER_ID BIGINT NOT NULL,
179 SENDER_ID BIGINT NOT NULL
180) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
181CREATE TABLE IF NOT EXISTS message (
182 id BIGINT NOT NULL,
183 body CHARACTER VARYING(3000),
184 message_date TIMESTAMP WITHOUT TIME ZONE,
185 message_read BOOLEAN,
186 subject CHARACTER VARYING(255),
187 receiver_id BIGINT NOT NULL,
188 sender_id BIGINT NOT NULL
189) [42001-196]
190Location : db/migration/V1__init.sql (/home/max/IdeaProjects/portal/target/classes/db/migration/V1__init.sql)
191Line : 115
192Statement : CREATE TABLE IF NOT EXISTS message (
193 id BIGINT NOT NULL,
194 body CHARACTER VARYING(3000),
195 message_date TIMESTAMP WITHOUT TIME ZONE,
196 message_read BOOLEAN,
197 subject CHARACTER VARYING(255),
198 receiver_id BIGINT NOT NULL,
199 sender_id BIGINT NOT NULL
200)
201
202 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
203 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
204 at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284)
205 at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282)
206 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
207 at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282)
208 at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
209 at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
210 at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
211 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
212 at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
213 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059)
214 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)
215 at org.flywaydb.core.Flyway.execute(Flyway.java:1418)
216 at org.flywaydb.core.Flyway.migrate(Flyway.java:1006)
217 at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
218 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687)
219 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)
220 ... 41 common frames omitted
221Caused by: org.h2.jdbc.JdbcSQLException: СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
222 ID BIGINT NOT NULL,
223 BODY CHARACTER VARYING(3000),
224 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
225 MESSAGE_READ BOOLEAN,
226 SUBJECT CHARACTER VARYING(255),
227 RECEIVER_ID BIGINT NOT NULL,
228 SENDER_ID BIGINT NOT NULL
229) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
230Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
231 ID BIGINT NOT NULL,
232 BODY CHARACTER VARYING(3000),
233 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
234 MESSAGE_READ BOOLEAN,
235 SUBJECT CHARACTER VARYING(255),
236 RECEIVER_ID BIGINT NOT NULL,
237 SENDER_ID BIGINT NOT NULL
238) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
239CREATE TABLE IF NOT EXISTS message (
240 id BIGINT NOT NULL,
241 body CHARACTER VARYING(3000),
242 message_date TIMESTAMP WITHOUT TIME ZONE,
243 message_read BOOLEAN,
244 subject CHARACTER VARYING(255),
245 receiver_id BIGINT NOT NULL,
246 sender_id BIGINT NOT NULL
247) [42001-196]
248 at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
249 at org.h2.message.DbException.getSyntaxError(DbException.java:205)
250 at org.h2.command.Parser.getSyntaxError(Parser.java:541)
251 at org.h2.command.Parser.read(Parser.java:3258)
252 at org.h2.command.Parser.readIfMore(Parser.java:894)
253 at org.h2.command.Parser.parseCreateTable(Parser.java:6234)
254 at org.h2.command.Parser.parseCreate(Parser.java:4351)
255 at org.h2.command.Parser.parsePrepared(Parser.java:366)
256 at org.h2.command.Parser.parse(Parser.java:321)
257 at org.h2.command.Parser.parse(Parser.java:297)
258 at org.h2.command.Parser.prepareCommand(Parser.java:258)
259 at org.h2.engine.Session.prepareLocal(Session.java:578)
260 at org.h2.engine.Session.prepareCommand(Session.java:519)
261 at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
262 at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:176)
263 at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
264 at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
265 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
266 at java.lang.reflect.Method.invoke(Method.java:498)
267 at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
268 at com.sun.proxy.$Proxy86.execute(Unknown Source)
269 at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
270 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
271 ... 58 common frames omitted
27220:52:29.220 [ERROR] TestContextManager:234 - Caught exception while allowing TestExecutionListener [org.springframework.test.context.web.ServletTestExecutionListener@6069db50] to prepare test instance [ru.edu.portfolio.unit.remote.CertificateControllerTest@26794848]
273java.lang.IllegalStateException: Failed to load ApplicationContext
274 at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124)
275 at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83)
276 at org.springframework.test.context.web.ServletTestExecutionListener.setUpRequestContextIfNecessary(ServletTestExecutionListener.java:189)
277 at org.springframework.test.context.web.ServletTestExecutionListener.prepareTestInstance(ServletTestExecutionListener.java:131)
278 at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230)
279 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228)
280 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287)
281 at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
282 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289)
283 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247)
284 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
285 at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
286 at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
287 at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
288 at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
289 at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
290 at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
291 at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
292 at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
293 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
294 at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
295 at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
296 at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
297 at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
298 at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
299Caused by: 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.dbsupport.FlywaySqlScriptException:
300Migration V1__init.sql failed
301-----------------------------
302SQL State : 42001
303Error Code : 42001
304Message : СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
305 ID BIGINT NOT NULL,
306 BODY CHARACTER VARYING(3000),
307 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
308 MESSAGE_READ BOOLEAN,
309 SUBJECT CHARACTER VARYING(255),
310 RECEIVER_ID BIGINT NOT NULL,
311 SENDER_ID BIGINT NOT NULL
312) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
313Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
314 ID BIGINT NOT NULL,
315 BODY CHARACTER VARYING(3000),
316 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
317 MESSAGE_READ BOOLEAN,
318 SUBJECT CHARACTER VARYING(255),
319 RECEIVER_ID BIGINT NOT NULL,
320 SENDER_ID BIGINT NOT NULL
321) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
322CREATE TABLE IF NOT EXISTS message (
323 id BIGINT NOT NULL,
324 body CHARACTER VARYING(3000),
325 message_date TIMESTAMP WITHOUT TIME ZONE,
326 message_read BOOLEAN,
327 subject CHARACTER VARYING(255),
328 receiver_id BIGINT NOT NULL,
329 sender_id BIGINT NOT NULL
330) [42001-196]
331Location : db/migration/V1__init.sql (/home/max/IdeaProjects/portal/target/classes/db/migration/V1__init.sql)
332Line : 115
333Statement : CREATE TABLE IF NOT EXISTS message (
334 id BIGINT NOT NULL,
335 body CHARACTER VARYING(3000),
336 message_date TIMESTAMP WITHOUT TIME ZONE,
337 message_read BOOLEAN,
338 subject CHARACTER VARYING(255),
339 receiver_id BIGINT NOT NULL,
340 sender_id BIGINT NOT NULL
341)
342
343 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628)
344 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
345 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
346 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
347 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
348 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
349 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
350 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:296)
351 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
352 at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1078)
353 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:857)
354 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
355 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693)
356 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360)
357 at org.springframework.boot.SpringApplication.run(SpringApplication.java:303)
358 at org.springframework.boot.test.context.SpringBootContextLoader.loadContext(SpringBootContextLoader.java:120)
359 at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98)
360 at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116)
361 ... 24 common frames omitted
362Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
363Migration V1__init.sql failed
364-----------------------------
365SQL State : 42001
366Error Code : 42001
367Message : СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
368 ID BIGINT NOT NULL,
369 BODY CHARACTER VARYING(3000),
370 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
371 MESSAGE_READ BOOLEAN,
372 SUBJECT CHARACTER VARYING(255),
373 RECEIVER_ID BIGINT NOT NULL,
374 SENDER_ID BIGINT NOT NULL
375) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
376Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
377 ID BIGINT NOT NULL,
378 BODY CHARACTER VARYING(3000),
379 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
380 MESSAGE_READ BOOLEAN,
381 SUBJECT CHARACTER VARYING(255),
382 RECEIVER_ID BIGINT NOT NULL,
383 SENDER_ID BIGINT NOT NULL
384) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
385CREATE TABLE IF NOT EXISTS message (
386 id BIGINT NOT NULL,
387 body CHARACTER VARYING(3000),
388 message_date TIMESTAMP WITHOUT TIME ZONE,
389 message_read BOOLEAN,
390 subject CHARACTER VARYING(255),
391 receiver_id BIGINT NOT NULL,
392 sender_id BIGINT NOT NULL
393) [42001-196]
394Location : db/migration/V1__init.sql (/home/max/IdeaProjects/portal/target/classes/db/migration/V1__init.sql)
395Line : 115
396Statement : CREATE TABLE IF NOT EXISTS message (
397 id BIGINT NOT NULL,
398 body CHARACTER VARYING(3000),
399 message_date TIMESTAMP WITHOUT TIME ZONE,
400 message_read BOOLEAN,
401 subject CHARACTER VARYING(255),
402 receiver_id BIGINT NOT NULL,
403 sender_id BIGINT NOT NULL
404)
405
406 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
407 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
408 at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284)
409 at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282)
410 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
411 at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282)
412 at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
413 at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
414 at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
415 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
416 at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
417 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059)
418 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)
419 at org.flywaydb.core.Flyway.execute(Flyway.java:1418)
420 at org.flywaydb.core.Flyway.migrate(Flyway.java:1006)
421 at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
422 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687)
423 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)
424 ... 41 common frames omitted
425Caused by: org.h2.jdbc.JdbcSQLException: СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
426 ID BIGINT NOT NULL,
427 BODY CHARACTER VARYING(3000),
428 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
429 MESSAGE_READ BOOLEAN,
430 SUBJECT CHARACTER VARYING(255),
431 RECEIVER_ID BIGINT NOT NULL,
432 SENDER_ID BIGINT NOT NULL
433) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
434Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
435 ID BIGINT NOT NULL,
436 BODY CHARACTER VARYING(3000),
437 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
438 MESSAGE_READ BOOLEAN,
439 SUBJECT CHARACTER VARYING(255),
440 RECEIVER_ID BIGINT NOT NULL,
441 SENDER_ID BIGINT NOT NULL
442) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
443CREATE TABLE IF NOT EXISTS message (
444 id BIGINT NOT NULL,
445 body CHARACTER VARYING(3000),
446 message_date TIMESTAMP WITHOUT TIME ZONE,
447 message_read BOOLEAN,
448 subject CHARACTER VARYING(255),
449 receiver_id BIGINT NOT NULL,
450 sender_id BIGINT NOT NULL
451) [42001-196]
452 at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
453 at org.h2.message.DbException.getSyntaxError(DbException.java:205)
454 at org.h2.command.Parser.getSyntaxError(Parser.java:541)
455 at org.h2.command.Parser.read(Parser.java:3258)
456 at org.h2.command.Parser.readIfMore(Parser.java:894)
457 at org.h2.command.Parser.parseCreateTable(Parser.java:6234)
458 at org.h2.command.Parser.parseCreate(Parser.java:4351)
459 at org.h2.command.Parser.parsePrepared(Parser.java:366)
460 at org.h2.command.Parser.parse(Parser.java:321)
461 at org.h2.command.Parser.parse(Parser.java:297)
462 at org.h2.command.Parser.prepareCommand(Parser.java:258)
463 at org.h2.engine.Session.prepareLocal(Session.java:578)
464 at org.h2.engine.Session.prepareCommand(Session.java:519)
465 at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
466 at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:176)
467 at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
468 at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
469 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
470 at java.lang.reflect.Method.invoke(Method.java:498)
471 at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
472 at com.sun.proxy.$Proxy86.execute(Unknown Source)
473 at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
474 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
475 ... 58 common frames omitted
476
477java.lang.IllegalStateException: Failed to load ApplicationContext
478
479 at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124)
480 at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83)
481 at org.springframework.test.context.web.ServletTestExecutionListener.setUpRequestContextIfNecessary(ServletTestExecutionListener.java:189)
482 at org.springframework.test.context.web.ServletTestExecutionListener.prepareTestInstance(ServletTestExecutionListener.java:131)
483 at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230)
484 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228)
485 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287)
486 at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
487 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289)
488 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247)
489 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
490 at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
491 at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
492 at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
493 at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
494 at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
495 at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
496 at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
497 at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
498 at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
499 at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
500 at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
501 at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
502 at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
503 at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
504Caused by: 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.dbsupport.FlywaySqlScriptException:
505Migration V1__init.sql failed
506-----------------------------
507SQL State : 42001
508Error Code : 42001
509Message : СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
510 ID BIGINT NOT NULL,
511 BODY CHARACTER VARYING(3000),
512 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
513 MESSAGE_READ BOOLEAN,
514 SUBJECT CHARACTER VARYING(255),
515 RECEIVER_ID BIGINT NOT NULL,
516 SENDER_ID BIGINT NOT NULL
517) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
518Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
519 ID BIGINT NOT NULL,
520 BODY CHARACTER VARYING(3000),
521 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
522 MESSAGE_READ BOOLEAN,
523 SUBJECT CHARACTER VARYING(255),
524 RECEIVER_ID BIGINT NOT NULL,
525 SENDER_ID BIGINT NOT NULL
526) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
527CREATE TABLE IF NOT EXISTS message (
528 id BIGINT NOT NULL,
529 body CHARACTER VARYING(3000),
530 message_date TIMESTAMP WITHOUT TIME ZONE,
531 message_read BOOLEAN,
532 subject CHARACTER VARYING(255),
533 receiver_id BIGINT NOT NULL,
534 sender_id BIGINT NOT NULL
535) [42001-196]
536Location : db/migration/V1__init.sql (/home/max/IdeaProjects/portal/target/classes/db/migration/V1__init.sql)
537Line : 115
538Statement : CREATE TABLE IF NOT EXISTS message (
539 id BIGINT NOT NULL,
540 body CHARACTER VARYING(3000),
541 message_date TIMESTAMP WITHOUT TIME ZONE,
542 message_read BOOLEAN,
543 subject CHARACTER VARYING(255),
544 receiver_id BIGINT NOT NULL,
545 sender_id BIGINT NOT NULL
546)
547
548 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1628)
549 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
550 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
551 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
552 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
553 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
554 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
555 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:296)
556 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
557 at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1078)
558 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:857)
559 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
560 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693)
561 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360)
562 at org.springframework.boot.SpringApplication.run(SpringApplication.java:303)
563 at org.springframework.boot.test.context.SpringBootContextLoader.loadContext(SpringBootContextLoader.java:120)
564 at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98)
565 at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116)
566 ... 24 more
567Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
568Migration V1__init.sql failed
569-----------------------------
570SQL State : 42001
571Error Code : 42001
572Message : СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
573 ID BIGINT NOT NULL,
574 BODY CHARACTER VARYING(3000),
575 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
576 MESSAGE_READ BOOLEAN,
577 SUBJECT CHARACTER VARYING(255),
578 RECEIVER_ID BIGINT NOT NULL,
579 SENDER_ID BIGINT NOT NULL
580) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
581Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
582 ID BIGINT NOT NULL,
583 BODY CHARACTER VARYING(3000),
584 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
585 MESSAGE_READ BOOLEAN,
586 SUBJECT CHARACTER VARYING(255),
587 RECEIVER_ID BIGINT NOT NULL,
588 SENDER_ID BIGINT NOT NULL
589) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
590CREATE TABLE IF NOT EXISTS message (
591 id BIGINT NOT NULL,
592 body CHARACTER VARYING(3000),
593 message_date TIMESTAMP WITHOUT TIME ZONE,
594 message_read BOOLEAN,
595 subject CHARACTER VARYING(255),
596 receiver_id BIGINT NOT NULL,
597 sender_id BIGINT NOT NULL
598) [42001-196]
599Location : db/migration/V1__init.sql (/home/max/IdeaProjects/portal/target/classes/db/migration/V1__init.sql)
600Line : 115
601Statement : CREATE TABLE IF NOT EXISTS message (
602 id BIGINT NOT NULL,
603 body CHARACTER VARYING(3000),
604 message_date TIMESTAMP WITHOUT TIME ZONE,
605 message_read BOOLEAN,
606 subject CHARACTER VARYING(255),
607 receiver_id BIGINT NOT NULL,
608 sender_id BIGINT NOT NULL
609)
610
611 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
612 at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
613 at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:284)
614 at org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:282)
615 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
616 at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:282)
617 at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46)
618 at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207)
619 at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156)
620 at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
621 at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156)
622 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1059)
623 at org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)
624 at org.flywaydb.core.Flyway.execute(Flyway.java:1418)
625 at org.flywaydb.core.Flyway.migrate(Flyway.java:1006)
626 at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
627 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687)
628 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)
629 ... 41 more
630Caused by: org.h2.jdbc.JdbcSQLException: СинтакÑичеÑÐºÐ°Ñ Ð¾ÑˆÐ¸Ð±ÐºÐ° в выражении SQL "CREATE TABLE IF NOT EXISTS MESSAGE (
631 ID BIGINT NOT NULL,
632 BODY CHARACTER VARYING(3000),
633 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
634 MESSAGE_READ BOOLEAN,
635 SUBJECT CHARACTER VARYING(255),
636 RECEIVER_ID BIGINT NOT NULL,
637 SENDER_ID BIGINT NOT NULL
638) "; ожидалоÑÑŒ "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"
639Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS MESSAGE (
640 ID BIGINT NOT NULL,
641 BODY CHARACTER VARYING(3000),
642 MESSAGE_DATE TIMESTAMP WITHOUT[*] TIME ZONE,
643 MESSAGE_READ BOOLEAN,
644 SUBJECT CHARACTER VARYING(255),
645 RECEIVER_ID BIGINT NOT NULL,
646 SENDER_ID BIGINT NOT NULL
647) "; expected "WITH, (, FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, NOT, NULL, AUTO_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, ,, )"; SQL statement:
648CREATE TABLE IF NOT EXISTS message (
649 id BIGINT NOT NULL,
650 body CHARACTER VARYING(3000),
651 message_date TIMESTAMP WITHOUT TIME ZONE,
652 message_read BOOLEAN,
653 subject CHARACTER VARYING(255),
654 receiver_id BIGINT NOT NULL,
655 sender_id BIGINT NOT NULL
656) [42001-196]
657 at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
658 at org.h2.message.DbException.getSyntaxError(DbException.java:205)
659 at org.h2.command.Parser.getSyntaxError(Parser.java:541)
660 at org.h2.command.Parser.read(Parser.java:3258)
661 at org.h2.command.Parser.readIfMore(Parser.java:894)
662 at org.h2.command.Parser.parseCreateTable(Parser.java:6234)
663 at org.h2.command.Parser.parseCreate(Parser.java:4351)
664 at org.h2.command.Parser.parsePrepared(Parser.java:366)
665 at org.h2.command.Parser.parse(Parser.java:321)
666 at org.h2.command.Parser.parse(Parser.java:297)
667 at org.h2.command.Parser.prepareCommand(Parser.java:258)
668 at org.h2.engine.Session.prepareLocal(Session.java:578)
669 at org.h2.engine.Session.prepareCommand(Session.java:519)
670 at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
671 at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:176)
672 at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
673 at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
674 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
675 at java.lang.reflect.Method.invoke(Method.java:498)
676 at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
677 at com.sun.proxy.$Proxy86.execute(Unknown Source)
678 at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
679 at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
680 ... 58 more
681
682
683Process finished with exit code 255