Hello,
I'm trying to run "database migrate" on my existing dspace 5.6 database to
a new install of dspace 6.3.
database migrate succeeds in 3 updates then fails with " Unable to check
whether table "public"."schema_version" exists":
[root@rworks61 dspace]# bin/dspace database migrate
Database URL: jdbc:postgresql://dspacepg:5432/researchworks56_db
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.java:673)
at
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:576)
at
org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:221)
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:229)
at
org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81)
Caused by: org.flywaydb.core.api.FlywayException: Unable to check whether
table "public"."schema_version" exists
at org.flywaydb.core.internal.dbsupport.Table.exists(Table.java:53)
at
org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.createIfNotExists(MetaDataTableImpl.java:89)
at
org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.addAppliedMigration(MetaDataTableImpl.java:117)
at
org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:340)
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)
... 8 more
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while
sending to the backend.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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.executeQuery(PgStatement.java:224)
at
org.postgresql.jdbc.PgDatabaseMetaData.getTables(PgDatabaseMetaData.java:1249)
at
org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:645)
at
org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:645)
at org.flywaydb.core.internal.dbsupport.Table.exists(Table.java:84)
at
org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLTable.doExists(PostgreSQLTable.java:48)
at org.flywaydb.core.internal.dbsupport.Table.exists(Table.java:51)
... 21 more
Caused by: java.io.EOFException
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
database info shows the following:
Database Software: PostgreSQL version 9.4.20
Database Driver: PostgreSQL JDBC Driver version 42.2.1
PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.1)
+----------------+-----------------------------------------------------+---------------------+---------+
| 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 | Upgrade to DSpace 1.8 schema
| | <Baseln |
| 3.0 | Upgrade to DSpace 3.x schema
| | <Baseln |
| 4.0 | Initializing from DSpace 4.0 database schema |
2016-01-07 09:23:04 | Success |
| 4.9.2015.10.26 | DS-2818 registry update
| | Ignored |
| 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy |
2016-01-07 09:23:04 | Success |
| 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop constraint |
2016-01-07 09:23:06 | Success |
| 5.0.2014.09.26 | DS-1582 Metadata For All Objects |
2016-01-07 09:23:06 | Success |
| 5.6.2016.08.23 | DS-3097 |
2016-11-08 09:15:38 | Success |
| 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type id column |
2019-01-22 13:16:32 | Success |
| 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow |
2019-01-22 13:16:34 | Success |
| 6.0.2015.03.06 | DS 2701 Dso Uuid Migration |
2019-01-22 13:16:34 | Success |
| 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 |
| 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow
| | Pending |
+----------------+-----------------------------------------------------+---------------------+---------+
Any help would be greatly appreciated!
Khanh
University of Washington
--
All messages to this mailing list should adhere to the DuraSpace Code of
Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
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 dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
