Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set script/db/notify_message_setting.groovy::2020-08-28-fix-message-data::xiangwang04@mail.com:
Reason: liquibase.exception.DatabaseException: Duplicate key name 'UK_NOTIFY_MESSAGE_SETTING_U1' [Failed SQL: CREATE INDEX UK_NOTIFY_MESSAGE_SETTING_U1 ON hzero_message.NOTIFY_MESSAGE_SETTING(NOTIFY_TYPE, CODE, PROJECT_ID, EVENT_NAME, ENV_ID)]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.Liquibase.update(Liquibase.java:214) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.Liquibase.update(Liquibase.java:192) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.Liquibase.update(Liquibase.java:188) ~[liquibase-core-3.5.5.jar!/:na]
at org.hzero.installer.liquibase.LiquibaseExecutor.load(LiquibaseExecutor.java:306) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.runToDb(LiquibaseExecutor.java:200) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
at org.hzero.installer.liquibase.LiquibaseExecutor.execute(LiquibaseExecutor.java:116) ~[hzero-installer-0.2.6.RELEASE.jar!/:0.2.6.RELEASE]
... 16 common frames omitted
Caused by: liquibase.exception.DatabaseException: Duplicate key name 'UK_NOTIFY_MESSAGE_SETTING_U1' [Failed SQL: CREATE INDEX UK_NOTIFY_MESSAGE_SETTING_U1 ON hzero_message.NOTIFY_MESSAGE_SETTING(NOTIFY_TYPE, CODE, PROJECT_ID, EVENT_NAME, ENV_ID)]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259) ~[liquibase-core-3.5.5.jar!/:na]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582) ~[liquibase-core-3.5.5.jar!/:na]
... 24 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Duplicate key name 'UK_NOTIFY_MESSAGE_SETTING_U1'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666) ~[mysql-connector-java-8.0.15.jar!/:8.0.15]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307) ~[liquibase-core-3.5.5.jar!/:na]
... 29 common frames omitted
message 会报加索引重复,造成失败,删除对应索引即可