database migration flyway failed
365 views
Skip to first unread message
christian criollo
Mar 14, 2017, 6:00:07 PM3/14/17
to DSpace Technical Support
Hi all
I am trying to upgrade my dspace instance from 4.0 to 6.0 . the
problem is: when I start tomcat, the flyway failed in this point:
Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: ValidateObject failed
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1008)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
... 19 more
2017-03-14 16:36:53,842 INFO org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from: filesystem:/home/dspace/bibdigital/etc/oracle, classpath:org.dspace.storage.rdbms.sqlmigration.oracle, classpath:org.dspace.storage.rdbms.migration
2017-03-14 16:36:53,956 INFO org.flywaydb.core.internal.util.VersionPrinter @ Flyway 4.0.3 by Boxfuse
2017-03-14 16:36:53,996 INFO org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: jdbc:oracle:thin:@192.168.220.120:1521:wicesin (Oracle 11.2)
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ Pending DSpace database schema migrations:
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.01.03 DS-3024 SQL PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.07.21 DS-2775 SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.08.23 DS-3097 SQL PENDING
2017-03-14 16:36:54,098 INFO org.flywaydb.core.internal.command.DbValidate @ Successfully validated 30 migrations (execution time 00:00.017s)
2017-03-14 16:36:54,119 INFO org.flywaydb.core.internal.command.DbMigrate @ Current version of schema "BIBDIGITALMIGR": 6.0.2015.03.06
2017-03-14 16:36:54,119 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "BIBDIGITALMIGR" to version 6.0.2015.03.07 - DS-2701 Hibernate migration
2017-03-14 16:36:54,347 ERROR org.flywaydb.core.internal.command.DbMigrate @ Migration of schema "BIBDIGITALMIGR" to version 6.0.2015.03.07 - DS-2701 Hibernate migration failed! Please restore backups and roll back database and code!
2017-03-14 16:36:54,352 FATAL org.dspace.core.Context @ Cannot initialize database via Flyway!
java.sql.SQLException: Flyway migration error occurred
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:666)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:574)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:550)
at org.dspace.core.Context.<clinit>(Context.java:94)
at org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:74)
at org.dspace.app.util.DSpaceWebappListener.contextInitialized(DSpaceWebappListener.java:31)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1230)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1876)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration V6.0_2015.03.07__DS-2701_Hibernate_migration.sql failed
-----------------------------------------------------------------
SQL State : 42000
Error Code : 942
Message : ORA-00942: la tabla o vista no existe
Location : org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql (/home/usuarios/icapp/file:/home/jakarta/apache-tomcat-7.0.50/webapps/biblioteca_digital/WEB-INF/lib/dspace-api-6.0.jar!/org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql)
Line : 12
Statement : DROP VIEW community2item
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java:352)
at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.java:47)
at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigrate.java:308)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:305)
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:655)
... 18 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: la tabla o vista no existe
Thanks for the help
Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: ValidateObject failed
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1008)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
... 19 more
2017-03-14 16:36:53,842 INFO org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from: filesystem:/home/dspace/bibdigital/etc/oracle, classpath:org.dspace.storage.rdbms.sqlmigration.oracle, classpath:org.dspace.storage.rdbms.migration
2017-03-14 16:36:53,956 INFO org.flywaydb.core.internal.util.VersionPrinter @ Flyway 4.0.3 by Boxfuse
2017-03-14 16:36:53,996 INFO org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: jdbc:oracle:thin:@192.168.220.120:1521:wicesin (Oracle 11.2)
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ Pending DSpace database schema migrations:
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.01.03 DS-3024 SQL PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING
2017-03-14 16:36:54,067 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.07.21 DS-2775 SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING
2017-03-14 16:36:54,068 INFO org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.08.23 DS-3097 SQL PENDING
2017-03-14 16:36:54,098 INFO org.flywaydb.core.internal.command.DbValidate @ Successfully validated 30 migrations (execution time 00:00.017s)
2017-03-14 16:36:54,119 INFO org.flywaydb.core.internal.command.DbMigrate @ Current version of schema "BIBDIGITALMIGR": 6.0.2015.03.06
2017-03-14 16:36:54,119 INFO org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "BIBDIGITALMIGR" to version 6.0.2015.03.07 - DS-2701 Hibernate migration
2017-03-14 16:36:54,347 ERROR org.flywaydb.core.internal.command.DbMigrate @ Migration of schema "BIBDIGITALMIGR" to version 6.0.2015.03.07 - DS-2701 Hibernate migration failed! Please restore backups and roll back database and code!
2017-03-14 16:36:54,352 FATAL org.dspace.core.Context @ Cannot initialize database via Flyway!
java.sql.SQLException: Flyway migration error occurred
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:666)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:574)
at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:550)
at org.dspace.core.Context.<clinit>(Context.java:94)
at org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:74)
at org.dspace.app.util.DSpaceWebappListener.contextInitialized(DSpaceWebappListener.java:31)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1230)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1876)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:
Migration V6.0_2015.03.07__DS-2701_Hibernate_migration.sql failed
-----------------------------------------------------------------
SQL State : 42000
Error Code : 942
Message : ORA-00942: la tabla o vista no existe
Location : org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql (/home/usuarios/icapp/file:/home/jakarta/apache-tomcat-7.0.50/webapps/biblioteca_digital/WEB-INF/lib/dspace-api-6.0.jar!/org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql)
Line : 12
Statement : DROP VIEW community2item
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:117)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:71)
at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java:352)
at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.java:47)
at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigrate.java:308)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate.java:305)
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:655)
... 18 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: la tabla o vista no existe
Thanks for the help
Christian Criollo
Reply all
Reply to author
Forward
0 new messages