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.
