Re: [dspace-tech] DSpace-CRIS Database Update Failure

Tue, 30 Aug 2016 06:59:46 -0700 

Hi Sean,
In the version of Flyway (3.x) used by DSpace 5.5, a validation error ("Caused by: org.flywaydb.core.api.FlywayException: Validate failed.") often is the result of running migrations from different OSes (e.g. Ubuntu vs Mac vs Windows) or sometimes even different servers. When Flyway "validates" a migration, it just generates a checksum from the validation file. Unfortunately, in this version of Flyway, the checksum generated was different based on the operating system, etc. 


In any case, this error is usually something that can be safely 
ignored/corrected.  To tell Flyway to ignore the validation issues and 
update the checksums, simply run:


[dspace]/bin/dspace database repair


This runs a "repair" in Flyway, which just regenerates the checksums of 
all migrations on the current server. It will ensure validation should 
no longer fail on this server in the future.



After running the "repair", you should be able to rerun the migrations 
successfully.



As a sidenote, in Flyway 4 (which we are upgrading to in DSpace 6), this 
issue is resolved. They've figured out a better way to generate these 
checksums so that they are now supposedly the same cross-platform.  So, 
hopefully this sort of validation issue will happen less in the future.


- Tim


On 8/30/2016 7:34 AM, Sean Carte wrote:

I'm trying to update a standard DSpace 5.5 installation into a 
DSpace-CRIS installation. But problems arise after tomcat is started, 
during the flyway db update.


I'm running this on Ubuntu 16.04, PostgreSQL 9.5, Tomcat 7, OpenJDK 1.8.

Any suggestions on how I can get around this?

The steps I took and the dspace log are copied below.


I downloaded the source code from 
https://github.com/Cineca/DSpace/tree/dspace-cris-5.5.0


dspace@dspace:~/DSpace-dspace-cris-5.5.0$ mvn -U clean package
 ...
[INFO] BUILD SUCCESS
...

dspace@dspace:~/DSpace-dspace-cris-5.5.0$ cd 
dspace/target/dspace-installer/
dspace@dspace:~/DSpace-dspace-cris-5.5.0/dspace/target/dspace-installer$ 
ant update

...
BUILD SUCCESSFUL
Total time: 1 minute 1 second

dspace@dspace:~/DSpace-dspace-cris-5.5.0/dspace/target/dspace-installer$ 
cd /dspace/

dspace@dspace:/dspace$ mkdir rp-files
dspace@dspace:/dspace$ mkdir rg-files
dspace@dspace:/dspace$ mkdir ou-files
dspace@dspace:/dspace$ mkdir do-files
dspace@dspace:/dspace$ mkdir ws-xsd

