I think I found my answer here:
http://sourceforge.net/p/dspace/mailman/message/33687361/
seems to be working.
On Fri, May 8, 2015 at 1:39 PM, Jose Blanco <[email protected]> wrote:
> Tim, Thanks. I just ran
>
> [dspace]/bin/dspace database migrate
>
> and I'm getting this error:
>
> Caused by: org.postgresql.util.PSQLException: ERROR: constraint
> "metadatavalue_item_id_fkey" of relation "metadatavalue" does not exist
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
> at org.
>
>
> This is what database info, tells me:
>
> | 3.0 | Upgrade to DSpace 3.x sche | |
> PreInit |
> | 4.0 | Initializing from DSpace 4 | 2015-05-08 13:23:25 |
> Success |
> | 5.0.2014.08.08 | DS-1945 Helpdesk Request a | 2015-05-08 13:23:26 |
> Success |
> | 5.0.2014.09.25 | DS 1582 Metadata For All O | |
> Pending |
> | 5.0.2014.09.26 | DS-1582 Metadata For All O | |
> Pending |
>
> I ran info before migrate and it told me what you predicted. Als, I ran
> update-sequences.sql
> before migrate. Not sure what to do from here.
>
> -Thank you! Jose
>
> On Fri, May 8, 2015 at 1:33 PM, Tim Donohue <[email protected]>
> wrote:
>
>> Hi Jose,
>>
>> Yes, those are the migration scripts themselves in the API. There are a
>> lot of them in the upgrade to 5.x, primarily to support the idea of
>> "metadata on all objects".
>>
>> You can also get a "summary" report of your database's status by running:
>>
>> [dspace]/bin/dspace database info
>>
>> This will show a list of all the database migrations (all the way back
>> to 1.0).
>>
>> Since you don't have Flyway yet enabled on the database (which happens
>> as part of the 5.x upgrade), this "info" command will note something
>> like "Your database looks to be compatible with DSpace version [#]. All
>> upgrades *after* version [#] will be run during the next migration".
>>
>> - Tim
>>
>> On 5/8/2015 11:41 AM, Jose Blanco wrote:
>> > I think I found the changes in:
>> >
>> >
>> dspace/dspace-api/target/classes/org/dspace/storage/rdbms/sqlmigration/postgres
>> >
>> > There are lots of changes.
>> >
>> > -Jose
>> >
>> > On Fri, May 8, 2015 at 12:33 PM, Jose Blanco <[email protected]
>> > <mailto:[email protected]>> wrote:
>> >
>> > I'm upgrading to version 5.2 from 4, and see that now the db
>> > upgrade is handled with flyway. Before running
>> >
>> > [dspace]/bin/dspace database migrate
>> >
>> > It would be good to see what changes are going to be done to the db.
>> > Is there a file that shows how the db will change?
>> >
>> > Thank you! Jose
>> >
>> >
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > One dashboard for servers and applications across Physical-Virtual-Cloud
>> > Widest out-of-the-box monitoring support with 50+ applications
>> > Performance metrics, stats and reports that give you Actionable Insights
>> > Deep dive visibility with transaction tracing using APM Insight.
>> > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>> >
>> >
>> >
>> > _______________________________________________
>> > DSpace-tech mailing list
>> > [email protected]
>> > https://lists.sourceforge.net/lists/listinfo/dspace-tech
>> > List Etiquette:
>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> One dashboard for servers and applications across Physical-Virtual-Cloud
>> Widest out-of-the-box monitoring support with 50+ applications
>> Performance metrics, stats and reports that give you Actionable Insights
>> Deep dive visibility with transaction tracing using APM Insight.
>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>> _______________________________________________
>> DSpace-tech mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>> List Etiquette:
>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>>
>
>
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
