Can you provide more details how you got it working? I was today doing a migration from 1.6 -> 5.6 and I got similar errors. I suspect there might be a bug in the flyway migration.
br, Ilja Sidoroff University of Helsinki, Library > On 23 Nov 2016, at 09:49, Tim GD <[email protected]> wrote: > > Finally, I modify those two views and it can be done. > > Tim GD於 2016年11月23日星期三 UTC+8上午10時45分25秒寫道： > After upgraded the dsapce from 1.6.2 to 6.0(ant update) in windows, I tried > to upgrade the database, but it exists error in database migration. > There is an error. > ERROR: cannot drop table metadatavalue column resource_id because other > objects depend on it > > When I drop the column resource_id by using cascade and migrate again, it > will say that the column resource_id does not exist. > How to solve that problem? > > The following are the command line(dspace database info & dspace database > migrate) > > C:\dspace\bin>dspace database info > Using DSpace installation in: C:\dspace > > Database Type: postgres > Database URL: jdbc:postgresql://localhost:5433/dspace > Database Schema: public > Database Username: dspace > Database Software: PostgreSQL version 9.6.0 > Database Driver: PostgreSQL Native Driver version PostgreSQL 9.4.1212.jre6 > PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3) > > +----------------+--------------------------------------------------+----------- > ----------+---------+ > | Version | Description | > Installed > on | State | > +----------------+--------------------------------------------------+----------- > ----------+---------+ > | 1.1 | Initial DSpace 1.1 database schema | > | Pending | > | 1.2 | Upgrade to DSpace 1.2 schema | > | Pending | > | 1.3 | Upgrade to DSpace 1.3 schema | > | Pending | > | 1.3.9 | Drop constraint for DSpace 1 4 schema | > | Pending | > | 1.4 | Upgrade to DSpace 1.4 schema | > | Pending | > | 1.5 | Upgrade to DSpace 1.5 schema | > | Pending | > | 1.5.9 | Drop constraint for DSpace 1 6 schema | > | Pending | > | 1.6 | Upgrade to DSpace 1.6 schema | > | Pending | > | 1.7 | Upgrade to DSpace 1.7 schema | > | Pending | > | 1.8 | Upgrade to DSpace 1.8 schema | > | Pending | > | 3.0 | Upgrade to DSpace 3.x schema | > | Pending | > | 4.0 | Upgrade to DSpace 4.x schema | > | Pending | > | 4.9.2015.10.26 | DS-2818 registry update | > | Pending | > | 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy | > | Pending | > | 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop constraint | > | Pending | > | 5.0.2014.09.26 | DS-1582 Metadata For All Objects | > | Pending | > | 5.6.2016.08.23 | DS-3097 | > | Pending | > | 6.0.2015.03.06 | DS 2701 Dso Uuid Migration | > | Pending | > | 6.0.2015.03.07 | DS-2701 Hibernate migration | > | Pending | > | 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration | > | Pending | > | 6.0.2016.01.03 | DS-3024 | > | Pending | > | 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables | > | Pending | > | 6.0.2016.02.25 | DS-3004-slow-searching-as-admin | > | Pending | > | 6.0.2016.04.01 | DS-1955 Increase embargo reason | > | Pending | > | 6.0.2016.04.04 | DS-3086-OAI-Performance-fix | > | Pending | > | 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights | > | Pending | > | 6.0.2016.05.10 | DS-3168-fix-requestitem item id column | > | Pending | > | 6.0.2016.07.21 | DS-2775 | > | Pending | > | 6.0.2016.07.26 | DS-3277 fix handle assignment | > | Pending | > | 6.0.2016.08.23 | DS-3097 | > | Pending | > +----------------+--------------------------------------------------+----------- > ----------+---------+ > > > NOTE: This database is NOT yet initialized for auto-migrations (via Flyway). > > Your database looks to be compatible with DSpace version 1.6 > All upgrades *after* version 1.6 will be run during the next migration. > > If you'd like to upgrade now, simply run 'dspace database migrate'. > > C:\dspace\bin>dspace database migrate > Using DSpace installation in: C:\dspace > > Database URL: jdbc:postgresql://localhost:5433/dspace > 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.j > ava:666) > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.j > ava:574) > at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:222) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.j > ava:229) > at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81) > Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: > Migration V6.0_2015.03.07__DS-2701_Hibernate_migration.sql failed > ----------------------------------------------------------------- > SQL State : 2BP01 > Error Code : 0 > Message : ERROR: cannot drop table metadatavalue column resource_id > because o > ther objects depend on it > Detail: view t depends on table metadatavalue column resource_id > Hint: Use DROP ... CASCADE to drop the dependent objects too. > Location : > org/dspace/storage/rdbms/sqlmigration/postgres/V6.0_2015.03.07__DS- > 2701_Hibernate_migration.sql > (C:\dspace\file:\C:\dspace\lib\dspace-api-6.0.jar!\ > org\dspace\storage\rdbms\sqlmigration\postgres\V6.0_2015.03.07__DS-2701_Hibernat > e_migration.sql) > Line : 391 > Statement : ALTER TABLE metadatavalue DROP COLUMN IF EXISTS resource_id > > at > org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java > :117) > at > org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute( > SqlMigrationExecutor.java:71) > at > org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java > :352) > at > org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.ja > va:47) > at > org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigr > ate.java:308) > at > org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran > sactionTemplate.java:72) > at > org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate > .java:305) > at > org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.ja > va:47) > at > org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr > ate.java:230) > at > org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr > ate.java:173) > at > org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran > sactionTemplate.java:72) > at > org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1 > 73) > at org.flywaydb.core.Flyway$1.execute(Flyway.java:959) > 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.j > ava:655) > ... 8 more > Caused by: org.postgresql.util.PSQLException: ERROR: cannot drop table > metadatav > alue column resource_id because other objects depend on it > Detail: view t depends on table metadatavalue column resource_id > Hint: Use DROP ... CASCADE to drop the dependent objects too. > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx > ecutorImpl.java:2455) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor > Impl.java:2155) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja > va:288) > at > org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) > > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) > at > org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303 > ) > at > org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289 > ) > at > org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266 > ) > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:262) > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatem > ent.java:291) > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatem > ent.java:291) > at > org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(Jd > bcTemplate.java:238) > at > org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java > :114) > ... 24 more > > In the dspace.log > > 2016-11-23 09:29:03,599 INFO > org.dspace.importer.external.service.ImportService @ Loading 1 import sources. > 2016-11-23 09:29:05,612 INFO org.dspace.core.LoggerServiceImpl @ Using > dspace provided log configuration (log.init.config) > 2016-11-23 09:29:05,612 INFO org.dspace.core.LoggerServiceImpl @ Loading: > C:\dspace/config/log4j.properties > 2016-11-23 09:29:06,036 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Loading Flyway DB migrations from: filesystem:C:\dspace/etc/postgres, > classpath:org.dspace.storage.rdbms.sqlmigration.postgres, > classpath:org.dspace.storage.rdbms.migration > 2016-11-23 09:29:06,081 INFO org.flywaydb.core.internal.util.VersionPrinter > @ Flyway 4.0.3 by Boxfuse > 2016-11-23 09:29:06,156 INFO > org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: > jdbc:postgresql://localhost:5433/dspace (PostgreSQL 9.6) > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Pending DSpace database schema migrations: > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.01.03 DS-3024 SQL PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.07.21 DS-2775 SQL PENDING > 2016-11-23 09:29:06,337 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING > 2016-11-23 09:29:06,338 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.08.23 DS-3097 SQL PENDING > 2016-11-23 09:29:06,440 INFO org.flywaydb.core.internal.command.DbValidate @ > Successfully validated 30 migrations (execution time 00:00.067s) > 2016-11-23 09:29:06,533 INFO org.flywaydb.core.internal.command.DbMigrate @ > Current version of schema "public": 6.0.2015.03.06 > 2016-11-23 09:29:06,533 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate > migration > 2016-11-23 09:30:18,920 ERROR org.flywaydb.core.internal.command.DbMigrate @ > Migration of schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate > migration failed! Changes successfully rolled back. > 2016-11-23 09:38:50,771 INFO > org.dspace.importer.external.service.ImportService @ Loading 1 import sources. > 2016-11-23 09:38:52,099 INFO org.dspace.core.LoggerServiceImpl @ Using > dspace provided log configuration (log.init.config) > 2016-11-23 09:38:52,100 INFO org.dspace.core.LoggerServiceImpl @ Loading: > C:\dspace/config/log4j.properties > 2016-11-23 09:38:52,584 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Loading Flyway DB migrations from: filesystem:C:\dspace/etc/postgres, > classpath:org.dspace.storage.rdbms.sqlmigration.postgres, > classpath:org.dspace.storage.rdbms.migration > 2016-11-23 09:38:52,589 INFO org.flywaydb.core.internal.util.VersionPrinter > @ Flyway 4.0.3 by Boxfuse > 2016-11-23 09:38:52,727 INFO > org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: > jdbc:postgresql://localhost:5433/dspace (PostgreSQL 9.6) > 2016-11-23 09:38:52,858 INFO > org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Repair of failed > migration in metadata table "public"."schema_version" not necessary. No > failed migration detected. > 2016-11-23 09:38:52,933 INFO org.flywaydb.core.internal.command.DbRepair @ > Successfully repaired metadata table "public"."schema_version" (execution > time 00:00.073s). > 2016-11-23 09:39:04,871 INFO > org.dspace.importer.external.service.ImportService @ Loading 1 import sources. > 2016-11-23 09:39:06,115 INFO org.dspace.core.LoggerServiceImpl @ Using > dspace provided log configuration (log.init.config) > 2016-11-23 09:39:06,115 INFO org.dspace.core.LoggerServiceImpl @ Loading: > C:\dspace/config/log4j.properties > 2016-11-23 09:39:06,838 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Loading Flyway DB migrations from: filesystem:C:\dspace/etc/postgres, > classpath:org.dspace.storage.rdbms.sqlmigration.postgres, > classpath:org.dspace.storage.rdbms.migration > 2016-11-23 09:39:06,993 INFO org.flywaydb.core.internal.util.VersionPrinter > @ Flyway 4.0.3 by Boxfuse > 2016-11-23 09:39:07,095 INFO > org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: > jdbc:postgresql://localhost:5433/dspace (PostgreSQL 9.6) > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Pending DSpace database schema migrations: > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.01.03 DS-3024 SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.07.21 DS-2775 SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING > 2016-11-23 09:39:08,688 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.08.23 DS-3097 SQL PENDING > 2016-11-23 09:39:08,778 INFO org.flywaydb.core.internal.command.DbValidate @ > Successfully validated 30 migrations (execution time 00:00.043s) > 2016-11-23 09:39:08,906 INFO org.flywaydb.core.internal.command.DbMigrate @ > Current version of schema "public": 6.0.2015.03.06 > 2016-11-23 09:39:08,906 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate > migration > 2016-11-23 09:40:26,973 ERROR org.flywaydb.core.internal.command.DbMigrate @ > Migration of schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate > migration failed! Changes successfully rolled back. > 2016-11-23 09:50:28,065 INFO > org.dspace.importer.external.service.ImportService @ Loading 1 import sources. > 2016-11-23 09:50:29,531 INFO org.dspace.core.LoggerServiceImpl @ Using > dspace provided log configuration (log.init.config) > 2016-11-23 09:50:29,531 INFO org.dspace.core.LoggerServiceImpl @ Loading: > C:\dspace/config/log4j.properties > 2016-11-23 09:50:30,104 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Loading Flyway DB migrations from: filesystem:C:\dspace/etc/postgres, > classpath:org.dspace.storage.rdbms.sqlmigration.postgres, > classpath:org.dspace.storage.rdbms.migration > 2016-11-23 09:50:30,150 INFO org.flywaydb.core.internal.util.VersionPrinter > @ Flyway 4.0.3 by Boxfuse > 2016-11-23 09:50:30,256 INFO > org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: > jdbc:postgresql://localhost:5433/dspace (PostgreSQL 9.6) > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Pending DSpace database schema migrations: > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.01.03 DS-3024 SQL PENDING > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING > 2016-11-23 09:50:30,506 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING > 2016-11-23 09:50:30,507 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING > 2016-11-23 09:50:30,507 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.07.21 DS-2775 SQL PENDING > 2016-11-23 09:50:30,507 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING > 2016-11-23 09:50:30,507 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.08.23 DS-3097 SQL PENDING > 2016-11-23 09:50:30,552 INFO org.flywaydb.core.internal.command.DbValidate @ > Successfully validated 30 migrations (execution time 00:00.022s) > 2016-11-23 09:50:30,675 INFO org.flywaydb.core.internal.command.DbMigrate @ > Current version of schema "public": 6.0.2015.03.06 > 2016-11-23 09:50:30,676 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate > migration > 2016-11-23 09:50:31,185 ERROR org.flywaydb.core.internal.command.DbMigrate @ > Migration of schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate > migration failed! Changes successfully rolled back. > 2016-11-23 10:18:04,418 INFO > org.dspace.importer.external.service.ImportService @ Loading 1 import sources. > 2016-11-23 10:18:06,262 INFO org.dspace.core.LoggerServiceImpl @ Using > dspace provided log configuration (log.init.config) > 2016-11-23 10:18:06,262 INFO org.dspace.core.LoggerServiceImpl @ Loading: > C:\dspace/config/log4j.properties > 2016-11-23 10:18:06,824 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Loading Flyway DB migrations from: filesystem:C:\dspace/etc/postgres, > classpath:org.dspace.storage.rdbms.sqlmigration.postgres, > classpath:org.dspace.storage.rdbms.migration > 2016-11-23 10:18:07,000 INFO org.flywaydb.core.internal.util.VersionPrinter > @ Flyway 4.0.3 by Boxfuse > 2016-11-23 10:18:07,097 INFO > org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: > jdbc:postgresql://localhost:5433/dspace (PostgreSQL 9.6) > 2016-11-23 10:18:33,337 INFO > org.dspace.importer.external.service.ImportService @ Loading 1 import sources. > 2016-11-23 10:18:34,688 INFO org.dspace.core.LoggerServiceImpl @ Using > dspace provided log configuration (log.init.config) > 2016-11-23 10:18:34,688 INFO org.dspace.core.LoggerServiceImpl @ Loading: > C:\dspace/config/log4j.properties > 2016-11-23 10:18:35,404 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Loading Flyway DB migrations from: filesystem:C:\dspace/etc/postgres, > classpath:org.dspace.storage.rdbms.sqlmigration.postgres, > classpath:org.dspace.storage.rdbms.migration > 2016-11-23 10:18:35,535 INFO org.flywaydb.core.internal.util.VersionPrinter > @ Flyway 4.0.3 by Boxfuse > 2016-11-23 10:18:35,653 INFO > org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: > jdbc:postgresql://localhost:5433/dspace (PostgreSQL 9.6) > 2016-11-23 10:18:36,446 INFO > org.flywaydb.core.internal.metadatatable.MetaDataTableImpl @ Creating > Metadata table: "public"."schema_version" > 2016-11-23 10:18:36,629 INFO org.flywaydb.core.internal.command.DbBaseline @ > Successfully baselined schema with version: 1.6 > 2016-11-23 10:18:36,822 INFO org.dspace.storage.rdbms.DatabaseUtils @ > Pending DSpace database schema migrations: > 2016-11-23 10:18:36,822 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 1.7 Upgrade to DSpace 1.7 schema SQL PENDING > 2016-11-23 10:18:36,822 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 1.8 Upgrade to DSpace 1.8 schema SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 3.0 Upgrade to DSpace 3.x schema SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 4.0 Upgrade to DSpace 4.x schema SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 4.9.2015.10.26 DS-2818 registry update SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 5.0.2014.08.08 DS-1945 Helpdesk Request a Copy SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 5.0.2014.09.25 DS 1582 Metadata For All Objects drop constraint JDBC PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 5.0.2014.09.26 DS-1582 Metadata For All Objects SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 5.6.2016.08.23 DS-3097 SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.03.06 DS 2701 Dso Uuid Migration JDBC PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.01.03 DS-3024 SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING > 2016-11-23 10:18:36,823 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING > 2016-11-23 10:18:36,824 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING > 2016-11-23 10:18:36,824 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING > 2016-11-23 10:18:36,824 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING > 2016-11-23 10:18:36,824 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.07.21 DS-2775 SQL PENDING > 2016-11-23 10:18:36,824 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING > 2016-11-23 10:18:36,824 INFO org.dspace.storage.rdbms.DatabaseUtils @ > 6.0.2016.08.23 DS-3097 SQL PENDING > 2016-11-23 10:18:36,918 INFO org.flywaydb.core.internal.command.DbValidate @ > Successfully validated 30 migrations (execution time 00:00.073s) > 2016-11-23 10:18:36,995 INFO org.flywaydb.core.internal.command.DbMigrate @ > Current version of schema "public": 1.6 > 2016-11-23 10:18:36,995 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 1.7 - Upgrade to DSpace 1.7 schema > 2016-11-23 10:18:37,084 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 1.8 - Upgrade to DSpace 1.8 schema > 2016-11-23 10:18:37,884 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 3.0 - Upgrade to DSpace 3.x schema > 2016-11-23 10:18:38,196 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 4.0 - Upgrade to DSpace 4.x schema > 2016-11-23 10:18:38,623 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 4.9.2015.10.26 - DS-2818 registry update > 2016-11-23 10:18:38,688 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 5.0.2014.08.08 - DS-1945 Helpdesk > Request a Copy > 2016-11-23 10:18:38,767 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 5.0.2014.09.25 - DS 1582 Metadata For > All Objects drop constraint > 2016-11-23 10:18:38,789 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 5.0.2014.09.26 - DS-1582 Metadata For > All Objects > 2016-11-23 10:18:50,970 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 5.6.2016.08.23 - DS-3097 > 2016-11-23 10:18:51,016 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 6.0.2015.03.06 - DS 2701 Dso Uuid > Migration > 2016-11-23 10:18:51,189 INFO org.flywaydb.core.internal.command.DbMigrate @ > Migrating schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate > migration > 2016-11-23 10:20:18,188 ERROR org.flywaydb.core.internal.command.DbMigrate @ > Migration of schema "public" to version 6.0.2015.03.07 - DS-2701 Hibernate > migration failed! Changes successfully rolled back. > > > -- > 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. -- 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.
