#java #flyway
#java #flyway
Вопрос:
Есть много более низких версий до 3.94, но запуски is пропускаются 3.1-3.93 и начинаются с 3.94… (версии 1.1,1.2,1.3,1.4,2.1 предшествуют версии 3.1 в другом модуле)
Я понятия не имею, как устранить эту ошибку..Тот же код в IDE другого коллеги работает нормально.
2019-04-16 11:49:35.795 INFO 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migrating schema `mydb` to version 1.1 - 20190222-init
2019-04-16 11:49:35.815 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_dict' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:35.846 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_menu' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:35.873 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_operate' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:35.900 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_role' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:35.921 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_role_menu' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:35.942 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_role_operate' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:36.023 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_operate_log' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:36.060 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_event_hook' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:36.089 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.gjj_notice' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:36.126 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.gjj_notice_type' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:36.161 INFO 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migrating schema `mydb` to version 1.2 - 20190222-init
2019-04-16 11:49:36.215 INFO 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migrating schema `mydb` to version 1.3 - 20190312-init
2019-04-16 11:49:36.217 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown table 'mydb.mydb_heng_i18n' (SQL State: 42S02 - Error Code: 1051)
2019-04-16 11:49:36.256 INFO 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migrating schema `mydb` to version 1.4 - 20190313-init
2019-04-16 11:49:36.269 INFO 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migrating schema `mydb` to version 2.1 - 20190311-init
2019-04-16 11:49:36.297 INFO 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migrating schema `mydb` to version 3.92 - 20190401-init
2019-04-16 11:49:36.312 INFO 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migrating schema `mydb` to version 3.93 - 20190402-init
2019-04-16 11:49:36.325 INFO 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migrating schema `mydb` to version 3.94 - 20190402-init
2019-04-16 11:49:36.329 WARN 6408 --- [ main] [] o.f.c.internal.dbsupport.JdbcTemplate : DB: Unknown column 'i18n_nid' in 'field list' (SQL State: 42S22 - Error Code: 1054)
2019-04-16 11:49:36.330 ERROR 6408 --- [ main] [] o.f.core.internal.command.DbMigrate : Migration of schema `mydb` to version 3.94 failed! Please restore backups and roll back database and code!
Комментарии:
1. Похоже, что миграция версий 3.92, 3.93, 3.94 проходит успешно.
2. Мне жаль менять вопрос на [он проходит с пропуском 3.1-3.91 и начинается с 3.92]…
3. попробуйте прежде всего очистить свою базу данных:
mvn flyway:clean
, затемmvn flyway:migrate
4. кроме того, пожалуйста, добавьте информацию в свой вопрос, выполнив следующие команды:
mvn: flyway:info
иmvn flyway:validate
.