Exception in thread "main" org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V36__add_group_member_count_history_message.sql failed

SQL State : 42S21 Error Code : 1060 Message : Duplicate column name '_history_message' Location : ./migrate/mysql/V36__add_group_member_count_history_message.sql (/opt/im-server/./migrate/mysql/V36__add_group_member_count_history_message.sql) Line : 1 Statement : alter table t_group add column _history_message tinyint NOT NULL DEFAULT 0, COMMENT "new group member can load group history messages"

at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:370)
at org.flywaydb.core.internal.command.DbMigrate.access$200(DbMigrate.java:54)
at org.flywaydb.core.internal.command.DbMigrate$3.call(DbMigrate.java:284)
at org.flywaydb.core.internal.jdbc.TransactionTemplate.execute(TransactionTemplate.java:74)
at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:281)
at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:246)
at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:54)
at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:164)
at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:161)
at org.flywaydb.core.internal.database.mysql.MySQLNamedLockTemplate.execute(MySQLNamedLockTemplate.java:60)
at org.flywaydb.core.internal.database.mysql.MySQLConnection.lock(MySQLConnection.java:147)
at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:155)
at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:161)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:139)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1395)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:1356)
at org.flywaydb.core.Flyway.execute(Flyway.java:1711)
at org.flywaydb.core.Flyway.migrate(Flyway.java:1356)
at win.liyufan.im.DBUtil.init(DBUtil.java:141)
at io.moquette.server.Server.startServer(Server.java:234)
at io.moquette.server.Server.startServer(Server.java:226)
at io.moquette.server.Server.startServer(Server.java:210)
at io.moquette.server.Server.start(Server.java:120)
at cn.wildfirechat.server.Server.main(Server.java:15)

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

SQL State : 42S21 Error Code : 1060 Message : Duplicate column name '_history_message' Location : ./migrate/mysql/V36__add_group_member_count_history_message.sql (/opt/im-server/./migrate/mysql/V36__add_group_member_count_history_message.sql) Line : 1 Statement : alter table t_group add column _history_message tinyint NOT NULL DEFAULT 0, COMMENT "new group member can load group history messages"

at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:253)
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:202)
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:125)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:77)
at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:367)
... 23 more

Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name '_history_message' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75) at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:235) at org.flywaydb.core.internal.sqlscript.StandardSqlStatement.execute(StandardSqlStatement.java:42) at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:189) ... 26 more