Upgrade error from DSPACE 5.3 to 5.6

[Massimiliano CILURZO]

Dear all,

 We tried to upgrade our DSpace server to 5.6 but we have found some errors on our dspace log after  ant update.

if we run dspace database info 

+----------------+----------------------------+---------------------+---------+

| Version        | Description                | Installed on        | State   |

+----------------+----------------------------+---------------------+---------+

| 1.1            | Initial DSpace 1.1 databas |                     | PreInit |

| 1.2            | Upgrade to DSpace 1.2 sche |                     | PreInit |

| 1.3            | Upgrade to DSpace 1.3 sche |                     | PreInit |

| 1.3.9          | Drop constraint for DSpace |                     | PreInit |

| 1.4            | Upgrade to DSpace 1.4 sche |                     | PreInit |

| 1.5            | Upgrade to DSpace 1.5 sche |                     | PreInit |

| 1.5.9          | Drop constraint for DSpace |                     | PreInit |

| 1.6            | Upgrade to DSpace 1.6 sche |                     | PreInit |

| 1.7            | Upgrade to DSpace 1.7 sche |                     | PreInit |

| 1.8            | Upgrade to DSpace 1.8 sche |                     | PreInit |

| 3.0            | Upgrade to DSpace 3.x sche |                     | PreInit |

| 4.0            | Initializing from DSpace 4 | 2015-10-14 10:15:28 | Success |

| 5.0.2014.08.08 | DS-1945 Helpdesk Request a | 2015-10-14 10:15:29 | Success |

| 5.0.2014.09.25 | DS 1582 Metadata For All O | 2015-10-14 10:15:31 | Success |

| 5.0.2014.09.26 | DS-1582 Metadata For All O | 2015-10-14 10:15:31 | Success |

| 5.6.2016.08.23 | DS-3097                    |                     | Pending |

+----------------+----------------------------+---------------------+---------+

DS-3097 is pending

 

and dspace.log

2017-01-24 12:43:31,577 INFO  org.dspace.storage.rdbms.DatabaseUtils @ Pending DSpace database schema migrations:

2017-01-24 12:43:31,577 INFO  org.dspace.storage.rdbms.DatabaseUtils @  5.6.2016.08.23 DS-3097 SQL PENDING

2017-01-24 12:43:31,623 INFO  org.flywaydb.core.internal.command.DbValidate @ Validated 16 migrations (execution time 00:00.038s)

2017-01-24 12:43:31,626 ERROR org.dspace.storage.rdbms.DatabaseManager @ Failed to initialize the database:  

java.sql.SQLException: Flyway migration error occurred

        at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:430)

        at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:338)

        at org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java:1373)

        at org.dspace.storage.rdbms.DatabaseManager.getDbName(DatabaseManager.java:1491)

        at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:191)

        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 Checksum mismatch for migration V5.0_2014.08.08__DS-1945_Helpdesk_Request_a_Copy.sql: DB=-872444192, Classpath=1316176070

        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:419)

        ... 10 more

Coudl you help me?

Thanks 

Best regards

Massimiliano Cilurzo

[Massimiliano CILURZO]

Solved.

I used the" dspace database repair" comand and now it works

Thanks