Solved. I used the" dspace database repair" comand and now it works Thanks
Il giorno martedì 24 gennaio 2017 12:45:18 UTC+1, Massimiliano CILURZO ha scritto: > > 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 > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
