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 <tdono...@duraspace.org> 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 <blan...@umich.edu
> > <mailto:blan...@umich.edu>> 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
> > DSpace-tech@lists.sourceforge.net
> > 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
> DSpace-tech@lists.sourceforge.net
> 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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
