Hi Karol,
Sorry for the delayed response. It looks like your DSpace database has
one (or more) non-standard "views" created that are getting in the way
of the automatic database migration process. As we have now moved to
this automatic database migration, we are unfortunately not able to
support non-standard, custom tables or views.
Specifically, the problematic custom view in this case is one called
"stats.v_workflow", which according to the error "depends on table
community column short_description". In DSpace 5, that database column
no longer exists, and all Community metadata is now stored in Dublin
Core (dc).
If you still require custom tables or views, I'd recommend creating your
own custom Flyway (http://flywaydb.org/) SQL or Java migration scripts
to manage those custom tables/views. DSpace will automatically look for
custom Flyway scripts in the following areas:
* In the [dspace]/etc/postgres/ folder (it looks for *.sql files)
* In the Java classpath under the Java package (or subpackages):
"org.dspace.storage.rdbms.migration"
I just added some additional documentation about managing custom DB
migrations (via Flyway) to our official documentation at:
https://wiki.duraspace.org/display/DSDOC5x/Storage+Layer#StorageLayer-CustomRDBMStables,columsorviews
In order to proceed with the upgrade, you likely will need to review
that custom view at least temporarily. Then the question is just whether
you need to recreate it (via a custom Flyway migration), or if your
custom DSpace can live without it.
Good luck,
Tim
On 1/10/2016 2:54 AM, Karol Sokalski wrote:
Hi everyone,
I have problem with upgrade database from DSpace 3.2 to DSpace 5.4
I using /dspace/bin/dspace database migrate
*
*
*database info *
| 3.0 | Initializing from DSpace 3 | 2016-01-10 09:45:33 |
Success |
| 4.0 | Upgrade to DSpace 4.x sche | 2016-01-10 09:45:34 |
Success |
| 5.0.2014.08.08 | DS-1945 Helpdesk Request a | 2016-01-10 09:45:35 |
Success |
| 5.0.2014.09.25 | DS 1582 Metadata For All O | 2016-01-10 09:45:35 |
Success |
*| 5.0.2014.09.26 | DS-1582 Metadata For All O | * *| Pending |*
*
*
*LOG:*
*
*
2016-01-10 09:45:40,741 ERROR
org.flywaydb.core.internal.command.DbMigrate @ Migration of schema
"public" to version 5.0.2014.09.26 failed! Changes successfully rolled
back.
2016-01-10 09:45:40,753 ERROR org.dspace.storage.rdbms.DatabaseManager
@ Failed to initialize the database:
java.sql.SQLException: Flyway migration error occurred
Caused by:
org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: Error
executing statement at line 84: alter table community drop column
introductory_text, drop column short_description, drop column
side_bar_text, drop column copyright_text, drop column name
Caused by: org.postgresql.util.PSQLException: ERROR: cannot drop table
community column short_description because other objects depend on it
Detail: view stats.v_workflow depends on table community column
short_description
Hint: Use DROP ... CASCADE to drop the dependent objects too.
*
*
--
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
--
Tim Donohue
Technical Lead for DSpace & DSpaceDirect
DuraSpace.org | DSpace.org | DSpaceDirect.org
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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.
