java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • DSpace-CRIS Database Update Failure
    via by Sean Carte,
  • Upgrade error from DSPACE 5.3 to 5.6
    via by Massimiliano CILURZO,
  • GitHub comment 205#129602580
    via GitHub by amiri-ge
    ,
  • GitHub comment 4942#171625913
    via GitHub by Dreampie
    ,
    • java.sql.SQLException: Flyway migration error occurred at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:483) at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:391) at org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java:1378) at org.dspace.storage.rdbms.DatabaseManager.getDataSource(DatabaseManager.java:653) at org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:632) at org.dspace.core.Context.init(Context.java:145) at org.dspace.core.Context.<init>(Context.java:119) at org.dspace.storage.rdbms.DatabaseLegacyReindexer.reindex(DatabaseLegacyReindexer.java:52) at org.dspace.storage.rdbms.DatabaseLegacyReindexer.afterRepair(DatabaseLegacyReindexer.java:144) at org.flywaydb.core.internal.command.DbRepair$3.doInTransaction(DbRepair.java:114) at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) at org.flywaydb.core.internal.command.DbRepair.repair(DbRepair.java:111) at org.flywaydb.core.Flyway$6.execute(Flyway.java:994) at org.flywaydb.core.Flyway$6.execute(Flyway.java:990) at org.flywaydb.core.Flyway.execute(Flyway.java:1171) at org.flywaydb.core.Flyway.repair(Flyway.java:990) at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:217) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:78) Caused by: org.flywaydb.core.api.FlywayException: Validate failed. Found differences between applied migrations and available migrations: Migration on the classpath has not been applied to database: 3.2.1.0 at org.flywaydb.core.Flyway.doValidate(Flyway.java:912) at org.flywaydb.core.Flyway.access$400(Flyway.java:50) at org.flywaydb.core.Flyway$1.execute(Flyway.java:817) at org.flywaydb.core.Flyway$1.execute(Flyway.java:811) at org.flywaydb.core.Flyway.execute(Flyway.java:1171) at org.flywaydb.core.Flyway.migrate(Flyway.java:811) at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:472) ... 22 more

    Users with the same issue

    slash
    10 times, last one,
    Andreas Häber
    8 times, last one,
    johnxfly
    1 times, last one,
    kjhdofjosvs
    5 times, last one,
    serious2monkeys
    39 times, last one,
    23 more bugmates