1.4.17升级1.5+ 出现问题

v587xpt

原版本是1.4.17，换成1.5.3后，运行jar包，出现：
2022-05-31 11:39:44.486 INFO 4776 --- [ main] o.f.core.internal.command.DbMigrate : Migrating schemahalodb_1to version "6 - migrate create contents table" 2022-05-31 11:39:44.499 ERROR 4776 --- [ main] o.f.core.internal.command.DbMigrate : Migration of schemahalodb_1` to version "6 - migrate create contents table" failed! Please restore backups and roll back database and code!
2022-05-31 11:39:44.521 INFO 4776 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2022-05-31 11:39:44.545 ERROR 4776 --- [ main] o.s.boot.SpringApplication : Application run failed

org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V6__migrate_create_contents_table.sql failed

SQL State : 23000
Error Code : 1062
Message : Duplicate entry '2' for key 'contents.PRIMARY'
Location : migration/V6migrate_create_contents_table.sql (/usr/local/halo/file:/usr/local/halo/halo-1.5.3.jar!/BOOT-INF/classes!/migration/V6migrate_create_contents_table.sql)
Line : 2
Statement : -- Migrate post content to contents table
INSERT INTO contents(post_id, status, patch_log_id, head_patch_log_id, content, original_content, create_time,
update_time)
SELECT id,
status,
id,
id,
format_content,
original_content,
create_time,
update_time
FROM posts

at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:378) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.command.DbMigrate.lambda$applyMigrations$1(DbMigrate.java:271) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:66) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:270) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:243) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.command.DbMigrate.lambda$migrateAll$0(DbMigrate.java:141) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.database.mysql.MySQLNamedLockTemplate.execute(MySQLNamedLockTemplate.java:60) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.database.mysql.MySQLConnection.lock(MySQLConnection.java:154) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:141) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:101) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.Flyway$1.execute(Flyway.java:219) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.Flyway$1.execute(Flyway.java:170) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.Flyway.execute(Flyway.java:586) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.Flyway.migrate(Flyway.java:170) ~[flyway-core-7.15.0.jar!/:na]
at run.halo.app.listener.StartedListener.migrate(StartedListener.java:123) ~[classes!/:1.5.3]
at run.halo.app.listener.StartedListener.onApplicationEvent(StartedListener.java:76) ~[classes!/:1.5.3]
at run.halo.app.listener.StartedListener.onApplicationEvent(StartedListener.java:47) ~[classes!/:1.5.3]
at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) ~[spring-context-5.3.18.jar!/:5.3.18]
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) ~[spring-context-5.3.18.jar!/:5.3.18]
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) ~[spring-context-5.3.18.jar!/:5.3.18]
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:421) ~[spring-context-5.3.18.jar!/:5.3.18]
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378) ~[spring-context-5.3.18.jar!/:5.3.18]
at org.springframework.boot.context.event.EventPublishingRunListener.started(EventPublishingRunListener.java:105) ~[spring-boot-2.5.12.jar!/:2.5.12]
at org.springframework.boot.SpringApplicationRunListeners.lambda$started$5(SpringApplicationRunListeners.java:75) ~[spring-boot-2.5.12.jar!/:2.5.12]
at java.base/java.util.ArrayList.forEach(ArrayList.java:1507) ~[na:na]
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:117) ~[spring-boot-2.5.12.jar!/:2.5.12]
at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:111) ~[spring-boot-2.5.12.jar!/:2.5.12]
at org.springframework.boot.SpringApplicationRunListeners.started(SpringApplicationRunListeners.java:75) ~[spring-boot-2.5.12.jar!/:2.5.12]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:345) ~[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 run.halo.app.Application.main(Application.java:21) ~[classes!/:1.5.3]
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:567) ~[na:na]
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[halo-1.5.3.jar:1.5.3]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) ~[halo-1.5.3.jar:1.5.3]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[halo-1.5.3.jar:1.5.3]
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88) ~[halo-1.5.3.jar:1.5.3]

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

at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:277) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:224) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:128) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:78) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:67) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:27) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:66) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:370) ~[flyway-core-7.15.0.jar!/:na]
... 40 common frames omitted

Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '2' for key 'contents.PRIMARY'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:241) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111) ~[flyway-core-7.15.0.jar!/:na]
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:212) ~[flyway-core-7.15.0.jar!/:na]
... 46 common frames omitted

2022-05-31 11:39:44.559 INFO 4776 --- [ main] o.e.jetty.server.AbstractConnector : Stopped ServerConnector@29ef6856{HTTP/1.1, (http/1.1)}{0.0.0.0:8090}
2022-05-31 11:39:44.560 INFO 4776 --- [ main] org.eclipse.jetty.server.session : node0 Stopped scavenging
2022-05-31 11:39:44.561 INFO 4776 --- [ main] o.e.j.s.h.ContextHandler.application : Destroying Spring FrameworkServlet 'dispatcherServlet'
2022-05-31 11:39:44.562 INFO 4776 --- [ main] o.e.jetty.server.handler.ContextHandler : Stopped o.s.b.w.e.j.JettyEmbeddedWebAppContext@5b332439{application,/,[file:///tmp/jetty-docbase.8090.15184187017743554723/, jar:file:/usr/local/halo/halo-1.5.3.jar!/BOOT-INF/lib/springfox-swagger-ui-3.0.0.jar!/META-INF/resources],STOPPED}
2022-05-31 11:39:44.595 INFO 4776 --- [ main] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
2022-05-31 11:39:44.597 INFO 4776 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2022-05-31 11:39:44.606 INFO 4776 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
`
查询先关后，好像是mysql数据库有问题，问下，1.4的mysql库和1.5的mysql库是有差异了吗？如何解决下

