C:\dspace\bin>dspace database info
Using DSpace installation in: C:\dspace

Database Type: postgres
Database URL: jdbc:postgresql://localhost:5432/dspace
Database Schema: public
Database Username: dspace
Database Software: PostgreSQL version 9.6.24
Database Driver: PostgreSQL JDBC Driver version 42.2.1
PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3)

+----------------+-----------------------------------------------------+---------------------+---------+
| Version        | Description                                         | Installed on        | State   |
+----------------+-----------------------------------------------------+---------------------+---------+
| 1.1            | Initial DSpace 1.1 database schema                  |                     | <Baseln |
| 1.2            | Upgrade to DSpace 1.2 schema                        |                     | <Baseln |
| 1.3            | Upgrade to DSpace 1.3 schema                        |                     | <Baseln |
| 1.3.9          | Drop constraint for DSpace 1 4 schema               |                     | <Baseln |
| 1.4            | Upgrade to DSpace 1.4 schema                        |                     | <Baseln |
| 1.5            | Upgrade to DSpace 1.5 schema                        |                     | <Baseln |
| 1.5.9          | Drop constraint for DSpace 1 6 schema               |                     | <Baseln |
| 1.6            | Upgrade to DSpace 1.6 schema                        |                     | <Baseln |
| 1.7            | Upgrade to DSpace 1.7 schema                        |                     | <Baseln |
| 1.8            | Initializing from DSpace 1.8 database schema        | 2016-12-01 08:35:37 | Success |
| 3.0            | Upgrade to DSpace 3.x schema                        | 2016-12-01 08:35:37 | Success |
| 4.0            | Upgrade to DSpace 4.x schema                        | 2016-12-01 08:35:38 | Success |
| 4.9.2015.10.26 | DS-2818 registry update                             | 2016-12-01 08:35:38 | Success |
| 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy                     | 2016-12-01 08:35:38 | Success |
| 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop constraint    | 2016-12-01 08:35:38 | Success |
| 5.0.2014.09.26 | DS-1582 Metadata For All Objects                    | 2016-12-01 08:35:38 | Success |
| 5.6.2016.08.23 | DS-3097                                             | 2016-12-01 08:35:44 | Success |
| 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type id column |                     | Ignored |
| 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow              |                     | Ignored |
| 6.0.2015.03.06 | DS 2701 Dso Uuid Migration                          | 2016-12-01 08:35:44 | Success |
| 6.0.2015.03.07 | DS-2701 Hibernate migration                         | 2016-12-01 08:35:44 | Success |
| 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration                | 2016-12-01 08:36:14 | Success |
| 6.0.2016.01.03 | DS-3024                                             | 2016-12-01 08:36:14 | Success |
| 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables                   | 2016-12-01 08:36:15 | Success |
| 6.0.2016.02.25 | DS-3004-slow-searching-as-admin                     | 2016-12-01 08:36:15 | Success |
| 6.0.2016.04.01 | DS-1955 Increase embargo reason                     | 2016-12-01 08:36:15 | Success |
| 6.0.2016.04.04 | DS-3086-OAI-Performance-fix                         | 2016-12-01 08:36:15 | Success |
| 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights          | 2016-12-01 08:36:15 | Success |
| 6.0.2016.05.10 | DS-3168-fix-requestitem item id column              | 2016-12-01 08:36:15 | Success |
| 6.0.2016.07.21 | DS-2775                                             | 2016-12-01 08:36:15 | Success |
| 6.0.2016.07.26 | DS-3277 fix handle assignment                       | 2016-12-01 08:36:15 | Success |
| 6.0.2016.08.23 | DS-3097                                             | 2016-12-01 08:36:15 | Success |
| 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow              | 2018-11-13 08:28:14 | Success |
+----------------+-----------------------------------------------------+---------------------+---------+


C:\dspace\bin>dspace database migrate ignored
Using DSpace installation in: C:\dspace

Database URL: jdbc:postgresql://localhost:5432/dspace
Migrating database to latest version AND running previously "Ignored" migrations... (Check logs for details)
Migration exception:
java.sql.SQLException: Flyway migration error occurred
        at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:673)
        at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:187)
        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.java:229)
        at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81)
Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration V5.7_2017.04.11__DS-3563_Index_metadatavalue_resource_type_id_column.sql failed
-----------------------------------------------------------------------------------------
SQL State  : 42703
Error Code : 0
Message    : ERROR: column "resource_type_id" does not exist
Location   : org/dspace/storage/rdbms/sqlmigration/postgres/V5.7_2017.04.11__DS-3563_Index_metadatavalue_resource_type_id_column.sql (C:\dspace\file:\C:\dspace\lib\dspace-api-6.3.jar!\org\dspace\storage\rdbms\sqlmigration\postgres\V5.7_2017.04.11__DS-3563_Index_metadatavalue_resource_type_id_column.sql)
Line       : 16
Statement  : CREATE INDEX metadatavalue_resource_type_id_idx ON metadatavalue (resource_type_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.java:47)
        at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigrate.java:308)
        at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
        at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:305)
        at org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.java:47)
        at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:230)
        at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:173)
        at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
        at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:173)
        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.java:662)
        ... 7 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "resource_type_id" does not exist
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
        at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
        at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
        at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)
        at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:238)
        at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:114)
        ... 23 more

C:\dspace\bin>