Skip to content
This repository has been archived by the owner on Apr 25, 2023. It is now read-only.

I can't launch the local host page with db Error. #1072

Open
letsplay23 opened this issue Jul 5, 2022 · 1 comment
Open

I can't launch the local host page with db Error. #1072

letsplay23 opened this issue Jul 5, 2022 · 1 comment

Comments

@letsplay23
Copy link

How do we solve this problem?

C:\Users\Administrator\git\sagan>gradlew :sagan-site:bootRun

Task :sagan-site:bootRun
18:24:35.939 [Thread-0] DEBUG org.springframework.boot.devtools.restart.classloader.RestartClassLoader - Created RestartClassLoader org.springframework.boot.devtools.restart.classloader.RestartClassLoader@2468fbaf

. ____ _ __ _ _
/\ / ' __ _ () __ __ _ \ \ \
( ( )__ | '_ | '| | ' / ` | \ \ \
\/ )| |)| | | | | || (| | ) ) ) )
' || .__|| ||| |_, | / / / /
=========||==============|/=////
:: Spring Boot :: (v2.5.12)

2022-07-05 18:24:36.336 INFO 17036 --- [ restartedMain] sagan.site.SiteApplication : Starting SiteApplication using Java 11.0.15 on DESKTOP-2MKARF5 with PID 17036 (C:\Users\Administrator\git\sagan\sagan-site\build\classes\java\main started by Administrator in C:\Users\Administrator\git\sagan\sagan-site)
2022-07-05 18:24:36.337 INFO 17036 --- [ restartedMain] sagan.site.SiteApplication : No active profile set, falling back to 1 default profile: "default"
2022-07-05 18:24:36.376 INFO 17036 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2022-07-05 18:24:36.376 INFO 17036 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2022-07-05 18:24:37.394 INFO 17036 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2022-07-05 18:24:37.395 INFO 17036 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2022-07-05 18:24:37.524 INFO 17036 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 123 ms. Found 6 JPA repository interfaces.
2022-07-05 18:24:37.534 INFO 17036 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2022-07-05 18:24:37.535 INFO 17036 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode.
2022-07-05 18:24:37.565 INFO 17036 --- [ restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface sagan.site.blog.PostRepository. If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository.
2022-07-05 18:24:37.566 INFO 17036 --- [ restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface sagan.site.projects.ProjectGroupRepository. If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository.
2022-07-05 18:24:37.567 INFO 17036 --- [ restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface sagan.site.projects.ProjectRepository. If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository.
2022-07-05 18:24:37.567 INFO 17036 --- [ restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface sagan.site.projects.ReleaseRepository. If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository.
2022-07-05 18:24:37.567 INFO 17036 --- [ restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface sagan.site.team.support.TeamRepository. If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository.
2022-07-05 18:24:37.567 INFO 17036 --- [ restartedMain] .RepositoryConfigurationExtensionSupport : Spring Data Redis - Could not safely identify store assignment for repository candidate interface sagan.site.tools.SpringToolsPlatformRepository. If you want this repository to be a Redis repository, consider annotating your entities with one of these annotations: org.springframework.data.redis.core.RedisHash (preferred), or consider extending one of the following types with your repository: org.springframework.data.keyvalue.repository.KeyValueRepository.
2022-07-05 18:24:37.567 INFO 17036 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 26 ms. Found 0 Redis repository interfaces.
2022-07-05 18:24:38.294 INFO 17036 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
2022-07-05 18:24:38.302 INFO 17036 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2022-07-05 18:24:38.302 INFO 17036 --- [ restartedMain] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.60]
2022-07-05 18:24:38.419 INFO 17036 --- [ restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2022-07-05 18:24:38.419 INFO 17036 --- [ restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2043 ms
2022-07-05 18:24:38.503 INFO 17036 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2022-07-05 18:24:38.583 INFO 17036 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2022-07-05 18:24:38.587 INFO 17036 --- [ restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '/h2-console'. Database available at 'jdbc:h2:mem:03d31374-9336-49f1-8318-80720869c727'
2022-07-05 18:24:38.833 INFO 17036 --- [ restartedMain] o.f.c.internal.license.VersionPrinter : Flyway Community Edition 7.7.3 by Redgate
2022-07-05 18:24:38.847 INFO 17036 --- [ restartedMain] o.f.c.i.database.base.DatabaseType : Database: jdbc:h2:mem:03d31374-9336-49f1-8318-80720869c727 (H2 1.4)
2022-07-05 18:24:38.897 INFO 17036 --- [ restartedMain] o.f.core.internal.command.DbValidate : Successfully validated 7 migrations (execution time 00:00.019s)
2022-07-05 18:24:38.905 INFO 17036 --- [ restartedMain] o.f.c.i.s.JdbcTableSchemaHistory : Creating Schema History table "PUBLIC"."flyway_schema_history" ...
2022-07-05 18:24:38.925 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.927 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.937 INFO 17036 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Current version of schema "PUBLIC": << Empty Schema >>
2022-07-05 18:24:38.943 INFO 17036 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Migrating schema "PUBLIC" to version "1 - initialize"
2022-07-05 18:24:38.949 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.951 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.952 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.952 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.952 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.960 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.960 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.961 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.963 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.976 INFO 17036 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Migrating schema "PUBLIC" to version "2 - projectpages"
2022-07-05 18:24:38.981 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.983 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.985 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.986 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.987 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.989 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.990 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.990 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:38.999 INFO 17036 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Migrating schema "PUBLIC" to version "3 - springtools"
2022-07-05 18:24:38.999 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.000 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.007 INFO 17036 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Migrating schema "PUBLIC" to version "4 - projects"
2022-07-05 18:24:39.009 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.010 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.011 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.014 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.015 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.015 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.025 INFO 17036 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Migrating schema "PUBLIC" to version "5 - project refactoring"
2022-07-05 18:24:39.025 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.026 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.026 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.026 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.026 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.026 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.026 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.026 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.027 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.027 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.029 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.029 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.030 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.030 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.031 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.032 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.033 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.034 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.035 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.035 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.037 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.037 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.037 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.037 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.039 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.040 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.041 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.041 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.041 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.041 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.041 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.042 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.042 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.043 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.043 INFO 17036 --- [ restartedMain] o.f.c.i.s.DefaultSqlScriptExecutor : 0 rows affected
2022-07-05 18:24:39.045 ERROR 17036 --- [ restartedMain] o.f.core.internal.command.DbMigrate : Migration of schema "PUBLIC" to version "5 - project refactoring" failed! Please restore backups and roll back database and code!
2022-07-05 18:24:39.052 WARN 17036 --- [ restartedMain] 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:
Migration V5__project_refactoring.sql failed

SQL State : 42001
Error Code : 42001
Message : Syntax error in SQL statement "ALTER TABLE PROJECT_SAMPLE MODIFY[*] TITLE VARCHAR(255) NOT NULL"; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL [42001-200]
Location : db/migration/V5__project_refactoring.sql (C:\Users\Administrator\git\sagan\sagan-site\build\resources\main\db\migration\V5__project_refactoring.sql)
Line : 60
Statement : ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL

2022-07-05 18:24:39.064 INFO 17036 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2022-07-05 18:24:39.066 INFO 17036 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
2022-07-05 18:24:39.067 INFO 17036 --- [ restartedMain] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2022-07-05 18:24:39.079 INFO 17036 --- [ restartedMain] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2022-07-05 18:24:39.107 ERROR 17036 --- [ restartedMain] o.s.boot.SpringApplication : Application run failed

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:
Migration V5__project_refactoring.sql failed

SQL State : 42001
Error Code : 42001
Message : Syntax error in SQL statement "ALTER TABLE PROJECT_SAMPLE MODIFY[*] TITLE VARCHAR(255) NOT NULL"; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL [42001-200]
Location : db/migration/V5__project_refactoring.sql (C:\Users\Administrator\git\sagan\sagan-site\build\resources\main\db\migration\V5__project_refactoring.sql)
Line : 60
Statement : ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154) ~[spring-context-5.3.18.jar:5.3.18]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908) ~[spring-context-5.3.18.jar:5.3.18]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.18.jar:5.3.18]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.5.12.jar:2.5.12]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) ~[spring-boot-2.5.12.jar:2.5.12]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:448) ~[spring-boot-2.5.12.jar:2.5.12]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:339) ~[spring-boot-2.5.12.jar:2.5.12]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1365) ~[spring-boot-2.5.12.jar:2.5.12]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) ~[spring-boot-2.5.12.jar:2.5.12]
    at sagan.site.SiteApplication.main(SiteApplication.java:15) ~[main/:na]
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
    at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
    at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-2.5.12.jar:2.5.12]

Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Migration V5__project_refactoring.sql failed

SQL State : 42001
Error Code : 42001
Message : Syntax error in SQL statement "ALTER TABLE PROJECT_SAMPLE MODIFY[*] TITLE VARCHAR(255) NOT NULL"; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL [42001-200]
Location : db/migration/V5__project_refactoring.sql (C:\Users\Administrator\git\sagan\sagan-site\build\resources\main\db\migration\V5__project_refactoring.sql)
Line : 60
Statement : ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL

    at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:427) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.access$200(DbMigrate.java:56) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate$3.call(DbMigrate.java:331) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:66) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:328) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:291) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:195) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:192) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.jdbc.TableLockingExecutionTemplate$1.call(TableLockingExecutionTemplate.java:38) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:66) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.jdbc.TableLockingExecutionTemplate.execute(TableLockingExecutionTemplate.java:33) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.database.base.Connection.lock(Connection.java:103) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:192) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.Flyway.execute(Flyway.java:572) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.Flyway.migrate(Flyway.java:165) ~[flyway-core-7.7.3.jar:na]
    at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66) ~[spring-boot-autoconfigure-2.5.12.jar:2.5.12]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) ~[spring-beans-5.3.18.jar:5.3.18]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.3.18.jar:5.3.18]
    ... 23 common frames omitted

Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Migration V5__project_refactoring.sql failed

SQL State : 42001
Error Code : 42001
Message : Syntax error in SQL statement "ALTER TABLE PROJECT_SAMPLE MODIFY[*] TITLE VARCHAR(255) NOT NULL"; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL [42001-200]
Location : db/migration/V5__project_refactoring.sql (C:\Users\Administrator\git\sagan\sagan-site\build\resources\main\db\migration\V5__project_refactoring.sql)
Line : 60
Statement : ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL

    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:271) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:218) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:126) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:78) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:67) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:27) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:66) ~[flyway-core-7.7.3.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:424) ~[flyway-core-7.7.3.jar:na]
    ... 45 common frames omitted

Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "ALTER TABLE PROJECT_SAMPLE MODIFY[*] TITLE VARCHAR(255) NOT NULL"; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
ALTER TABLE project_sample MODIFY title VARCHAR(255) NOT NULL [42001-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453) ~[h2-1.4.200.jar:1.4.200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2-1.4.200.jar:1.4.200]
at org.h2.message.DbException.getSyntaxError(DbException.java:243) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Parser.getSyntaxError(Parser.java:1053) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Parser.parseAlterTable(Parser.java:7705) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Parser.parseAlter(Parser.java:6983) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Parser.parsePrepared(Parser.java:887) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Parser.parse(Parser.java:843) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Parser.parse(Parser.java:819) ~[h2-1.4.200.jar:1.4.200]
at org.h2.command.Parser.prepareCommand(Parser.java:738) ~[h2-1.4.200.jar:1.4.200]
at org.h2.engine.Session.prepareLocal(Session.java:657) ~[h2-1.4.200.jar:1.4.200]
at org.h2.engine.Session.prepareCommand(Session.java:595) ~[h2-1.4.200.jar:1.4.200]
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235) ~[h2-1.4.200.jar:1.4.200]
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:212) ~[h2-1.4.200.jar:1.4.200]
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201) ~[h2-1.4.200.jar:1.4.200]
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na]
at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:241) ~[flyway-core-7.7.3.jar:na]
at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111) ~[flyway-core-7.7.3.jar:na]
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:206) ~[flyway-core-7.7.3.jar:na]
... 51 common frames omitted

Task :sagan-site:bootRun FAILED

FAILURE: Build failed with an exception.

  • What went wrong:
    Execution failed for task ':sagan-site:bootRun'.

Process 'command 'C:\Program Files\Eclipse Adoptium\jdk-11.0.15.10-hotspot\bin\java.exe'' finished with non-zero exit value 1

  • Try:

Run with --stacktrace option to get the stack trace.
Run with --info or --debug option to get more log output.
Run with --scan to get full insights.

BUILD FAILED in 6s
10 actionable tasks: 1 executed, 9 up-to-date
@letsplay23
Copy link
Author

For those who have read this, please refer to #1012.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@letsplay23