Did you restart "migrating" from a fresh db_restore of the DSpace5.5 db?
And than (without starting Tomcat) do the sequence: bin/dspace database migrate then check what was done with: bin/dspace database info and eventualy continue with: bin/dspace database repair bin/dspace database migrate ignored -- Jordan Dne sreda, 31. avgust 2016 12.23.36 UTC+2 je oseba Sean Carte napisala: > > > On 31 August 2016 at 12:00, Jordan Piščanc <[email protected] > <javascript:>> wrote: > >> I have same problem with the migration from DSpace5.1 to DSpace-CRIS5.3 >> >> I solved with: >> >> bin/dspace database repair >> bin/dspace database migrate ignored >> >> Let us know if it works for you. >> > > Thanks, Jordan; unfortunately that only produces more errors: > > dspace@dspace:~$ /dspace/bin/dspace database migrate ignored > > Database URL: jdbc:postgresql://localhost:5432/dspace > Migrating database to latest version AND running previously "Ignored" > migrations... (Check logs for details) > Caught exception: > java.sql.SQLException: Flyway migration error occurred > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:483) > at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:184) > 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.internal.dbsupport.FlywaySqlScriptException: > Error executing statement at line 9: alter table cris_do_wpointer add > column urlPath varchar(255) > at > org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:91) > at > org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:73) > at > org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:287) > at > org.flywaydb.core.internal.command.DbMigrate$5.doInTransaction(DbMigrate.java:285) > at > org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) > at > org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:285) > at > org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:46) > at > org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:207) > at > org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:156) > at > org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72) > at > org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:156) > at org.flywaydb.core.Flyway$1.execute(Flyway.java:864) > 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) > ... 7 more > Caused by: org.postgresql.util.PSQLException: ERROR: relation > "cris_do_wpointer" does not exist > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) > at > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) > at > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) > at > org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) > at > org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:235) > at > org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:89) > ... 22 more > > > Sean > -- > > -- 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.
