Hi Bill,

Some days ago, I upgraded our 5.5 instance to 5.6 and I got a similar error message when I updated our index with index-discovery: Flyway migration error occurred ..... Found differences between applied migrations and available migrations: Migration Checksum mismatch for migration"

After some Google searches, I read the advice to repair the database: dspace/bin/dspace database repair

I did so and after "index-discovery" and a tomcat restart, everything worked fine again.

I hope this is helpful for you?

Kind regards,
Marion


-----------------------------------
Marion Weber
Bibliotheks-IT
Universitäts- und Landesbibliothek Bonn
Postfach 2460, D-53014 Bonn
Tel. 0228 / 73 75 50 Fax: 0228 / 73 75 46
eMail: marion.we...@ulb.uni-bonn.de
Internet: http://www.ulb.uni-bonn.de
Twitter: http://twitter.com/ulbbonn
Facebook: http://facebook.com/ulbbonn

Am 20.10.2016 um 21:48 schrieb Bill T:
One more item worth noting: I have not enabled configurable workflow, hence cwf_workflowitem does not exist in the database!

On Thursday, October 20, 2016 at 2:32:25 PM UTC-5, Bill T wrote:

    HI all!

    I'm attempting to upgrade my 5.5 instance to 6.0rc4.  My postgres
    version is 9.5.1

    A fresh install works fine, but installing over my current v5.5
    database throws this error when I run database migrate:

    Migrating database to latest version... (Check dspace logs for
    details)
    Migration exception:
    java.sql.SQLException: Flyway migration error occurred
            at
    
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:666)
            at
    
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:574)
            at
    org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:222)
            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:229)
            at
    org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81)
    Caused by: org.flywaydb.core.api.FlywayException: Validate failed:
    Detected applied migration not resolved locally: 5.0.2014.11.04
            at org.flywaydb.core.Flyway.doValidate(Flyway.java:1008)
            at org.flywaydb.core.Flyway.access$100(Flyway.java:72)
            at org.flywaydb.core.Flyway$1.execute(Flyway.java:921)
            at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
            at org.flywaydb.core.Flyway.execute(Flyway.java:1373)
            at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
            at
    
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:655)
            ... 8 more

    This would seem to refer to:

    ...

    | 5.0.2014.11.04 | Enable XMLWorkflow Migration               |
    2016-04-07 07:45:35 | Missing |
    ...
    from database info

    for what it's worth, running database info in v5.5 yields
    ...
    | 5.0.2014.11.04 | Enable XMLWorkflow Migrati | 2016-04-07
    07:45:35 | Success |
    ...

    for the same patch.

    Any ideas anybody?
    Thanks,
    Bill

--
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com <mailto:dspace-tech+unsubscr...@googlegroups.com>. To post to this group, send email to dspace-tech@googlegroups.com <mailto:dspace-tech@googlegroups.com>.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "DSpace 
Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Reply via email to