Ryan Wang 👍

是因为你之前有升级到 1.5 之后又降级到 1.4。解决方案参考 halo-dev/halo1765

v587xpt

Ryan Wang 👍 抱歉，是我没有说清楚；我重新搭建的1.5版本，里面没有数据。我将1.4.17的数据库导入到了1.5的数据库里，并且将1.4.17的 ~.halo 文件复制到了 1.5 ~.halo 里，以此实现 1.4到1.5的升级，因为之前我用1.5的jar包直接替换1.4 的jar包，启动并没有成功；

Ryan Wang 👍

v587xpt 你直接将 1.4 的数据放到了 1.5 的版本里，意味着没有执行升级脚本吗？

建议完整恢复到 1.4.17 的状态，然后再重新使用 1.5 的版本启动，如果有异常，提供一下日志即可。

v587xpt

Ryan Wang 👍 我恢复了1.4.17的halo，并且验证了它是可以正常使用的；然后我关闭了1.4.17 的jar，~.halo 和MySQL数据库文件都没有改动，然后启动了 1.5.3的jar包，这是启动到终止的所有日志；

Version: 1.5.3
2022-05-31 15:51:47.582  INFO 26207 --- [           main] run.halo.app.Application                 : Starting Application v1.5.3 using Java 13.0.1 on xpt.v587xpt.top with PID 26207 (/usr/local/halo/halo-1.5.3.jar started by root in /usr/local/halo)
2022-05-31 15:51:47.593  INFO 26207 --- [           main] run.halo.app.Application                 : No active profile set, falling back to 1 default profile: "default"
2022-05-31 15:51:49.505  INFO 26207 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2022-05-31 15:51:49.505  INFO 26207 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2022-05-31 15:51:49.880  INFO 26207 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 361 ms. Found 24 JPA repository interfaces.
2022-05-31 15:51:51.343  INFO 26207 --- [           main] org.eclipse.jetty.util.log               : Logging initialized @5627ms to org.eclipse.jetty.util.log.Slf4jLog
2022-05-31 15:51:51.528  INFO 26207 --- [           main] o.s.b.w.e.j.JettyServletWebServerFactory : Server initialized with port: 8090
2022-05-31 15:51:51.557  INFO 26207 --- [           main] org.eclipse.jetty.server.Server          : jetty-9.4.45.v20220203; built: 2022-02-03T09:14:34.105Z; git: 4a0c91c0be53805e3fcffdcdcc9587d5301863db; jvm 13.0.1+9
2022-05-31 15:51:51.599  INFO 26207 --- [           main] o.e.j.s.h.ContextHandler.application     : Initializing Spring embedded WebApplicationContext
2022-05-31 15:51:51.599  INFO 26207 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 3899 ms
2022-05-31 15:51:52.418  INFO 26207 --- [           main] run.halo.app.config.HaloConfiguration    : Halo cache store load impl : [class run.halo.app.cache.InMemoryCacheStore]
2022-05-31 15:51:53.489  INFO 26207 --- [           main] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
2022-05-31 15:51:53.555  INFO 26207 --- [           main] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.4.33
2022-05-31 15:51:53.636  INFO 26207 --- [           main] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
2022-05-31 15:51:53.802  INFO 26207 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2022-05-31 15:51:53.984  INFO 26207 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2022-05-31 15:51:54.059  INFO 26207 --- [           main] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.MySQL8Dialect
2022-05-31 15:51:55.676  INFO 26207 --- [           main] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2022-05-31 15:51:55.689  INFO 26207 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2022-05-31 15:51:56.669  INFO 26207 --- [           main] org.eclipse.jetty.server.session         : DefaultSessionIdManager workerName=node0
2022-05-31 15:51:56.669  INFO 26207 --- [           main] org.eclipse.jetty.server.session         : No SessionScavenger set, using defaults
2022-05-31 15:51:56.671  INFO 26207 --- [           main] org.eclipse.jetty.server.session         : node0 Scavenging every 600000ms
2022-05-31 15:51:56.718  INFO 26207 --- [           main] o.e.jetty.server.handler.ContextHandler  : Started o.s.b.w.e.j.JettyEmbeddedWebAppContext@d9f5fce{application,/,[file:///tmp/jetty-docbase.8090.5418095725129921593/, jar:file:/usr/local/halo/halo-1.5.3.jar!/BOOT-INF/lib/springfox-swagger-ui-3.0.0.jar!/META-INF/resources],AVAILABLE}
2022-05-31 15:51:56.718  INFO 26207 --- [           main] org.eclipse.jetty.server.Server          : Started @11003ms
2022-05-31 15:51:59.625  INFO 26207 --- [           main] run.halo.app.handler.file.FileHandlers   : Registered 9 file handler(s)
2022-05-31 15:52:01.209  INFO 26207 --- [           main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 4 endpoint(s) beneath base path '/api/admin/actuator'
2022-05-31 15:52:01.276  INFO 26207 --- [           main] o.e.j.s.h.ContextHandler.application     : Initializing Spring DispatcherServlet 'dispatcherServlet'
2022-05-31 15:52:01.276  INFO 26207 --- [           main] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2022-05-31 15:52:01.279  INFO 26207 --- [           main] o.s.web.servlet.DispatcherServlet        : Completed initialization in 3 ms
2022-05-31 15:52:01.291  INFO 26207 --- [           main] o.e.jetty.server.AbstractConnector       : Started ServerConnector@ab7a938{HTTP/1.1, (http/1.1)}{0.0.0.0:8090}
2022-05-31 15:52:01.292  INFO 26207 --- [           main] o.s.b.web.embedded.jetty.JettyWebServer  : Jetty started on port(s) 8090 (http/1.1) with context path '/'
2022-05-31 15:52:01.325  INFO 26207 --- [           main] run.halo.app.Application                 : Started Application in 14.801 seconds (JVM running for 15.61)
2022-05-31 15:52:01.326  INFO 26207 --- [           main] run.halo.app.listener.StartedListener    : Starting migrate database...
2022-05-31 15:52:01.398  INFO 26207 --- [           main] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 7.15.0 by Redgate
2022-05-31 15:52:01.399  INFO 26207 --- [           main] o.f.c.i.database.base.BaseDatabaseType   : Database: jdbc:mysql://127.0.0.1:3306/halodb (MySQL 8.0)
2022-05-31 15:52:01.443  INFO 26207 --- [           main] o.f.c.i.s.JdbcTableSchemaHistory         : Repair of failed migration in Schema History table `halodb`.`flyway_schema_history` not necessary. No failed migration detected.
2022-05-31 15:52:01.462  INFO 26207 --- [           main] o.f.core.internal.command.DbRepair       : Successfully repaired schema history table `halodb`.`flyway_schema_history` (execution time 00:00.034s).
2022-05-31 15:52:01.477  INFO 26207 --- [           main] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 7.15.0 by Redgate
2022-05-31 15:52:01.499  INFO 26207 --- [           main] o.f.core.internal.command.DbValidate     : Successfully validated 12 migrations (execution time 00:00.009s)
2022-05-31 15:52:01.511  INFO 26207 --- [           main] o.f.core.internal.command.DbMigrate      : Current version of schema `halodb`: 4
2022-05-31 15:52:01.525  INFO 26207 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `halodb` to version "5 - migrate remove notnull for email in comments table"
2022-05-31 15:52:01.619  INFO 26207 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `halodb` to version "6 - migrate create contents table"
2022-05-31 15:52:01.631 ERROR 26207 --- [           main] o.f.core.internal.command.DbMigrate      : Migration of schema `halodb` to version "6 - migrate create contents table" failed! Please restore backups and roll back database and code!
2022-05-31 15:52:01.655  INFO 26207 --- [           main] ConditionEvaluationReportLoggingListener : 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2022-05-31 15:52:01.678 ERROR 26207 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V6__migrate_create_contents_table.sql failed
------------------------------------------------------
SQL State  : 23000
Error Code : 1062
Message    : Duplicate entry '2' for key 'contents.PRIMARY'
Location   : migration/V6__migrate_create_contents_table.sql (/usr/local/halo/file:/usr/local/halo/halo-1.5.3.jar!/BOOT-INF/classes!/migration/V6__migrate_create_contents_table.sql)
Line       : 2
Statement  : -- Migrate post content to contents table
INSERT INTO contents(post_id, status, patch_log_id, head_patch_log_id, content, original_content, create_time,
                     update_time)
SELECT id,
       status,
       id,
       id,
       format_content,
       original_content,
       create_time,
       update_time
FROM posts

	at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:378) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.command.DbMigrate.lambda$applyMigrations$1(DbMigrate.java:271) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:66) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:270) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:243) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.command.DbMigrate.lambda$migrateAll$0(DbMigrate.java:141) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.database.mysql.MySQLNamedLockTemplate.execute(MySQLNamedLockTemplate.java:60) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.database.mysql.MySQLConnection.lock(MySQLConnection.java:154) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:141) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:101) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:219) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.Flyway$1.execute(Flyway.java:170) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.Flyway.execute(Flyway.java:586) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.Flyway.migrate(Flyway.java:170) ~[flyway-core-7.15.0.jar!/:na]
	at run.halo.app.listener.StartedListener.migrate(StartedListener.java:123) ~[classes!/:1.5.3]
	at run.halo.app.listener.StartedListener.onApplicationEvent(StartedListener.java:76) ~[classes!/:1.5.3]
	at run.halo.app.listener.StartedListener.onApplicationEvent(StartedListener.java:47) ~[classes!/:1.5.3]
	at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176) ~[spring-context-5.3.18.jar!/:5.3.18]
	at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169) ~[spring-context-5.3.18.jar!/:5.3.18]
	at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143) ~[spring-context-5.3.18.jar!/:5.3.18]
	at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:421) ~[spring-context-5.3.18.jar!/:5.3.18]
	at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378) ~[spring-context-5.3.18.jar!/:5.3.18]
	at org.springframework.boot.context.event.EventPublishingRunListener.started(EventPublishingRunListener.java:105) ~[spring-boot-2.5.12.jar!/:2.5.12]
	at org.springframework.boot.SpringApplicationRunListeners.lambda$started$5(SpringApplicationRunListeners.java:75) ~[spring-boot-2.5.12.jar!/:2.5.12]
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1507) ~[na:na]
	at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:117) ~[spring-boot-2.5.12.jar!/:2.5.12]
	at org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:111) ~[spring-boot-2.5.12.jar!/:2.5.12]
	at org.springframework.boot.SpringApplicationRunListeners.started(SpringApplicationRunListeners.java:75) ~[spring-boot-2.5.12.jar!/:2.5.12]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:345) ~[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 run.halo.app.Application.main(Application.java:21) ~[classes!/:1.5.3]
	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:567) ~[na:na]
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[halo-1.5.3.jar:1.5.3]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) ~[halo-1.5.3.jar:1.5.3]
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[halo-1.5.3.jar:1.5.3]
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88) ~[halo-1.5.3.jar:1.5.3]
Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException: Migration V6__migrate_create_contents_table.sql failed
------------------------------------------------------
SQL State  : 23000
Error Code : 1062
Message    : Duplicate entry '2' for key 'contents.PRIMARY'
Location   : migration/V6__migrate_create_contents_table.sql (/usr/local/halo/file:/usr/local/halo/halo-1.5.3.jar!/BOOT-INF/classes!/migration/V6__migrate_create_contents_table.sql)
Line       : 2
Statement  : -- Migrate post content to contents table
INSERT INTO contents(post_id, status, patch_log_id, head_patch_log_id, content, original_content, create_time,
                     update_time)