dspace@dspace:/dspace$ cp -r 
/home/dspace/DSpace-dspace-cris-5.5.0/dspace/etc/webservice/* ws-xsd/

dspace@dspace:/dspace$ logout
root@dspace:~# service tomcat7 restart

root@dspace:~# tail -f /dspace/log/dspace.log.2016-08-30

2016-08-30 13:19:12,014 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Loading F
lyway DB migrations from: filesystem:/dspace/etc/postgres, 
classpath:org.dspace.
storage.rdbms.sqlmigration.postgres, 
classpath:org.dspace.storage.rdbms.migratio

n

2016-08-30 13:19:12,145 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
DSpace da

tabase schema is up to date

2016-08-30 13:19:31,044 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS is

 'PostgreSQL'

2016-08-30 13:19:31,046 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS dr

iver version is '9.5.4'

2016-08-30 13:19:31,078 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Loading F
lyway DB migrations from: filesystem:/dspace/etc/postgres, 
classpath:org.dspace.
storage.rdbms.sqlmigration.postgres, 
classpath:org.dspace.storage.rdbms.migratio

n

2016-08-30 13:19:31,109 INFO 
org.flywaydb.core.internal.dbsupport.DbSupportFact

ory @ Database: jdbc:postgresql://localhost:5432/dspace (PostgreSQL 9.5)

2016-08-30 13:19:31,179 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
DSpace da

tabase schema is up to date

2016-08-30 13:19:33,861 INFO org.dspace.content.MetadataSchema @ 
Loading schema

 cache for fast finds

2016-08-30 13:19:33,889 INFO org.dspace.content.MetadataField @ 
Loading Metadat

aField elements into cache.

2016-08-30 13:19:34,522 INFO 
org.dspace.app.xmlui.aspect.artifactbrowser.Commun
ityBrowser @ 
anonymous:session_id=E5A4709B5B44D932EBB86F788B2F03CE:ip_addr=10.0.

36.134:view_community_list:

2016-08-30 13:19:34,536 INFO 
org.dspace.app.xmlui.aspect.discovery.SidebarFacet

sTransformer @ facets for scope, null: 3

2016-08-30 13:56:41,449 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS is

 'PostgreSQL'

2016-08-30 13:56:41,452 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS dr

iver version is '9.5.4'

2016-08-30 13:56:41,494 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Loading F
lyway DB migrations from: filesystem:/dspace/etc/postgres, 
classpath:org.dspace.
storage.rdbms.sqlmigration.postgres, 
classpath:org.dspace.storage.rdbms.migratio

n

2016-08-30 13:56:41,573 INFO 
org.flywaydb.core.internal.dbsupport.DbSupportFact

ory @ Database: jdbc:postgresql://localhost:5432/dspace (PostgreSQL 9.5)

2016-08-30 13:56:41,721 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Pending DSpace database schema migrations:
2016-08-30 13:56:41,722 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.4.0.0

DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING

2016-08-30 13:56:41,722 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.4.0.1

DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING

2016-08-30 13:56:41,759 INFO 
org.flywaydb.core.internal.command.DbValidate @ Va

lidated 32 migrations (execution time 00:00.030s)

2016-08-30 13:56:41,761 ERROR org.dspace.storage.rdbms.DatabaseManager 
@ SQL get

DataSource Error -
java.sql.SQLException: Flyway migration error occurred

        at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.j

ava:483)

        at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.j

ava:391)

        at 
org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.j

ava:1378)

        at 
org.dspace.storage.rdbms.DatabaseManager.getDataSource(DatabaseManage

r.java:653)

        at 
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManage

r.java:632)
        at org.dspace.core.Context.init(Context.java:145)
        at org.dspace.core.Context.<init>(Context.java:119)

        at 
org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebap

p.java:80)

        at 
org.dspace.app.util.DSpaceContextListener.contextInitialized(DSpaceCo

ntextListener.java:128)

        at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContex

t.java:5068)

        at 
org.apache.catalina.core.StandardContext.startInternal(StandardContex

t.java:5584)

        at 
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
        at 
org.apache.catalina.startup.HostConfig.reload(HostConfig.java:1547)
        at 
org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java

:1511)

        at 
org.apache.catalina.startup.HostConfig.check(HostConfig.java:1744)
        at 
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java

:333)

        at 
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl

eSupport.java:117)

        at 
org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBa

se.java:90)

        at 
org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBas

e.java:1371)

        at 
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.p

rocessChildren(ContainerBase.java:1543)

        at 
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.p

rocessChildren(ContainerBase.java:1553)

        at 
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1521)

        at java.lang.Thread.run(Thread.java:745)

Caused by: org.flywaydb.core.api.FlywayException: Validate failed. 
Found differe
nces between applied migrations and available migrations: Migration on 
the class

path has not been applied to database: 3.2.1.0
        at org.flywaydb.core.Flyway.doValidate(Flyway.java:912)
        at org.flywaydb.core.Flyway.access$400(Flyway.java:50)
        at org.flywaydb.core.Flyway$1.execute(Flyway.java:817)
        at org.flywaydb.core.Flyway$1.execute(Flyway.java:811)
        at org.flywaydb.core.Flyway.execute(Flyway.java:1171)
        at org.flywaydb.core.Flyway.migrate(Flyway.java:811)

        at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.j

ava:472)
        ... 22 more

2016-08-30 13:57:26,647 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS is

 'PostgreSQL'

2016-08-30 13:57:26,650 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS dr

iver version is '9.5.4'

2016-08-30 13:57:26,687 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Loading F
lyway DB migrations from: filesystem:/dspace/etc/postgres, 
classpath:org.dspace.
storage.rdbms.sqlmigration.postgres, 
classpath:org.dspace.storage.rdbms.migratio

n

2016-08-30 13:57:26,724 INFO 
org.flywaydb.core.internal.dbsupport.DbSupportFact

ory @ Database: jdbc:postgresql://localhost:5432/dspace (PostgreSQL 9.5)

2016-08-30 13:57:26,870 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Pending D

Space database schema migrations:

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.0.0

DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.0.1

FIX-SNAPSHOT-DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.0.2

DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.0.3

DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.0.4

DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.0.5

DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.0.6

DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.1.0

DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING

2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.3.1.1 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.4.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 13:57:26,871 INFO org.dspace.storage.rdbms.DatabaseUtils @  
5.4.0.1 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 13:57:26,954 INFO 
org.flywaydb.core.internal.command.DbValidate @ Va

lidated 32 migrations (execution time 00:00.062s)

2016-08-30 13:57:26,955 ERROR org.dspace.storage.rdbms.DatabaseManager 
@ SQL get

DataSource Error -
java.sql.SQLException: Flyway migration error occurred

        at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.j

ava:483)

        at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.j

ava:391)

        at 
org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.j

ava:1378)

        at 
org.dspace.storage.rdbms.DatabaseManager.getDataSource(DatabaseManage

r.java:653)

        at 
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManage

r.java:632)
        at org.dspace.core.Context.init(Context.java:145)
        at org.dspace.core.Context.<init>(Context.java:119)

        at 
org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebap

p.java:80)

        at 
org.dspace.app.util.DSpaceContextListener.contextInitialized(DSpaceCo

ntextListener.java:128)

        at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContex

t.java:5068)

        at 
org.apache.catalina.core.StandardContext.startInternal(StandardContex

t.java:5584)

        at 
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
        at 
org.apache.catalina.startup.HostConfig.reload(HostConfig.java:1547)
        at 
org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java

:1511)

        at 
org.apache.catalina.startup.HostConfig.check(HostConfig.java:1744)
        at 
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java

:333)

        at 
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl

eSupport.java:117)

        at 
org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBa

se.java:90)

        at 
org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBas

e.java:1371)

        at 
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.p

rocessChildren(ContainerBase.java:1543)

        at 
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.p

rocessChildren(ContainerBase.java:1553)

        at 
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.r

un(ContainerBase.java:1521)
    at java.lang.Thread.run(Thread.java:745)

Caused by: org.flywaydb.core.api.FlywayException: Validate failed. 
Found differences between applied migrations and available migrations: 
Migration on the classpath has not been applied to database: 3.2.1.0

    at org.flywaydb.core.Flyway.doValidate(Flyway.java:912)
    at org.flywaydb.core.Flyway.access$400(Flyway.java:50)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:817)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:811)
    at org.flywaydb.core.Flyway.execute(Flyway.java:1171)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:811)

    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:472)

    ... 22 more

2016-08-30 13:58:31,489 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS is 'PostgreSQL'
2016-08-30 13:58:31,493 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS driver version is '9.5.4'
2016-08-30 13:58:31,563 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Loading Flyway DB migrations from: filesystem:/dspace/etc/postgres, 
classpath:org.dspace.storage.rdbms.sqlmigration.postgres, 
classpath:org.dspace.storage.rdbms.migration
2016-08-30 13:58:31,605 INFO 
org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: 
jdbc:postgresql://localhost:5432/dspace (PostgreSQL 9.5)
2016-08-30 13:58:31,837 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Pending DSpace database schema migrations:
2016-08-30 13:58:31,838 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,838 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.1 FIX-SNAPSHOT-DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,838 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.2 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,838 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.3 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,838 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.4 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,839 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.5 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,839 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.6 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,839 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.1.0 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,839 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.1.1 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:58:31,839 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.4.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 13:58:31,839 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.4.0.1 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 13:58:31,882 INFO 
org.flywaydb.core.internal.command.DbValidate @ Validated 32 
migrations (execution time 00:00.038s)
2016-08-30 13:58:31,884 ERROR org.dspace.storage.rdbms.DatabaseManager 
@ SQL getDataSource Error -

java.sql.SQLException: Flyway migration error occurred

    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:483)
    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:391)
    at 
org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java:1378)
    at 
org.dspace.storage.rdbms.DatabaseManager.getDataSource(DatabaseManager.java:653)
    at 
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:632)

    at org.dspace.core.Context.init(Context.java:145)
    at org.dspace.core.Context.<init>(Context.java:119)

    at 
org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:80)
    at 
org.dspace.app.util.DSpaceContextListener.contextInitialized(DSpaceContextListener.java:128)
    at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5068)
    at 
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584)
    at 
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
    at 
org.apache.catalina.core.ContainerBase.access$000(ContainerBase.java:133)
    at 
org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:156)
    at 
org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:145)

    at java.security.AccessController.doPrivileged(Native Method)

    at 
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
    at 
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at 
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
    at 
org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1962)
    at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

    at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

    at java.lang.Thread.run(Thread.java:745)

Caused by: org.flywaydb.core.api.FlywayException: Validate failed. 
Found differences between applied migrations and available migrations: 
Migration on the classpath has not been applied to database: 3.2.1.0

    at org.flywaydb.core.Flyway.doValidate(Flyway.java:912)
    at org.flywaydb.core.Flyway.access$400(Flyway.java:50)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:817)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:811)
    at org.flywaydb.core.Flyway.execute(Flyway.java:1171)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:811)

    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:472)

    ... 25 more

2016-08-30 13:59:14,609 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS is 'PostgreSQL'
2016-08-30 13:59:14,613 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS driver version is '9.5.4'
2016-08-30 13:59:14,656 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Loading Flyway DB migrations from: filesystem:/dspace/etc/postgres, 
classpath:org.dspace.storage.rdbms.sqlmigration.postgres, 
classpath:org.dspace.storage.rdbms.migration
2016-08-30 13:59:14,695 INFO 
org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: 
jdbc:postgresql://localhost:5432/dspace (PostgreSQL 9.5)
2016-08-30 13:59:14,802 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Pending DSpace database schema migrations:
2016-08-30 13:59:14,803 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,808 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.1 FIX-SNAPSHOT-DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,809 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.2 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,809 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.3 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,809 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.4 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,809 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.5 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,809 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.6 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,810 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.1.0 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,810 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.1.1 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 13:59:14,810 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.4.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 13:59:14,810 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.4.0.1 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 13:59:14,880 INFO 
org.flywaydb.core.internal.command.DbValidate @ Validated 32 
migrations (execution time 00:00.057s)
2016-08-30 13:59:14,885 ERROR org.dspace.storage.rdbms.DatabaseManager 
@ SQL getDataSource Error -

java.sql.SQLException: Flyway migration error occurred

    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:483)
    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:391)
    at 
org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java:1378)
    at 
org.dspace.storage.rdbms.DatabaseManager.getDataSource(DatabaseManager.java:653)
    at 
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:632)

    at org.dspace.core.Context.init(Context.java:145)
    at org.dspace.core.Context.<init>(Context.java:119)

    at 
org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:80)
    at 
org.dspace.app.util.DSpaceContextListener.contextInitialized(DSpaceContextListener.java:128)
    at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5068)
    at 
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584)
    at 
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
    at 
org.apache.catalina.core.ContainerBase.access$000(ContainerBase.java:133)
    at 
org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:156)
    at 
org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:145)

    at java.security.AccessController.doPrivileged(Native Method)

    at 
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
    at 
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at 
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
    at 
org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1962)
    at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

    at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

    at java.lang.Thread.run(Thread.java:745)

Caused by: org.flywaydb.core.api.FlywayException: Validate failed. 
Found differences between applied migrations and available migrations: 
Migration on the classpath has not been applied to database: 3.2.1.0

    at org.flywaydb.core.Flyway.doValidate(Flyway.java:912)
    at org.flywaydb.core.Flyway.access$400(Flyway.java:50)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:817)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:811)
    at org.flywaydb.core.Flyway.execute(Flyway.java:1171)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:811)

    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:472)

    ... 25 more

2016-08-30 14:00:04,741 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Loading Flyway DB migrations from: filesystem:/dspace/etc/postgres, 
classpath:org.dspace.storage.rdbms.sqlmigration.postgres, 
classpath:org.dspace.storage.rdbms.migration
2016-08-30 14:00:04,913 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Pending DSpace database schema migrations:
2016-08-30 14:00:04,913 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,913 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.1 FIX-SNAPSHOT-DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,913 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.2 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,913 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.3 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,913 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.4 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,913 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.5 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,914 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.6 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,914 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.1.0 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,914 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.1.1 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:04,914 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.4.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 14:00:04,914 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.4.0.1 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 14:00:58,914 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS is 'PostgreSQL'
2016-08-30 14:00:58,917 INFO org.dspace.storage.rdbms.DatabaseManager 
@ DBMS driver version is '9.5.4'
2016-08-30 14:00:58,959 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Loading Flyway DB migrations from: filesystem:/dspace/etc/postgres, 
classpath:org.dspace.storage.rdbms.sqlmigration.postgres, 
classpath:org.dspace.storage.rdbms.migration
2016-08-30 14:00:58,996 INFO 
org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: 
jdbc:postgresql://localhost:5432/dspace (PostgreSQL 9.5)
2016-08-30 14:00:59,226 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
Pending DSpace database schema migrations:
2016-08-30 14:00:59,227 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,228 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.1 FIX-SNAPSHOT-DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,228 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.2 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,228 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.3 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,228 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.4 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,229 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.5 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,229 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.0.6 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,229 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.1.0 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,229 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.3.1.1 DSpaceCRIS-Upgrade-crismodule 5 to 53 SQL PENDING
2016-08-30 14:00:59,229 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.4.0.0 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 14:00:59,229 INFO org.dspace.storage.rdbms.DatabaseUtils @ 
    5.4.0.1 DSpaceCRIS-Upgrade-crismodule 5 to 54 SQL PENDING
2016-08-30 14:00:59,289 INFO 
org.flywaydb.core.internal.command.DbValidate @ Validated 32 
migrations (execution time 00:00.054s)
2016-08-30 14:00:59,291 ERROR org.dspace.storage.rdbms.DatabaseManager 
@ SQL getDataSource Error -

java.sql.SQLException: Flyway migration error occurred

    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:483)
    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:391)
    at 
org.dspace.storage.rdbms.DatabaseManager.initialize(DatabaseManager.java:1378)
    at 
org.dspace.storage.rdbms.DatabaseManager.getDataSource(DatabaseManager.java:653)
    at 
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:632)

    at org.dspace.core.Context.init(Context.java:145)
    at org.dspace.core.Context.<init>(Context.java:119)

    at 
org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:80)
    at 
org.dspace.app.util.DSpaceContextListener.contextInitialized(DSpaceContextListener.java:128)
    at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5068)
    at 
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584)
    at 
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
    at 
org.apache.catalina.core.ContainerBase.access$000(ContainerBase.java:133)
    at 
org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:156)
    at 
org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:145)

    at java.security.AccessController.doPrivileged(Native Method)

    at 
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
    at 
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at 
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
    at 
org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1962)
    at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

    at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

    at java.lang.Thread.run(Thread.java:745)

Caused by: org.flywaydb.core.api.FlywayException: Validate failed. 
Found differences between applied migrations and available migrations: 
Migration on the classpath has not been applied to database: 3.2.1.0

    at org.flywaydb.core.Flyway.doValidate(Flyway.java:912)
    at org.flywaydb.core.Flyway.access$400(Flyway.java:50)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:817)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:811)
    at org.flywaydb.core.Flyway.execute(Flyway.java:1171)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:811)

    at 
org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:472)

    ... 25 more
^C

Sean
--

--

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

--
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.






















					Reply via email to