SELECT id,
       status,
       id,
       id,
       format_content,
       original_content,
       create_time,
       update_time
FROM posts

	at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:277) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:224) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:128) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:78) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:67) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:27) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:66) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:370) ~[flyway-core-7.15.0.jar!/:na]
	... 40 common frames omitted
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '2' for key 'contents.PRIMARY'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.28.jar!/:8.0.28]
	at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:241) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111) ~[flyway-core-7.15.0.jar!/:na]
	at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:212) ~[flyway-core-7.15.0.jar!/:na]
	... 46 common frames omitted

2022-05-31 15:52:01.698  INFO 26207 --- [           main] o.e.jetty.server.AbstractConnector       : Stopped ServerConnector@ab7a938{HTTP/1.1, (http/1.1)}{0.0.0.0:8090}
2022-05-31 15:52:01.699  INFO 26207 --- [           main] org.eclipse.jetty.server.session         : node0 Stopped scavenging
2022-05-31 15:52:01.700  INFO 26207 --- [           main] o.e.j.s.h.ContextHandler.application     : Destroying Spring FrameworkServlet 'dispatcherServlet'
2022-05-31 15:52:01.701  INFO 26207 --- [           main] o.e.jetty.server.handler.ContextHandler  : Stopped o.s.b.w.e.j.JettyEmbeddedWebAppContext@d9f5fce{application,/,[file:///tmp/jetty-docbase.8090.5418095725129921593/, jar:file:/usr/local/halo/halo-1.5.3.jar!/BOOT-INF/lib/springfox-swagger-ui-3.0.0.jar!/META-INF/resources],STOPPED}
2022-05-31 15:52:01.722  INFO 26207 --- [           main] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
2022-05-31 15:52:01.724  INFO 26207 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2022-05-31 15:52:01.732  INFO 26207 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.```

Ryan Wang 👍

v587xpt 从这个日志上来看，就是因为之前升级过 1.5，然后降级回去 1.4 了。

Ryan Wang 👍

尝试一下 halo-dev/halo1765

v587xpt

Ryan Wang 👍
感谢大佬；
在确认1.4.17正常后，我关闭了1.4.17，然后换上了1.5.3的jar包，重新启动，失败；
然后按照您所说的，删除 flyway_schema_history 表 installed_rank 字段的第7条和第8条数据，再次启动1.5.3的jar。
成功升级了；